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
}
?>