Answers for "mysql query get one row"

SQL
0

get only one row in mysql

$q = "select whatIwant FROM table where id = 'myId' LIMIT 1";
$r = mysql_query($q);
while($i = mysql_fetch_array($r)) {
   $j = $i['whatIwant'];
}
echo $j;
Posted by: Guest on May-29-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language