RE: [PHP] Session migration problem...
| From: | Jake McHenry | Date: | Tue, 21 Oct 2003 03:06:10 +0000 |
| Subject: | RE: [PHP] Session migration problem... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-166875@lists.php.net to get a copy of this message | ||
> -----Original Message-----
> From: Jake McHenry [mailto:linux@nittanytravel.com]
> Sent: Monday, October 20, 2003 10:32 PM
> To: php-general@lists.php.net
> Subject: RE: [PHP] Session migration problem...
>
>
> > -----Original Message-----
> > From: Chris Shiflett [mailto:shiflett@php.net]
> > Sent: Monday, October 20, 2003 9:56 PM
> > To: Jake McHenry; php-general@lists.php.net
> > Subject: Re: [PHP] Session migration problem...
> >
> >
> > --- Jake McHenry <linux@nittanytravel.com> wrote:
> > > $result = mysql_query("SELECT * FROM
users
> > > WHERE uname =
> > > '".$_POST['username']."'");
> >
> > Don't put uname in single quotes. Aside from that, don't
> > forget that you can interpolate variables with curly braces.
> > Depending on your personal preference, you might find it
> > easier to read:
> >
> > "select * from users where uname = '{$_POST['username']}'"
> >
> > Hope that helps.
> >
> > Chris
> >
> > =====
> > My Blog
> > http://shiflett.org/
> > HTTP Developer's Handbook
> > http://httphandbook.org/
> > RAMP Training Courses
> > http://www.nyphp.org/ramp
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
> I took the single quotes off of the field name, uname, but still
> getting the same error at the same line in the file...
>
> Any other suggestions?
>
>
> Thanks,
>
> Jake McHenry
> Nittany Travel MIS Coordinator
> http://www.nittanytravel.com
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
HAHA.. Sorry everyone.... I found my problem... The field name in the
table is username, not uname.... I guess I must have changed that as
well. My head is spinning from all the stuff I'm trying to change...
My only other question is can I change from '".."' to
".."? When I
try to run a query on the table name, it has to be within `` instead
of ''. I just tried it, it looks like it works... Just want to make
sure this is ok.
Thanks,
Jake