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?
Assistance With Code To List Data
Moderator: General Moderators
Re: Assistance With Code To List Data
The mysql_fetch_assoc() function returns only one row at a time. You need to call it multiple times to get more than one row. The most common way to do that is by using a loop, as is demonstrated in the documentation.
PHP Manual: mysql_fetch_assoc
Edit: This post was recovered from search engine cache.
PHP Manual: mysql_fetch_assoc
Edit: This post was recovered from search engine cache.
Last edited by McInfo on Mon Jun 14, 2010 4:10 pm, edited 1 time in total.
Re: Assistance With Code To List Data
Thanks for the response but I am using the assoc( ). I even tested to code on the link and it is not working. Any other ideas using my code above?
Re: Assistance With Code To List Data
Read what McInfo told you. You are misunderstanding what a "fetch" does. The "assoc" form of fetch has nothing whatsoever to do with how many rows are returned.Snatchio wrote:Thanks for the response but I am using the assoc( ). I even tested to code on the link and it is not working. Any other ideas using my code above?
Re: Assistance With Code To List Data
Thanks Jack,
In looking at my code where do you see I am going wrong?
In looking at my code where do you see I am going wrong?
Re: Assistance With Code To List Data
Before you look at your code, go back and read what McInfo told you. It's all there.Snatchio wrote:Thanks Jack,
In looking at my code where do you see I am going wrong?