Re: exasperated again

On Tue, Jun 30, 2009 at 4:01 PM, PJ<af.gourmet@videotron.ca> 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@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 > > 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