Stuart wrote:
2009/7/4 PJ <>:
Stuart wrote:
2009/7/4 PJ <>:

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:
$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 =
            while ( $row = mysql_fetch_assoc($result) ) {
            echo "<br />";
            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);
    echo $count;
          if (mysql_num_rows($result) > 0) {
          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 ---

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?
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.


But not on a productions server, right? (Since this should have been
corrected before "going live")

Indeed. If you're using the same server for both then use ini_set to
turn display_errors off on the production site.


Or, if it is running apache, you can set these values from within the httpd.conf file for your respective <VirtualHost>...</VirtualHost>

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to