Going directly to a MySQL Database Record

[fool]

Hello,

For a few days now I have been trying to do what I suspected isn't too
difficult. I have a MySQL database of user profiles. I want my users to be able
to access their profiles and update them (PHP). I only want them to be able to
access and update their own profiles.

I have tried a couple of things. (none of which worked).

Firstly I created a log-on screen using the dreamweaver new login server
behaviour (using a password and email as the logon requirements).

This worked to an extent but when the user logged on, they were not directed
to the record with the corresponding email and password, rather the first
database record entry. After a bit of searching around, I came to gather that I
need to send a URL Parameter and used a method similar to one I saw in the
Master_detail tutorial in the dreamweaver developer area. However I could not
get it to work to my needs.

My second attempt was to create a form with the following SQL Statement SELECT
*
FROM TestTable
WHERE contactmail = '". $POST['email']. AND password = . $POST['password'].'"

But again, the URL parameter caused me problems.

Any advice on this would really and truly be greatly appreciated. Many thanks.

Adam

[rickvv1]

Adam - I hesitate sending you to an off-site resource....but:
PHPfreaks.com can be a valuab;e resource with various tutorials.
[url]http://www.phpfreaks.com/tutorials/65/0.php[/url]

Also, if you follow the Master/Detail tutorial(as in....Build a small site
with that tutorials, instead of simply reading it ;) here at macromedia, you
will see the light to your URL parameter dilemma. You are very close.
Double check your UPPER/lower case, look at the URLparameter again in your
results page, check for missing "=" signs.
Good hunting,
rick