Re: Resource ID#2 ????
| From: | Jas | Date: | Wed, 29 May 2002 16:41:11 +0000 |
| Subject: | Re: Resource ID#2 ???? | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-19498@lists.php.net to get a copy of this message | ||
If you look at the previously posted code at the bottom of the form there is
a echo for the sql select statement that is echoing "Resource id #2" on the
page. Now that error is the correct field id number in the database, I am
just not sure how to itemize the data from that table, at least I think.
Any help would be great!
Jas
"Jason Wong" <phplist@gremlins.com.hk> wrote in message
news:200205300033.39109.phplist@gremlins.com.hk...
> On Thursday 30 May 2002 00:17, Jas wrote:
> > 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);
>
> Make liberal use of error checking (see manual) and mysql_error().
>
> --
> Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
> Open Source Software Systems Integrators
> * Web Design & Hosting * Internet & Intranet Applications Development *
>
>
> /*
> grep me no patterns and I'll tell you no lines.
> */
>