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