[SOLVED] What does mysql_query(); Return?

[jjacquay712]

I am a little confused about mysql querys in php. When you do a query like this:

<?php
$var = mysql_query("SELECT * FROM table;");
?>

What would the variable $var be / datatype? and how could i use mysql_fetch_array(); without the mysql_query() function inside of it?

[jjacquay712]

I found something about resources http://us3.php.net/manual/en/language.types.resource.php but im still confused  ???

[Maq]

Why don't you look in the manual?  mysql_query()

 

Usually it's the resource id or else false.

[printf]

a resource, on failure returns false... mysql_error () will be filled with the error (string) if it fails...

[premiso]

<?php
$var = mysql_query("SELECT * FROM table;");

if (is_resource($var)) {
    while ($row = mysql_fetch_assoc($var)) {
          print_r($row);
   }
}else {
    echo 'Query failed, error is: ' . mysql_error();
}
?>

 

Hope that helps ya.