Getting Values from database in array format

phpmagesh

I have a table with only one field say p_code. for that field i have around 30 values like MMBF,TRED,TFRE,EDFC,TTRRE ect., to goes on.

I am trying to retrive all the values in the single query like this:

Expand|Select|Wrap|Line Numbers

 
$sql_query_product = mysql_query("SELECT Product_Code FROM " . TABLE_PRODUCT_CODE . "");    

while($row_pr = mysql_fetch_array($sql_query_product))

{                      

$product_code = array($row_pr['Product_Code']);

}

But i m getting the last value of that field.

Can anyone help me how to get all the values in a single array with comma seperated values.

Thanks in advance,

Regards,

Markus

You're resetting the $product_code variable with each iteration. I recommend pushing the new value into an array like so:

Expand|Select|Wrap|Line Numbers

 
$product_codes = array();
 
while (/* mysql */) {

    $product_codes[] = // data

}

Atli

And, once you have them all in an array, if you want that as a comma-separated list, you can use implode.

Expand|Select|Wrap|Line Numbers

$list = implode($product_codes, ",");

Dormilich

info: some PHP classes allow you to directly save the result set into an array without further looping…

phpmagesh

Quote:

Originally Posted by Atli

And, once you have them all in an array, if you want that as a comma-separated list, you can use implode.

Expand|Select|Wrap|Line Numbers

$list = implode($product_codes, ",");

Yeah,

This solved my problem,

Thanks

Regards,

Getting Values from database in array format

re: Getting Values from database in array format

re: Getting Values from database in array format

re: Getting Values from database in array format

re: Getting Values from database in array format

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/about