CODEWITHSUNDEEP
phpmysql
Belgin Fish
Belgin Fish

Reputation: 19847

Retrieve Specific Data/Value From Database 1 Line PHP

I'm just wondering how I can retrieve a specific value (only 1 thing will be returned) from a database using php.

My query is 

mysql_query("SELECT balance FROM users WHERE username = '". $this->username . "'")

I'm just looking for it to retrieve the data from that row so I can save it directory into a variable.

Upvotes: 0

Views: 1764

Answers (1)

edwin
edwin

Reputation: 2841

In MySQL, you can limit the number of results using LIMIT:

mysql_query("SELECT balance FROM users WHERE username = '". $this->username . "' LIMIT 1")

Upvotes: 3

Related Questions