Newbie URL passing Help

[Anon]

I'm sorry, I don't even know what to call this operation.

I'm trying to pass a variable through a URL and grab it, and then log into SQL and grab the data pertaining to that Varible.

Here is the longer explination.
I have a User list, a basic table of 4, I've been able to log into SQL and then output all data in that table, the User Table. The problem is I had 28 Columns, and so I decided to do a second page with detailed info on the User.

so I try to Pass the Username through the URL when clicked.
http://www.homesite.com/datarecord.php?User=$row[username]

Then I'm stuck on how to create datarecord.php. Before this, I had only done a full list of the table, now I only want one record displayed.

Can Anyone Help, or Point me in the right direction?

[nightowl]

First of all, you certainly need the right SQL-command. Since this is a pretty simple example (and you give the impression not to know it), you might want to learn sql first: www.sqlcourse.com.

It would be something like

$sql = "select * from users where username=$User";

Now you have the exact data, you need to print it out.

[Anon]

One key thing you missed NightOwl you've got to put ' ' around $user or it'll return an error.

As to the question at hand though Degage, to pass a varriable through the url all you do is include it in your links. <a href="xxx.whatever?username=this">

Then in the page xxx.whatever you'll have a varriable setup called $username with the value of "this"

You can then use that varriable anywhere in xxx.whatever

Mark