All pastes #467766 Raw Edit

Mine

public text v1 · immutable
·published 2007-05-02 18:26 UTC
rendered paste body
<?php
session_start();
include("config.php");
if(isset($_REQUEST["id"])){
   $id = $_REQUEST["id"];
   $indexs = mysql_query("SELECT * FROM ".$prefix."main WHERE `id` = '$id'") or die(mysql_error());
   $index = mysql_fetch_array($indexs);
   $sub = $index["name"];
   $metakeywords = $index["metakeywords"];
   $metadescription = $index["metadescription"];
}
else {
    $query = "select * from ".$prefix."categories where `name` = 'TOP'";
    $result = mysql_query($query);
    $myrow = mysql_Fetch_array($result);

    $query = "select * from ".$prefix."menu where `category` = ".$myrow["id"]." order by ";
    if($myrow["orderby"] == "custom")
       $query .= "`orderby` asc";
    else
       $query .= "`name` ".$myrow["orderby"];
    $result = mysql_query($query);
    $myrow = mysql_Fetch_array($result);

    $query = "select * from ".$prefix."main where `id`=".$myrow["link"];
    $result = mysql_query($query);
    $myrow = mysql_fetch_array($result);

    $metakeywords = $myrow["metakeywords"];
    $metadescription = $myrow["metadescription"];    
}
?>