Can you think of any reason it wouldn't work?
I took the same code and created a PHP file and copied to my server and it works fine.
With the WYSIWYG off, I pasted the same code in a News item, but it does not show the results.
Is there something else I need to do?
Here is the code. I starred the username and password for this post. Like I said above, this same code works fine when put into a seperate .php file and copied to the server. See here (
www.aiabgames.com/temp/test.php)
<?
$username="******";
$password="******";
$database="aiabgame_joomla";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM jos_games WHERE Type='Joystick'";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
?>
<html>
<head><center>
<?
$i=0;
while ($i < $num) {
$Title=mysql_result($result,$i,"Title");
Echo $Title;
Echo "<BR>";
$i++;
}
?>
</center>
</body>
</html>
Thanks
Author