I could be missing something, but it looks like you are using the result of the mysql_query as the actual result. It actually returns some weird identifier. To access the real info you'd have to use something like mysql_fetch_array to get it.
Check out this and see if it helps: http://www.php.net/manual/en/function.mysql-query.php -Natalie -----Original Message----- From: Jas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 12:18 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Resource ID#2 ???? Ok here is my problem, I set this up so a user selects a name form a select box and that name or $user_id is then passed to this page so the user can edit the contact info etc. However it does not pull the selected $user_id and place each field into my form boxes, all I get is a Resource ID #2. Not sure how I can over come this... $table = "auth_users"; $record = @mysql_query("SELECT * FROM $table WHERE user_id = '$user_id'",$dbh); $var_form .= "<table width=\"100%\" border=\"0\" cellpadding=\"7\"><form name=\"$user_id\" method=\"post\" action=\"del_account.php\"> <tr><td width=\"20%\" colspan=\"2\"><b>Edit Account $user_id</b></td></tr> <tr><td width=\"20%\">First Name:</td><td width=\"80%\"><input type=\"text\" name=\"$f_name\" size=\"30\" maxlength=\"30\" value=\"$f_name\"><font class=\"copyright\">i.e. John</font></td></tr> <tr><td width=\"20%\">Last Name:</td><td width=\"80%\"><input type=\"text\" name=\"$l_name\" size=\"30\" maxlength=\"30\" value=\"$l_name\"><font class=\"copyright\">i.e. Doe</font></td></tr> <tr><td width=\"20%\">Email:</td><td width=\"80%\"><input type=\"text\" name=\"$email_addy\" size=\"30\" maxlength=\"30\" value=\"$email_addy\"><font class=\"copyright\">i.e. [EMAIL PROTECTED]</font></td></tr> <tr><td width=\"20%\">User Name:</td><td width=\"80%\"><input type=\"text\" name=\"$un\" size=\"30\" maxlength=\"30\" value=\"$un\"><font class=\"copyright\">i.e. j-doe</font></td></tr> <tr><td width=\"20%\">Password:</td><td width=\"80%\"><input type=\"password\" name=\"$pw\" size=\"30\" maxlength=\"30\"><font class=\"copyright\">(password must be alpha-numeric, i.e. pAs5w0rd)</font></td></tr> <tr><td width=\"20%\">Confirm Password:</td><td width=\"80%\"><input type=\"password\" name=\"$pw\" size=\"30\" maxlength=\"30\"><font class=\"copyright\">please confirm password entered</font></td></tr> <tr><td width=\"20%\"> </td><td width=\"80%\"><input type=\"submit\" name=\"add\" value=\"edit user\"> <input type=\"reset\" name=\"reset\" value=\"reset\"></td></tr> </form></table>"; echo $record; } else { blah blah } Thanks in advance, Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
