[SOLVED] weird problem in small script

[aebstract]

I don't get it :/ I have a column called payment, which is either 'credit' or '30Day' and right now I have this script:

 

$result = mysql_query("SELECT * FROM p_orders WHERE customer_id='$id' ORDER BY id DESC") or DIE(mysql_error());
      while($r=mysql_fetch_array($result))
      {

      $invoice=$r["id"];
      $orderdate=$r["order_date"];
      $po=$r["po"];
      $orderdate = explode(' ', $orderdate);
      $orderdate = $orderdate[0];
      $payment=$r["payment"];
      $payed=$r["payed"];


if ($payment == 'credit'){
if ($payed == 0){
$paynow = "<a href=\"$payment\"><font color=\"red\">(pay)</font></a>";
}
}
$row_color = ($row_count % 2) ? $color1 : $color2;

$order_history .= "<tr class=\"tableRowCursor\" style=\"background-image: url($row_color);\" onclick=\"DoNav('index.php?page=myorders&invoice=$invoice');\"><td>$orderdate</td><td></td><td>i$invoice $paynow</td><td></td><td>$po</td></tr>";

$row_count++;

      }

 

Which is placing all my rows from the database, correctly. However, the bit about the payment deal:

 

if ($payment == 'credit'){
if ($payed == 0){
$paynow = "<a href=\"$payment\"><font color=\"red\">(pay)</font></a>";
}
}

 

It is displaying a link beside every item except the first one and every single item is saying credit, when half of them are 30Day in the database.. any ideas?

[aebstract]

nvm this was just me being stupid in the morning. The variable $paynow is staying set every time around ;(

[PFMaBiSmAd]

You need to initialize $paynow to an empty string before your logic that sets it to the link so that it will only be set to the link when the correct conditions exist.