vb.org Archive - Is my syntax correct?

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

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

- - Is my syntax correct? (https://vborg.vbsupport.ru/showthread.php?t=58389)

SpeedStreet

11-04-2003 08:32 PM

Is my syntax correct?

I'm trying to create a query that will insert information into different tables at the same time, is my code right, or do I need to alter it?

Thanks!

PHP Code:


		
			
  $insertSQL = sprintf("INSERT INTO forums_user (userid, username, password, salt, options, joindate, usergroupid) VALUES (%s, %s, '" . addslashes(md5(md5($_POST['password']) . $asalt)) . "','" . addslashes($asalt) . "','0','$today','2')",

                       GetSQLValueString($_POST['userid'], "int"),

                       GetSQLValueString($_POST['username'], "text"),

                   ("INSERT INTO forums_usertextfield (userid) VALUES ('" . addslashes($_POST['userid']) . "')"),

                   ("INSERT INTO forums_userfield (userid) VALUES ('" . addslashes($_POST['userid']) . "')")

                   );

KuraFire

11-04-2003 10:41 PM

doing INSERTs in multiple tables is really just doing multiple different queries, and as such you should really just do separate queries.

It won't save you any speed or overhead by trying to fake them as one query, not just because that can't really be done, but also because that's not a real way of optimizing queries. :)

So, just run different insert queries and run them separately. :)

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00991 seconds Memory Usage 1,713KB 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 (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (2)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: