MySQL : mysql_result function : error in page....please help

[Oleg Butuzov]

Code: Select all

<?php 

$db = mysql_connect("localhost", "xxxxxxx", "xxxxxx"); 

mysql_select_db("xxxxxxxxx",$db); 

$result = mysql_query("SELECT * FROM employees",$db); 

printf("First Name: %s<br>\n", mysql_result($result,0,"first")); 

printf("Last Name: %s<br>\n", mysql_result($result,0,"last")); 

printf("Address: %s<br>\n", mysql_result($result,0,"address")); 

printf("Position: %s<br>\n", mysql_result($result,0,"position")); 

?>

try this

Code: Select all

<?php 

$db = mysql_connect("localhost", "xxxxxxx", "xxxxxx") or die(mysql_error()); 

mysql_select_db("xxxxxxxxx",$db) or die(mysql_error()); 

$result = mysql_query("SELECT * FROM employees",$db) or die(mysql_error()); ; 

while($data=mysql_fetch_array($result)){
//print functions for 
//$data['rowname'] elements
}
?>