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

How can i steam a video on my PHP site? (non YouTube)
Basically I have a PHP site and don't want to give page rank to YouTube. I just want to stream a bas

cookie problem
I hv a website url
In this site main menu functionality based on cookie when user click on parti

Do While statement
hi guys,

This may sound trivial but im new to php and as part of an assignmenti have to const

newbie question about multiple queries
hi everyone,
I'm sorry to ask such a basic question, but I'm young and trying to learn php on my

Navigation include for all site directories
Hi,

I need a navigation include that can deal with directories at different levels on a site.

Production Order Enterprise Service to Manufacturing Exctn Sys (MES) ???
Hello Experts,

In our current landscape SAP ECC 5.0 is integrated to MES system via PI 7.

animation progress while uploading files?
Hello, i have some website form to upload few files to server. i want to put some gif animation whi

Creating a function
Basically i wanna put all this code in a seperate file

Code: <?php

image upload, resize THEN submit form
Ok so I have a form that requires the user to upload an image, and then do something with that image

A problem with my GD class
Hello,

I created a nice (and simple for now) GD class.
The problem is , it works great on