NYCPHP Meetup

[John W. Markert]

Please advise, is the following possible in mysql or is one limited to joining 2 tables.

     $query = "select * from advlistings, valsec, valprim
      where ((advlistings.advId=$advId)
      and (valsec.SecID=advlistings.secId)    
      and (valprim.primeId=valsec.primeID))";

assume all table names are corect and .variables are correct.

the error that I get is:
    Unknown column 'valprim.primeId' in 'where clause'

Thanks,

John
___________________________________________

John W. Markert
14 Joanna Way
Kinnelon, NJ 07405
Phone: (973)838-8956
Cell: (201)788-1740
Fax: (973)838-4561 
email: markert at optonline.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20030604/2c1f18e0/attachment.html>