#4 Please add a $table_prefix

[Steve Frampton]

As many of us are hosting with 3rd partys and can not
control database creation, etc., it might not be
possible to create a "jobs" database. In my case, I
have one database where I have to share everything
else. So, it would be helpful to define a
$table_prefix variable, and then do
inserts/updates/queries on $table_prefix_tablename. In
my case I modified things to point to jobs_... so it
would not conflict with my other tables.

Thanks!

[Steve Frampton]

Logged In: YES
user_id=36586

Also, please consider using table aliases:

SELECT location.name, salary.amount, blah blah
FROM location, salary, ...
WHERE location.......

becomes

SELECT a.name, b.amount, blah blah
FROM location a, salary b, ...
WHERE a........

That makes it MUCH easier to modify the code to add things
like the $table_prefix idea.

Thanks...