problems transfering info

[hellz]

hi, hope someone can help. Ive got a page of items brought from database and at the end of each item there is a link saying add to basket. It gives different product id in the address bar when clicking on the link but i cant get it to show on the next page.
The code im using to transfer the info is:
<a href=\"cart.php?ProductId=$row[ProductId]\">Add Item</a>

Then im trying to use the following code to show the item on the next page:

<?php
$dbc = mysql_connect ('******.com','***','***') OR die('Could not connect to MySQL : ' . mysql_error() );
mysql_select_db ('***') OR die('Could not select the database : ' . mysql_error() );

$ProdId = $_GET['ProductId'];
$query = "SELECT * FROM item WHERE ProductId='$Prodid'";

$result =  mysql_query ($query);
$row= mysql_fetch_array($result);
 ?> 


<table width="700" border="0" align="center" cellpadding="5" cellspacing="1" class="entryTable">
  <tr class="entryTableHeader"> 
   <td colspan="2" align="center">Item</td>
   <?php echo $row['Artist'];?>
   <td align="center">&nbsp;Price</td> 
     <?php echo $row['Price'];?>
   <td width="75" align="center">Quantity</td>

<?php echo $row['qty'];?>" />  

<?php echo $row['ProductId'];?>" />
   <td align="center">Total</td>
  <td width="75" align="center">&nbsp;</td>
 </tr>
</table>

Can anyone help me fix the problem?

[heffym]

When you Echo your prodID does anything come up?

I use a similar script which works below

<?php require('connect.php') ?>
<?php
$id= $_GET['id'];
$querystring = "SELECT * FROM ship where id = '$id'";
$tourlist = mysql_query($querystring);
$numrows = mysql_num_rows($tourlist);
for($i=0;$i<$numrows;$i++) {
$row = mysql_fetch_array($tourlist);
print "<tr><td><b><u><FONT color = 'Green'><h3>".$row['customer']."</font></h3></b></u></td></tr>";
}
$customer = $row['customer'];
$CHBI = $row['CHBI'];
$AAFISC = $row['AAFISC'];
$THBU = $row['THBU'];
$PTIW = $row['PTIW'];
$CI = $row['CI'];
$PAI = $row['PAI'];
$CD = $row['CD'];
$UIS = $row['UIS'];
?>

[bradgrafelman]

To get a little more information, try changing this:

$query = "SELECT * FROM item WHERE ProductId='$Prodid'";

$result = mysql_query ($query);
$row= mysql_fetch_array($result);

to this:

$query = "SELECT * FROM item WHERE ProductId='$Prodid'";

$result = mysql_query ($query) or die('MySQL error: ' . mysql_error() . "<hr>Query: $query");
$row= mysql_fetch_array($result);
var_dump($row);

Let us know what the output is (specifically, if an error message is outputted OR the output of the var_dump call).

EDIT: Also, welcome to PHPBuilder, hellz! Just a friendly note: when posting PHP code, please use the board's [noparse]

[/noparse] bbcode tags as they make your code much easier to read and analyze. I already added these tags to your post above, but just keep this in mind for the future!

EDIT2: Woops! I missed something. Carefully examine your code above; you define $ProdId in one place yet you try to use $Prodid in another. Make the capitalization consistent and see if that works.

[hellz]

 $ProdId= $_GET['ProductId'];
$querystring = "SELECT * FROM item where ProductId = '$ProdId'";
$item = mysql_query($querystring);
$numrows = mysql_num_rows($item);
for($i=0;$i<$numrows;$i++) {
$row = mysql_fetch_array($item);
print "<tr><td><b><u><FONT color = 'Green'><h3>".$row['ProductId']."</font></h3></b></u></td></tr>";
}
$ProductId = $row['ProductId'];
$Artist = $row['Artist'];
$Price = $row['Price'];
?> 

Ive used the above code but getting nothing on the page at all. Any Ideas?

[bradgrafelman]

If you're just expecting one item (which would seem to be the case), then having a for() loop and all of that other code is superfluous (and error-prone, as you can see).

Try going back to your original code, making the fix I suggested, and, if that still doesn't work, adding the extra debug information I suggested.

[hellz]

 

$ProdId = $_GET['ProductId'];
$query = "SELECT * FROM item WHERE ProductId='$Proid'";

$result = mysql_query ($query) or die('MySQL error: ' . mysql_error() . "<hr>Query: $query"); 
$row= mysql_fetch_array($result); 
var_dump($row);
 ?> 


<table width="700" border="0" align="center" cellpadding="5" cellspacing="1" class="entryTable">
  <tr class="entryTableHeader"> 
   <td colspan="2" align="center">Item</td>
   <?php echo $row['Artist'];?>
   <td align="center">&nbsp;Price</td> 
     <?php echo $row['Price'];?>
   <td width="75" align="center">Quantity</td>
   	<form name="update_item" method="get"> 
<input type="hidden" name="action" value="update_item" /> 
<input type="hidden" name="id" value="<?php echo $row['ProductId'];?>" /> 
<input type="text" size="6" name="qty" value="<?php echo $row['qty'];?>" /> <input type="submit" value="update" />
</form> 

   <td align="center">Total</td>
  <td width="75" align="center">&nbsp;</td>
 </tr>
</table>
 

Also tried that and that brings up nothing aswell.

[bradgrafelman]

Double check your typing; $Proid isn't the same as $ProdId.

[hellz]

ones proid and ones prodid double checked that lol

[bradgrafelman]

Ok... well did you fix one or the other? Also, try echo'ing out your query and pasting it here.