471,624 Members | 1,767 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,624 software developers and data experts.

user login can edit their record only - PHP / MySQL

Hi,
I'm fairly new to developing PHP / MySQL databases. I've just created a
job posting board that works OK, but I want this feature: user creates
their username/password to enter a listing. Once they've entered a job
listing, they can login again and will be able to edit / drop their
listing only. Any pointers in the right direction would be appreciated.
Jul 17 '05 #1
1 1489
Too broad a question, my friend. The answer would be "you need to read
a little about db design and how it applies to php projects".
Basically, if you for example have two MySql tables, one of them with
the user data and another with their listings data (assuming one user
can have more than one of these "listings"), you need a way to identify
wich listing/s belong to wich user/s. Usually this wil be a field in
the listings table containing the name (or any other handle/key you
have assigned to the users) of its corresponding user.

Jul 17 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Ben Binskin | last post: by
2 posts views Thread by Bennett Haselton | last post: by
reply views Thread by Adam Fortuno KOVICK | last post: by
6 posts views Thread by Bob Sanderson | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.