<?php
$query1 = "SELECT `asc_prods.name` FROM `asc_prods` LEFT JOIN `democart` ON `asc_prods.pid` = `democart.tip`;";
$result1 = mysql_db_query($query);
while($row1 = mysql_fetch_array($result1)) {
echo "<td> {$row1[0]} </td>";
}
?>
I've got the above code, the problem I have with it is that I need to get the value returned by the statement $query1 into a table datacell, and frankly I don't know how to do it. When I execute it in the phpmyadmin it returns the rows as expected. Now the problem is that before I insert them in the above mentioned datacell I have to separate them somehow (they are in the order I want them to be, so this is the only problem, actually two problems). Hope someone can help me.