Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?
- $user="gentech_tg1";
- $password="admin1372";
- $database="gentech_tg1";
- $connection=mysql_connect('localhost',$user,$password);
- @mysql_select_db($database) or die( "Unable to select database");
- $query = "SELECT * FROM `users` WHERE `about_me` = '' LIMIT 10 " ;
- $result = mysql_query($query) or die(mysql_error());
- while($row = mysql_fetch_array($result)){
- $id = $row['id'];
- $query_a = "SELECT * FROM `about_me_var` ORDER BY RAND() LIMIT 10" ;
- $result_a = mysql_query($query_a) or die(mysql_error());
- while($row_a = mysql_fetch_array($result_a)){
- $about_me[] = $row_a['about_me'];
- }
- $about_me_list =
- $about_me[0].' '.
- $about_me[1].' '.
- $about_me[2].' '.
- $about_me[3].' '.
- $about_me[4].' '.
- $about_me[5].' '.
- $about_me[6].' '.
- $about_me[7].' '.
- $about_me[8].' '.
- $about_me[9];
- $result = mysql_query("UPDATE users SET `about_me` = '".$about_me_list."' WHERE `id` = '".$id."' ") or die(mysql_error());
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement