Re: exasperated again - shot in the foot

On Tue, Jun 30, 2009 at 4:50 PM, Bastien Koert<phpster@gmail.com> wrote: > On Tue, Jun 30, 2009 at 4:48 PM, PJ<af.gourmet@videotron.ca> wrote: >> PJ 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? >>> >>> >> Damn, it's frustrating to find that there is a difference between msql >> and mysql... ouch, the foot hurts now! >> >> -- >> Hervé Kempf: "Pour sauver la planète, sortez du capitalisme." >> ------------------------------------------------------------- >> Phil Jourdan --- pj@ptahhotep.com >>   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 >> >> > > Blame the native, libraries that is > > -- > > Bastien > > Cat, the other other white meat > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > Take it as a sign you shouldn't be using mysql_ at all :) Use the OOP interface to mysqli or PDO and these problems don't happen