Posted: Tue Sep 21, 2004 6:15 pm
and here's what should work for you:
note which lines are commented
Code: Select all
<?php require_once('../../Connections/hungryusaconnection.php'); ?>
<?php
$colname_rsmenu = "1";
if (isset($HTTP_GET_VARS['namefield'])) {
$colname_rsmenu = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['namefield'] : addslashes($HTTP_GET_VARS['namefield']);
}
mysql_select_db($database_hungryusaconnection, $hungryusaconnection);
$query_rsmenu = sprintf("SELECT * FROM menus WHERE item LIKE '%%%s%%' ORDER BY item ASC", $colname_rsmenu);
$rsmenu = mysql_query($query_rsmenu, $hungryusaconnection) or die(mysql_error());
$row_rsmenu = mysql_fetch_assoc($rsmenu);
$totalRows_rsmenu = mysql_num_rows($rsmenu);
//mysql_free_result($rsmenu);
?>
<?php
do
{
//$row_rsmenu ++;
print( '<p style="color: #000000">' );
print( $row_rsmenu ['item' ]. '<p>' );
}
while ( $row_rsmenu =mysql_fetch_assoc ($rsmenu ));
?>