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. Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.