On Tue, Jun 30, 2009 at 4:01 PM, PJ<af.gourmet@xxxxxxxxxxxx> wrote:
> 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
> WHERE publisher = 'whoever'";
> $result = mysql_query($sql,$db);
> $row = mysql_fetch_assoc($result);
> if (mysql_num_rows($result) !== 0) {
> $pub = $row['id'];
> Syntax is ok, echo "hello"; works.
>
>
> This works in the test page:
> $aid = array();
> $ord = array();
> $sql = "SELECT authID, ordinal
> FROM book_author WHERE bookid = 624 ORDER BY ordinal ASC";
> $result = mysql_query($sql, $db);
> //$row = mysql_fetch_assoc($result);
> while ( $row = mysql_fetch_assoc($result) ) {
> $aid[]=$row['authID'];
> $ord[]=$row['ordinal'];
> }
> var_dump($aid);
> echo "<br />";
> var_dump($ord);
> echo $aid[0], " - ";
> echo $ord[0];
>
> This does not:
> $fi="joe"; $la="joe";
> $sql = "SELECT id FROM author
> WHERE first_name = '$fi' && last_name = '$la'";
> $result = msql_query($sql, $db);
> $row = mysql_fetch_assoc($result);
> $count=mysql_num_rows($result);
> echo $count;
> if (mysql_num_rows($result) > 0) {
> $a_id=$row['id'];
> }
> echo $a_id, "<br /><br />";
> 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?
>
> --
> Hervé Kempf: "Pour sauver la planète, sortez du capitalisme."
> -------------------------------------------------------------
> Phil Jourdan --- pj@xxxxxxxxxxxxx
> http://www.ptahhotep.com
> http://www.chiccantine.com/andypantry.php
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
I see a typo in the last block where you call $result =
msql_query(...) instead of $result = mysql_query(...). Is that in your
actual code?
Andrew
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
