Putting database objects into an array

[biglurch]

Im trying to take two columns from a table and put the values into an array, so i can use the arrays to put the values into list boxes. This is what i have so far any help will be appreciated.


<code>

$ids = Array(); //array declaration

//query selecting data from table
$query = 'Select category_id FROM categories';
$result = mysql_query($query) or die(mysql_error());

//while loop continues until no more values in table
while ($row = mysql_fetch_assoc($result)) {
foreach ($line as $col_value) {
$ids($col_value);
//sets array values to each column value
}
}
echo " $ids";

</code>

Live by the code, Die by the code!!

 

[ggriffit]

why not use the PUSH function of the array (

http://uk2.php.net/manual/en/function.array-push.php)

to push each item into the array as you process it ?

Alternatively, why not just replace the array with an echo statement and print ou the rows as select OPTIONs tags where you need them ?

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005

http://www.greggriffiths.org/livelink/

 

[sleipnir214]

Have you looked at the example code that is in the PHP online manual? mysql_fetch_assoc() page

I also recommend that you take a look in the PHP online manual section on [link

http://www.php.net/manual/en/function.mysql-fetch-assoc.php

]Arrays[/url], although I don't see why you'd need an array here if you're just going to output the values from the DB.



Want the best answers? Ask the best questions! TANSTAAFL!

 

[biglurch]

After i get them outputed into the list box people will be able to choose the category then i based on the ID from that table it will pull all the entryies from another table with that id associated with it and display them all. I figured i needed the array to so when one is chosen i can reference that array object within the query to select the items from the other table.

Live by the code, Die by the code!!

 

[sleipnir214]

You need to understand how web code works.

The user points his browser at your script. The browser then connects to the web server and instructs the server to run the script. The server will run the script and pipe its output to your browser. Your script will then terminate. The browser will render that HTML into something the user can manipulate. When the user submits the data from a form, the browser then invokes a script.

That second-invoked script can be the same as the first or another script entirely, but unless you're using something like a session variable (link), the data in your array will not be there. The script will have terminated and all memory will have been freed.



Want the best answers? Ask the best questions! TANSTAAFL!

 

[ggriffit]

if you pass the array client side you may be able to do some of this using Javascript -

http://www.greggriffiths.org/webdev/clientside/javascript/linkeddropdowns/

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005

http://www.greggriffiths.org/livelink/

 

[biglurch]

Now that i got it working i just wanted to post the code back so you can see.
<code>
<form method="post" action="/includes/mem_results.php" >
<?php
$query = 'SELECT * FROM categories';
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
echo "<select>";
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
echo "<option value=\"$row[0]\">$row[1]";

}
echo "</select>";
?>
<br />
<input type="submit" value="Submit" />
</form>
</code>

This takes the data from the database, puts the id field as the list box value and the name field as the name displayed by the list box.

Live by the code, Die by the code!!