Hey there,

I am trying to create a link between two tables so that a parsed php record set from one page acts as the variable for one table which is then put into the other as the filter

page 1 ---> abc.php?recordID=99
page2 ---> def.php --->dataset

In effect the code would be literally (not necessarily right tho)

SELECT *

FROM products

WHERE products_id = <?php echo $row_catprodswitch['products_id']; ?>

is there a way to successfully code this?

Thanks

Thanks got it using a join string