Records not displaying

[affordit]

Can anyone see where I messed up displays the table but no records?

I inserted 6 test records.

<?php
session_start(); // start up your PHP session!
include("client_info3.php"); 
include("top_mid_nav.inc"); 

include("sharons_dbinfo2.inc.php");
mysql_connect(mysql,$name,$password);
mysql_select_db($database) or die( "Unable to select database"); 

@$sql = "Select * from content";
$results = mysql_query($sql) or die(mysql_error());
$count=mysql_num_rows($result);

?>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><form name="form1" method="post" action="">
<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td bgcolor="#FFFFFF"> </td>
<td colspan="4" bgcolor="#FFFFFF"><strong>Delete multiple records</strong> </td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF"><strong>Item</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Heading</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Picture</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Description</strong></td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['item']; ?>"></td>
<td bgcolor="#FFFFFF"><? echo $rows['item']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['heading']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['picture']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['description']; ?></td>
</tr>
<?php
}
?>
<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
</tr>
<?
// Check if delete button active, start this 
if($delete){
for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$sql = "DELETE FROM content WHERE item='$del_id'";
$result = mysql_query($sql);
}


if($result){
echo "<meta http-equiv=\"refresh\" content=\"0;URL=change_products.php\">";
}
}
mysql_close();
?>
</table>
</form>
</td>
</tr>
</table>

[revraz]

Same as I posted in your other thread.  You use $result and $results

 

$results = mysql_query($sql) or die(mysql_error());

$count=mysql_num_rows($result);

 

[revraz]

And looking farther down, you use $result again and you use <? short tags.

[affordit]

Thanks I looked for that and still missed it

[PFMaBiSmAd]

When learning php, developing php code, or debugging php code, turning on full php error reporting to get php to help you, will find things like code that references variable names that don't exist.