Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 12-14-2002, 06:08 PM
Sebastian's Avatar
Sebastian Sebastian is offline
 
Join Date: Oct 2002
Location: America
Posts: 488
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default what is wrong?

trying to get the latest articles from my database and it's returning: Fatal error: Call to undefined function: sql_fetch_row() in /path/to/home

i tried mysql_fetch_row and still gives me an error, any ideas?


Code:
<?php
$dbhostname= "localhost"; 
$dbusername= ""; 
$dbpassword= ""; 
$dbdatabase= "";
$table ="db_stories"; 

$db = @mysql_connect($dbhostname,$dbusername,$dbpassword);
$result = @mysql_query("SELECT sid, title, comments, counter from $table order by sid DESC limit 0,5", $db);

while(list($sid, $title, $comtotal, $counter) = sql_fetch_row($result, $db)) {

}

?>
Reply With Quote
  #2  
Old 12-14-2002, 07:23 PM
GSHelpBoy GSHelpBoy is offline
 
Join Date: Nov 2001
Location: Rhode Island
Posts: 34
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The valid function is mysql_fetch_row($result).
Reply With Quote
  #3  
Old 12-14-2002, 07:47 PM
Sebastian's Avatar
Sebastian Sebastian is offline
 
Join Date: Oct 2002
Location: America
Posts: 488
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

okay, this is the entire script and it gives me: Warning: Wrong parameter count for mysql_fetch_row() in /home/path/

what gives, am i doing something wrong?

Code:
<?php
$dbhostname= "localhost"; 
$dbusername= "db_user"; 
$dbpassword= "db_pass"; 
$dbdatabase= "db_name";
$table ="db_stories"; 


$db = @mysql_connect($dbhostname,$dbusername,$dbpassword);

$result = @mysql_query("SELECT sid, title, comments, counter from $table order by sid DESC limit 0,5", $db);
          while(list($sid, $title, $comments, $counter) = mysql_fetch_row($result, $db)); {

}

?>
Reply With Quote
  #4  
Old 12-14-2002, 10:19 PM
GSHelpBoy GSHelpBoy is offline
 
Join Date: Nov 2001
Location: Rhode Island
Posts: 34
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The only parameter needed in the function mysql_fetch_row() is the query resource, so get rid of ', $db'.

Also, why do you have a semicolon ( at the end of the line with the mysql_fetch_row function?
Reply With Quote
  #5  
Old 12-14-2002, 11:23 PM
Sebastian's Avatar
Sebastian Sebastian is offline
 
Join Date: Oct 2002
Location: America
Posts: 488
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

lol. i just noticed that semicolon, i removed it. thanks, it's working now, such a simple mistake can cause it not to work.
Reply With Quote
Reply


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

Forum Jump


All times are GMT. The time now is 06:21 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.11208 seconds
  • Memory Usage 2,200KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (2)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete