Get error while returning data from mysql

[ghjk]

When I retriwe data from mysql I got an error saying "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\xxxr\xxx.php on line 34". Please help me.

$sql="SELECT VehicleMake,VehicleType FROM vehicles WHERE VehicleType=$type AND VehicleMake=$make";
    echo $sql;
    $result = mysql_query($sql);
    while($row = mysql_fetch_array($result))
    {
    echo $row['VehicleMake'] . " " . $row['VehicleType'];
    echo "<br />";
    }
 
 

[Atli]

Hey.

If the mysql_query call fails, it will return FALSE instead of a MySQL resource.
Also, if the query doesn't return a result table (like with INSERT or UPDATE queries), the call will return TRUE, rather then a MySQL resource.

The mysql_fetch_array function only takes a MySQL resource object, so if you don't make sure the query result is a resource, you will get this warning.

Typically, you do something like:

$result = mysql_query($sql);
if($result) {
  while($row = mysql_fetch_array($result)) {
    // etc.
  }
}

Or just

$result = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_array($result)) {
    // etc.
}