Deleting multipule recorts at the same time.

[brett]

Hi, I am new to all of this and loving every minute of it!. I am building a tool for our HR to manage the job listings. I need suggestions on how to code the portion that will delete jobs they no longer want. What I was thinking was a page that pulls up all the records based on locations, then to have a check box that they can check. (multiple jobs at once) then click the delete button. I am having a hard time figuring out how I can make that work. Any suggestions?
Thanks
Brett

[csousley]

Give this as try, in the form that displays the job listings you need to make your input names like this:

<input type='checkbox' name='jobid[]' value='<?=$jobid?>'>

then in the php page that deletes the jobs you would do something like this:

foreach($jobid as $value) {
$query = 'delete from table where jobid = $value';
}

Make Sence?

-Cy

[brett]

Will that work for multiple jobs at once?

[csousley]

Yes, the foreach statement is a loop for each time 'jobid[]' is passed. So if you check five jobs for deletion it will delete those five jobs.

Now it's not exatly at the same time in reality, but as far as the user is concerned, it deletes them all at the same time.

Does that help?

-Cy