MySQL Loop problem

Vovex Technology · Post #1 (**permalink**) 06-14-2004, 11:32 AM

I am trying to configure a basic PHP program. So far my script can add people to a clientel base. But when I try to view a list of who is in the database. It only shows the first result. It wont loop through and grab the rest.

Someone help please.

Here is the code
--------------------------------------------

<html>
<head>
<title>Client View List</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#FFFFFF" text="#000000">
Sort by: 
 

<?
$username="********";
$password="********";
$database="********";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database CONTACTS");
$query="SELECT * FROM contacts";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

$i=0;
while ($i < $num) {

$first=mysql_result($result,$i,"first");
$last=mysql_result($result,$i,"last");
$address=mysql_result($result,$i,"address");
$suite=mysql_result($result,$i,"suite");
$city=mysql_result($result,$i,"city");
$state=mysql_result($result,$i,"state");
$zip=mysql_result($result,$i,"zip");
$phone=mysql_result($result,$i,"phone");
$fax=mysql_result($result,$i,"fax");
$email=mysql_result($result,$i,"email");

++$i;
}

?>
<table width="90%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td width="5%"> </td>
<td width="26%" bgcolor="#CCCCCC">Name</td>
<td width="22%" bgcolor="#CCCCCC">Phone</td>
<td width="17%" bgcolor="#CCCCCC">City / State</td>
<td width="30%" bgcolor="#CCCCCC">Email Address</td>
</tr>
<tr>
<td width="5%"> </td>
<td width="26%"> 
 
<? echo "$first $last " ?>
</td>
<td width="22%"> 
<? echo "$phone " ?>
</td>
<td width="17%"> 
<? echo "$city , $state " ?>
</td>
<td width="30%"> 
<? echo "$email " ?>
</td>
</tr>
</table>
</body>
</html>

Vovex Technology · Post #2 (**permalink**) 06-14-2004, 01:24 PM

Never mind. I figured it out. Im a moron

Just in case you guys wanted the code. Here ya go.

Working Code
----------------------------------------------------
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#FFFFFF" text="#000000">
Sort by: 
 
<table width="90%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td width="5%"> </td>
<td width="26%" bgcolor="#CCCCCC">Name</td>
<td width="22%" bgcolor="#CCCCCC">Phone</td>
<td width="17%" bgcolor="#CCCCCC">City / State</td>
<td width="30%" bgcolor="#CCCCCC">Email Address</td>
</tr>

<?
$username="***********";
$password="***********";
$database="***********";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database CONTACTS");
$query="SELECT * FROM contacts";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

$i=0;
while ($i < $num) {

$first=mysql_result($result,$i,"first");
$last=mysql_result($result,$i,"last");
$address=mysql_result($result,$i,"address");
$suite=mysql_result($result,$i,"suite");
$city=mysql_result($result,$i,"city");
$state=mysql_result($result,$i,"state");
$zip=mysql_result($result,$i,"zip");
$phone=mysql_result($result,$i,"phone");
$fax=mysql_result($result,$i,"fax");
$email=mysql_result($result,$i,"email");

echo "<tr>";
echo "<td> </td>";
echo "<td>  $first $last </td>";
echo "<td> $phone </td>";
echo "<td> $city , $state </td>";
echo "<td> $email </td>";
echo "</tr>";

++$i;
}

?>
</table>
</body>
</html>

FatalSw1tch · Post #3 (**permalink**) 06-14-2004, 08:56 PM

you could have put the mysql close just at the bottom before the ?>