السلام عليكم،
تفضلي اختي هذا السكربت كامل بس غيري مايلزم.
كود PHP:
<?
// -- Database name,
define('TABLE_NAME',"ac_books_cats");
$res_id = mysql_connect("localhost","username","password");
$db = mysql_select_db("DTABASE_NAME",$res_id);
// -- Query Table...
$sql = "SELECT * FROM ".TABLE_NAME." ORDER BY ord ASC";
$result = mysql_query($sql,$res_id);
if ($_POST['DoOrder']) {
while ( $row = mysql_fetch_array($result,MYSQL_ASSOC) ) {
$sql = "UPDATE ".TABLE_NAME." SET ord = ".$order_id[$row['id']]." WHERE id = ".$row['id'];
$do = mysql_query($sql) or die(mysql_error());
}
echo "Updated...";
}
else {
echo '<form method="post" action="'.$_SERVER['PHP_SELF'].'"><table border="1" width="100%">
<TR>
<TH>ID</TH>
<TH>title</TH>
<TH>IMG</TH>
<TH>ORDER</TH>
</TR>
';
while ( $row = mysql_fetch_array($result,MYSQL_ASSOC) ) {
echo '<TR>
<TH>'.$row['id'].'</TH>
<TH>'.$row['title'].'</TH>
<TH>'.$row['img'].'</TH>
<TH><input type="text" size="3" Value="'.$row['ord'].'" Name="order_id['.$row['id'].']" ></TH>
</TR>
';
}
echo '</table><input type="submit" Name="DoOrder" Value="Reorder"></form>';
}
?>