Counting returned MySQL rows, and possibly storing returned recordset in a session variable

From: Date: Tue, 26 May 2009 11:01:28 +0000
Subject: Counting returned MySQL rows, and possibly storing returned recordset in a session variable
Groups: php.windows 
Request: Send a blank email to php-windows+get-29355@lists.php.net to get a copy of this message
As far as I know/thought, you could include something like COUNT(*) in a list of fields to be returned from MySQL to get told how many rows were returned by mysql_query, but it doesn't seem to want to work on this instance of MySQL I have here installed inside WAMP. Also, if I try assigning the result of mysql_query to a session variable, the mysql_fetch_array function doesn't work since the result set hasn't been assigned to the current mysql session or something - is there any way to carry this over page to page without requerying the database itsself? TIA Jacob Kruger Blind Biker Skype: BlindZA '...fate had broken his body, but not his spirit...'

« previous php.windows (#29355) next »