'tblmodel alias not unique

[darkfreaks]

$SQLstmt="SELECT * FROM tblModel,tblImages";
$SQLstmt=$SQLstmt."WHERE tblModel.modelNo = $modno";  
$SQLstmt=$SQLstmt."AND tblmodel.modelid = tblimages.modelid";

 

anyone know  how to fix this with the query?

[darkfreaks]

i noticed i had an error with the spelling of the fields before but fixed it and still having the same problem

 

 

 

$SQLstmt="SELECT * FROM tblModel,tblImages";
$SQLstmt=$SQLstmt."WHERE tblModel.modelNo = $modno";  
$SQLstmt=$SQLstmt."AND tblModel.modelID = tblImages.modelID";

[xyph]

Don't forget spaces when you concatenate.

 

Echo out $SQLstmt, what do you see?

[scootstah]

On a side note, PHP's concatenation operator is a little bit cleaner

 

$SQLstmt="SELECT * FROM tblModel,tblImages";
$SQLstmt .= " WHERE tblModel.modelNo = $modno";  
$SQLstmt .= " AND tblModel.modelID = tblImages.modelID";

 

I also added the spaces xyph was talking about.

[darkfreaks]

solved thanks