mysql环境中，如何用sql语句给字符串变量赋值？

mysql给字符串变量赋值的方法是用select into 变量结构完成赋值。使用sql的结构语法：SELECT ... INTO var_list selects column values and stores them into variables.比如定义一个sql变量：@x varchar(10)@y varchar(20)select id,name INTO @x,@y from dx_tt 这样就完成了赋值。

$sql="select * from list order by id asc "

$rs = mysql_query($sql)

while ($row = mysql_fetch_array($rs))

{

$data[] = $row//需要保存到2维数组中才可以调用的

}

echo "这是第一条记录。ID=".$data[0][0]."，title=".$data[0][2]

运行这个看看 有不明白的请看我给的参考资料 和PHP手册

sprintf(query, "SELECT *FROM history WHERE serialnumber='%s' AND adtcode='%s' LIMIT 1", dataStr,modulename)

if (!mysql_real_query(mysql, query, (unsigned long)strlen(query))) {

res = mysql_use_result(mysql)

numfields = mysql_field_count(mysql)

while (row=mysql_fetch_row(res)) {

fprintf(outfile, "\r\n")

lengths = mysql_fetch_lengths(res)

fields=mysql_fetch_fields(res)

for (i=0i<numfieldsi++) {

fprintf(outfile, "%.*s ", (int)lengths[i], row[i])

}

}

---