- $query = SQL_QUERY("SELECT id, action, what, title, sort FROM "._MYSQL_PREFIX."_guest_menu WHERE (what='' OR what IS NULL) ORDER BY sort ASC", __FILE__, __LINE__);
+ $result = SQL_QUERY("SELECT id, action, what, title, sort FROM "._MYSQL_PREFIX."_guest_menu WHERE (what='' OR what IS NULL) ORDER BY sort ASC", __FILE__, __LINE__);
} else {
// List sub menus
} else {
// List sub menus
- $query = SQL_QUERY_ESC("SELECT id, action, what, title, sort FROM "._MYSQL_PREFIX."_guest_menu WHERE action='%s' AND what != '' AND what IS NOT NULL ORDER BY sort ASC",
+ $result = SQL_QUERY_ESC("SELECT id, action, what, title, sort FROM "._MYSQL_PREFIX."_guest_menu WHERE action='%s' AND what != '' AND what IS NOT NULL ORDER BY sort ASC",
array($SUB), __FILE__, __LINE__);
}
// Get number of menu entries
array($SUB), __FILE__, __LINE__);
}
// Get number of menu entries
- $max = SQL_NUMROWS($query);
+ $max = SQL_NUMROWS($result);
if ($max > 0)
{
if ($max > 0)
{
- // Some entties does exist!
- if (!empty($SUB))
- {
- // Set sub value
- define('__SUB_VALUE', $SUB);
- }
- else
- {
- // No sub menu selected
- define('__SUB_VALUE', "");
- }
+ // Set sub value
+ define('__SUB_VALUE', $SUB);
$SW = 2; $cnt = 0; $OUT = "";
$SW = 2; $cnt = 0; $OUT = "";
- while (list($id, $act, $wht, $title, $sort) = SQL_FETCHROW($query))
+ while (list($id, $act, $wht, $title, $sort) = SQL_FETCHROW($result))
{
$cnt++;
if (($sort == 0) || (($sort == 1) && (!empty($SUB))))
{
$cnt++;
if (($sort == 0) || (($sort == 1) && (!empty($SUB))))