SunQuest
           Database Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Codewalkers Forums > Other Technologies > Database Help
Reload this Page

mysql error

Discuss mysql error in the Database Help forum on Codewalkers.
mysql error General SQL help. Help with MySQL, MSSQL, Oracle, mSQL, PostgreSQL, etc.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Codewalkers Forums Sponsor:
Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here
  #1  
Old November 22nd, 2003, 03:21 AM
actown actown is offline
Codewalkers Newbie (0 - 499 posts)
  
Join Date: Apr 2007
Posts: 22 actown User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Send a message via ICQ to actown Send a message via AIM to actown Send a message via Yahoo to actown
mysql error
i get the error : Warning: mysql_result(): supplied argument is not a valid MySQL result resource in d:apacheapachehtdocslillypetslogin2.php on line 77
can some one help me?
Reply With Quote
  #2  
Old November 22nd, 2003, 08:25 AM
prycejones prycejones is offline
Codewalkers Newbie (0 - 499 posts)
  
Join Date: Apr 2007
Posts: 87 prycejones User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 9 m 44 sec
Reputation Power: 2
Send a message via ICQ to prycejones
RE: mysql error
Can you provide a snippet of the code that is going wrong and proof of what is in your variables so we can have a bit to go on, thanx.
Reply With Quote
  #3  
Old November 22nd, 2003, 10:08 PM
zackcoburn zackcoburn is offline
Codewalkers Newbie (0 - 499 posts)
  
Join Date: Apr 2007
Posts: 184 zackcoburn User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 2
RE: mysql error
Yes, code will be needed to fully assess the situation. I have seen this error before, however. It means that your "resource result" is invalid. You should check your mysql_query.

The way to use mysql_result is like this (for example):
php Code:
Original - php Code 
  1.  
  2. $users = mysql_query("SELECT name FROM users where id=247;");
  3. //$users is your "resource result"
  4. echo mysql_result($users,0,"name");
Reply With Quote
  #4  
Old November 23rd, 2003, 01:37 AM
sliver's Avatar
sliver sliver is offline
Moderator
Codewalkers Novice (500 - 999 posts)
  
Join Date: Apr 2007
Location: WI, USA
Posts: 897 sliver User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 23 h 44 m 13 sec
Reputation Power: 2
Send a message via AIM to sliver Send a message via XFire to sliver
RE: mysql error
Add:
php Code:
Original - php Code

this will print the error from mysql.
Reply With Quote
Reply

Viewing: Codewalkers Forums > Other Technologies > Database Help > mysql error

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 5 hosted by Hostway.