Hi, I am fairly new to php and mysql so this may just be my own ignorance at this point. I am converting an application from ASP/ACCESS to PHP/MySQL. Most of the sql statements seem to work fine but this one popped up tonight and I have no idea what is wrong with it since it worked fine in the original applications.
Anything that is really obviously wrong for a php/mysql app?

Thanks,
Steve

Hello ssalter,

It's hard to say just from reading the query and without some info on the db structure and data (at least for me).

What is the error message if any?

__________________
J de Silva
Learning Journal | GIDForums™ | GIDNetwork™ | GIDWebhosts™ | GIDSearch™

Thanks for the reply!

It worked great on the original application and the data/data structures are the same so I was thinking it might just be an uncompatibility between the way access and mysql handled inner joins. After pounding on it for another couple of hours I gave up, looked at it this morning and immediately found my calling the query was at fault, ie:


I had two blasted $$ in from of the rs recordset when I make the query. Such a simple thing and I spent hours just not seeing it. *shakes head* But then the toughest problems often turn out to be simple typos sometimes.