brunoboy
-
Posts
1 -
Joined
-
Last visited
Never
brunoboy's Achievements
Newbie (1/5)
0
Reputation
-
Display all results from a table ...
brunoboy posted a topic in Editor Help (PhpStorm, VS Code, etc)
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.