MMSHFE
جمعه 18 فروردین 1391, 14:21 عصر
این یک مثاله:
mysql_connect('localhost', 'root', '') or die('Connection error');
mysql_select_db('dbname') or die('Database error');
mysql_query('SET NAMES \'utf8\'');
mysql_set_charset('utf8');
$books = mysql_query('SELECT * FROM `book` ORDER BY `id` DESC LIMIT 3');
if($books && mysql_num_rows($books) > 0) {
echo '<p>'.PHP_EOL;
echo '<b>Books</b><br/>'.PHP_EOL;
while($book = mysql_fetch_assoc($books)) {
echo $book['name'].'<br/>'.PHP_EOL;
}
echo '</p>'.PHP_EOL;
}
$games = mysql_query('SELECT * FROM `game` ORDER BY `id` DESC LIMIT 3');
if($games && mysql_num_rows($games) > 0) {
echo '<p>'.PHP_EOL;
echo '<b>Games</b><br/>'.PHP_EOL;
while($game = mysql_fetch_assoc($games)) {
echo $game['name'].'<br/>'.PHP_EOL;
}
echo '</p>'.PHP_EOL;
}
$downloads = mysql_query('SELECT * FROM `download` ORDER BY `id` DESC LIMIT 3');
if($downloads && mysql_num_rows($downloads) > 0) {
echo '<p>'.PHP_EOL;
echo '<b>Downloads</b><br/>'.PHP_EOL;
while($download = mysql_fetch_assoc($downloads)) {
echo $download['name'].'<br/>'.PHP_EOL;
}
echo '</p>'.PHP_EOL;
}
$news = mysql_query('SELECT * FROM `news` ORDER BY `id` DESC LIMIT 3');
if($news && mysql_num_rows($news) > 0) {
echo '<p>'.PHP_EOL;
echo '<b>News</b><br/>'.PHP_EOL;
while($new = mysql_fetch_assoc($news)) {
echo $new['name'].'<br/>'.PHP_EOL;
}
echo '</p>'.PHP_EOL;
}
موفق باشید.