PHP + mySQL problems

[Poff]

Hi,

I'm trying to go through a tutorial on PHP + mySQL here (http://www.freewebmasterhelp.com/tutorials/phpmysql/4).

It's working fine until I get to the line $num=mysql_numrows($result); where I get the error message

Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/flaatartist/www/page1/page1.php on line 81

Soo... is there a fault in the tutorial? Or did I do something else wrong? Here's a copy of all of my code:

<?php
$username="myusername";
$password="mypassword";
$database="flaatartist";

mysql_connect("mysqldatabase",$username,$password);

@mysql_select_db($database) or die("error connecting to database");

mysql_query("INSERT INTO contacts VALUES ('Erlend','Handeland')");

$query="SELECT * FROM contacts";
$resulr=mysql_query($query);




$num=mysql_numrows($result);

mysql_close();

echo "<b>Database</b><br><br>";


$i=0;



while ($i < $num) {

echo "Navn: <b>$fornavn $etternavn</b><br>";


$i++;
$fornavn=mysql_result($result,$i,"fornavn");
$etternavn=mysql_result($result,$i,"etternavn");
}
?>

[mac-convert]

$query="SELECT * FROM contacts";
$resulr=mysql_query($query);

Looks like a typo - resulr s/b result ???

[werther]

$resulr=mysql_query($query);


$resulr should be $result

edit: Too slow sorry...

[Poff]

Thanks a lot! Silly mistake! :) Now it all works like a charm. (after fixing another silly mistake I found towards the bottom.. :))

[nightelf]

You could also simplify this part:

while ($i < $num) {

echo "Navn: <b>$fornavn $etternavn</b><br>";


$i++;
$fornavn=mysql_result($result,$i,"fornavn");
$etternavn=mysql_result($result,$i,"etternavn");
}

to

for ($i = 1; $i <= $num; $i++)
{

echo "Navn: <b>$fornavn $etternavn</b><br>";

$fornavn=mysql_result($result,$i,"fornavn");
$etternavn=mysql_result($result,$i,"etternavn");
}