drew22299 — Mon, 16 Jul 2007 15:19:28 +0000

I will try chaning all of the references to userId when I can get to my computer.

At the top of the user details page is

<?php
username = request.cookies("passes")
?>

I think username is the email address, this is why I asked if the cookies have anything to do with the error?

This is the code on the browse user page, "user" is the email field, why does it give an error when I replace user with userId? It's still refering to a record? or is it because it isn't a primary key?

while not rs.eof%>

<?php
=rs("userId")
?>

Align="left">

<?php
=rs("user")
?>

<?php
=rs("user")
?>

pr0gr4mm3r — Mon, 16 Jul 2007 13:25:44 +0000

Doubt it. If you change it to the userid instead of the email, you should change all queries on that page that refers to the email. Make it refer to the userid instead.

...or a less efficient but quicker way would be to insert some code in the beginning of the page that takes the userid from the URL, and uses that to find the email address. Then, you can set the email $_GET variable for the rest of the queries that use it.

drew22299 — Mon, 16 Jul 2007 11:20:41 +0000

Thanks for your replies and yes, there is the userId field. It's a script I have modified so I can learn how it works. If I change the reference to userId as the reference in the link it goes to the user details page and there is an ASP error which says there needs to be a current record selected or something. There are some cookie assignments at the top of the page, could they have anything to do with this error?

pr0gr4mm3r — Sun, 15 Jul 2007 18:35:01 +0000

Your system is using that email address as the key in the database. Unless there is another unique field in the DB that you can use as the key, you will have to stick with the email address.

brady.k — Sun, 15 Jul 2007 15:11:54 +0000

It would depend on your site's structure. If you created the system that allows profile.php/user?wahterv@aasf.com to show the profile, then you are the one who knows how to fix it.

Otherwise, it depends on whose/what code you're using. Chances are that if it's some packaged software, it's not going to be easy to change.