control problem?

From: Date: Fri, 29 Dec 2000 16:20:29 +0000
Subject: control problem?
References: 1  Groups: php.db php.general 
Request: Send a blank email to php-db+get-5503@lists.php.net to get a copy of this message
Greetings: Could someone help me? I'm having a problem with the following code: ----------------------------- if ($row = mysql_fetch_array($result)) { do { print "<tr>"; print "<td>"; $transaction=$row["transaction"]; echo "<a href=\"www.bakergrfx.com/hsb/select_transaction.php?transaction='$transactio n'>"; print $transaction; print "</a><td>"; print $row["order_number"]; print "<td>"; print $row["product_code"]; print "<td>"; print $row["description"]; print "<td>"; print $row["quantity_ordered"]; print "<td>"; print $row["date_shipped"]; } while($row = mysql_fetch_array($result)); } else {print "Sorry, no records were found!";} ----------------------------- Here's what happens: I expect a list of all transactions in my database, each of them hyperlinked. It works perfectly until the LAST line, at which point the code is broken, and instead of Transaction 29 (hyperlinked),I get the following: <a href="www.bakergrfx.com/hsb/select_transaction.php?transaction='29'>29 Can anyone tell me what I'm doing wrong? Thanks so much in advance, Ken

« previous php.db (#5503) next »