php - store multiple row result from mySQL left join query as one variable -

php - store multiple row result from mySQL left join query as one variable -

i new php , mysql. have left bring together query using find products client has registered. query works in phpmyadmin, , can echo in php next code:

$custprods = "select t.prodtype, s.sizes, c.color registeredproducts p left bring together prodtypes t on t.id = p.prodtype left bring together prodsizes s on s.id = p.prodsize left bring together prodcolors c on c.id = p.prodcolor p.customerid = '".$thiscust."'"; $allcustprods = mysql_query($custprods); while($prodrow = mysql_fetch_array($allcustprods)){ echo $prodrow['prodtype']. " - ". $prodrow['sizes']. " - ". $prodrow['color']; echo "<br />"; }

however, don't want echo user see, want store result in variable later use. have tried doing instead:

while($prodrow = mysql_fetch_array($allcustprods)){ $allprods = $prodrow['prodtype']. " - ". $prodrow['sizes']. " - ". $prodrow['color']; }

but gives me recent row inserted instead of results. same using my_fetch_assoc seen here. have tried this:

while($prodrow = mysql_fetch_array($allcustprods)){ $allprods = array($prodrow['prodtype']. " - ". $prodrow['sizes']. " - ". $prodrow['color']); }

which echos 'array'. followed this post , used print_r($allprods); 1 time 1 time again gave me lastly inserted row. have spent hours researching , grateful help. give thanks you.

i figured out , wanted post in case 1 else has issue. needed declare $allprods array, , utilize array_push store each instance. used implode store 1 variable later use.

$custprods = "select t.prodtype, s.sizes, c.color registeredproducts p left bring together prodtypes t on t.id = p.prodtype left bring together prodsizes s on s.id = p.prodsize left bring together prodcolors c on c.id = p.prodcolor p.customerid = '".$thiscust."'"; $allcustprods = mysql_query($custprods); $allprods = array(); while($prodrow = mysql_fetch_assoc($allcustprods)){ array_push($allprods, $prodrow['prodtype']. " - ". $prodrow['sizes']. " - ". $prodrow['color']); } $custprods = implode('<br>', $allprods);

php mysql arrays