-
[help] web
1.----------------------------------------
Warning: mssql_query() [function.mssql-query]: message: 对象名 'site_rules' 无效。 (severity 16) in D:\www\kal\pages\rules.php on line 8
Warning: mssql_query() [function.mssql-query]: Query failed in D:\www\kal\pages\rules.php on line 8
Warning: mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource in D:\www\kal\pages\rules.php on line 9
Code:
<?
echo '<table align="center" class="content" cellspacing="0" cellpadding="0">
<tr>
<td>';
include("bbcode.php");
$query = mssql_query("SELECT * FROM site_download ORDER by id DESC");
while($r = mssql_fetch_array($query)){
$descr = bbcode($r['descr']);
$link = $r['link'];
$link = str_replace("http://","",$link);
$link = str_replace("www.","",$link);
echo '<table width="300" align="center">
<tr><td width="100" class="style6"><strong><u>Name:</u></strong></td><td class="D_Red">'.$r['name'].'</td></tr>
<tr><td width="100" class="style6"><strong><u>Version:</u></strong></td><td class="D_Red">'.$r['version'].'</td></tr>
</table>
<table width="300" align="center">
<tr><td class="D_Red">'.$descr.'</td></tr>
<tr><td class="D_Red"><center><a href="http://'.$link.'" target="_blank" class="D_Red"><strong>Download</strong></a></center></td></tr>
</table><br />';
}
echo '</td>
</tr>
</table><br />';
?>
SQL:
1 id int 4
0 link varchar 50
0 name varchar 60
0 version varchar 50
0 descr varchar 1000
2.------------------------------------------
Warning: mssql_query() [function.mssql-query]: message: 对象名 'site_rules' 无效。 (severity 16) in D:\www\kal\pages\rules.php on line 8
Warning: mssql_query() [function.mssql-query]: Query failed in D:\www\kal\pages\rules.php on line 8
Warning: mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource in D:\www\kal\pages\rules.php on line 9
Code:
<?
echo '<table align="center" class="content" cellspacing="0" cellpadding="0">
<tr>
<td>
<table width="440" align="center">
<tr>
<td>';
$query = mssql_query("SELECT * FROM site_rules");
while($r = mssql_fetch_array($query)){
include("bbcode.php");
$content = bbcode($r['content']);
echo $content;
}
echo '</td>
</tr>
</table>
</td>
</tr>
</table><br />';
?>
SQL2000:
1 id int 4
0 content varchar 8000
THANK.
