[Noob Help] Retrieving Info (MSSQL 2000)

[Octie]

Ok so, I think most of you guys will solve my problem in a sec.

I've come to the following code:

<?
$result = do_query("SELECT "current_imp" FROM "account","GameDB");
$imp = mssql_num_rows($result);

echo "<div style=\"clear:both;margin-top:50px;\"><table>
		<tr><td>Total Item Mall Points:</td><td>". $imp. "</td></tr>
	</table></div>";
?>

I don't really know if this is correct, but it's my only shot. The info is here:

Database: GameDB
Table: Account
Column: current_imp

[tomhath]

First thing is to get rid of all the extra quotes in your query. You should also be checking for an error after the do_query call.

$result = do_query("SELECT  current_imp  FROM  account","GameDB");

[Channel5]

Try this:

<? 
$result = do_query("SELECT current_imp FROM account", GameDB); 
$imp = mysql_num_rows($result); 

echo '<div style="clear:both;margin-top:50px;"><table><tr><td>Total Item Mall Points:</td><td>'. $imp. '</td></tr></table></div>'; 
?> 

You only put "" around the query itself, then tag the database on after the quotes.

I use echo 'stuff'; (the singles quote marks) because I've found it can be tedious to add the backslashes before the "s (double quote marks) in the html. But if I use the singles instead of the doubles, the only time have to add the backslash is if there's a single quote mark, which isn't nearly as often in html code...

Just a tip I found helpful, in case you're interested.

[walterquez]

I think GameDB should be enclosed in quotes, otherwise PHP would think it is a constant.