Need to define variable using a do/while statement

[webproclaim]

I need some help declaring a varialbe using data generated from a database using a do/while statment.

Let me clarify what I am doing...

<?php do echo "'".($row_rcdAlsoPurchased['fldOrderID'])."', "; while ($row_rcdAlsoPurchased = mysql_fetch_assoc($rcdAlsoPurchased)); ?>

This code prints this in the browser: '3e9482f663032', '3e820bf72fe41',

I need to create a variable ($test) and have it have the value of '3e9482f663032', '3e820bf72fe41', using the do/while loop pulling the information from the database.

The above code above prints to the browser just fine. I just can't figure out out to assign the same value to a variable. I tried the code below but I get a parse error. Any ideas?

<?php $test = do echo "'".($row_rcdAlsoPurchased['fldOrderID'])."', "; while ($row_rcdAlsoPurchased = mysql_fetch_assoc($rcdAlsoPurchased)); ?>

[eoghain]

<?php
   $test = '';
   do {
      $test = $row_rcdAlsoPurchased['fldOrderID'];
      echo "'".($row_rcdAlsoPurchased['fldOrderID'])."', ";
   } while ($row_rcdAlsoPurchased = mysql_fetch_assoc$rcdAlsoPurchased));
?>

Change your do..while from a single line into a code block. Personally I believe you should always used code blocks instead of one liners.

Ofcourse this will leave $test populated with the last rows value for fldOrderID. If you want to have all of them stored then you need to store them in an array:

<?php
   $test = array()
   do {
      $test[] = $row_rcdAlsoPurchased['fldOrderID'];
      echo "'".($row_rcdAlsoPurchased['fldOrderID'])."', ";
   } while ($row_rcdAlsoPurchased = mysql_fetch_assoc$rcdAlsoPurchased));
?>

[webproclaim]

I'm not getting the result I'm looking for.

<?php
$test = array();
do {
$test[] = $row_rcdAlsoPurchased['fldOrderID'];
echo "'".($row_rcdAlsoPurchased['fldOrderID'])."', ";
} while ($row_rcdAlsoPurchased = mysql_fetch_assoc($rcdAlsoPurchased));
?>

This code displays my data on the page.

<?php echo $test ; ?>

This code just displays 'array'

I need the string the first block of code is printing to the screen to be written to the $test variable. I'm reall ynot trying to end up with an array. I just want a simple string containing the data.

Thoughts?

[matt_4013]

I don't really see what you're trying to do. From what I can tell, you want to get the first row from your database and put it into a variable, yes?

$test = $row_rcdAlsoPurchased['fldOrderID'];

do {
echo "'".($row_rcdAlsoPurchased['fldOrderID'])."', ";
} while ($row_rcdAlsoPurchased = mysql_fetch_assoc($rcdAlsoPurchased));

Or did you want it to do it every time, and overwrite each time it loops?

do {

$test = $row_rcdAlsoPurchased['fldOrderID'];
echo "'".($row_rcdAlsoPurchased['fldOrderID'])."', ";
} while ($row_rcdAlsoPurchased = mysql_fetch_assoc($rcdAlsoPurchased));

[eoghain]

Matt's first code example is what you are looking for.

[suntra]

He just doesn't know how to print the array...

Here's how

<?
foreach($test as $strValeur) {
     echo $strValeur . "<BR/>\n";
}
?>