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
