Page 1 of 1

Automatically show number of rows

Posted: Thu Jun 21, 2007 8:55 pm
by gavenp
I have a form for registrations and at the top of the form (outside te form <> ) I have the following

"As of  (Date) we have (Number) Expressions of Interest"

Where date is the date of the computer being used (based on clock)
Where number is the number of rows already in circusart db from table register1

I can get the clock working but how do I show the number of rows from the register1 table in circusart db.

Currently this form is in html for editing purposes.

Posted: Thu Jun 21, 2007 9:02 pm
by smudge
computer being used as... a server or a client?
if it's a server, use the php date() function
if it's a client, use javascript.

as for the number of rows in a db, take a look at http://us3.php.net/manual/en/ref.mysql.php. You should find what you are looking for there.