transfering data

[Hellz]

<td><"a href=cart.php?ProductId=$row[ProductId]">Add Item</a></td>

 

Im trying to get the above code to transfer data from one page to another. I have different items for sale on the sales page, the information comes from a database and i want it to transfer the data from a selected item onto the cart page.

 

I thought the above code would put a link on the sale page saying Add item at the end of each item information that has been brought from the database. Then when the user clicks on the link it will take them to the cart page and i then want it to display the information for the item they selected.

 

I was also wondering what the code would be that i would put on the cart page to show the information that i have transferred?

 

Any help would be greatly appreciated

[micah1701]

for starters, your HTML has the "quotes" in the wrong place, and your PHP is not in between PHP tags.

 

you need something like:

 

<td><a href="cart.php?ProductId=<?php echo $row[ProductId]; ?>">Add Item</a></td>

[Hellz]

<?php

 

$dbc = mysql_connect ('bbp.webcontrolcenter.com','****','****') OR die('Could not connect to MySQL : ' . mysql_error() );

mysql_select_db ('***') OR die('Could not select the database : ' . mysql_error() );

 

 

$query = "SELECT * FROM item WHERE sale='yes'";

$result =  mysql_query ($query);

 

?>

<table>

  <tr>

    <td ><strong>Artist Name</strong></td>

    <td ><strong>Album Name </strong></td>

    <td ><strong>Price </strong></td>

    <td ><strong>Product Description</strong></td>

      <td ><strong>Image</strong></td>

          <td ><strong>Add to Basket</strong></td>

  </tr>

 

<?php

 

while($row = mysql_fetch_array($result,MYSQL_ASSOC))

{

Echo "<tr><td>$row[Artist]</td><td>$row[Album] </td><td>$row[Price]</td><td>$row[ProductDesc]</td><td><img src=$row[image] /><td><"a href=cart.php?ProductId=$row[ProductId]">Add Item</a></td>

</tr>\n";

 

}

mysql_close();

?>

 

</table>

 

^^ that is all my current code

 

[micah1701]

again, your quotes in the HTML are partially to blame, try:

<?php //.....
echo "<tr><td>$row[Artist]</td><td>$row[Album] </td><td>$row[Price]</td><td>$row[ProductDesc]</td><td><img src=$row[image] /><td><a href=\"cart.php?ProductId=$row[ProductId]\">Add Item</a></td>
</tr>\n";

//.... ?>

 

I moved the " in your <a> tag to after the href=  and then I \escaped it so it would screw up the quote marks that your echo statement is in

[Hellz]

yea that works and transfers itas it says in the address bar. How do i then get it to display that item on the page?

[Hellz]

<?php

 

$dbc = mysql_connect ('bbp.webcontrolcenter.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=do_query($query);

$row= mysql_fetch_array($result);

 

echo "Artist . " $row['Artist] . "<br/>";

echo "Album . " $row['Album'] . "<br/>";

 

?>

 

^^ Thats the code i got atm to show the result on the cart page but it does not work.

[ober]

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

 

Try that.  If $Prodid is not an integer, you need to surround it in single quotes:

 

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

 

You should also clean the input (the user can alter anything in the $_GET global array).

[Hellz]

that doesn't work, i just get a blank screen, no banner or navigation either.

any other ideas?