var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
PHP/mySQL duplicate outputs
I'm having a little trouble with this mySQL query I got help with a week or so ago on this forum
I'm getting duplicates of the same entry... and when there are more entries to be displayed - i get even more duplicates of the same entry....
SELECT b.*, c.* FROM tod_company_information c, tod_bookings b INNER JOIN tod_bookings ON c.company_id = b.company_id ORDER BY b.date_in ASC
I dont understand whats happening... I know its something to do with the query.. because when i use a much simpler query, i just get the expected 1 output from each individual record...
Does anyone have any idea why its doing this?
Thanks in advance
SELECT b.*, c.* FROM tod_company_information c INNER JOIN tod_bookings b ON c.company_id = b.company_id ORDER BY b.date_in ASC
yep, you had one of the tables in your query twice. That would cause it to duplicate entries.
Thanks guys , it worked
I appreciate the help