Simple php array question please

Hello, how can I insert the result of a query into an array so that it appears like the following quoted example if you print_r the info on a page?
Quote:


Array ( [0] => [1] => blah 1 [2] => blah 2 [3] => blah 3 [4] etc...


There is a script that explodes one string into seperate parts and I am replacing that with separate database entries. I would like to insert each row into an array so I do not have to do such a serious rewrite of the script if all of the results are in an array already. I used:
Quote:


print_r(array($item_row['item_name']));


However it only displays one result and not all of the rows:
Quote:


Array ( [0] => blah 1 )




I know that it is possible since a year ago someone did this for me. Thanks!





Last edited by lexington : 12-17-2008 at 05:11 PM.

If someone doesn't understand my question I can rephrase it. Please help since I cannot finish this script unless I have this one simple command. A guy took 5 seconds and gave it to me a year ago and I cannot remember how it was done.

can we see a part of the code or something, cause I guess the whole idea is wrong





__________________Hicham MallahWeb Developer

Ok I think I just figured it out from searching a million pages on Google. This works:
PHP Code:



while ( $item_row = mysql_fetch_array($item_res) )
{
ÂÂ*ÂÂ*ÂÂ*$newarray[] = $item_row['item_name'];
}
print_r($newarray);

cool, there was no use searching u said you want to put the rows into an array then u were trying to print_r a single row as an array





__________________Hicham MallahWeb Developer

Lexington you can use foreach.
Code:
foreach ($item_row as $name=> $value) {
echo 'Name: '.$name.' - Value: '.$value.'<br />';
}

Thanks man but I got what I needed

Try this http://adodb.sf.net

bager, what does a database abstraction layer have to do with the original question?





__________________
Craig Sparks | Web Developerhttp://www.jexlabs.com

Quote:



Originally Posted by csparks


bager, what does a database abstraction layer have to do with the original question?


He can find or use what he needs with this library.