2009/6/30 PJ <af.gourmet@videotron.ca>:
> Could somebody please explain to me what is wrong with this code?
> In my script it works, returns the correct id, but when I try it in a
> test pages, nothing in the world gets it to work. This is rather
> frustrating, again:
> THIS WORKS IN ANOTHER PAGE; IN THE TEST PAGE ID DOES NOT.
> $sql = "SELECT id FROM publishers
> Syntax is ok, echo "hello"; works.
>
>
> This works in the test page:
> $aid = array();
> $ord = array();
> $sql = "SELECT authID, ordinal
";
>
> This does not:
> $fi="joe"; $la="joe";
> $sql = "SELECT id FROM author
> The test page prints out echo "some text"; but no results when the
> results are there....
> Tell me I have missed something simple here, or is this normal for php ?
> I have checked the queries on Mysql command line and they are fine.
> I have verified the syntax and Netbeans tells me it is fine.
> Same results Firefox3 (2 machines) & IE 8.
> What is not fine?
>
> --
> -------------------------------------------------------------
> Phil Jourdan --- pj@ptahhotep.com
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
Is that exactly your code?
see your 4th line:
> $result = msql_query($sql, $db);
you forgot the "y" in mysql_query function...
if you have a 500 error code maybe this is the problem
--
Maximiliano Churichi
<mchurichi@gmail.com>
|