Hi,

I'm trying to populate a pulldown menu with values from a database field which are separated by commas. It's a simple enough thing to do, so I am a little baffled as to why I'm not getting the result I'm after!

Instead of a nicely populated menu, I get the word "Array" and, when I echo out all of the variables, I get "resource id#3".

Here's the code:

PHP Code:

include ("dbconnect.inc.php");
$product_id=$_GET['product_id'];
$query="SELECT quantity FROM products";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$i=0;
$delimited=$result;
$delimiter=",";
$splitcontents = explode($delimiter, $delimited); 
 
 
echo "<select name=\"quantity\">";
while ($i < $num){
echo "<option>$splitcontents</option>";
$i++;
}
echo "</select>";
echo ("$splitcontents");
echo ("$delimited");
echo ("$result"); 


Can anyone shed some light on this?

It's probably just something simple, as usual!

Thanks!

mysql_query() does not return any actual data, but only a handle to it. Then you can access the data with the mysql_fetch_* functions.

Below is a version which should work.

<?php
    include ("dbconnect.inc.php");
    $product_id=$_GET['product_id'];
    $query="SELECT quantity FROM products";
    $result=mysql_query($query);
?>
 
<select name="quantity">
    <?php while ($row=mysql_fetch_row($result)) :?>
    <option><?php echo $row[0]; ?></option>
    <?php endwhile; ?>
</select>
 
<?php 
    echo $splitcontents;
    echo $delimited;
    echo $result;
?>

Hi Neroux, you always come to my rescue! Thanks...

OK, your code now results in a value in the menu, so that's a step forward. The result of the query, however, needs to be split up and echoed separately - i.e instead of 250,500,750,1000 appearing as one value, they should each be a separate option. So, I've adjusted the code as follows and I'm still just getting the word "Array" in the menu.

PHP Code:

include ("dbconnect.inc.php");
$product_id=$_GET['product_id'];
$query="SELECT quantity FROM products";
$result=mysql_query($query);
mysql_close();
echo "<select name=\"quantity\">";
while ($row=mysql_fetch_row($result)) :
$options = explode(",", $row); 
echo "<option>";
echo $options[0];
echo "</option>";
endwhile;
echo "</select>"; 


Any ideas? Thanks again...

What does the quantity column of your products table contain for each row?

Just some comma separated values to be split up and used as options. Currently, in the test database, the values are 250,500.

And you always want to display just the first value?

Then the following should work

PHP Code:

include ("dbconnect.inc.php");
 
$product_id=$_GET['product_id'];
 
$query="SELECT quantity FROM products";
$result=mysql_query($query);
 
echo "<select name=\"quantity\">";
while ($row=mysql_fetch_row($result))
{
    $options = explode(',', $row[0]);
    echo "<option>";
    echo $options[0];
    echo "</option>";
}
echo "</select>";
 
mysql_close(); 


He heh, we're almost there... but I want all of the values to display, hence the CSV format. This code works fine but, as you said, only displays the first value.

So you want to display all individual separated values from all rows?

Why dont you just store them in separate rows?

Then this should work

PHP Code:

include ("dbconnect.inc.php");

$product_id=$_GET['product_id'];

$query="SELECT quantity FROM products";
$result=mysql_query($query);

echo "<select name=\"quantity\">";
while ($row=mysql_fetch_row($result))
{
    $vals = explode(',', $row[0]);
    foreach ($vals as $val)
    {
        echo "<option>";
        echo $val;
        echo "</option>";
    }
}
echo "</select>";
 
mysql_close(); 


Because I'm coding an e-commerce facility (my first, as you may gather!), and the "quantity" row can contain any number of values. If I only provide, say, five rows and I have six quantities to enter, I'm stuck. Make sense?

Okay, does the above solution work for you?

Spot on. You're a Godsend today, I was stuck on this quite badly! Another lesson learned.

Thanks fella!