mysql select a single row

Discuss coding issues, and scripts related to PHP and MySQL.
User avatar
JanMolendijk
Posts:282
Location:Holland Rotterdam

mysql select a single row

I wanna use this code but only a single row, do you known how to select it ?
https://coursesweb.net/php-mysql/php-mys ... t-order-by

Code: Select all

// SELECT sql query
$sql = "SELECT `id`, `name`, `pass` FROM `users`";

JanMolendijk Posts:282
I found the answer i have to do this

Code: Select all

// SELECT sql query
$sql = "SELECT `user_longbio`, `user_id` FROM `user` WHERE `user_id`='10000' ";