Variable not passing ... can't see why

tanaka99

Can anyone identify why the 'id' variable in the Add Item line is not passing? On the address line of browser its null. the ItemId variable is setup in the table ...

Here's my code:

<?php

// This page will list all of the items
// from the prices table. Each item will have
// a link to add it to the cart

include("db.php");

// Get a connection to the database
$cxn = @ConnectToDb($dbServer, $dbUser, $dbPass, $dbName);
$result = mysql_query("select * from prices order by partno asc");
?>
	<html>
	<head>
	<title> Product List </title>
	</head>
	<body bgcolor="#ffffff">
	<h1>Products</h1>
	<table width="760" cellspacing="0" cellpadding="0" border="0">
		<tr>
			<td bgcolor="red">
				<font face="verdana" size="1" color="white">
					&nbsp;&nbsp;<b>Part No.</b>
				</font>
			</td>
			<td bgcolor="red">
				<font face="verdana" size="1" color="white">
					<b>Description</b>
				</font>
			</td>
			<td bgcolor="red">
				<font face="verdana" size="1" color="white">
					<b>Price</b>
				</font>
			</td>
			<td bgcolor="red">
				<font face="verdana" size="1" color="white">
					&nbsp;&nbsp;<b>Stock Code</b>
				</font>
			</td>
			<td bgcolor="red">
				<font face="verdana" size="1" color="white">
					&nbsp;&nbsp;<b>Disc. Code</b>
				</font>
			</td>
			<td bgcolor="red">
				<font face="verdana" size="1" color="white">
					&nbsp;&nbsp;<b>Latest Rev</b>
				</font>
			</td>

			<td bgcolor="red">
				<font face="verdana" size="1" color="white">
					<b>Add</b>
				</font>
			</td>
		</tr>
		<?php
		while($row = mysql_fetch_array($result))
		{
		?>
			<tr>
				<td>
					<font face="verdana" size="1" color="black">
						<?php echo $row["partno"]; ?>
					</font>
				</td>
				<td>
					<font face="verdana" size="1" color="black">
						$<?php echo $row["desc"]; ?>
					</font>
				</td>
				<td>
					<font face="verdana" size="1" color="black">
						<?php echo $row["price"]; ?>
					</font>
				</td>
				<td>
					<font face="verdana" size="1" color="black">
						<?php echo $row["stkcode1"]; ?>
					</font>
				</td>
				<td>
					<font face="verdana" size="1" color="black">
						<?php echo $row["disccode"]; ?>
					</font>
				</td>
				<td>
					<font face="verdana" size="1" color="black">
						<?php echo $row["lrev"]; ?>
					</font>
				</td>
				<td>
					<font face="verdana" size="1" color="black">
						<a href="dealers/cart.php?action=add_item&id=<?php echo $row["itemId"]; ?>&qty=1">Add Item</a>
					</font>
				</td>
			</tr>
			<tr>
				<td width="760" colspan="7">
					<hr size="1" color="red" NOSHADE>
				</td>
			</tr>
		<?php
		}
	?>
		<tr>
			<td width="760" colspan="7">
				<font face="verdana" size="1" color="black">
					<a href="index.php?t=1&d=5&b=cart">Your Shopping Cart &gt;&gt;</a>
				</font>
			</td>
		</tr>
	</table>
</body>
</html>

dbchip2000

I don't know if this matters, but you said that the id field was "ItemID" and below, you echoed it $row["itemID"] with a lower case I. Also, make sure on your dealers/cart.php file that it is checking for the Get variable of it and not the Post, $_GET["id"].
If neither of those help, a hint of debugging is to view the source of the actual output. Then you can see if the <?php echo $row["itemID"]; ?> part works. If it prints it, you know it is a problem farther along in cart.php

trooper

change

 $cxn = @ConnectToDb($dbServer, $dbUser, $dbPass, $dbName); 
    $result = mysql_query("select * from prices order by partno asc");


 $cxn = ConnectToDb($dbServer, $dbUser, $dbPass, $dbName) or die(mysql_error()); 
    $result = mysql_query("select * from prices order by partno asc") or die(mysql_error());

That way if there are any problems with the connection (which i suspect there is) then you'll get an appropriate error message

by putting the @ in front of the function call you are supressing any error which makes debuging very very hard

HTH

tanaka99

the typo in case was it. Thanks.

trooper

great glad you sorted it

can you close this thread now then so that others can see that it has been resolved.

tanaka99

I've tried 5 times. It doesn't mark resolved. Does it take a few minutes to kick in?