Can't UPDATE MySQL entry, not sure why...
Posted: Thu Mar 30, 2006 4:44 pm
feyd | Please use
feyd | Please use
Code: Select all
andCode: Select all
tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
asically when I click on DONE, I want my script to change whatever STATUS is currently to 1. This script just doesn't work though, and I'm not sure what I'm missing here... I didn't include the usual mysql connect stuff.
I'm a bit of a noob so be gentle...Code: Select all
<?
if ( $mode=="done")
{
mysql_query ("UPDATE users SET status='1' WHERE id='$id'");
Print "Entry has been updated <p>";
}
$query = "SELECT id, name, time, notes, runs, user FROM upload WHERE status='0' AND destination='Advertising' ORDER BY id DESC";
$result = mysql_query($query) or die('Error, query failed');
if (mysql_num_rows($result) == 0)
{echo "Database is empty <br>";}
else
{while(list($id, $name, $time, $notes, $runs, $user) = mysql_fetch_array($result))
{
?>
<div id="DownloadNew">
<a href="downloadstest.php?id=<?=$id;?>"><div id="DownloadNewArrow" onclick="new Effect.Pulsate(this, {duration: 3})"></div></a>
<div id="DownloadNewFile">
<a href="downloadstest.php?id=<?=$id;?>" class="filename">
<? $trimmed = substr($name, 0, 28); if($trimmed != $name) echo $trimmed .= '...'; else if($trimmed <= $name) echo $name; ?></a><br />
<span class="description"><?=$notes;?></span>
</div>
<div id="DownloadNewSquiggly">}</div>
<div id="DownloadNewInfo">
<img src="media/download_new_user.png" /> <a href="javascript: openWindow()"><span class="username"><?=$user;?></span></a><br />
<img src="media/download_new_time.png" /> <?=$time;?></span><br />
<img src="media/download_new_rundate.png" /> <strong>Runs:</strong> <?=$runs;?></span>
</div>
<div id="DownloadNewDone">
<a href="admin.php?id=<?=$id;?>&mode=done"><input name="" type="checkbox" value="" /> Done?</a><br />
<select name="">
<option>Move?</option>
</select>
</div>
</div>
<? }} ?>feyd | Please use
Code: Select all
andCode: Select all
tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]