Webdetector Webmaster Forums - Your favorite webmaster community
 

Advertise Here Wordpress Premium Sportscrazyforum - Where Sport is a religion dnfame.com Spruce Host chooseapixel.com

Go Back   Webdetector Webmaster Forums - Your favorite webmaster community > Developers Corner > Programming

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 06-10-2008, 11:54 PM
directory_man's Avatar
Super Moderator
noobee
 
Join Date: Jun 2008
Posts: 34
Thanks: 2
Thanked 0 Times in 0 Posts
Default how do i trace this php sql error?

i found this error:
Query failed : Unknown column 'admin' in 'where clause'

well in fact, i successfully pass its id which is 'admin' to other page that will be using its value to a certain query.

here's my query:

$strID=$_GET['ID'];"SELECT userid,password,username,email,active FROM user WHERE userid=".$strID;
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored links
  #2 (permalink)  
Old 06-12-2008, 01:06 PM
Super Moderator
noobee
 
Join Date: Jun 2008
Posts: 36
Thanks: 0
Thanked 0 Times in 0 Posts
Default how do i trace this php sql error?

you need strID quoted:"SELECT userid,password,username,email... FROM user WHERE userid='".$strID."'";
or if
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored links
Reply

Bookmarks

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 On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT +1. The time now is 01:41 AM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
Ad Management by RedTyger