Assistance With Code To List Data
Posted: Tue Apr 21, 2009 12:07 pm
I am having an issue creating a listing of names. Currently people can sign up but then when you look at who signed up it only lists that last person who signed up and not everyone in the list. When I test it in Dreamweaver it seems to work correctly but when it is live I am having the issue. Here is the code...
<?php
mysql_select_db($database_Bunker, $Bunker);
$query_Recordset1 = "SELECT element_1_1, element_1_2 FROM ap_form_1 ORDER BY element_1_1 ASC";
$Recordset1 = mysql_query($query_Recordset1, $Bunker) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
Then in the body...
<table border='0' align="center" cellpadding='0' cellspacing='0'>
<tr>
<th>
<form>
<?php echo $row_Recordset1['element_1_1']; ?> <?php echo $row_Recordset1['element_1_2']; ?>
</form> </th>
</tr>
</table>
Can anyone please assist?
<?php
mysql_select_db($database_Bunker, $Bunker);
$query_Recordset1 = "SELECT element_1_1, element_1_2 FROM ap_form_1 ORDER BY element_1_1 ASC";
$Recordset1 = mysql_query($query_Recordset1, $Bunker) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
Then in the body...
<table border='0' align="center" cellpadding='0' cellspacing='0'>
<tr>
<th>
<form>
<?php echo $row_Recordset1['element_1_1']; ?> <?php echo $row_Recordset1['element_1_2']; ?>
</form> </th>
</tr>
</table>
Can anyone please assist?