Jump to content


Photo

Display all results from a table ...


  • Please log in to reply
1 reply to this topic

#1 brunoboy

brunoboy
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 07 September 2005 - 05:40 PM

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.

#2 Mattyspatty

Mattyspatty
  • Members
  • PipPipPip
  • Advanced Member
  • 76 posts
  • LocationEngland :D

Posted 15 September 2005 - 09:58 AM

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
ok, so my PHP is a bit rusty... my replies are 90% ok.
the other 10% either have syntax errors or are the "hard solution"
http://www.php.net  http://www.google.com - Are your friends!

I have a C++ problem with 'keybd_event' in certain applications. if you can help me PM me! :P
Needs motivation to create another quick cash website. I need a new TV




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users