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
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,
>
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