From: "Nick Wilson" <[EMAIL PROTECTED]>
Each user (must have an id,name clearly) can fetch as many urls as they wish, those urls get written to the db, then as each url is fetched from the db it is dealt with with php and deleted from the db.
What if a user gets cut off from the script and a whole bunch of unwanted urls are in the db though?
Should the db go like this?
db_urls url_id | user_id | project_id | url
db_user user_id | name | whatever
db_project project_id | user_id
Wow, now i've written it down it seems clearer ;) you guys reckon that's the right kind of schema (based on what you know from the above..)?
That structure looks good, but it really depends upon what "dealt with by PHP" means.
As for the user getting cut off with urls still in the DB... it shouldn't be an issue, but again it depends on what "dealt with by PHP" means.
---John Holmes...
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
