Mar 16th, 2007, 15:41
|
|
Reputable Member
|
|
Join Date: Mar 2007
Location: Kenya
Age: 19
Posts: 213
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
|
Re: help with my first learning database
- PHP: Select all
<?php
$db = mysql_connect("localhost", "myusername", "mypassword");
mysql_select_db("learndb",$db);
$result = mysql_query("SELECT * FROM personnel",$db);
echo "<TABLE>";
echo"<TR><TD><B>Full Name</B><TD><B>Nick Name</B><TD><B>Salary</B></TR>";
while ($myrow = mysql_fetch_array($result))
{
echo "<TR><TD>";
echo $myrow["firstname"];
echo " ";
echo $myrow["lastname"];
echo "<TD>";
echo $myrow["nick"];
echo "<TD>";
echo $myrow["salary"];
}
echo "</TABLE>";
?>
line 15 is...
- PHP: Select all
while ($myrow = mysql_fetch_array($result))
|