Jump to content

Archived

This topic is now archived and is closed to further replies.

brunoboy

Display all results from a table ...

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.