$link = mysql_connect("localhost","root","myoa888");$fields = mysql_list_fields('shop', 'ecs_goods', $link);$columns = mysql_num_fields($fields);for ($i = 0; $i < $columns; $i++) {echo mysql_field_name($fields,$i)."\n";}
//这段输出了shop 表esc_goodes的所有字段其中有个叫click_count字段,它的变量是点击量,现在我想输出esc_goodes中所有条,安click_count变量大小来排序输出如何做
$rs=mysql_query($sql,$link);
wihle($rw=mysql_fetch_row($rs)){
echo $rw['click_count']."<br>";}
$link = mysql_connect("localhost","root","myoa888");$sql="select * from esc_goods order by click_count desc";
$rs=mysql_query($sql,$link);
wihle($rw=mysql_fetch_row($rs)){
echo $rw['click_count']."<br>";}
mysql_close($link);
这样的吗
Parse error: syntax error, unexpected '{' in D:\RUIOA\webroot\www-web\ceshi\ECShop\mysql\1.php on line 7
服务器: localhost 数据库: shop 表 : ecs_goods
click_count 是ecs_goods 中的
$link = mysql_connect("localhost","root","myoa888");
mysql_select_db('shop',$link)
$sql="select * from esc_goods order by click_count desc";
$rs=mysql_query($sql,$link);
wihle($rw=mysql_fetch_row($rs)){
echo $rw['click_count']."<br>";
}
mysql_close($link);
后面少了;号加上去!
$sql="select * from esc_goods order by click_count desc";
有错
$sql="select * from esc_goods order by click_count desc";$query=mysql_query($sql);wihle($rs=mysql_fetch_assoc($query)) {
echo $rs['click_count']."<br>";
}
这句没用 是不是我版本太低了
mysql_connect('127.0.0.1' , 'root' , 'myoa888') or die('连接 ' .'127.0.0.1' . ' 失败。'); //连接数据库,失败则提示
mysql_select_db(shop) or die('选择数据库 ' . dz60 . ' 失败。'); //$sql = 'SELECT COUNT( * ) AS `2` , `click_count` FROM `ecs_goods` GROUP BY `click_count` ORDER BY `click_count` LIMIT 0, 30 ';
$sql = 'SELECT * FROM `ecs_goods` LIMIT 0, 30 ';
//$sql="select * from click_count order by esc_goods desc"; $query=mysql_query($sql);while ($row = mysql_fetch_assoc($query)) {
echo $row["click_count"].$row["goods_id"]."<br>";
}mysql_close();
这样可以 但是循序是低到高 我想高到低 修改那就结贴了
$sql = 'SELECT `ecs_goods`.`click_count` , `ecs_goods`.`goods_id`
FROM ecs_goods
ORDER BY `ecs_goods`.`click_count` DESC
LIMIT 0 , 30';
这个是最后获得的,完全达到自己要求的查询语句