Your question is already answered, but for future ref, I debug all my SQL by
running it at the command prompt to ensure that the version of MySQL that I'm
using actually recognises the commands (alternatively trawl through the command
list in the MySQL manual to see what the developers have to say about
limitations and non-ansi SQL implementation/extensions, but this can take some
time!)
Tom
"samsom, debra" wrote:
> I am writing some PHP code with calls to Mysql. I am trying to do a Inner
> join and I am not getting any results back from my query (and no errors).
> If I cut the Inner join out of the SQL statement it works.
>
> If I link the MySql tables into Microsoft Access and run the exact SQL
> statement it works with the correct results.
>
> Is there any special syntax that PHP requires for inner joins? I'm running
> PHP 3.0.11 and Mysql 3.22.34 on NT 4.0 with Apache (of course).
>
> 'SELECT tbl_cip.CIP, tbl_cip.Originator, tbl_cip.Coordinator,
> tbl_cip.AproveCancel,
> tbl_cip.Actionees, tbl_cip.Director, tbl_cip.Repeat,
> tbl_cip.HoldPending,
> tbl_cip.Auditor, tbl_cip.Verifier, tbl_cip.Date
> FROM tbl_cip
> INNER JOIN tbl_formid ON tbl_cip.FormID =
> tbl_formid.FormID';
>
> Debra Samsom
> Bristol Aerospace Ltd.
> (204) 775-8331 3402
> [EMAIL PROTECTED]
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
