MySQL error

[Anon]

Hey there - so far, I've always used ODBC connections - now, I have to use mySQL and I have been all over PHP.net and mysql's website looking for the answer. I am getting a "Supplied argument is not a valid MySQL result resource" error message. I apparently have no idea on how connect using mySQL. Can someone please help - thanks!

$db = mysql_connect("localhost","","");
mysql_select_db("sethcox_com",$db);
$result = mysql_query("SELET * FROM getprayer",$db);

if ($myrow = mysql_fetch_array($result)) {

	 echo "<table border=1>\n";

 echo "<tr><td>Name</td><td>Position</td></tr>\n";

 do {
	   printf("%s %s<br>", $myrow["name"], $myrow["spousename"]);

 } while ($myrow = mysql_fetch_array($result));
	 echo "</table>\n";

	 } else {
	 echo "Sorry, no records were found!";	
	 }

[crusty_php]

$result = mysql_query("SELET * FROM getprayer",$db);

Try SELECT

[Anon]

Oh sheesh - thanks for pointing that one out! Can't believe I missed that. Still though - same problem. The error is on the "if ($myrow = mysql_fetch_array($result))" line.

Any ideas? Thanks...

[crusty_php]

try this

$db = mysql_connect("localhost","","");
mysql_select_db("sethcox_com",$db);
$result = mysql_query("SELET * FROM getprayer",$db);

while(($myrow = mysql_fetch_array($result))){
printf("%s %s<br>", $myrow["name"], $myrow["spousename"]);
}

} else {
echo "Sorry, no records were found!";
}