SQLSTATE |
HY000 |
DATASOURCE |
artgalore_artSQL |
VENDORERRORCODE |
8642 |
SQL |
SELECT code, photo, PID, photonum, lname, fname, title, price, price_USA, pwidth, pheight, iwidth, iheight,
optionFile, descript, canvasprice, wrap, gallery, gallerywrap, unstretched, plaqueprice, plaquematted,
flushfloat, flushfloatmatted, catalogue, OPTIONNUM, unitednum, laminateprice, CODE1, CODE2, CODE3, CODE4, CODE5, CODE6, CODE7, CODE8, CODE9, CODE10, CODE11, CODE12, CODE13, CODE14, ACRYLIC, ACRYLICNG, ACRYLICUV, ACRYLICUVNG, MAT
FROM posterData
INNER JOIN unitedData ON posterData.unitednum=unitedData.unitedCode
INNER JOIN descriptionData ON posterData.descriptNum=descriptionData.descriptCode
INNER JOIN optionData ON posterData.optionNum=optionData.optionCode
WHERE photonum=1 AND code= (param 1) ;
|
|