vb.org Archive - php/query

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

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

- - php/query - moving data (https://vborg.vbsupport.ru/showthread.php?t=69635)

Reeve of shinra

09-19-2004 06:43 PM

php/query - moving data

I am trying to copy some the info in some fields in one table to blank fields in another table. Does this code look right to you? It doesnt seem to doing the trick.

Thanks

PHP Code:


		
			
$q = $DB_site->query("SELECT * FROM old_journal");



while($x = mysql_fetch_array($q)) {



$t = "INSERT INTO journals ('journal_id','journalist_id','entrycount','journalviews','active','lastentrydate') 

VALUES ('$x[journalid]','$x[userid]','$x[entries]','$x[views]','$x[enabled]','$x[timestamp]')";



mysql_query($t);

}

Natch

09-20-2004 12:10 AM

Take a look at the facilities provided by INSERT ... SELECT

DJ RRebel

09-20-2004 12:45 AM

Did you notice the following typo (extra space)? lol ... I hate making typos like that ... you never notice them until the very last thing ... lol ... like looking everywhere for your keys, only to find them in the last pocket !!! lol

'lastentrydat e'

Natch

09-20-2004 12:47 AM

Quote:

Originally Posted by Reeve of shinra

I am trying to copy some the info in some fields in one table to blank fields in another table. Does this code look right to you? It doesnt seem to doing the trick.

Thanks

PHP Code:


		
			
$q = $DB_site->query("SELECT * FROM old_journal");



while($x = mysql_fetch_array($q)) {



$t = "INSERT INTO journals ('journal_id','journalist_id','entrycount','journalviews','active','lastentrydate') 

VALUES ('$x[journalid]','$x[userid]','$x[entries]','$x[views]','$x[enabled]','$x[timestamp]')";



mysql_query($t);

}

You have quote marks around your fieldnames ... try this...[SQL]INSERT INTO journals (journal_id,journalist_id,entrycount,journalviews, active,lastentrydate)
VALUES ('$x[journalid]','$x[userid]','$x[entries]','$x[views]','$x[enabled]','$x[timestamp]')[/SQL]

All times are GMT. The time now is 05:58 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01992 seconds Memory Usage 1,730KB 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: