brunoboy Posted September 7, 2005 Share Posted September 7, 2005 Hi, I'm a beginner with php, MySql with dreamweaver ! I would like display all informations (rows and columns) from one of my sql "table". But with my code, I can only display one record. So I think I must use a "while", but is someone could say to me the exact code and emplacement I must write please. As this I could understand exactly that for future request. This is my code : <?php require_once('../Connections/transefusion.php'); ?> <?php mysql_select_db($database_transefusion, $transefusion); $query_tab_comment_test = "SELECT * FROM tab_commentaire ORDER BY `date` DESC"; $tab_comment_test = mysql_query($query_tab_comment_test, $transefusion) or die(mysql_error()); $row_tab_comment_test = mysql_fetch_assoc($tab_comment_test); $totalRows_tab_comment_test = mysql_num_rows($tab_comment_test); ?> <html> <head> <title>Untitled Document</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <font size="-5"><font color="#FF0000" size="3"><strong><?php echo $row_tab_comment_test['nom']; ?></strong></font> </font><br> <em><font color="#00CCFF" size="2"></font></em> </body> </html> <?php mysql_free_result($tab_comment_test); ?> Thanks a lot. Bruno. Link to comment https://forums.phpfreaks.com/topic/2489-display-all-results-from-a-table/ Share on other sites More sharing options...
Mattyspatty Posted September 15, 2005 Share Posted September 15, 2005 i am sure DW has some sort of repeating table thingy, use it if u can find it if not youll have to get sum1 to rebuild it cos DW makes code difficult to edit in certain situations Link to comment https://forums.phpfreaks.com/topic/2489-display-all-results-from-a-table/#findComment-8322 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.