content merging

cjgdesign

HI All.. First off, thank you very much for the help thus far! I don't think that I explained my problem real well, so I'll try again...

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

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

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

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

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

The above is only assigning the account 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 account numbers for the name Mark Ridley. So, for example, if i echo for variable $test, it will give me 11111111, 33333333. I'd sure appreciate any assistance! Thanks..

Sore

Sorry if I don´t understand you corectly.
If you want to make a string variable of the ids you can just add them up with

$a = "a";
$a .= "b";

otherwise you can put them into an array like

while...{
$test[$number]=$rowarray[adv_number];
$number++;
}

But I dont knowe if I understood you correct.

DoD

$result = mysql_query("SELECT * FROM advantage WHERE lname='$lname' AND phone='$phone_original' "); 

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

This loops the variable, so for instance the first loop its 111, then on the second, it will become 111 222 etc

Hopefully it works 🙂