control problem?
| From: | kmurrah | 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-general+get-32196@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