RE: [PHP-DB] query and display acting weird...

2003-07-25 Thread Aaron Wolski
As usual. John knows best. Thanks! Aaron -Original Message- From: CPT John W. Holmes [mailto:[EMAIL PROTECTED] Sent: July 25, 2003 3:05 PM To: Aaron Wolski; [EMAIL PROTECTED] Subject: Re: [PHP-DB] query and display acting weird... Probably need: ORDER BY t.manufacturer, t.colourID

Re: [PHP-DB] query and display acting weird...

2003-07-25 Thread CPT John W. Holmes
Probably need: ORDER BY t.manufacturer, t.colourID ---John Holmes... - Original Message - From: "Aaron Wolski" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July 25, 2003 2:58 PM Subject: [PHP-DB] query and display acting weird... > Hi Guys, >

[PHP-DB] query and display acting weird...

2003-07-25 Thread Aaron Wolski
Hi Guys, Code: echo "\n"; $query = "select t.manufacturer, t.id, t.colour, t.colourID, t.type, p.thread_index FROM kcs_threads t LEFT JOIN kcs_patternthreads p ON t.id = p.thread_index WHERE p.pattern_index = '$id' OR p.pattern_index IS NULL ORDER BY t.colourID"; $thread_manufacturer