[Resolved] Query Clauses

fean0r

I'm trying to let people edit there profile currenlty I'm trying to look user my user database (mysql) and when it finds the user name it returns all the profile information for that person.

but i just be doing it wrong....

SELECT * FROM user WHERE Name=USER

user is an example name of the actual person (username)

Name is the column where I store usernames

Any ideas?

jweissig

Hello,

Say for example that you have a table called 'user' that has a couple columns called "userid, username, passwd, notes, eyecolor, etc".

You use the following SQL query to find a userid (a #) with the username of 'justin';

SELECT userid, username FROM user WHERE username = 'justin';

in the example this will return userid "51". You will them create a query something like this.

UPDATE user SET username = 'justin', passwd = 'testing', notes = 'some notes', eyecolor = 'brown', etc = 'other stuff' WHERE userid = 51;

so we just took the userid 51 and created a update statement using SQL so that they can change their settings.

Hope this helps,
- Justin

fean0r

thanks

but what if I want to $userref in the claus? it dont seem to work that way..

username = $userref

fean0r

also say I want to display each item in the row of that ID?

Selecting -

$sql = "SELECT ID, username FROM user WHERE username = 'FEAN0R'";
$items = mysql_query($sql) or die(mysql_error());
$myrow = mysql_fetch_array($items);

displaying -

<?php echo $myrow["team_name"] ?>

As I'm sure you can guess i'm new to php.

Thanks

fean0r

its ok I got sorted thansk everyone..