我想在数据中根据某个值查询对应的值.例:知道user的值然后显示pwd的值。我在phpamdin里面测试的代码是:
$sql = 'SELECT pwd'
. ' FROM `appdata` '
. ' WHERE user = \'[email protected]\' LIMIT 0, 30';
但是加在php文件里面执行总是不成功。下面是我的代码,怎么修改呢?
<?php
include_once "logindatabase.php";
$cmd = mysql_query(SELECT * FROM appdata WHERE user [email protected]);
$rec = mysql_fetch_array($cmd);
echo $rec[Pwd];
?>
谢谢大家~
$sql = 'SELECT pwd'
. ' FROM `appdata` '
. ' WHERE user = \'[email protected]\' LIMIT 0, 30';
但是加在php文件里面执行总是不成功。下面是我的代码,怎么修改呢?
<?php
include_once "logindatabase.php";
$cmd = mysql_query(SELECT * FROM appdata WHERE user [email protected]);
$rec = mysql_fetch_array($cmd);
echo $rec[Pwd];
?>
谢谢大家~
include_once "logindatabase.php";
$cmd = mysql_query('SELECT * FROM appdata WHERE user="[email protected]"');
$rec = mysql_fetch_array($cmd);
//while($rec = mysql_fetch_array($cmd))
echo $rec['Pwd'];
?>
再问一个问题?显示只能用数组的方式来显示吗?因为这个值是唯一的,有没有办法直接显示?
<?php
include_once "logindatabase.php";
$cmd = mysql_query('SELECT Pwd FROM appdata WHERE user="[email protected]"');
$rec = mysql_fetch_array($cmd);
//while($rec = mysql_fetch_array($cmd))
//echo $rec['Pwd'];
echo $rec[0];
?>
感觉这样有些麻烦,不用数据直接赋值就好了。
include_once "logindatabase.php";
$cmd = 'UPDATE appdata SET sData ="'.$_post["u_content"].'"'.'WHERE User ="'.$_post["u_email"].'"';
$data = mysql_query($cmd) or die("失败了!");