Orangutang - 1:29 pm on Mar 10, 2011 (gmt 0)
24 hours later I remember I could try the query in phpMyAdmin :-)
I changed the table back to clientid from poclient and tried it, got some more info, this error.
mysql #1052 - Column 'clientid;' in where clause is ambiguous.
Googled it and found many posts and a very concise answer:
Its just like the error is saying that your field 'catID' in where clause in ambiguous, this means that it doesnt know wich field you are using because the same field is in both tables (tbl_listings,tbl_category), so you need to tell to mysql witch one u want.
Changed my code to this and works well:
WHERE porders.postatus = 'processed' AND porders.clientid = '$clientid'
Hope it helps someone.