try using your id column of the table Select * from table where table_id=1 using mysql_fetch_array with the above query will work.
Mike ----- Original Message ----- From: "Natividad Castro" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 27, 2002 5:04 PM Subject: [PHP-DB] retrieving one record at a time > Hi to all, > I'm new to PHP. I'm trying to retrieve data from a database, but I just want > to retrieve one record at a time and go through to the next records by click > next record. I know how to retrieve all record by using the > mysql_fetch_array, but I'm having problems to select one record at time. Any > idea? > > Thanks in advanced > Nato > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php