For $26 a month! That'll buy some excellent reference material instead :)
>>On Thu, 7 Mar 2002 11:47:51 -0500, Keith Elder <[EMAIL PROTECTED]> wrote: >>Hi Gavin, >> >>I didn't know if you knew this or not but there is a site which >>provides lives PHP / MySQL support. Take a look at http://www.phphelpdesk.com . It >is a live PHP support site which helps you get real time answers to PHP problems. >> >>Keith >> >> >>* Gavin Philips-Page ([EMAIL PROTECTED]) wrote: >>> User-Agent: Microsoft-Entourage/9.0.2509 >>> Date: Thu, 07 Mar 2002 18:20:31 +0200 >>> Subject: Stepping through a MySQL_fetch_array in PHP? >>> From: Gavin Philips-Page <[EMAIL PROTECTED]> >>> To: MySQL Problems <[EMAIL PROTECTED]> >>> >>> Could anybody please help: >>> >>> In the query I have included a limit string which allows me to display >>> individual records page by page. The limit string variable is >>> incremented/decremented using hyperlinks. I feel it would be better if I >>> could somehow manually step through the returned >>> $query_data = mysql_fetch_array($result). Is it possible to create a loop >>> with a counter to step through the records contained in the array? >>> >>> // PHP Code >>> $link_id = db_connect($default_dbname) ; >>> if(!$link_id) error_message(sql_error()) ; >>> $query = "select count(*) from $user_tablename" ; >>> $result = mysql_query($query) ; >>> if(!$result) error_message(sql_error()) ; >>> $query_data = mysql_fetch_row($result) ; >>> $total_num_user = $query_data[0] ; >>> if(!$total_num_user) error_message('No records found!') ; >>> >>> $query = "select usernumber, userid, userpassword, username, sex, >>> nationality, usermail, userprofile, registerdate, date_format(registerdate, >>> '%M, %e, %Y') as formatted_registerdate, lastaccesstime, >>> date_format(lastaccesstime, '%M, %e, %Y') as formatted_lastaccesstime from >>> $user_tablename $order_by_str $sort_order_str $limit_str" ; >>> >>> $result = mysql_query($query) ; >>> if(!$result) error_message(sql_error()) ; >>> >>> $query_data = mysql_fetch_array($result) ; >>> // Table displaying the found records from MySQL database >>> >>> Thanx >>> >>> Gavin >>> >> >> >>####################################################### >> Keith Elder >> Email: [EMAIL PROTECTED] AIM: ZZorKKa YIM: keitheld >> Phone: 1-734-507-1438 >> Text Messaging (145 characters): [EMAIL PROTECTED] >>Web: http://www.zorka.com (Howto's, News, and hosting!) >> >> "With enough memory and hard drive space >> anything in life is possible!" >>####################################################### >> >>--------------------------------------------------------------------- >>Before posting, please check: >> http://www.mysql.com/manual.php (the manual) >> http://lists.mysql.com/ (the list archive) >> >>To request this thread, e-mail <[EMAIL PROTECTED]> >>To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> >>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
