But what happens if you don't know how many pages you are about to make, or you do but then you decide to make some more?

I beleive the idea of altering the table structure on the fly is great, so you dont have to mess with mysql all the time, altering tables, or dropping them and create new ones...Can you help me make script?

Don't you think there's a contradiction here?

I beleive the idea of altering the table structure on the fly is great, so you dont have to mess with mysql all the time, altering tables, or dropping them and create new ones...

(Bold is mine) You either think that altering the table is a great idea, or that it's a complete mess. And you're right in the second case.

What Fletch meant<stroke>, I think,</stroke> is that you should have a table with two columns: one for the name of the page, and the other for the associated counter. Something like this:

+----------+---------+
| pagename | counter |
+----------+---------+
| home     | 123     |
| page_1   | 22      |
| page_2   | 16      |
| credits  | 2       |
| policy   | 1       |
+----------+---------+
[download]

This way, each new page is just a new record in this table, which you can do with a simple INSERT.

Hey! Up to Dec 16, 2007 I was named frodo72, take note of the change! Flavio
perl -ple'$_=reverse' <<<ti.xittelop@oivalf

Io ho capito... ma tu che hai detto?

Yes indeed this is very clear and better.

But in order to increase a counter for a specific page or create it first and then populate it, the script must know which webpage just loaded for example page_5.html and extract just the filename without the dot and extension.

How to do this? The best i can do is this:

$pagename = "something that tells me what si the name of the currnt sc
+ript running, just its filename";

if ( $pagename is an already actual field inside table 'counter' then 
+)
{
    $select = $db->prepare( "SELECT pagename, pagecounter FROM counter
+s" );
    $select->execute;
}
else
{
    $select = $db->prepare( "INSERT INTO counters (pagename, pagecount
+er) VALUES (?, ?)" );
    $select->execute( $pagename, 1 );


my $pagecounter;
while( $row = $select->fetchrow_hashref )
{
    $pagecounter += $row->{pagecounter} unless ( $row->{host} eq "&#92
+5;ίκος" );
}
[download]