> -----Original Message----- > From: Jake McHenry [mailto:[EMAIL PROTECTED] > Sent: Monday, October 20, 2003 10:32 PM > To: [EMAIL PROTECTED] > Subject: RE: [PHP] Session migration problem... > > > > -----Original Message----- > > From: Chris Shiflett [mailto:[EMAIL PROTECTED] > > Sent: Monday, October 20, 2003 9:56 PM > > To: Jake McHenry; [EMAIL PROTECTED] > > Subject: Re: [PHP] Session migration problem... > > > > > > --- Jake McHenry <[EMAIL PROTECTED]> 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php