search for other fields by username

[beennn]

in my table i haveusername | age | --------------------1-------------202-------------253-------------30how can search for a users age by there username?like: find username 1's age and echo it

Edited July 22, 2011 by beennn

[beennn]

in case that didnt make sense iv done a diagramdiagram on imageShack

Edited July 22, 2011 by beennn

[Ingolme]

Do you have a database?

[beennn]

yes

[Ingolme]

OK. Have you looked at the PHP tutorial for databases on W3Schools?

[beennn]

a few days ago i did, cant remember there being the answer to this because i was looking for something else but ill read through it again

[HungryMind]

Hi.Try, This

if($rs=mysql_fetch_array(mysql_query("SELECT * FROM table_name where username='Bob'"))){echo $rs['age'];}else{echo 'No Record Found';}

But! If you've multiples same age values in database, Then what will you do?

[beennn]

So this will work so long as no 2 ages are the same? what happens then?EDIT: Ahh looks like i didnt read all the way through the tut.found what im looking for; altho before i start to implement it into my site, will this come accross any problems when it comes to having multiple values?

<?php$con = mysql_connect("localhost","peter","abc123");if (!$con)  {  die('Could not connect: ' . mysql_error());  }mysql_select_db("my_db", $con);$result = mysql_query("SELECT * FROM PersonsWHERE FirstName='Peter'");while($row = mysql_fetch_array($result))  {  echo $row['FirstName'] . " " . $row['LastName'];  echo "<br />";  }?>

Edited July 22, 2011 by beennn

[Ingolme]

So this will work so long as no 2 ages are the same? what happens then?EDIT: Ahh looks like i didnt read all the way through the tut.found what im looking for; altho before i start to implement it into my site, will this come accross any problems when it comes to having multiple values?

<?php$con = mysql_connect("localhost","peter","abc123");if (!$con)  {  die('Could not connect: ' . mysql_error());  }mysql_select_db("my_db", $con);$result = mysql_query("SELECT * FROM PersonsWHERE FirstName='Peter'");while($row = mysql_fetch_array($result))  {  echo $row['FirstName'] . " " . $row['LastName'];  echo "<br />";  }?>

There's no problem if the names are unique. If the names aren't unique, then you will have to show a list of results. That's shown right there in the tutorial.A proper database table must always have at least one unique field.

[beennn]

thank you very much