Single line database query

mastero4

I am setting up a new site that the first page is a setup for people to pay their referrers. I have given them a user id that is auto incremented in the database. After filling out the final form, they are given their ID and URL to promote. This is all fine.

My problem is that I can not figure out how to have the page URL say http://whatever.com/index.php?id=34 and it pulls out their other fields such as e-gold account number without pulling everyone in the database.

Can you help with this portion of the scripts? Thank You in Advance.

[deleted]

you just make a href to the index. <a href="index.php?id=34">User XYZ</a>

Then you can make a sql query like in the index.php script:

$sql = "SELECT e-gold FROM tablename WHERE userid = $_GET['ID']";

that should return you the e-gold column content in you database. (of the user with the id 34)

ali

mastero4

I have done this, the the egold number is to be pulled within another script. When I was using this route, but with the egold number as the referral id and no database it worked fine. I can not get it though. Here is a portion of that code with the e-gold payment with XXXXXX where I need their e-gold number to appear:

The field for XXXXXX should be named egold.
Thanks