People use to suppress errors / warning messages....I know I use it a lot 
with obdc and SQL SERVER procedures...


At 02:32 PM 5/30/2002 -0400, Leotta, Natalie (NCI/IMS) wrote:
> From what I've seen on the site, it doesn't look like people use the
>@ in @mysql_query, and I know that I don't use it for sybase_query.  Where
>did it come from?
>Assuming that's not the problem, I'd try printing out everything.  Right
>after your while, print $row - it should say "array", then try printing
>$row[0] and see if that works.  Then try printing $row['user_id'].
>You may also want to try doing a SELECT with the fieldnames, instead of just
>the *.  Also, make sure you're typing the field names correctly - they are
>case sensitive.
>Hopefully one of these suggestions will help you.
>-----Original Message-----
>From: Jas [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, May 30, 2002 2:18 PM
>Subject: Re: Re[2]: [PHP-DB] how to pull array out?
>Ok, given there are people out there that expect people to "do the work for
>them", however if you look at my original post (today) you will see that I
>have queried the database, feed the results into an array, then called the
>array elements into my form, however simple this may be for you it is still
>not pulling out the results of the array into my form.  I do believe I am
>missing something, and doing homework is a part of my everyday routine
>trying to develop web based apps.  The code again:
>$table = "auth_users"; // names the table to query correct?
>  $record = @mysql_query("SELECT * FROM $table WHERE user_id =
>'$user_id'",$dbh); // pulls all records in relation to $user_id correct?
>    while ($row = mysql_fetch_array($record)) { // pulls results of query
>into an array correct?
>     $user_id = $row['user_id']; // assigns unique names for my different
>editable regions correct?
>     $f_name = $row['f_name'];
>     $l_name = $row['l_name'];
>     $email_addy = $row['email_addy'];
>     $un = $row['un'];
>     $pw = $row['pw']; }
>     $var_form .= <form name=\"$user_id\" method=\"post\"
>       <b>Edit Account $user_id</b><br> // echoes the $user_id that is going
>to be edited correct?
>     First Name:<input type=\"text\" name=\"f_name\" size=\"30\"
>maxlength=\"30\" value=\"$f_name\"><br> // displays text box to edit with
>$f_name variable from resulting array correct?
>     Last Name:<input type=\"text\" name=\"l_name\" size=\"30\"
>maxlength=\"30\" value=\"$l_name\"><br> // displays text box to edit with
>$l_name variable from resulting array correct?
>     Email:<input type=\"text\" name=\"email_addy\" size=\"30\"
>maxlength=\"30\" value=\"$email_addy\"><br> // displays text box to edit
>with $email_addy variable from resulting array correct?
>     User Name:<input type=\"text\" name=\"un\" size=\"30\" maxlength=\"30\"
>value=\"$un\"><br>  // displays text box to edit with $un variable from
>resulting array correct?
>     Password:<input type=\"password\" name=\"pw\" size=\"30\"
>maxlength=\"30\"><br> // displays text box to edit with $pw variable from
>resulting array correct?
>     Confirm Password:<input type=\"password\" name=\"cpw\" size=\"30\"
>     &nbsp;<input type=\"submit\" name=\"add\" value=\"edit
>user\">&nbsp;&nbsp;<input type=\"reset\" name=\"reset\" value=\"reset\">";
>Any help or examples are appreciated.  Please understand I am trying to
>learn this scripting language and RTFM does not help as most of the time I
>post here as a LAST resort, i.e. after I have indeed RTFM'ed.
>Thanks again,
>"Julie Meloni" <[EMAIL PROTECTED]> wrote in message
> > Jas (and anyone else) -
> >
> > With all due respect, you're acting like a troll.  Posting a question,
> > getting MANY correct answers, then reposting the question and bitching
> > about not understanding the answers, well, that's troll-like.
> >
> > Granted, many responses on this list over the past while have been
> > sarcastic, but usually also have the answer in them.  The tone comes
> > from people asking the questions not doing their own homework.
> >
> > e.g.
> >
> > Mailing lists such as this one are not intended to give people
> > verbatim answers to their problems, such as "I have to write an
> > application for my university class, please do it for me" and the
> > like.  Instead, these lists will help those who attempt to help
> > themselves.
> >
> > The fact of the matter is, RTFM is the right answer.  The very
> > simplistic method of reading the results of a MySQL query are right
> > there in the manual, in the MySQL query functions section.  Also,
> > they're in zillions of tutorials, any basic book on PHP, and so on.
> >
> > In short:
> >
> > 1) connect to db server -- mysql_connect()
> > 2) select db -- mysql_select_db()
> > 3) issue query -- mysql_query()
> > 4) from there you get a result identifier.  You feed that into
> > mysql_result() or mysql_fetch_array() or mysql_fetch_row()
> >
> > Read the manual for the differences -- including examples.
> >
> >
> > You say:
> > J> rest of us we rely on examples, etc to get it done.
> >
> > They ARE in the manual, which is pretty much the best manual out there
> > for just about anything.
> >
> > Good luck,
> > - Julie
> >
> > --> Julie Meloni
> > -->
> >
> > Find "Sams Teach Yourself MySQL in 24 Hours" at
> >
> >
>PHP Database Mailing List (
>To unsubscribe, visit:
>PHP Database Mailing List (
>To unsubscribe, visit:

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to