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 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. Link to comment https://forums.phpfreaks.com/topic/42401-php-mysql-connection/#findComment-205686 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.