Need help on php/mysql query echoing?

M

Mark

New member
here is the code, it displays the first row to that persons id, but how can I make it to show on all user_id's

<?php
$user_id = $userinfo['user_id'];
$query = @mysql_query("SELECT * FROM sales WHERE user_id ='$user_id'") or die(mysql_error());
$donate = @mysql_fetch_array($query);

if($donate['product'] == donation){

echo '<font color = "green"><b><br />$ '; ?>
<?php
echo $donate['amount_paid'];
echo '</b></font>';
}
?>
 
for all user_id in the table

$query = mysql_query("SELECT * FROM sales");
while($info = mysql_fetch_assoc($query)){
extract($info);
echo "<font color=\"green\">$field_name</font><br>";
}

or for all donations just by 1 user_id

$query = mysql_query("SELECT * FROM sales WHERE user_id='$userinfo[user_id]'");
while($info = mysql_fetch_assoc($query)){
extract($info);
echo "<font color=\"green\">$field_name</font><br>";
}
 
Back
Top