How to assign SQL query results to variables in php

php method to assign sql query results to variables: 1. Get a value through the "mysql_query($sql);" and "mysql_result($query,0);" methods; 2. Through "mysql_fetch_array" Get an array.

Recommended: "PHP Video Tutorial"

Specific questions:

$sql = "select field1 from pre_common_member_profile where uid='$username'";

The result is like this:

field1
1234

How to assign 1234 to a variable

Solution:

You only take this one The value still needs to be an array. Just take one word.

$sql = "select field1 from pre_common_member_profile where uid='$username'";
$query = mysql_query($sql);
$bianliang = mysql_result($query,0);
echo $bianliang;

If you get an array.

$sql = "select field1 from pre_common_member_profile where uid='$username'";
$query = mysql_query($sql);
while($row = mysql_fetch_array($query))
{
echo $row["field1 "];
}

The above is the detailed content of How to assign SQL query results to variables in php. For more information, please follow other related articles on the PHP Chinese website!