Windows Phone Thoughts - Daily News, Views, Rants and Raves

Check out the hottest Windows Mobile devices at our Expansys store!

Digital Home Thoughts

Loading feed...

Laptop Thoughts

Loading feed...

Android Thoughts

Loading feed...


Go Back   Thoughts Media Forums > WINDOWS PHONE THOUGHTS > Windows Phone Thoughts Site Updates
Reload this Page

User Names Now Merged - Having Problems? Let Us Know


 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 05-22-2008, 02:49 AM
rlobrecht
Thinker
rlobrecht's Avatar
Join Date: Aug 2006
Posts: 333
I would think you could do something like
$userids = select user_id from users_table;
for each $userid in $userids
update users_table set join_date = 'select min(post_date) from post_table where user_id=$userid' where user_id = $userid;
next

and if that doesn't work you could just select all the user_ids into a text file, and then create another query file with the middle query explicitly specified for each user_id and then run that query file.
 
Reply With Quote
 

« Previous Thread | Next Thread »

Thread Tools
Display Modes
Threaded Mode Threaded Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:07 AM.

Contact Us - Thoughts Media Inc. - Archive - Privacy Statement - Top