Values in HTML Tables

[shanis42p]

<?php

I have assembled a PHP page that promts a user for contact information. It all works properly.

I created another page to allow an (non-MySQL knowing) administrator access that information. When it displays it displays it displays all the info from my MySQL database in one continous stream.

I would like to place this info into a table. I tried using HTML tags to insert a table, but then the row that I tagged just gets overwritten by more incoming records. The only thing that displays on my page is the last record.

Is there a way to add another row to my HTML table dynamically?

Thanks for any help,
Shane.

?>

[LordShryku]

Show us what you're doing. Shouldn't be anything more than just using a <tr> tag in a loop

[shanis42p]

<?php
$hostname = "localhost";
$username = "root";
$password = "*******";
$usertable = "tblemployment";
$dbname = "mastercut";
$today = getdate();
mysql_connect($hostname,$username,$password) or die("Unable to connect to database");

mysql_select_db( "$dbname") or die( "Unable to select database");

$query = "SELECT * FROM $usertable WHERE jobtitle IS NOT NULL";

$result = mysql_query($query);

$number = mysql_num_rows($result);

$i = 0;

if($number == 0):
	print "<center>Sorry, we do not have any current job openings available ";
	print "for $today[month] $today[year].</center>";

elseif($number > 0):
	print "<center>Jobs currently available as of $today[month] $today[year] <br><br><br><br>";		
	while ($i < $number):
			$jobtitle = mysql_result($result,$i,"jobtitle");
			$jobdescription = mysql_result($result,$i,"jobdescription");
			$dateadded = mysql_result($result,$i,"dateadded");

			print "$jobtitle         ";
			print "$jobdescription              ";
			print "$dateadded             ";


			$i++;
	endwhile;
endif;			

I tried using a <tr> tag in a loop all I got was one row that was rewritten over and over again. This is what I have as of now. I am thinking it has to be during the print statements I will need some sort of conditional looping.

Thanks in advance,
Shanis

[LordShryku]

We'll start here...

 $number = mysql_num_rows($result);

$i = 0;

if($number == 0):
print "<center>Sorry, we do not have any current job openings available ";
print "for $today[month] $today[year].</center>";

elseif($number > 0):
print "<center>Jobs currently available as of $today[month] $today[year] <br><br><br><br>";
while ($i < $number):
$jobtitle = mysql_result($result,$i,"jobtitle");
$jobdescription = mysql_result($result,$i,"jobdescription");
$dateadded = mysql_result($result,$i,"dateadded");

print "$jobtitle ";
print "$jobdescription ";
print "$dateadded ";


$i++;
endwhile;
endif; 

Try this instead:

if(mysql_num_rows($result) == 0) {
   print "<center>Sorry, we do not have any current job openings available 
          for ".$today['month']." ".$today['year'].".</center>";
}
else {
   echo "<table border=\"1\">";
   while($row=mysql_fetch_array($result)) {
      echo "<tr>
              <td>".$row['jobtitle']."</td>
              <td>".$row['jobdescription']."</td>
              <td>".$row['dateadded']."</td>
            </tr>";
   }
   echo "</table>";
}

[shanis42p]

All works well,

Thanks a bundle.

Shane