Jump to content

selecting certain data from database


mattm1712

Recommended Posts

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

Link to comment
https://forums.phpfreaks.com/topic/199821-selecting-certain-data-from-database/
Share on other sites

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'];
}

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.