Moving items

[EVASiON]

Hello,

A friend sent me here to solve my problem, I hope someone can help me.

Here's the problem:

I have a database:

+------+--------------+
| id   | data         |
+------+--------------+
|    1 | image1       |
|    2 | image2       |
|    3 | image3       |
|    4 | url1         |
|    5 | url2         |
|    6 | url3         |
|    7 | description1 |
|    8 | description2 |
|    9 | description3 |
|   10 | image4       |
|   11 | image5       |
|   12 | image6       |
|   13 | url4         |
|   14 | url5         |
|   15 | url6         |
|   16 | description4 |
|   17 | description5 |
|   18 | description6 |
+------+--------------+

And I would like to make a FORM which would make new entries for image1, url1 and description1, but at the same time move the current info for 1 to the info for two:

newdata -> image1, url1, description1
image1, url1, description1 -> image2, url2, description2
image2, url2, description2 -> image3, url3, description3
image3, url3, description3 -> image4, url4, description4
image4, url4, description4 -> image5, url5, description5
image5, url5, description5 -> image6, url6, description6
image6, url6, description6 -> DELETE

I don't know how to do this in PHP and would be glad if someone could help me with this. Thanks.

/EVASiON

[leatherback]

First off.. I think your database design has a basic flaw.

It looks to me like you should have your database like this:

|id|image|url|description|

Then you could even better create it like this:

|id|image|url|description|insertorder|

Make the ID an autoincrement colum.

When you have a new entry, you update the table using these queries:

"update MY_TABLE set insertorder=insertorder+1"
"delete from MY_TABLE where insertorder>6"
"insert into MY_TABLE (image, url, description, insertorder) values ('$image', '$url', '$description', 1)"

Hope this solves your problem.

[EVASiON]

Your solution would give me a problem, because I need to call all the items seperately. I have to store image1 into a $var, image2 into a $var, etc. I don't know if that's possible with your solution. Is there any way to do what I want to do with my current table?

Thanks.

/EVASiON

[leatherback]

Hi,

You COULD do exactly the same thing with your table. Add an insertorder colum, and use the queries provided.

But IF the image1, url1 and description1 you really should reformat your database. Just a matter of proper database design.
And then you can still insert all your individual fields in a database:

$result = mysql_query(select * from MY_TABLE order by insertorder);
  if($result)
  {
   $i=1;
   while ($row = mysql_fetch_array($result)
   {
    $image[$i] = $row[image];
    $url[$i] = $row[url];
    $description[$i] = $rpow[description];
    $i++;
    }
  }

This would give you image1 in $image[1], url1 in $url[1] etcetc
There is even a way to create $url1 from url and $i, but I do not have that in my mind at the moment.. Need some sleep..
J.