Current location: Hot Scripts Forums » Programming Languages » PHP » SQL Problem !HELP


SQL Problem !HELP

Reply
  #1 (permalink)  
Old 06-25-04, 11:17 AM
landboy landboy is offline
Newbie Coder
 
Join Date: May 2004
Posts: 35
Thanks: 0
Thanked 0 Times in 0 Posts
SQL Problem !HELP

Hello,
I am making a clan payment system.
I am working on the login/register part. Frist. When i try to login it says
Unknown column 'boob' in 'where clause'
I have inserted a column boob in the db

here is the part of the code which does that error:
PHP Code:

/* Select user from database */

$find "SELECT * FROM clanpay_users WHERE username=$username & password=$password";
$query mysql_query("$find") or die(mysql_error()); 
Reply With Quote
  #2 (permalink)  
Old 06-25-04, 12:01 PM
sufyan sufyan is offline
Newbie Coder
 
Join Date: Jun 2003
Location: Melbourne, AU
Posts: 53
Thanks: 0
Thanked 0 Times in 0 Posts
Try:
PHP Code:

$find "SELECT * FROM clanpay_users WHERE username='$username' AND password='$password'";

$query mysql_query($find) or die(mysql_error()); 
BTW, this code vulnerable to SQL injections.
Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL infinite loop problem with VB application Syed Visual Basic 2 05-07-04 10:19 AM
Problem Dealing with Null Valuers in SQL Query hai_anilreddy Visual Basic 3 02-08-04 08:39 AM
Help with ASP & FORMS blessedrub ASP 0 01-23-04 10:22 AM
ASP SQL query string problem CollinAmes ASP 2 10-24-03 11:09 AM
change my field in this example sal21 ASP 3 07-14-03 02:49 AM


All times are GMT -5. The time now is 05:06 AM.
vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.