php shows no results
| From: | Dominic | Date: | Sat, 02 Aug 2003 20:21:20 +0000 |
| Subject: | php shows no results | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-20993@lists.php.net to get a copy of this message | ||
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