how to make a popup window that loads everytime a user logs into the system.

[backups2007]

I want to be able to create a popup window that opens everytime a user logs in. And that window displays all the status of the forms that the user has filled up. I have 3 types of form status. Cancelled, pending, and finished. I want to be able to sort them by date created and by the total number of cancelled and pending forms. How should I do it?

[code green]

You are going to need a database to drive that page.
A simple table should be enough with user ID, name and status.
The user would log on with their details then submit the page.
then a script could verify the input, read the database and display the info back.

[backups2007]

You are going to need a database to drive that page.
A simple table should be enough with user ID, name and status.
The user would log on with their details then submit the page.
then a script could verify the input, read the database and display the info back.

Should I just use mysql_num_rows( ) to display and count the number of pending or cancelled transactions?

[code green]

Should I just use mysql_num_rows( ) to display and count the number of pending or cancelled transactions.

mysql_num_rows( ) returns the number of records returned from a SELECT query.
The most important thing is a good query returning the data needed.
Records can be counted in various ways.
You seem to be only in the planning stage of the whole project at the moment, wheras the number of records is trivial.
Start the DB and form design first.

[backups2007]

mysql_num_rows( ) returns the number of records returned from a SELECT query.
The most important thing is a good query returning the data needed.
Records can be counted in various ways.
You seem to be only in the planning stage of the whole project at the moment, wheras the number of records is trivial.
Start the DB and form design first.

I've already done that. I've been working on the project for a few months now. I'm not really an expert in PHP and just needed expert advice.

[code green]

I've already done that. I've been working on the project for a few months now. I'm not really an expert in PHP and just needed expert advice.

Sorry! Yes it sounds like you need a simple DB table.
Instead of mysql_num_rows( ) you could use COUNT in the query then the recordset returned would be simply a number.
But, as I was trying to drive at, it all depends on your overall design really.
Good luck and please ask again

[backups2007]

Sorry! Yes it sounds like you need a simple DB table.
Instead of mysql_num_rows( ) you could use COUNT in the query then the recordset returned would be simply a number.
But, as I was trying to drive at, it all depends on your overall design really.
Good luck and please ask again

Apology accepted. Thanks. Well, what about the date. how do i display it? Say for example, if I put something like 'There are (number) forms pending for approval as of 12/06/2007'?

[code green]

'There are (number) forms pending for approval as of 12/06/2007'?

Is that June 6 or December 12?

I want to be able to sort them by date created and by the total number of cancelled and pending forms.
How should I do it

table design of `form_status` 
with fields of `user_id` INT,`pending` TINYINT,`completed` TINYINT ,`date`  DATETIME

You could get all the data and manipulte with code or get the pending/comleted etc seperately.
Lets take the second idea.
[PHP]mysql_connect() etc..
$res = mysql_query(SEL ECT * FROM `form_status` WHERE `pending`
ORDER BY `date` DESC);
$lastEntry = mysql_fetch_ass oc($res);
echo 'There are '.mysql_num_row s($res).' forms pending for approval as of '. date('m/d/Y',strtotime($l astEntry['date'];[/PHP]And then repeat for cancelled etc.
There are other ways of course and my syntax may be out but hopefully this will help