JukEboX Posted May 1, 2008 Share Posted May 1, 2008 I am looking to show all the information last submitted to a certain table by each field. I have the connection info as well as how to query. not sure how to show the information. Ideas? Using MySQL and PHP Link to comment https://forums.phpfreaks.com/topic/103774-call-last-info/ Share on other sites More sharing options...
realjumper Posted May 1, 2008 Share Posted May 1, 2008 How about: // Retrieve all the data from the table $result = mysql_query("SELECT * FROM table ORDER BY id desc LIMIT 0,1") or die(mysql_error()); // store the record of the table into $row $row= mysql_fetch_array( $result ); echo "$row[field]"; echo "<br>"; echo "$row[field2]"; echo "<br>"; echo "$row[field3]"; Link to comment https://forums.phpfreaks.com/topic/103774-call-last-info/#findComment-531308 Share on other sites More sharing options...
JukEboX Posted May 2, 2008 Author Share Posted May 2, 2008 Great thanks. I will try it. Link to comment https://forums.phpfreaks.com/topic/103774-call-last-info/#findComment-531383 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.