Page 1 of 1

Assistance With Code To List Data

Posted: Tue Apr 21, 2009 12:07 pm
by Snatchio
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?

Re: Assistance With Code To List Data

Posted: Tue Apr 21, 2009 12:48 pm
by McInfo
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.

Re: Assistance With Code To List Data

Posted: Tue Apr 21, 2009 2:04 pm
by Snatchio
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

Posted: Tue Apr 21, 2009 4:34 pm
by califdon
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?
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.

Re: Assistance With Code To List Data

Posted: Tue Apr 21, 2009 6:23 pm
by Snatchio
Thanks Jack,

In looking at my code where do you see I am going wrong?

Re: Assistance With Code To List Data

Posted: Tue Apr 21, 2009 7:41 pm
by califdon
Snatchio wrote:Thanks Jack,

In looking at my code where do you see I am going wrong?
Before you look at your code, go back and read what McInfo told you. It's all there.