# Simple PHP/MySql questions

**URL:** <https://forum.kirupa.com/t/simple-php-mysql-questions/55826>\
**Category:** programming\
**Created:** [June 28, 2004, 7:48am UTC](https://forum.kirupa.com/t/simple-php-mysql-questions/55826 "2004-06-28T07:48:23Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![opel](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/opel/32/199_2.png) [@opel](https://forum.kirupa.com/u/opel)\
**Post date:** [June 28, 2004, 7:48am UTC](https://forum.kirupa.com/t/simple-php-mysql-questions/55826/1 "2004-06-28T07:48:23Z")

</div>

I am currently learning php and Mysql and I have a few questions that I hoped the experts on here could answer.

I’m creating a job vacanies section of a clients site. They have 6 divsions in the company and want to show the jobs available for each divsion separately.

1. Is it best practice to create **six** tables in **one** database. Then have 6 pages , one for each table, pulling out and displaying the data?

2. I want my client to be able to delete jobs from the database. Should I show him how to delete them using PHP\_MyAdmin or is there a simpler way to do it?

3. Does anyone know a PHP script to allow people to browse from there comptuer and attach the files in the form?

Thank you

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [July 8, 2004, 3:42am UTC](https://forum.kirupa.com/t/simple-php-mysql-questions/55826/2 "2004-07-08T03:42:33Z")

</div>

> [@opel](#):
>
> 1. Is it best practice to create **six** tables in **one** database. Then have 6 pages , one for each table, pulling out and displaying the data?
> 2. I want my client to be able to delete jobs from the database. Should I show him how to delete them using PHP\_MyAdmin or is there a simpler way to do it?
> 3. Does anyone know a PHP script to allow people to browse from there comptuer and attach the files in the form?

I recently finish a simular project little bigger but the same functions

1: it doesnt mather howmuch tables are within 1 database…  
2: mysql\_query(DELETE FROM \<tablename\> WHERE something=somevalue  
3: uploads -\> $HTTP\_POST\_FILES or $\_FILES [www.php.net](http://www.php.net)

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [July 8, 2004, 8:40am UTC](https://forum.kirupa.com/t/simple-php-mysql-questions/55826/3 "2004-07-08T08:40:19Z")

</div>

thanks