Suzanne — Tue, 22 Jun 2004 22:08:07 +0000

oh, you want to print off your sql tables entirely?

column names and fields?

I already showed you how to count the rows, only you don't seem to mean "row" when you say row... You want to count every single cell? I think it would be advisable for you to go to mysql.com and learn the terminology so you can express your question in way that we can all understand so we don't confuse you further!

Anyway, if you know the column names, you can do what I told you earlier, only you'll identify them as such:

<?php
$sql = \"SELECT * FROM mydb\"; 
$qry = mysql_query($sql); 
$numrows = mysql_count_rows(); 
 
echo \"There are $numrows records in this database<br />They are as follows:<br /><br />\"; 
 
echo<<<OPENTABLE
<table width=\"100%\" id=\"listing\">
    <tr>
        <th>Column Name</th>
        <th>Column Name</th>
        <th>Column Name</th>
        <th>Column Name</th>
    </tr>
OPENTABLE;
while ($row = mysql_fetch_array($qry)) { 
    echo<<<ROW
<tr>
    <td>$row['title1']</td> 
    <td>$row['title2']</td> 
    <td>$row['title3']</td> 
    <td>$row['title4']</td>
</tr>
ROW;
}  
echo \"</table>\";
?>

Keripukki — Tue, 22 Jun 2004 21:00:50 +0000

I mean I'd like to view some table in database in "excel-style".
It could help a lot if somebody told me how to count those titles (I mean the fields in database).

Keripukki — Tue, 22 Jun 2004 20:22:33 +0000

Thanks for you're answers,
But what if I have something like this in my table:

<?php
 
titles | titles 2 | titles 3 ....
----------------------------------------
row       row        row
row       row        row
?>

Now I'd like to print those all titles to web page and print row under each. Count of titles is different in every of my tables... so I'd could be nice if I could print any of them with same script. Now I have to manually define how many titles there are and then query rows for each

Greg K — Tue, 22 Jun 2004 17:51:07 +0000

Can you provide a small sample of how you would like the output displayed and the table setup?

-Greg

Suzanne — Tue, 22 Jun 2004 15:55:01 +0000

Use a while loop.

<?php
$sql = \"SELECT title FROM mydb\";
$qry = mysql_query($sql);
$numrows = mysql_count_rows();

echo \"There are $numrows titles in this database<br />They are as follows:<br /><br />\";

while ($row = mysql_fetch_array($qry)) {
    echo \"$row['title']<br />\";
}
?>

See mysql.com for details on how to pull more selective information and sort it using the SELECT statement, and php.net on how to use while loops and others to get that information displayed.