Unknown column 'ItemPageName' in 'where clause'

[saundra]

This appears to be the code that is giving me trouble. Can someone help

<?
    include("common.php");
    require_once("$HeaderFile");
 
    if(empty($_GET[Start])){
        $Start = '0';
    }else{
        $Start = $_GET[Start];
    }
    $ByPage = $aset[pagina];
    $query = array();
    if(!empty($_GET[what])){
        $query[] = " (ItemName like '%$_GET[what]%' or ItemDesc like '%$_GET[what]%') ";
    }
    if(!empty($_GET[pagename])){
      $qcatalognum = "SELECT CategoryID FROM categories WHERE CategoryPageName = '$_GET[pagename]'";
      $rcatalognum = mysql_query($qcatalognum) or die(mysql_error());
      $catalognum  = mysql_fetch_array($rcatalognum);
        $query[] = " ItemCategory = '$catalognum[CategoryID]' ";
 
        /*********************************** BEGINNING OF THE BIG IF *****************************/
        if($catalognum[CategoryID]){
 
    if(!empty($_GET[SubcategoryID])){
        $query[] = " ItemSubcategory = '$_GET[SubcategoryID]' ";
    }
    if(!empty($query)){
        $my_query = implode(" and ", $query);
        $my_query = " WHERE $my_query";
    }
    if(!empty($_GET[ord1])){
        $order_by = " ORDER BY $_GET[ord1] ";
    }else{
        $order_by = " ORDER BY ItemName ";
    }
 
  // Modified On July 11, 2005 by Patrick Mahoney for Online-Net-Business.Com - Killer SEO Website Builder System
  if ($catalognum > 0) {
  $sel = mysql_query("SELECT CategoryDescInfo FROM categories WHERE CategoryPageName = '$_GET[pagename]'");
  if (mysql_num_rows($sel) > 0) {
    while ($fet = mysql_fetch_array($sel)) {
?>
        <table border='0' cellpadding='0' cellspacing='0' width='90%' align='center'>
          <tr>
            <td>
    <p><br />
    <?=$fet['CategoryDescInfo']?>
    <br /></p>
 
            </td>
          </tr>
        </table>
<?
    }
  } else echo '';
  } else echo '';
  // End Added Modified
 
//    include("pagina.php");
 
    // Show The Catalog Content
    $q1 = "SELECT * FROM items $my_query ORDER BY ItemID LIMIT $Start, $ByPage";
    $r1 = mysql_query($q1) or die(mysql_error());
    if(mysql_num_rows($r1) > '0'){
        $col = "#D7D7D7";
        while($a1 = mysql_fetch_array($r1)){
            if($col == "#ffffff"){
                $col = "#ffffff";
            }else{
                $col = "#ffffff";
            }                                                         // old link item.php?item=$a1[ItemID]
            if($PageFolder == "Folder"){
              $result_rows .= "<tr>\n\t<td cellpadding='4' width='100%' align='center'><a href='http://$_SERVER[HTTP_HOST]/$a1[ItemPageName]/'>$a1[ItemName]</a></td>\n\t\n</tr>\n\n";
          }elseif($PageFolder == "Page"){
            $result_rows .= "<tr>\n\t<td cellpadding='4' width='100%' align='center'><a href='http://$_SERVER[HTTP_HOST]/$a1[ItemPageName].html'>$a1[ItemName]</a></td>\n\t\n</tr>\n\n";
          }else{
        echo " - <b>Please Set Your Page View Preference In The Settings Area</b> - ";
      }
        }
        $qnav = "select count(*) from items $my_query";
        $rnav = mysql_query($qnav) or die(mysql_error());
        $anav = mysql_fetch_array($rnav);
        $rows = $anav[0];
 
        if($rows > $ByPage){
            $NextPrev =  "<br /><table align='center' width='400'><tr>";
            $NextPrev .= "<td align='center' cellpadding='4'> | ";
            $pages = ceil($rows/$ByPage);
            for($i = 0; $i <= ($pages); $i++){
                $PageStart = $ByPage*$i;
                $i2 = $i + 1;
                if($PageStart == $Start){
                    $links[] = " $i2\n\t ";
                }elseif($PageStart < $rows){
                  if($PageFolder == "Folder"){
                    $links[] = "<a href=\"http://$_SERVER[HTTP_HOST]/category$PageStart/$_GET[pagename]/\">$i2</a>\n\t ";
          }elseif($PageFolder == "Page"){
            $links[] = "<a href=\"http://$_SERVER[HTTP_HOST]/category$PageStart/$_GET[pagename].html\">$i2</a>\n\t ";
              }else{
            echo " - <b>Please Set Your Page View Preference In The Settings Area</b> - ";
          }
        }
      }
       // Below Is The Original Version Before Mod Rewrite
       // $links[] = "<a href=\"cat.php?Start=$PageStart&what=$_GET[what]&CategoryID=$_GET[CategoryID]&ord1=$_GET[ord1]\">$i2</a>\n\t ";
       // Below Was The First Attempt Before Mod Rewrite That Worked
       // $links[] = "<a href=\"http://$_SERVER[HTTP_HOST]/cat.php?Start=$PageStart&pagename=$_GET[pagename]\">$i2</a>\n\t ";
 
            $links2 = implode(" | ", $links);
            $NextPrev .= $links2;
            $NextPrev .=  "| </td>";
            $NextPrev .= "</tr></table><br />\n";
        }
            include_once("templates/ResultsTemplate.php");
    }else{
        include_once("templates/NoResultsTemplate.php");
    }
}else{
  /*******************************************************/
    $q1 = "SELECT * FROM items WHERE ItemPageName = '$_GET[pagename]'";
    $r1 = mysql_query($q1) or die(mysql_error());
    $a1 = mysql_fetch_array($r1);
 
    include_once("templates/ViewItemTemplate.php");
}
} /********************************** END OF THE BIG IF **********************************/
    require_once("$FooterFile");
?>
 

[dafodil]

This is the part of your code that gives you the error:

 
$q1 = "SELECT * FROM items WHERE ItemPageName = '$_GET[pagename]'";
 
 

Check if there is a column ItemPageName inside the items table.

[saundra]

Thank you, somehow I missed that. Now I am getting this error

Unknown column 'CategoryNum' in 'order clause'

I think this is the code giving me trouble

<?
chdir("..");
require_once("c ommon.php");
require_once("s iteadmin/access.php");
require_once("s iteadmin/AdminNavigation .php");

if(isset($_POST[s1]))
{
if(!empty($_POS T[categoryname]))
{
$CategoryPageNa me = strip_tags($_PO ST[categoryname]);
$BadChars = array("?", ">", "<", ".", ",", "'", "\"", "/", ":", ";", "}", "]", "{", "[", "+", "=",
"_", "-", ")", "(", "*", "&", "^", "%", "$", "#", "@", "!", "~", "`", "\\", "|", " ");
$CategoryPageNa me = str_replace($Ba dChars,"-",$CategoryPage Name);

// If Magic Quotes Are Turned Off, Add Slashes
if (get_magic_quot es_gpc() == 0){$_POST = array_map('adds lashes', $_POST);}

$q1 = "INSERT INTO categories SET
CategoryName = '$_POST[categoryname]',
CategoryNum = '$_POST[CategoryNum]',
CategoryPageNam e = '$CategoryPageN ame' ";
$r1 = mysql_query($q1 );

if(mysql_error( ))
{
$error = "<span class=BlackLink >The category name <font color=black>$_P OST[categoryname]</font> already exist!</span>";
}
}
else
{
$error = "<span class=BlackLink >Enter the New Category name, please!</span>";
}
}

?>

<br>
<center>

<span>Add A New Category</span>
<br><br>

<form method="post">
<table border="1" style="border-collapse: collapse" bordercolor="#D 8D8D8" align="center" cellpadding="4" >
<caption align="center"> <?=$error?></caption>
<tr>
<td align="right">N ew Category Name:</td>
<td><input type="text" name="categoryn ame" size="20"> Category Number: <input type="text" name="CategoryN um" size="1"></td>
</tr><tr>
<td colspan="2" align="center"> <input type="submit" name="s1" value="Add New Category"></td>
</tr>

</table>
</form>

<?

$q1 = "select * from categories order by CategoryNum";
$r1 = mysql_query($q1 ) or die(mysql_error ());

if(mysql_num_ro ws($r1) > '0')
{
echo "<br>";

echo "<table border=\"1\" style=\"border-collapse: collapse\" bordercolor=\"# 000000\" align=\"center\ " width=\"400\" cellpadding=\"2 \"><tr><td background=\"im ages/nav-bgcolor.gif\" align=\"center\ "><b>Positi on</b></td>\n\t\n\t<td background=\"im ages/nav-bgcolor.gif\" align=\"center\ "><b>Categories </b></td>\n\t<td background=\"im ages/nav-bgcolor.gif\" align=center><b >Action</b></td>\n</tr>\n\n";

$col = "white";

while($a1 = mysql_fetch_arr ay($r1))
{
if($col == "white")
{
$col = "dddddd";
}
else
{
$col = "white";
}

echo "<tr bgcolor=$col>\n \t<td align=\"center\ ">$a1[CategoryNum]</td>\n\t<td align=left>$a1[CategoryName]</td>\n\t<td width=100 align=center><a class=GreenLink href=\"EditCate gory.php?Catego ryID=$a1[CategoryID]\">edit</a> | <a class=BlackLink href=\"DeleteCa tegory.php?Cate goryID=$a1[CategoryID]\" onclick=\"retur n cdel('$a1[CategoryName] category');\">d elete</a></td>\n</tr>\n\n";
}

echo "</table>";
}
?>

[dafodil]

Just the same as my first advice, check if the column exists.

 
$q1 = "select * from categories order by CategoryNum";