0 Replies Latest reply on Oct 1, 2007 12:49 PM by SyKeSnr1

    Insert vairable in statement from different recordset

    SyKeSnr1 Level 1

      The situation is as follows:

      I have 2 recordsets on 1 page that both get their information from the same table named products.

      For recordset 2 I have this php statement:
      $query_Recordsset2 = "SELECT * FROM products WHERE Productsubcategorie = 'echo $Recordset1[Productsubcategorie]' ORDER BY Invoerdatum DESC";

      As you can see, i want to give it the productsubcategory of the first recordset. however, this statement gives me an empty field. No information is now shown. What am i doing wrong? When I maunally input the productsubcategory it does work...