Return the same row more then once

[fawkers]

Hello Everyone,

 

Seasons Greetings....

 

Right i've got a SQL query which would should return the same row but multipule times, however i only get the row returned once.

 

How should I go about this?

 

Thanks

 

.Adam

[kmount]

Without seeing the SQL query and an example from the database it's hard to tell...

[webman]

Do you mean you think that the query you've constructed should return multiple rows as it is; or do you want to know how to make it return multiple rows? Either way, posting the query you have will help in responding

[fawkers]

SELECT SUM(`cost`)
			FROM `costs`
			WHERE `id` in (
				SELECT `cost_id`
				FROM `events`
				WHERE `printer_id` = $printer_id
			)

 

webman should reconise the code (since its been added to his printmaster system )

 

i've attached the full zip file with the database printmastertest.zip

 

This should return the same row multipule times so I can sum up the cost from each row.

Edited December 28, 2010 by fawkers