Question

PHP 里的查询语句

在一产品展示系统里（product.php）。
全部数据集合时为
$result=mysql_query("select * from `product` order by Shop_Id desc ");
此时正常显示所有数据。
请问：在各分类里访问该如何编写？
如一分里连到此：
product.php?classname=第一分类
product.php?classname=第二分类
................
在product.php里应该编写哪一些语句呢？
在ASP里直接用classname=request("classname")
我在php里用了$_POST,$_request, $_GET都不行
请高手帮忙

Answer 1

O'Reilly Learning PHP & MySQL 第二版
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=170283
PHP 5 傻瓜书
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=156854
PHP官方参考手册 中文+英文CHM版
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=174312
Upgrading to PHP 5
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=172787
Wrox Beginning PHP 5
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=146843
PHP 5 Advanced
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=152684
PHP 5与MySQL编程初学者指南
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=152044
PHP 5和MySQL 5 从入门到精通 PDF文字版
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=166059
PHP 4.1 从入门到精通
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=159334
O'Reilly PHP Cookbook 第二版
http://bbs.topsage.com/dispbbs_123_171395_1.html
How to Do Everything with PHP and MySQL
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=175991
PHP & MySQL Web Development
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=175913
PHP Programming Solutions
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=173163
PHP Objects Patterns and Practice
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=173160
Learning PHP Data Objects
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=173151
PHP技术内幕
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=159332
PHP最新参考手册
http://bbs.topsage.com/dispbbs.asp?BoardID=123&ID=146233
PHP程序设计
http://bbs.topsage.com/dispbbs.asp?BoardID=123&ID=146171
PHP经典100例
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=152400
PHP by Example
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=176304
Object Oriented PHP Concepts Techniques and Code
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=152398
The PHP Anthology 第二版
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=167353
PHP API使用完全指南
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=164843
Wiley出版 Makeing Use of PHP
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=166790
PHP实例教程
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=152574
PHP in Action
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=152648
PHP+MySQL网络开发技术
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=156149
PHP设计模式构架师指南
http://bbs.topsage.com/dispbbs_123_171267_1.html
Dreamweaver CS3 with CSS, Ajax, and PHP
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=147123
AJAX and PHP Building Responsive Web Applications
http://bbs.topsage.com/dispbbs.asp?BoardID=123&ID=151261
Beginning Ajax with PHP
http://bbs.topsage.com/dispbbs.asp?BoardID=123&ID=146176
PHP Programming with PEAR
http://bbs.topsage.com/dispbbs.asp?BoardID=123&ID=148389
PHP MySQL and Apache自学教程
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=146232
PHP Apache和MySQL网页开发初步
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=148871
24小时学会使用PHP MySQL Apache
http://bbs.topsage.com/dispbbs.asp?BoardID=123&ID=149004
PHP MySQL 网络应用程序开发核心
http://bbs.topsage.com/dispbbs.asp?BoardID=123&ID=149005
Professional LAMP - Linux,Apache,MySQL and PHP 5 Web Development
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=152045
Setting Up LAMP - Getting Linux Apache MySQL and PHP Working Together
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=157654
Beginning PHP,Apache,MySQL Web Developmnet
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=151985
Beginning PHP and Oracle 从入门到精通
http://bbs.topsage.com/dispbbs_123_171292_1.html
PHP Data Objects for MySQL
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=152186
MySQL and PHP from Scratch
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=152162
Extending and Embedding PHP
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=152160
Wiley出版 Secure PHP Development
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=165544
O'Reilly Building Tag Clouds in Perl and PHP
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=152158
Wrox Professional Apache Tomcat 5
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=152054
PHP MySQL编程初学者指南
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=158793
Beginning PHP and Oracle (PDF文字版)
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=159155
Advanced PHP for Web Professionals
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=159168
Essential PHP Security
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=175045
Pro PHP XML and Web Services
http://bbs.topsage.com/dispbbs_123_171266_1.html
Apache Server 2.0 实用指南
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=159297
Apache管理员手册
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=159296
Apache使用指南与实现原理
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=159287
PHP专业项目实例开发 中文PDF版
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=159322
PHP高级开发技术与实例 中文PDF影版
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=159319
PHP 5 for Flash
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=159407
O'Reilly - Tomcat权威指南
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=160138
Wrox Professional Apache Tomcat 6
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=157418
Pro Jakarta Tomcat 5
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=160230
Foundations of PEAR - Rapid PHP Development
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=160612
Practical Web 2.0 Applications with PHP(Apress 2008最新版)
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=170237
Practical Apache Struts 2 Web 2.0 Projects
http://bbs.topsage.com/dispbbs.asp?boardID=123&ID=170311

Answer 2

应该是
$var= $_get("classname");
$result=mysql_query("select * from `product` where classname='{$var}' order by Shop_Id desc ");