How to do retrieve sql data and display in php page

Question

i want to retrieve particular cell data from mysql. and it should display in a php page.

details-

db name: register, table name: users

columns are: username, fullname, email, password.

i want to display 'fullname' column first row data in php. how to do that.

Possible duplicate of Fetching data from MySQL database using PHP, Displaying it in a form for editing — Rahul
– Rahul, Commented Feb 29, 2016 at 5:42

urfusion · Accepted Answer · 2016-02-29 05:42:38Z

-2

NOTE: MySql is deprecated. You should use MySqli or PDO.

This would help you.

$sql = "SELECT fullname FROM users";
$row = mysql_query($sql);

while($data = mysql_fetch_assoc($row)){
    echo $data['fullname'];
}

answered Feb 29, 2016 at 5:42

urfusion

5,4995 gold badges56 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

@Dagon : didn't get you.