jjJOHNSON Posted March 12, 2007 Share Posted March 12, 2007 Hi I have created a database in mysql and inserted data into it. I now what to get the data out one record at a time and then press a button to get the next record. i have written the following code but this only either returns the first record or when used with a while loop produces a table of all record. $result = mysql_query("SELECT * FROM table) or die(mysql_error()); $row = mysql_fetch_array( $result ); print "<tr> Record:".$row['record'] Anyone got any ideas woule be grateful. JJ Quote Link to comment https://forums.phpfreaks.com/topic/42401-php-mysql-connection/ Share on other sites More sharing options...
wildteen88 Posted March 12, 2007 Share Posted March 12, 2007 That code only fetches one record as that is how you have coded it. You should use a while loop in order to get all the records from result of the sql query. Quote Link to comment https://forums.phpfreaks.com/topic/42401-php-mysql-connection/#findComment-205686 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.