vb.org Archive - MySql Question

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

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

- - MySql Question (https://vborg.vbsupport.ru/showthread.php?t=189997)

Cash2Paypal

09-04-2008 04:26 AM

MySql Question

Code:

INSERT INTO `site_database`.`vb_itrader` (`rateid`, `userid`, `rateduserid`, `rating`, `buyselltrade`, `subject`, `dealurl`, `dateline`, `ipaddress`) VALUES ('7', '23', '1', '1', '2', 'Great Trader, Can''t wait to work with again!', '', '0', '');

I wants to insert this into the mysql of iTrader. The point of the site will be to keep your TR from another forum. This puts in the feedback needed for 1 TR. I need the first value (here is a 7) to repeat various amounts of time. If someone comes with the TR of 158 I want to be able to run this 158 times and not change the rateid manually. If anyone could help I would greatly appreciate it! Thanks

Eikinskjaldi

09-04-2008 04:32 AM

Your question is not making alot of sense.

What do you mean "repeat various amounts of time"? is the ratieid supposed to be the same in each case, so effectively an identical entry 158 times? If so why not just add a counter field?

Are you asking how to cause the rateid to auto increment?

Can you rephrase the question?

Cash2Paypal

09-04-2008 04:46 AM

Thanks! Actually I got it! HAHA 6 hours later.. I am still learning mysql..

All times are GMT. The time now is 05:56 PM.

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