help with this error please..Warning: mysql_fetch_array():

[aron]

this is the error i get.
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in d:\nuvocreative\flash_marketing.php on line 10
cant=0

this is the php code..

<?php
$db_username="username";
$db_password="password";
$db_name="database_name";
$connection = mysql_connect("server","$db_username","$db_password") or die('Could not connect to the database server'); 
$db = mysql_select_db("$db_name", $connection) or die ("Unable to select database."); 

    $result = mysql_query("SELECT client_first_name, client_last_name, client_email FROM email_marketing"); 
    $cant = 0; 
    while($row=mysql_fetch_array($result)){ 
        echo "Firstname$cant=$row[client_first_name]&Lastname$cant=$row[client_last_name]&Email:$cant=$row[client_email]&"; 
        $cant++; 
    } 
    echo "cant=$cant";
?>

cheers aron.

[rachel2004]

Originally posted by aron

$connection = mysql_connect("server","$db_username","$db_password") or die('Could not connect to the database server'); 
$db = mysql_select_db("$db_name", $connection) or die ("Unable to select database."); 

    $result = mysql_query("SELECT client_first_name, client_last_name, client_email FROM email_marketing"); 

[/B]

You are missing your $connection variable in your mysql_query. Try this:

$result = mysql_query("SELECT client_first_name, client_last_name, client_email FROM email_marketing", $connection);

[noimad1]

By the way, the mysql_fetchrow error is usually a generic mysql error. It can be very helpful to put this code anytime you are querying a database. You want to put it right after your " $result = mysql_query()" section.

It will give you a more direct error and will often times help you track down the error faster:

if($result == false){
echo mysql_errno().":".mysql_error()."<BR>";
exit;
}

[Shrike]

The error is due to the fact that the query returned no results. By the way, PHP will use the first active connection it finds if you don't specify a connection by name.

[patbator]

I advise you to catch the error that mysql can return on processing your query

$result = mysql_query($sql) or die('Error :' . mysql_error().'<br>'.$sql);

Typically, PHP doesn't display syntax error returned by the mysql server, so when you try to fetch from the result of a query that failed (it's different from not retunrnig any rows 🙂) all that PHP is able to tell you is that $result is not a valid result id (in fact I bet it is set to false)...

Well, just print the error with mysql_error() and you should be able to debug your query ...

good luck