Resource id #2

[Anon]

Why did mysql send this:

Resource id #2

Whit the commando:

$result = mysql_query("select id, emne, dato, svar from MYSQL where id > '0'");

//Ulrik Q K

[sepodati]

$result gets assigned as "Result id #2" and then you use mysql_fetch_row or mysql_fetch_array or mysql_result to get data from the rows returned in the result set.

Read the manual.

---John Holmes...

[Anon]

Hi,
Result id #2 and Resource id #2 are not the same!
The $result post: Resource id #2 and $data is nothing!

MY CODE IS:

$result = mysql_query("select id, emne, dato, svar from mysql where id > '0'") or die (mysql_error());
$antat = MYSQL_NUM_ROWS($resultat);
if ($antal > 0)
{
while($data = mysql_fetch_array($resultat))
{
SOMETHING
}}

:END OF CODE

PS: Mysql_error don´t post something.

[sepodati]

Whatever...I just typed the wrong thing. It still applies.

If you are assigning the result from your query to $result, why are you using $resultat in your mysql_num_rows() function? And why are you using it in your mysql_fetch_array() function, too???

You should use $result in each.

---John Holmes...