Take info from one coloum and move to another

Posted on 16th Feb 2014 07:03 pm by admin

Hi all,

I have this:
Code: [Select]$array = "SELECT stock_id FROM stocks WHERE stock_id BETWEEN '1' and '5' ";
$res = mysql_query($array);
$count = 0;
while ($row = mysql_fetch_assoc($res)){
if (is_int($count / 10) || $count == 0){
$rand_low = rand(1,5);
$rand_high = rand(1,5);
}
$num = rand($rand_low,$rand_high);
$update = "UPDATE stocks SET t_val=$num WHERE stock_id='" . $row['stock_id'] ."'";
if (mysql_query($update)){
echo "Updated record(s)<br />n";
}
}
Which simply updates a coloum called t_val with a random value between 1 and 5. I have another coloum in the table called y_val. What I would like to do is take the value of t_val before it is updated with the new rand and save it to the y_val coloum. How would I do this?

Many thanks

Your Answer:

Login to answer

Other forums

Need to write a cookie with a url var
Not sure if its possible, but I need to write a cookie with a url.

So this would write 2232 a

Multi Level Array Problem
hi all,

For example I have array like below:

$temp = array(array('north america', 'us'

Basic Question about Threading and PHP...
I have a page that I am working on and it is taking several hours to process. The basics of what th

Share admin accross websites
I'm using .net memberships and roles in one of my sites, but I need to be able to share logins and p

upload only text files
hi guys i want to upload only text like like (pdf,note pad and ofiice files) so can any one please t

preg_replace question
Hello!!

I hope someone can help me with preg_replace.

I load two tables from an extern

PHP Blog help
Need help with posting comments in a word press blog? I have a comments page where the comments are

problem with refreshing
in my site, i have an index page, it has a main div. this main div's content is changing according t

download directory onto C drive
I am attempting (if this is possible) to write a routine to automatically dump the contents of a dir

Displaying pictures
i have worked my way through storing images in directory and storing the location in mySQL db.Now i