still stuck

symoore22

hi
ive posted a couple of posts recently about this problem and i have made progress but im still having trouble.

Im trying to make the products listed at:
http://www.bluetipdvd.co.uk/index.php

be a link that opens a new window to display details about that particular product.

If you click on the links you will see that address of the new smaller window is based on the product ID but there is an error message.

please help

thanks

simon

the unexpected T_VARIABLE is coming from this line
$sql= "SELECT name, longdescription, ID, price FROM products WHERE ID = $ID";

an the code for that page is:
<body>
<?php include "vsadmin/db_conn_open.php";

$ID = $_GET['ID']
$sql= "SELECT name, longdescription, ID, price FROM products WHERE ID = $ID";

$result=mysql_query($query);
$num=mysql_num_rows($result);

mysql_close();

?>
<table width="100%" height="59" border="0" cellpadding="1" cellspacing="1">
<tr>
<td><? echo "$ID"?> </td><td><? echo "$name"?></td><td><? echo "$longdescription"?></td>
</tr>
</table>

</body>
</html>

rlafountain

Try this:

$sql = "SELECT name, longdescription, ID, price FROM products WHERE ID = '$ID' ";

kburger

It's the line above. You left off the semicolon.

$ID = $_GET['ID'];

symoore22

thanks for such prompt action - some progress has been made.

the changes suggested have fixed the initial problem but it now says that:

this line:
$num=mysql_num_rows($result);

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/bluetip/public_html/longprod.php on line 19

progress has been made despite this because the new window that popsup is displaying the relevant ID.

kburger

$sql= "SELECT name, longdescription, ID, price FROM products WHERE ID = $ID";
$result=mysql_query($query);
$num=mysql_num_rows($result);

should be this:

$sql= "SELECT name, longdescription, ID, price FROM products WHERE ID = $ID";
$result=mysql_query($sql);
$num=mysql_num_rows($result);

edit: oops - I originally had a typo

symoore22

great thats worked

can i just say i have posted on a few forums on the web and you have been the most help easily - it only took 5 mins.

im sure i will be back in the not to distant future.