PHP + mySQL problems

[Poff]

Hi,

I'm trying to go through a tutorial on PHP + mySQL here.

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");
}