Move record from one row to another

Kiril_cvetkov

Hello, I need some Help Here.
So i have 2 rows with 10 records (with 10 catid)
and i want the records from the first row to move in the another row and the first row to be EMPTY 🙂

Any Ideas!!!? Will be very grateful 😉

Cheers

dagon

why??

I seriously doubt this is the correct approach to what ever the issue is, what are you trying to achieve?

Kiril_cvetkov

Example, i have the FIELDS: views and pastviews
how to move the data from views to pastviews?

dagon

ok, but why?

djjjozsi

add more examples , and be specific.

what are views and pastviews?

you said:
Move record from one row to another

you're thinking of this:
move one field into another ? thats not the same...

Kiril_cvetkov

every 7 days i want some records to reset example the view counter, and i want to have example : past views of the article and will make top 10 weekly article winners

btw i have one idea 🙂

djjjozsi

update table_name set past=new , new='12345' WHERE rowid=2

Kiril_cvetkov

yes man but the problem is that there are too many rows 😃
i made while counter
but i don't know does it will be fast

Kiril_cvetkov

does while is good idea? the script will be executing fast or?
EDIT * I made with while and it's working good :eek: but 😃 if there are more then 100 000 articles does while will be good idea??
i think that it will be slow

djjjozsi

Kiril_cvetkov;10917768 wrote:
does while is good idea? the script will be executing fast or?

you can use this UPDATE in a single sql query:

update table_name set `past`=`new` , `new`='12345' WHERE 1

this will set the past field's value to the new field's value, and set 12345 to the new field on your whole table. if you need this, then execute this sql query.

lets have a make a backup from your database before run such a harmful UPDATE code.

Kiril_cvetkov

djjjozsi;10917769 wrote:
you can use this UPDATE in a single sql query:
update table_name set `past`=`new` , `new`='12345' WHERE 1
this will set the past field's value to the new field's value, and set 12345 to the new field on your whole table. if you need this, then execute this sql query.

lets have a make a backup from your database before run such a harmful UPDATE code.

But example --> Where catid="1";
that will be only for the first catid, i want to make for all
here is what i made:
$i=0;
$number_of_categories=row[COUNT('catid')];
while ($i<=$number_of_categories)
{
$i++
update table_name set past=`` , new='$past[$i]' WHERE catid=$i
}

djjjozsi

....
update table_name set `past`=`new[$i]` , `new`='12345[$i]' WHERE catid=$i

new[$i] and 12345[$i] don't have a sense...

lets read the manual for the right syntax:
http://dev.mysql.com/doc/refman/5.0/en/update.html

Kiril_cvetkov

i give you 😃 example let them call variables $12345[$1]

djjjozsi

variables mustn't begin with a number 🙂

update table_name set `past`=`new` , `new`='' WHERE 1

new is a field name and not a variable...
past is a field name not a variable.
WHERE 1 is a condition, means set these values evrywhere...

Kiril_cvetkov

i've already corrected that

Kiril_cvetkov

ok thanks buddy 🙂 cheers