Done the query, made a table, but now..

[cheese]

Hi again all,

😃
So, I have created a nice looking table on a page so that the customer can see what we have available, but now I want to be able to allow the customer to click on one of the items in the table and have that go and query the database for a 'Full' description of the item in the table.

😕
I suppose I am asking how do you make a hyperlink query a database.

:rolleyes:
Thanks for any help.

Neil.

[kevinsequeira]

try this

<a href="description.php?product_id=3">product 3</a>

//description.php

$id = $_GET['product_id'];

$query = "select * from products where id =".$id;
.
.
.
.

reg
kevin

[cheese]

Thanks Kev,

By the time I read your post I had figured a similar method. I used;

print "<td bgcolor=#B2B3F0><A HREF=awaitingmoreinfo.php?whr=";
print $col1;
print $col2;
print ">";

Then just used GET on the next page to do the work like this;

$warehouseprefix = substr($GET[whr],0,2);
$warehouseref = substr($GET[whr],2);

    /* Connecting, selecting database */
  $link = odbc_connect("mydatabase","sa","",""); 

$row = odbc_exec($link,"SELECT Consignments.ReceiverCode, .............................etc........ FROM Consignments INNER JOIN Publishers ON Publishers.PublisherCode = Consignments.PublisherCode WHERE (((Consignments.Prefix)='$warehouseprefix') AND ((Consignments.WRef)='$warehouseref'))");

This selects the record to produce a table from.

Regards,

Neil.