Hi Eric
What is the query variable? Is that the table names and columns?
I have no idea how to understand the code I have just pasted, I general use the dreamweaver recordset user interface. I'm not sure how to change the code or even to know which part of the code is incorrect
$Paramperson_id_WADApeople = "-1";
if (isset($_GET['person_id'])) {
$Paramperson_id_WADApeople = (get_magic_quotes_gpc()) ? $_GET['person_id'] : addslashes($_GET['person_id']);
}
mysql_select_db($database_connElite, $connElite);
$query_WADApeople = sprintf("SELECT person_id, person_cat_id, salutation_id, firstname, lastname, address, city, postcode, mobile, email, telephone, fax, username, password, password_hint, newsletter_id, user_level FROM people WHERE person_id = %s", GetSQLValueString($Paramperson_id_WADApeople, "int"));
$WADApeople = mysql_query($query_WADApeople, $connElite) or die(mysql_error());
$row_WADApeople = mysql_fetch_assoc($WADApeople);
$totalRows_WADApeople = mysql_num_rows($WADApeople);?>
my table name is people
the primary key is person_id
Many Thanks