Re-Order by ID Number
Posted on
16th Feb 2014 07:03 pm by
admin
I have a cms set up for inputting an image, thumb, title, pdf, and eps. When input the database assigns an ID number. The front end displays each upload by ID number. I'm trying to set up the back end so that a user can re-order by changing the ID number. I can get it to display the ID number in an editable text area, display thumb and title for each entry. With the code below it doesn't update the database ID number when I save. What am I doing wrong here? (Just to let you know this code is a modified version of my 'delete entry' code that works)
<?php
if($session->logged_in){
mysql_connect("localhost", "yeee", "eeeee") or die(mysql_error()) ;
mysql_select_db("eeeeee") or die(mysql_error()) ;
if(!isset($cmd))
{
$result = mysql_query("select * from test order by id");
while($r=mysql_fetch_array($result))
$title=$r["title"];
$id=$r["id"];
$thumb=$r["thumb"];
echo "<div style='display:block; width:400px; padding-left:25px;padding-right:25px; margin:auto; background-color:#ffffff;'>
<img src='images/menu-top.jpg' style='width:450px;margin-left:-25px;'><br />
<form>
<table>
<tr>
<td><input type='text' name='id' value='$id' size='3'></td><td width='350px'><strong>$title</strong></td>
</tr>
<td colspan='2' align='center'><img src='upload/test/$thumb'></td>
</table></form>";
}
}
?>
<?php
echo "<div style='text-align:center;'><a href='testorder.php?cmd=order&id=$id'>Submit</a></div>";
?>
<?php
if($cmd=="order")
{
$sql = "UPDATE test SET id='$id'";
$result = mysql_query($sql);
echo "UPDATED!";
echo "<a href='main.php'>Click here to return to the Administration Area.</a>";
}
}
else{
echo "[<a href='main.php'>Please Login</a>]";
}
?>
No comments posted yet
Your Answer:
Login to answer
214 
12 
Other forums
Mysql error message
help me find out what this error message means:
"Duplicate entry '0' for key 'PRIMARY'&q
PHP and SMS
Hi all forum members. I am new here and am unsure what category shoild I post this in.
Moderator
send message to the java application
Oracle 10g with Windows platform.
I have a java application that periodically pings the d
PHP / MySQL Associative Multidimensional Array:
Hello.
I have data in a MySQL Table that adheres to the below: (note, no index, could add if
Sessions Value Not Saved
Hi,
Im making a login form and im using this code:
Code: if($login=="true"){
"From field" in PHP email form
I used a wizard to create a PHP email form. I was able to customize it with the exception of the Fr
date function help
i need help with date function
Code: [Select]<!DOCTYPE HTML PUBLIC "-//W3C//DTD H
isset undefined variable
Hi all,
Hope someone can point out the obvious. I've a log in script, if you dont enter a use
Material Master Update through BAPI - Follow up material not updated
Hi Experts,
I am updating the material master through a custom transaction using the BAPI
Logging and nologging bulk insert
Hi,
oracle version: 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
