Posted by Steve on 04/14/07 05:02

<GGG@steric.net> wrote in message
news:1176522019.704438.239630@y5g2000hsa.googlegroups.com...
|
| I have the following query:
| $inquiry="SELECT * FROM dtartwork as da JOIN avaprints ON
| da.id=avaprints.id ";
| $inquiry.="LEFT JOIN dtimg ON da.id=dtimg.id WHERE da.id=$idm".

fix the shitty query formatting! that's a start! how do you expect to
maintain or debug that shit. here's a good example of a query you can
actually use:

$sql = "
SELECT *
FROM dtartwork da
JOIN avaprints av
ON av.id = da.id
LEFT JOIN dtimg im
ON im.id = da.id
WHERE da.id = '" . $idm . "'
";

[Back to original message]