Code: Select all
[PHP]
$db = mysql_connect('localhost','user_name','password') or die("Error while trying to connect to host");
mysql_select_db('table',$db) or die("Error while trying to connect to database");
$sql = "SELECT * FROM phpwcms_article ORDER BY article_id";
if($result = mysql_query($sql, $db)) {
echo "<br>";
while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
extract ($row ,'OVERWRITE');
echo "this is an article summary ".$article_id."<br>";
echo $article_summary."<br>";
}
mysql_free_result($result);
}
[/PHP]

