我可以将一个字段的查询结果存储到不同的变量中吗? 如果没有那么我该怎么做?
问题描述:
This code shows the output as subject1 subject2 subject3 subject4
but I want to store that values in different variables (like $s1=[1],$s2[2],$s3[3],$s4[4]
) so I and use them in different functions what should I do? can any one help please...
此代码将输出显示为 subject1 subject2 subject3 subject4 code>但我想要 将这些值存储在不同的变量中(如
$ s1 = [1],$ s2 [2],$ s3 [3],$ s4 [4] code>)所以我在不同的函数中使用它们是什么 我该怎么办? 任何人都可以帮忙... p>
div>
答
$query = mysql_query("select `subject` from `markssub1` where `sname`='$user' AND `sid`='$id'");
$subjects = [];
while($row = mysql_fetch_array($query))
{
$subjects[] = $row['subject'];
}
foreach($subjects as $subject){
echo $subject . '
';
}