the-dream
02-18-2008, 07:23 PM
Hey Guys!
I cannot get my code to work, I don't get any errors! I'm sure its some really simple but I just can't spot it!
<?php
include('includes/dbconnect.php');
$user = $_SESSION['MM_Username'];
if(isset($_GET['del'])) {
$del_id = $_GET['del'];
mysql_query("UPDATE favs SET user = '' WHERE id = '$del_id' AND user = '$user'") or die('<div class="passbad">Sorry there was an error!</div>');
echo '<div class="addfav">The selected favorite was successfully deleted! <a href="favs.php">Close</a>!</div><br />';
}
$result = mysql_query("SELECT * FROM favs WHERE user = '$user' ORDER BY title ASC") or die('<div class="passbad">Sorry there was an error!</div>');
echo '<div class="bb">';
while($row = mysql_fetch_array($result)) {
echo '<div class="itemcontianer" style="border-left: #333333 1px solid; border-right: #333333 1px solid;">
<table cellpadding="0" cellspacing="0" width="780">
<tr>
<td>
<div class="itemtitle"0>
<a href="'.$row['url'].'">'.$row['title'].'</a>
</div>
<div class="itemdescription">
'.$row['description'].'
</div>
</div>
</td>
<td align="right" valign="middle">
<div align="right">
<a href="favs.php?del='.$row['id'].'" return false;" class="menulink"><img src="images/del.gif" border="0" /></a> </div></td></tr></table></div>';
}
echo '</div>';
?>
Thanks,
~ Christian
I cannot get my code to work, I don't get any errors! I'm sure its some really simple but I just can't spot it!
<?php
include('includes/dbconnect.php');
$user = $_SESSION['MM_Username'];
if(isset($_GET['del'])) {
$del_id = $_GET['del'];
mysql_query("UPDATE favs SET user = '' WHERE id = '$del_id' AND user = '$user'") or die('<div class="passbad">Sorry there was an error!</div>');
echo '<div class="addfav">The selected favorite was successfully deleted! <a href="favs.php">Close</a>!</div><br />';
}
$result = mysql_query("SELECT * FROM favs WHERE user = '$user' ORDER BY title ASC") or die('<div class="passbad">Sorry there was an error!</div>');
echo '<div class="bb">';
while($row = mysql_fetch_array($result)) {
echo '<div class="itemcontianer" style="border-left: #333333 1px solid; border-right: #333333 1px solid;">
<table cellpadding="0" cellspacing="0" width="780">
<tr>
<td>
<div class="itemtitle"0>
<a href="'.$row['url'].'">'.$row['title'].'</a>
</div>
<div class="itemdescription">
'.$row['description'].'
</div>
</div>
</td>
<td align="right" valign="middle">
<div align="right">
<a href="favs.php?del='.$row['id'].'" return false;" class="menulink"><img src="images/del.gif" border="0" /></a> </div></td></tr></table></div>';
}
echo '</div>';
?>
Thanks,
~ Christian