vb.org Archive - Updateing A Table

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

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

- - Updateing A Table (https://vborg.vbsupport.ru/showthread.php?t=68316)

Logikos

08-13-2004 11:24 PM

Updateing A Table

Okay i have a table in my database that has a few rows. There called:

Userid
Threadid
date

You can obvioulsly tell what there for.
Anyway, I added a new row called 'threadtitle' but the values are all blank. Is there anyway that i can run a update query to add all the threadtitles to the proper threadid. All the thread ids have the correct threadid, but now i want to be able to use the thread title.

Basicly, i just want to update the row threadtitle with the correct thread titles based on the threadid row. TIA!

Reeve of shinra

08-14-2004 12:31 AM

Disclaimer, I have no idea what I am doing. That said:

Something like this I imagine, but I wonder if you could use an * instead of a value (if I understood correctly)

PHP Code:


		
			
update tablename set fieldname='1' where fieldname='2';

Modin

08-14-2004 08:25 AM

as far as I know you can't do it in a single query, you'll need a quick script.

PHP Code:


		
			
<?php

require('global.php');



$threads = $DB_site->query("SELECT threadid, title FROM " . TABLE_PREFIX . "thread");

while($thread = $DB_site->fetch_array($threads))

{

    $DB_site->query("UPDATE YourTable SET title='$thread[title]' WHERE threadid='$thread[threadid]'");

}

echo "Script Done";

?>

Hopefully that works for ya :)

Logikos

08-14-2004 08:13 PM

kool trying now thanks

Logikos

08-17-2004 04:03 AM

Hey Modin Thanks alot, worked perfect. Just had too change

PHP Code:


		
			
SET title='$thread[title]'

PHP Code:


		
			
SET threadtitle = '" . addslashes($thread['title']) . "'

Due to some characters in thread titles.

Modin

08-17-2004 10:11 PM

ah good call there... slipped by me.

glad it worked, for the most part :)

All times are GMT. The time now is 02:25 AM.

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