Check what mysql_error() returns.
But I don't the see any code which should even display something:
-Mike
On Sat, 2 Aug 2003, Dominic wrote:
> Date: Sat, 2 Aug 2003 16:21:20 -0400
> From: Dominic <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] php shows no results
>
> I have the following php statement which shows results when I run on the
> database server in SQL. The page connects to the database server, but for
> some reason returns no results. It does show results if I setup for another
> table however. The code is:
>
> <?php require_once('../../Connections/Options.php'); ?>
> <?php
> mysql_select_db($database_Options, $Options);
> $query_Recordset1 = "SELECT * FROM TStory";
> $Recordset1 = mysql_query($query_Recordset1, $Options) or
> die(mysql_error());
> $row_Recordset1 = mysql_fetch_assoc($Recordset1);
> $totalRows_Recordset1 = mysql_num_rows($Recordset1);
> ?>
>
> The table was made as:
> CREATE TABLE `TStory` (
> `TstoryUID` smallint(6) NOT NULL auto_increment,
> `Title` varchar(100) NOT NULL default '',
> `ShortText` varchar(100) NOT NULL default '',
> `LongText` varchar(100) NOT NULL default '',
> `Page` smallint(6) NOT NULL default '1',
> `Section` smallint(6) NOT NULL default '1',
> `Writer` varchar(100) NOT NULL default '',
> PRIMARY KEY (`TstoryUID`)
> ) TYPE=MyISAM;
>
> Any thoughts would be greatly appreciated.
>
> --
> Dominic
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
