variable merging

[cjgdesign]

Hey everyone... I tried the suggestions that you gave me Sore & DoD... Thank you, but it didn't work... So, here I am back again looking for some more assistance... Any help that some one can give, would be greatly appreciated..

This is my situation...
In my database i have for example information stored like so (the hyphens are just so that you know the distinction between the field entries):

Ridley - 888-999-9999 - 11111111
Houston - 888-666-6666 - 22222222
Ridley - 888-999-9999 - 33333333

Ok, now.. This is what I currently have for my code:

$result = mysql_query("SELECT card_number FROM advantage WHERE name='Ridley' AND phone='888-999-9999' ");

while ($rowarray = mysql_fetch_array($result))
{
$test=$rowarray[card_number];
}
echo " $test ";

The above is only assigning the card number 11111111 to the variable $test because it is the first entry in the database with his information. I need to somehow make the variable $test echo all of the card numbers for the name Ridley. So, for example, if i echo for variable $test, it will give me 11111111, 33333333.

Again.. thanks for any assistance!

[bastien]

what you need to do is see how many elements are returned in the array and then combine them

while ($rowarray = mysql_fetch_array($result))
{
if(mysql_num_rows($result)=1){
//for only one result you want jus the number

$test=$rowarray[card_number];
}else{

$x=1; //set a counter to add elements correctly
if($x=1){
$test=$rowarray[card_number];
$x++; //add one to counter
}else{
//add the next result and separate with a comma to the var $test
$test=$test.",".$rowarray[card_number];
}
echo " $test ";

hth

[svnfightsvn]

try:

$test = "";
while ($rowarray = mysql_fetch_array($result)) 
{
  $test .= $rowarray[card_number].", "; 
} 
echo " $test ";

I even so - test should be outputting the last cardnumber encountered - 33333333 - in your example because you are looping through the result set, assigning the value of the array to $test each time, and then outputting the variable after the loop is through.