Automatically show number of rows

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
gavenp
Forum Newbie
Posts: 6
Joined: Sat Jun 09, 2007 3:03 am

Automatically show number of rows

Post 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.
smudge
Forum Contributor
Posts: 151
Joined: Sun May 20, 2007 12:13 pm

Post 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.
Post Reply