HTML and PHP loop

ZOR · Jul 10, 2006

How do I get my HTML table to be created and data to be entered in slotts AAAAA, BBBBBB etc. I cannot seem to get any table output moving it within the PHP loop.

<?
session_start();

mysql_connect("localhost", "root") or die(mysql_error());
mysql_select_db("pagefeeds") or die(mysql_error());

$query="SELECT * FROM betasp";
$result=mysql_query($query);

// this tells me how many rows in table
$num=mysql_numrows($result);
// echo $num;

mysql_close();

// loop through the records in database
$i=0;
while ($i < $num) {

$one=mysql_result($result,$i,"Code");
$two=mysql_result($result,$i,"Description");

echo "$one $two <hr> ";
$i++;
}

?>

<html>

<head>
<meta http-equiv="Content-Language" content="en-gb">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Code</title>
</head>

<body>

<form method="POST" action="" >

 
<table border="1" width="100%" id="table1">
<tr>
<td colspan="5"> </td>
</tr>
<tr>
<td width="18%" align="center">Code</td>
<td width="34%" align="center">Description</td>
<td width="5%" align="center">Qty</td>
<td width="18%">Unit Price £</td>
<td width="22%" rowspan="6"> </td>
</tr>

<tr>
<td width="18%">AAAAAAAA</td>
<td width="34%">BBBBBBBB</td>
<td width="5%" align="center"> </td>
<td width="18%">CCCCCCCC</td>
</tr>

</table>

 
 
 
 
<input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2">
</form>
 
 

</body>

</html>

I only need the table headings bit shown once.

Any help much appreciated. The form event posting info is ommited at the moment. Regards

robbieguy2003 · Jul 10, 2006

How about doing it like this;

Code:

<table border="0" cellpadding="0" cellpadding="0" width="80%"> 
<tr> 
  <td><strong>Field</strong></td>
  <td><strong>Type</strong></td>
</tr>
<tr> 
  <td>&nbsp;</td>
  <td>&nbsp;</td>
</tr>
<?
include ("admin/dbconf.php"); // include your db connection
			  
// Get Items Out //
$query = "show columns in users;";
$result = mysql_query($query);
 
while ($row = mysql_fetch_array($result)) {
?>
<tr> 
  <td><? echo $row['Field']; ?></td>
  <td><? echo $row['Type']; ?></td>
</tr>
<?
}
?>
</table>

That will print your table heading before the loop, the content in the middle (once for each row returned) and then end the table with </table> once finished.

I wish someone would just call me Sir, without adding 'Your making a scene'.

Rob

ZOR · Jul 10, 2006

Many thanks, however is there a way to sandwich just showing my results where they should go, as I can then have that part clearer for me to confiugure the table further, and wanting to keep columns set at widths etc.

I have tried removing showing the two fields at the start of the program, and carrying them down as echo statements later on with <? ?> tags but either get errors or nothings there. Many thanks

ZOR · Jul 10, 2006

Nearly there, but now the end of my table is crunched up. Anyone spot mistake, thanks

<form method="POST" action="" >

 
<table border="1" width="100%" id="table1">
<tr>
<td colspan="5"> </td>
</tr>
<tr>
<td width="18%" align="center">Code</td>
<td width="34%" align="center">Description</td>
<td width="5%" align="center">Qty</td>
<td width="18%">Unit Price £</td>
<td width="22%" rowspan="6"> </td>
</tr>

<?
$i=0;
while ($i < $num) {
$one=mysql_result($result,$i,"Code");
$two=mysql_result($result,$i,"Description");
?>

<tr>
<td width="18%" align="center"><? echo $one; ?></td>
<td width="34%" align="center"><? echo $two; ?></td>
<td width="5%" align="center">---</td>
<td width="18%">nothing</td>
<td width="22%" rowspan="6"> </td>
</tr>

<?
// echo $one;
// echo "<td>" < echo $one >; >echo "</td>";

$i++;
}
?>

</table>

 
 
 
 
<input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2">
</form>

ZOR · Jul 10, 2006

Can someone please tell me why when I insert the remmed out PHP the table (right hand end) loses its merge to the above cell, and looks unhappy'

 
 
 
<table border="1" width="80%" id="table3">
<tr>
<td colspan="4"> </td>
<td> </td>
</tr>
<tr>
<td>code</td>
<td>descip</td>
<td>qty</td>
<td>unit price</td>
<td rowspan="2"> </td>
</tr>

<?
// $i=0;
// while ($i < $num) {
// $one=mysql_result($result,$i,"Code");
// $two=mysql_result($result,$i,"Description");
?>

<tr>
<td>aaa</td>
<td>bbb</td>
<td>cccc</td>
<td>dddd</td>
</tr>
<?
// echo $one;
// echo "<td>" < echo $one >; >echo "</td>";

// $i++;
// }
?>

</table>

Would be so good to get rid of this so I can carry on. Thanks

KarveR · Jul 11, 2006

Here's my trusty dynamic php/mysql table, you'll hate the colours but it works like a charm.

Code:

	echo "<table align=\"center\" border=\"0\" cellspacing=\"1\" cellpadding=\"0\">\n";

	$row=0;

// display field names

		print "<th>row</th>";

	for ($i = 0; $i < mysql_num_fields($result); $i++) {

		print "<th>".mysql_field_name($result,$i)."</th>\n";

	}

	while ($myrow = @mysql_fetch_array($result)){

// start the results display table

		$row++;

		if($row%2){

			$color="#CCCCCC";

		}else{

			$color="#9FC6C4";

		}

		echo "<tr><td>$row</td>";

		for ($i = 0; $i < ($columns); $i++) {

			echo "<td bgcolor=\"$color\"> $myrow[$i] </td>\n";

		}

		echo "</tr>\n";

	}

	mysql_free_result($result);



	echo "</table>\n";

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

HTML and PHP loop

ZOR

Technical User

robbieguy2003

ISP

ZOR

Technical User

ZOR

Technical User

ZOR

Technical User

KarveR

MIS

Similar threads

Part and Inventory Search

Sponsor