[Hamed]

I have one table and I need to read records of this table but with one query and where I want to recod number one just I put one function.
(i think I need one class)

[Hamed]

PHP Code:

    public function get($tname)

    {

        global $db;

        $query = $db->query("SELECT * FROM `templates` WHERE sid='{$this->sid}' AND `tname`='{$tname}' LIMIT 1;");

        if($db->num_rows($query) != '0')

        {

            $t = $db->fetch_array($query);

            $tname = $t['tname'];

            $codes = $this->replace($t['codes']);

            //$codes = "<!-- start: $tname : {$this->sid} -->\n{$codes}\n<!-- end: $tname : {$this->sid} -->";

            $codes = str_replace("\\'", "'", addslashes($codes));

            return $codes;

        }

        else

        {

            die("TPLClass:We do not have ".$tname." in our templates table.!");

        }

    } 

Look I use this function to read my template code, when I read one template i will have one more query Now I want to read all templates at the 1st time and after that I use another function to read one of them??
It is possible?

[Jcbones]

PHP Code:

public function get_all() {

 global $db;

 $query = $db->query("SELECT `tname` FROM `templates`");

 if($db->num_rows($query) > 0) {

    while($t = $db->fetch_array($query)) {

       $arr[] = $t['tname'];

   }

  return $arr;

  }

return false;

} 

To use:

PHP Code:

if(!isset($_GET['get'])) {

$tmps = $class->get_all();

if($tmps) {

  foreach($tmps as $tname) {

        echo '<a href="?get=' . $tname . '">' . $tname . '</a><br />';

  }

}

}

else {

 $tmp = $_GET['get'];

$class->get($tmp);

}