0 Replies Latest reply on Aug 17, 2007 12:49 PM by Newsgroup_User

    What is wrong with my code?

    Level 7
      Hi there.

      DW CS3, PHP mySQL

      I'm trying to create my 3rd results page with the details page, but
      cannot seem to get this one right.

      For a start I have a one criteria search item. The results page works
      100% well, but when clicking on "more details >>" the details of the
      first record is returned. This happens even though when hovering my
      mouse over the "more details >>" link on the results page, it displays
      the correct record id.
      This is the sql statement of the results page:
      SELECT *
      FROM alternators
      WHERE p_KVA LIKE %colname%
      ORDER BY p_KVA ASC
      The Variables are:
      Name: Colname
      Type: Text
      Default Value: %
      Run-time Value: $_GET['p_KVA']

      My details page has a straight forward RecordSet, Select * from DB.

      I will really appreciate your help. I have to have this finish by
      tomorrow.

      Regards,
      Deon