[RESOLVED] Displaying entire contents of a database

[Doom87]

Hello i have a small database and i want to be able to create a page where it will list every single entry in that database.

How can i do this?

I've tried this:

$res=mysql_query("SELECT * FROM engr_users");

if(mysql_num_rows($res)==0){
   echo "There is no data in the table";
}
else{

$row=mysql_fetch_assoc($res);
echo "ID : $row[username] Name : $row[name] Email : $row[uic]";
}

but that only gives me the first entry, how can i get the others?

thanks

[wilku]

Continue to fetch next rows using [man]mysql_fetch_assoc[/man] - an example using while loop there.

[Doom87]

so i have to just keep copying and pasting this code over and over again in the code?

$row=mysql_fetch_assoc($res); 
echo "ID : $row[username] Name : $row[name] Email : $row[uic]";

[jkurrle]

while($row=mysql_fetch_assoc($res))
  {
  //do something in the loop
  }

[Doom87]

while($row=mysql_fetch_assoc($res))
  {
  echo "ID : $row[username] Name : $row[name] Email : $row[uic]";
  }

so would that be correct?

[roscor]

Try this to display all records with alternating row colours

<?
    $conn = mysql_connect($host, $username, $password) or die(mysql_error());
    mysql_select_db($database,$conn) or die(mysql_error());  

$query = ("SELECT * FROM engr_users") or die (mysql_error());;
$res = mysql_query($query) or die ("Could not run query.");

if(mysql_num_rows($res)==0){
   echo "There is no data in the table";
}
else{ 

?>

<table width="800" border="0" cellspacing="0" cellpadding="0" align="centre" >
<tr>
<td width="463" align="center">
  </td>
  </tr>
  </table>


  <table width="800" border="0" cellspacing="0" cellpadding="0" align="centre" >
  <tr>
   <td width="33.3%"   align="center"><font face="Verdana" size="2" color="#000000">Username:</font></td>   

	<td width="33.3%"  align="center"><font face="Verdana" size="2" color="#000000">Name:</font></td>
	<td width="33.3%"  align="center"><font face="Verdana" size="2" color="#000000">UIC:</font></td> 

</tr>

</table>





<table border="0" width="800" height="50"  bordercolor="#111111">


<tr>

  <td style="border-style:solid; border-width:1px; border-color:#000000;" width="100%" height="20" valign="top"  bgcolor="#FFFFFF" bordercolor="#111111">


<div class="scrollable" style="height:400px; width:800; overflow:auto;">


 <table cellSpacing="0" cellPadding="1" border="0" id="RecentFeedback" class="itemTable" width="800" height="20" align="top"> 
<td align="centre"><font face="Verdana" size="2" color="#000000"></td>
<td align="centre"><font face="Verdana" size="2" color="#000000"></td>
<td align="centre"><font face="Verdana" size="2" color="#000000"></td>
</tr>
<?
$color1 = '#EEEEEE';
$color2 = '#FFFFFFF';


$i = 0;

while ($row = mysql_fetch_array($res)) {

$color = (($i%2 == 0 || $i == 0) ? $color1 : $color2);


$username=$row['username'];
$name=$row['name'];
$uic=$row['uic'];

?>


<font face="Verdana" size="2" color="#000000">
<th><? echo "<td width='25%' bgcolor=$color align='centre' ><font face='Verdana' size='2' color='#000000'>$username</td>"; ?></th>
<th><? echo "<td width='30%'  bgcolor=$color align='centre' ><font face='Verdana' size='2' color='#000000'>$name</td>"; ?></th>
<th><? echo "<td width='5%'  bgcolor=$color align='centre' ><font face='Verdana' size='2' color='#000000'>$uic</td>"; ?></th>
</font>

</tr>

<?
$i++;
}
}

echo "</table>";


?>

untested!

[laserlight]

Try this to display all records with alternating row colours

Yes, but also try to do that with CSS instead, or a combination of CSS and clientside scripting if you must.

[Doom87]

roscor wrote:

Try this to display all records with alternating row colours
untested!

Wow it worked great. Thanks alot. And one more question. Is there a limit to how many rows it will create?

[wilku]

It will run as long as data from database is supplied. You could try pagination to split your list into more then one page (let's say 20 users per page). Search this forum for "pagination" to see how. It was mentioned in some sticky thread in either General Help, Newbies or Coding.