vb.org Archive - MYSQLI Error on 3.7

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - MYSQLI Error on 3.7 (https://vborg.vbsupport.ru/showthread.php?t=181860)

aggiefan

06-08-2008 04:30 AM

MYSQLI Error on 3.7

I had developed a pick 'em contest that worked great on 3.6.8. We just upgraded to 3.7 and I'm "cleaning up the errors" and found that my MYSQLI queries don't run (they return errors. Here's an example. Can somebody tell me what's wrong?

Error:

Quote:

Warning: mysqli_query() expects at least 2 parameters, 1 given in [path]\vbcontest.php on line 2347

Code:

PHP Code:


		
			
$query_user = "SELECT game1, game2, game3, game4, game5, game6, game7, game8, game9, game10, game11, game12, game13, game14, game15 FROM " . TABLE_PREFIX . "vbcontest_picks WHERE contestname = '$contestname' AND weekid = '$week' AND userid ='$userid'";

PHP Code:


		
			
$result_user  = mysqli_query($query_user);

Dismounted

06-08-2008 04:55 AM

If you are using vBulletin's global.php - just use the database class it provides. Otherwise, see the PHP manual page on mysqli_query().

aggiefan

06-08-2008 02:13 PM

I am using vbulletin's global.php. I guess I don't understand what you mean when you say, "just use the database class it provides"

Opserty

06-08-2008 02:21 PM

<a href="https://vborg.vbsupport.ru/showthread.php?t=119350&highlight=database" target="_blank">Using the vBulletin Database Class</a>

All times are GMT. The time now is 10:27 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01169 seconds Memory Usage 1,719KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: