I am trying to get a row from a table based on the record number, a unique ID in a table which is passed from another form. The record number seems to be passed correctly and is received on the forwarding page. The query in the PHP page does not bring up values in the receiving page although the query works when tried from an external application. Below is a listing of the PHP code. Could some one point out what I am doing incorrectly. Thanks!
<?php include("connect.php"); $id = $_GET['id']; $qProfile = "SELECT * FROM signers WHERE recordNum='$id' "; $rsProfile = mysql_query($qProfile); $row = mysql_fetch_array($rsProfile); extract($row); $recordnum = stripslashes($recordnum); $firstmiddlename = stripslashes($firstmiddlename); $lastname = stripslashes($lastname); … … mysql_close();?>