sending varibles

[rhaggert]

this is my background:
I've been working on this project on and off for almost a year. I just started out working with php and mysql at the begining of the project so all of it was just about new to me.
as of now I am faced with solving a problem that is keeping me from finishing the project.

details:
one php file prints the html (wich is a form) and sends it to another php file. now i can send infor mation via "<FORM action=otherfile.php method=post>" just fine but in the first page there is a mysql print out of employees table with there uid. now using form checkboxes i can grasp those uids and send them over. but when i get to the other page i need the number of rows; i guess i could use a mysql look up, again, to do a mysql_num_rows but there must be another way to send varibles. some one suggested that i use globals. now i havnt used them yet. also people (the employee) logs onto this site, so there could be multiple users running this script. if i use a global wouln't i run into problems since many users could be setting the value they are using to that global and in the end i do not think i would get the correct results in the database.

in general:
the project in general consists of 5 tables
1)employees
2)jobs
3)clients
and since i have a many to many relationship going on, i have
4)job emloyee relationship
5)job client relationship

now employees have to log on to the site and add clients and jobs (and many employees can have the same job. this is where my problem is. i have a mysql connect to print all employees and the user checks which others he has working with him. sending that data from the html_print functions to the "do the sql and digest somne info and actually add it to the db. sending that information to the next page seems to be a problem)

thanks for any help

[rohithmr]

well Im no database management expert but i think just including a hidden field in ur form in the first page can solve ur problem.

Do ur SQL print out in teh first page, get the uid and store it in $uid. Now when u print out the form include an addtional tag:

<input type="hidden" name="uid" value="<?php echo $uid; ?>">

now on the page that it submits to, u can access the uid like this:
$POST['uid'] or $GET['uid'], depending on whether u use POST or GET method to post ur data.

Surgeon General's Warning: As with other methods of passing data like using cookies, or passing it in the URL, the determined user CAN alter the uid manually. So include some kind of validation in the second page. 😃