[SOLVED] checking if sql queury was successfull?

[darksniperx]

$result = mysql_query("SELECT * FROM feed WHERE feed_id = '$id'");
if(!$result)
{
die("query unsuccessfull");
}
else
{
echo'queury successfull';
}

something along these lines, but to be able to check any kind of query, add, delete, update,...

the example above does not work me.

[revraz]

What do you want to know, if rows were found or if a connection was made to the DB?

[darksniperx]

if query was successfull, meaning there were no errors during query, and if rows were found or not

[trq]

<?php

  $sql = "SELECT * FROM feed WHERE feed_id = '$id'";
  if ($result = mysql_query($sql)) {
    // query was successfull.
    if (mysql_num_rows($result)) {
      // rows were found, fetch array and display result.
    } else {
      echo "No rows found";
    }
  } else {
    echo "Query failed<br />$sql<br />" . mysql_error();
  }

?>

[darksniperx]

thx, that is all that I needed!