竹貓星球

代碼: 選擇全部

<?

$pnlink = mysql_connect("你的主機位置","帳號","密碼") or die ("mysql_connect() failed.");
 mysql_select_db("phpbb_db", $pnlink) or die ("mysql_connect() failed.");

$pnquery = mysql_query("SELECT * FROM 4images_images WHERE cat_id ='1'  OR cat_id ='3'  OR cat_id ='5'  OR cat_id ='7'  OR cat_id ='9' order by image_date desc limit 3");
     
while ($myrow = mysql_fetch_row($pnquery)) {
echo "<a href="4images/details.php?image_id=$myrow[0]" class="index"><img src="4images/data/thumbnails/$myrow[1]/$myrow[9]" border="0"><BR>$myrow[3]</a><BR>"; }

mysql_close($pnlink); 


?>

代碼: 選擇全部

$pnlink = mysql_connect("[color=red]你的主機位置[/color]","帳號","密碼") 

代碼: 選擇全部

$pnlink = mysql_connect("[color=red]localhost[/color]","xxxx","xxxx") 

代碼: 選擇全部

mysql_select_db("[color=#ff0000]phpbb_db[/color]", $pnlink) or die ("mysql_connect() failed."); 

$pnquery = mysql_query("SELECT * FROM [color=#ff0000]4images_images[/color] WHERE cat_id ='1'  OR cat_id ='3'  OR cat_id ='5'  OR cat_id ='7'  OR cat_id ='9' order by image_date desc limit 3");