Re: Help with fwrite()

From: "Nick Wilson" <nick@stylesheet.org>

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...