Re: php shows no results

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 <dominic@jet-base.com> > To: php-windows@lists.php.net > 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 >