mysql 连接问题

[qqsweb]

$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变量大小来排序输出如何做

[dzxccsu]

写得那么复杂

$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>";

}

[qqsweb]

$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 中的

[dzxccsu]

[Quote=引用 2 楼 qqsweb 的回复:]
PHP code$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 中的
[/Quote]

$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);

[dzxccsu]

mysql_select_db('shop',$link)
后面少了;号加上去！

[qqsweb]

Parse error: syntax error, unexpected T_VARIABLE in D:\RUIOA\webroot\www-web\ceshi\ECShop\mysql\1.php on line 4

也就是
$sql="select * from esc_goods order by click_count desc";
有错

[qqsweb]

wihle($rw=mysql_fetch_row($rs)){

还是报这行出错

[qqsweb]

Parse error: syntax error, unexpected '{' in D:\RUIOA\webroot\www-web\ceshi\ECShop\mysql\1.php on line 6

[phpboy]

$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>";
}

[qqsweb]

$sql="select * from esc_goods order by click_count desc";
这句没用 是不是我版本太低了

[qqsweb]

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();

这样可以 但是循序是低到高 我想高到低 修改那就结贴了

[TR@SOE]

靠，可以这样提问！

[qqsweb]

所有问题都解决了 代码没错 主要是查询语句有问题

最好是通过phpMyAdminl来拿
$sql = 'SELECT `ecs_goods`.`click_count` , `ecs_goods`.`goods_id`
FROM ecs_goods
ORDER BY `ecs_goods`.`click_count` DESC
LIMIT 0 , 30';
这个是最后获得的，完全达到自己要求的查询语句