4
another question, but not on dropping tables,
updating them this time....
i currently have this code:
<?php
//Meta Redirect
echo "<head>";
echo "<meta http-equiv='Refresh' content='5;url=index.php'>";
echo "</head>";
//Get XOOPS Stuff
include "../../../include/cp_header.php";
xoops_cp_header();
//Retrieve Data from Form
$cid = $_POST['cid'];
$pic = $_POST['pic'];
//Set MySQL Table
$table = $xoopsDB->prefix( "bf2stats" ) ;
//Update Table
if (isset($cid)) {
$xoopsDB->query("UPDATE `$table` SET `cid` = '$cid', `pic` = '$pic' WHERE `wid` = '1' LIMIT 1");
}
if (empty($cid)) {
$cid = "Value Empty!";
$emp = "1";
}
if (empty($pic)) {
$pic = "Value Empty!";
$emp = "1";
}
OpenTable();
?>
<p align="center">Battlefield 2 Stats Supplied By bf2tracker.com</p>
<p align="center">You will be redirected back to the main page in 5 seconds.<br>
<?php
echo "$pic" ;
echo "$cid" ;
?>
<br>
<?php
if ($emp === '1') { echo "<font color='red'>Database Was Not Updated because one or more
variables are missing.</font>"; }
if (empty($emp)) { echo "<font color='green'>Database Was successfully updated.</font>"; }
?>
</p>
<p align="center">
<div align="center">
<table border="0" width="50%" id="table1" cellspacing="0" cellpadding="0">
<tr>
<td width="50%"><p align="right">BF2 Tracker Clan ID
<br>
</td>
<td>
<p align="center"><?php echo $cid ?></td>
</tr>
<tr>
<td width="50%">
<p align="right">Display Pictures on Side</td>
<td>
<p align="center">
<?php echo $pic ?>
</td></td>
</tr>
<tr>
<td width="50%"> </td>
<td> </td>
</tr>
</table>
<?php
CloseTable();
xoops_cp_footer();
?>
Now i know the data gets to it from the other form, and it all works, except it doesn't update the database.
Any Ideas?
