Solved

How does mysql_fetch_assoc store rows from a query?

Posted on 2008-10-24
1
603 Views
Last Modified: 2013-12-13
I am using Dreamweaver's built in functionality to create a drop down list from a MySQL query.  The problem I have is that if I try to duplicate the list on the same page, only the first instance is filled with info from the query.  It may have something to do with the way "mysql_fetch_assoc" counts through the rows.  Can someone please explain how this works and how I can create multiple lists from the one query?  Thanks.
// The following is a couple snippets from my page:
 

mysql_select_db($database_gw2000Connect, $gw2000Connect);

$query_getAllNames = "SELECT * FROM users";

$getAllNames = mysql_query($query_getAllNames, $gw2000Connect) or die(mysql_error());

$row_getAllNames = mysql_fetch_assoc($getAllNames);

$totalRows_getAllNames = mysql_num_rows($getAllNames);
 
 

<select name="entryToApply">

  <?php do { ?>

  <option value="<?php echo $row_entriesToApply['invoiceNum']; ?>">

    <?php echo $row_entriesToApply['invoiceNum']; ?>

  </option>

  <?php } while ($row_entriesToApply = mysql_fetch_assoc($entriesToApply)); ?>

</select>

Open in new window

0
Comment
Question by:CheeserTheAverage
1 Comment
 
LVL 3

Accepted Solution

by:
raminhos earned 500 total points
Comment Utility
Try:
<?
 

mysql_select_db($database_gw2000Connect, $gw2000Connect);

$sql = "SELECT * FROM users";

$qry = mysql_query($sql);

while ($row = mysql_fetch_array($qry)){
 

  // CREATE ARRAY WITH DATA

  $entries[] = $row_entriesToApply['invoiceNum'];
 

}
 

// FIRST SELECT
 

$select = "<select name='entryToApply'>";

foreach ($entries as $a){

  $select .= "<option value='$a'>$a</option>";

}

$select .= "</select>";
 
 
 

// SECOND SELECT
 

$select1 = "<select name='entryToApply2'>";

foreach ($entries as $b){

  $select1 .= "<option value='$b'>$b</option>";

}

$select1 .= "</select>";
 
 

/// and continue...
 
 

?>

Open in new window

0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
This article discusses four methods for overlaying images in a container on a web page
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to count occurrences of each item in an array.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now