[help] web

Results 1 to 1 of 1
  1. #1
    Member shenzhenyan is offline
    MemberRank
    May 2008 Join Date
    37Posts

    [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.




Advertisement