Scripts
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed Forums > Web Site Management > Scripts
Reload this Page

Warning: mysql_result() Pleae Help!

Discuss Warning: mysql_result() Pleae Help! in the Scripts forum on Dev Shed.
Warning: mysql_result() Pleae Help! Scripts forum discussing topics including building, optimization, and implementation. Discuss which scripting language is best suited to your needs.

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 Dev Shed 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 January 10th, 2006, 11:42 PM
CriminalTactic CriminalTactic is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Nov 2005
Posts: 28 CriminalTactic Negative: is most likely a SPAMMER and a traitor to the cause. 
Time spent in forums: 8 h 18 m 52 sec
Reputation Power: 0
Warning: mysql_result() Pleae Help!
im getting this error on one of my sites. please tell me how to fix if u know how
this is the error:
Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 6 in /home/thexbl/public_html/halo2/report.php on line 88

Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 6 in /home/thexbl/public_html/halo2/report.php on line 89

this is the part of the file that messes it up once i add it in but i need this in so pepole cant report loses with out accepting a chlalange.

PHP Code:
 $check_accepted = mysql_query("SELECT ed_status,er_status FROM chall_chat WHERE (challenger='$login[wid]' AND challenged = '$login[id]') OR (challenger='$login[id]' AND challenged = '$login[wid]') LIMIT 1");
$accepted_1 = mysql_result($check_accepted,0,'ed_status');
$accepted_2 = mysql_result($check_accepted,0,'er_status');

if(($accepted_1 != 'Accepted')&&($accepted_2 != 'Accepted')){
error("The challenge has not been accepted by both clans.");
} 
Reply With Quote
  #2  
Old January 12th, 2006, 04:30 AM
Axweildr's Avatar
Axweildr Axweildr is offline
CPAN medic ...
Click here for more information.
  
Join Date: Mar 2003
Location: Location: Location:
Posts: 11,279 Axweildr User rank is General 26th Grade (Above 100000 Reputation Level)Axweildr User rank is General 26th Grade (Above 100000 Reputation Level)Axweildr User rank is General 26th Grade (Above 100000 Reputation Level)Axweildr User rank is General 26th Grade (Above 100000 Reputation Level)Axweildr User rank is General 26th Grade (Above 100000 Reputation Level)Axweildr User rank is General 26th Grade (Above 100000 Reputation Level)Axweildr User rank is General 26th Grade (Above 100000 Reputation Level)Axweildr User rank is General 26th Grade (Above 100000 Reputation Level)Axweildr User rank is General 26th Grade (Above 100000 Reputation Level)Axweildr User rank is General 26th Grade (Above 100000 Reputation Level)Axweildr User rank is General 26th Grade (Above 100000 Reputation Level)Axweildr User rank is General 26th Grade (Above 100000 Reputation Level)Axweildr User rank is General 26th Grade (Above 100000 Reputation Level)Axweildr User rank is General 26th Grade (Above 100000 Reputation Level)Axweildr User rank is General 26th Grade (Above 100000 Reputation Level)Axweildr User rank is General 26th Grade (Above 100000 Reputation Level)  Folding Points: 122403 Folding Title: Super Ultimate Folder - Level 1Folding Points: 122403 Folding Title: Super Ultimate Folder - Level 1Folding Points: 122403 Folding Title: Super Ultimate Folder - Level 1Folding Points: 122403 Folding Title: Super Ultimate Folder - Level 1Folding Points: 122403 Folding Title: Super Ultimate Folder - Level 1Folding Points: 122403 Folding Title: Super Ultimate Folder - Level 1
Time spent in forums: 4 Months 22 h 38 m 24 sec
Reputation Power: 2731
Send a message via Google Talk to Axweildr
Orkut
I'm no expert in PHP, but it looks to me like you're trying to set the cursor to the first record of an empty recordset

The php forum would be the best place to look for help on this [Link], if you do post there, please post a link in this thread so that those coming after won't waste their time, and can follow the thread where the action is at
__________________
--Ax
without exception, there is no rule ...
The great thing about Object Oriented code is that it can make small, simple problems look like large, complex ones


09 F9 11 02
9D 74 E3 5B
D8 41 56 C5
63 56 88 C0
Some people, when confronted with a problem, think "I know, I'll use regular expressions." Now they have two problems. -- Jamie Zawinski
Detavil - the devil is in the detail, allegedly, and I use the term advisedly, allegedly ... oh, no, wait I did ...
Reply With Quote
  #3  
Old January 18th, 2006, 09:37 AM
mat087 mat087 is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jan 2006
Location: Terrebonne, Québec
Posts: 5 mat087 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 8 h 59 m 36 sec
Reputation Power: 0
PHP Code:
if( mysql_num_rows( $check_accepted ) )
{
    //There is one element (or more depending of your request...)
} 

Try searching on php.net for more information


Mathieu
Reply With Quote
Reply

Viewing: Dev Shed Forums > Web Site Management > Scripts > Warning: mysql_result() Pleae Help!

« 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 6 hosted by Hostway.