Resource ID#2 ????

From: Date: Wed, 29 May 2002 16:17:34 +0000
Subject: Resource ID#2 ????
Groups: php.db 
Request: Send a blank email to php-db+get-19494@lists.php.net to get a copy of this message
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. johndoe@email.com</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%\">&nbsp;</td><td width=\"80%\"><input type=\"submit\" name=\"add\" value=\"edit user\">&nbsp;&nbsp;<input type=\"reset\" name=\"reset\" value=\"reset\"></td></tr> </form></table>"; echo $record; } else { blah blah } Thanks in advance, Jas

« previous php.db (#19494) next »