I have a repeating record set displayed on the page and next to each record a tick box to select the record based on entry id to link to a delete button (all records ticked to be deleted); and a link to an update page to select the relevant record to update on another page using a session variable 'entryid' to select. ...it's not working
any ideas?? I have no session 'entryid' echoed out - now that's a problem to start with.
here is the header:
Code: Select all
<?php
ini_set('session.bug_compact_warn', 0);
ini_set('session.bug_compact_42', 0);
// set session entryid
$entry = $_POST['entryid'];
mysql_select_db($database_recommendingpeople, $recommendingpeople);
$query = "SELECT * FROM recommendations WHERE entryid= '$entry';";
$result = mysql_query($query, $recommendingpeople) or die(mysql_error());
$row = mysql_fetch_assoc($result);
if (!$result) {
echo "Got nothing";
} else {
$_SESSION['entryid'] = $row['entry'];
}
?>
<?php
$_SESSION['MM_Username'];
$_SESSION['userid'];
$_SESSION['entryid'];
echo $_SESSION['entryid'];
?>
<?php
$maxRows_rsrecommendations = 10;
$pageNum_rsrecommendations = 0;
if (isset($_GET['pageNum_rsrecommendations'])) {
$pageNum_rsrecommendations = $_GET['pageNum_rsrecommendations'];
}
$startRow_rsrecommendations = $pageNum_rsrecommendations * $maxRows_rsrecommendations;
$colname_rsrecommendations = "1";
if (isset($_SESSION['userid'])) {
$colname_rsrecommendations = (get_magic_quotes_gpc()) ? $_SESSION['userid'] : addslashes($_SESSION['userid']);
}
mysql_select_db($database_recommendingpeople, $recommendingpeople);
$query_rsrecommendations = sprintf("SELECT * FROM recommendations WHERE userid = %s", $colname_rsrecommendations);
$query_limit_rsrecommendations = sprintf("%s LIMIT %d, %d", $query_rsrecommendations, $startRow_rsrecommendations, $maxRows_rsrecommendations);
$rsrecommendations = mysql_query($query_limit_rsrecommendations, $recommendingpeople) or die(mysql_error());
$row_rsrecommendations = mysql_fetch_assoc($rsrecommendations);
if (isset($_GET['totalRows_rsrecommendations'])) {
$totalRows_rsrecommendations = $_GET['totalRows_rsrecommendations'];
} else {
$all_rsrecommendations = mysql_query($query_rsrecommendations);
$totalRows_rsrecommendations = mysql_num_rows($all_rsrecommendations);
}
$totalPages_rsrecommendations = ceil($totalRows_rsrecommendations/$maxRows_rsrecommendations)-1;
?>Code: Select all
<form action="" method="post" name="myrecommendations" id="myrecommendations">
<div align="center">
<table width="94%" border="10" bgcolor="#FFFFFF" id="recommendations">
<tr class="style8">
<td> </td>
<td width="30%">Business:</td>
<td colspan="2">Address:</td>
<td colspan="2">e-mail, telephone </td>
</tr>
<?php do { ?>
<tr>
<td><input type="checkbox" name="checkbox" value="<?php echo $row_rsrecommendations['entryid']; ?>">
<input name="hiddenField" type="hidden" value="<?php echo $row_rsrecommendations['entryid']; ?>"></td>
<td><?php echo $row_rsrecommendations['businessname']; ?></td>
<td><?php echo $row_rsrecommendations['townborough']; ?>,</td>
<td><?php echo $row_rsrecommendations['city']; ?></td>
<td> </td>
</tr>
<tr>
<td><a href="recommendationsupdate.php" title="recommendationsupdate" accesskey="u" value = $_SESSION['entryid']>update</a> </td>
<td><?php echo $row_rsrecommendations['firstname']; ?>,<?php echo $row_rsrecommendations['lastname']; ?></td>
<td><?php echo $row_rsrecommendations['county']; ?>,</td>
<td><?php echo $row_rsrecommendations['state']; ?></td>
<td colspan="2"><?php echo $row_rsrecommendations['email']; ?></td>
</tr>
<tr>
<td> </td>
<td><?php echo $row_rsrecommendations['businesscategory']; ?></td>
<td colspan="2"><?php echo $row_rsrecommendations['country']; ?></td>
<td colspan="2"><?php echo $row_rsrecommendations['tel']; ?></td>
</tr>
<tr>
<td> </td>
<td><div align="center">------------------</div></td>
<td colspan="2"><div align="center">------------------</div></td>
<td colspan="2"><div align="center">------------------</div></td>
</tr>
<?php } while ($row_rsrecommendations = mysql_fetch_assoc($rsrecommendations)); ?>
<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF"><div align="left">
<input name="delete" type="submit" id="delete" value="Delete">
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="150" height="30" align="right">
<param name="movie" value="button8.swf">
<param name="quality" value="high">
<param name="bgcolor" value="#FFFFFF">
<embed src="button8.swf" width="150" height="30" align="right" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" bgcolor="#FFFFFF"></embed>
</object>
</div></td>
</tr>
<?
// Check if delete button active, start this
mysql_select_db($database_recommendingpeople, $recommendingpeople);
if($delete){
for($i=0;$i<$count;$i++){
$del_entryid = $checkbox[$i];
$sql = "DELETE * FROM recommendations WHERE entryid ='$del_entryid'";
$result = mysql_query($sql);
}
// if successful redirect to delete_multiple.php
if($result){
echo "<meta http-equiv=\"refresh\" content=\"0;URL=myrecommendations.php\">";
}
}
mysql_close();
?>
</table>thanks in advance. You guys are great