TalkPHP - View Single Post

Tanax · 09-28-2007, 05:23 AM

PHP Code:


			
public function fetch($szSQL){
            $szResult = mysql_query($szSQL);
            $aResult = mysql_fetch_array($szResult);
            return $aResult;
        }

PHP Code:


			
$db = new database();
$sql = sprintf("SELECT * FROM `news` WHERE `title` = %s", mysql_escape_string($input));
$results = $db->fetch($sql);

foreach($results as $news) {
echo $news['title'];
}

09-28-2007, 05:23 AM	#3 (permalink)
Tanax The Prestige Join Date: Sep 2007 Location: Sweden, Stockholm Posts: 1,080 Thanks: 115	PHP Code: `public function fetch($szSQL){ $szResult = mysql_query($szSQL); $aResult = mysql_fetch_array($szResult); return $aResult; }` PHP Code: $db = new database(); $sql = sprintf("SELECT * FROM `news` WHERE `title` = %s", mysql_escape_string($input)); $results = $db->fetch($sql); foreach($results as $news) { echo $news['title']; }