selecting certain data from database

[mattm1712]

im new to php so if this is a stupid question just say so

 

i have made a comment system where it just posts commentes into a data base with, my data being username, email , comment and a idnumber

 

say i have a varible $t  is  post number 120 and a want to get the username from the data base how would i do that?

 

matt

[mattm1712]

what i want to do is make an email notification that replies if someone comments on the post

[coupe-r]

try this.

 

$result = mysql_query("SELECT * FROM

WHERE id='120'");   $row = mysql_fetch_array($result);   $username = $row['username'];   echo $username;

[de.monkeyz]

Do you know how to use MySQL queries in PHP?

 

If you wanted the username from post 120 you'd use the query

 

SELECT username FROM comments WHERE id = 120

 

Then in PHP:

 

$result = mysqli_query("SELECT `username` FROM comments WHERE id = 120");
if($result) {
    $row = mysqli_fetch_assoc($result);
    $username = $row['username'];
}

[CelticExile]

SELECT Username FROM tablename WHERE PostNo = $t

[mattm1712]

right i want to select the username from the first table then  using that usernamr select the email from another table in my database how would that work?