Re: exasperated again

2009/7/4 PJ <af.gourmet@videotron.ca>: > Ashley Sheridan wrote: >> On Sat, 2009-07-04 at 10:47 -0400, PJ wrote: >> >>> Jim Lucas 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? >>>>> >>>>> >>>> I was preaching this to you months ago.  You should have error >>>> reporting turned on in a development area. >>>> >>>> by that I mean php should be set to display_errors = on and >>>> error_reporting = E_ALL >>>> >>>> Give this a try in a development area and "you will see the errors of >>>> your ways..." >>>> >>>> >>> The error reporting is always on as you suggested and I use it all the time. >>> But error reporting cannot report a non-existing error - a human stupid >>> error that I finally caught - msql instead of mysql... oh. well... :-( >>> >>> -- >>> 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 >>> >>> >>> >> Actually, if you had error reporting on, it should have at least picked >> that up as a function that was not defined. You do mention you get a lot >> of white pages instead of errors, which suggests that either you do not >> have errors turned on, or you are turning them on from within PHP, > What do you mean "from within PHP" ? > Isn't this enough in the script? > error_reporting(E_ALL); > ini_set('display_errors', 1); As Ash points out that will not display errors in the code syntax since they prevent any of your script from being executed. You're better off setting these values in php.ini. -Stuart -- http://stut.net/ >>  which >> can sometimes fail if there are fatal errors in the code. >> >> Thanks >> Ash >> www.ashleysheridan.co.uk >> >> >> > > > -- > 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 > >