Tyler Longren pressed the little lettered thingies in this order...

> Hello everyone,
> I've been writing database enabled site for quite a while now.  One thing I
> have never figured out it how to determine if a sql query is successful.
> This works:
> if ($connection = mysql_connect("host","username","password")) {
>     print "Successful connection":
> }
> else {
> print "No connection";
> }
> But this won't work:
> if ($sql = mysql_query("SELECT * FROM table ORDER BY rand()")) {
>     print "SQL executed successfully.";
> }
> else {
>     print "SQL not executed successfully.";
> }
> Can anyone tell me how I can tell if the SQL executed successfully?  Is
> there any method besides OR DIE?

What's wrong with "or die(..." ? If you get no error, the query was 
successful.  If you take your "$sql =" out it *should* work.  mysql_query 
returns TRUE or FALSE depending on whether or not the query 
succeeded. This isn't tested, but it should work:
        if (mysql_query("SELECT * FROM table ORDER BY rand()")) {
        echo "Success!";
        } else {
        echo "Failure!";

Your statement above is checking to see if the fact that $sql is equal to 
mysql_query("SELECT * FROM table ORDER BY rand()") is TRUE, but 
you're using an assignment operator (=) and not a comparison operator 
(==), so it should always return FALSE. (Can you use an assignment 
operator in an if() statement?)

Christopher Ostmo
Innovative Application Ideas
Meeting cutting edge dynamic
web site needs since the 
dawn of Internet time (1995)

Business Applications:

Open Source Applications:

PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to