成功解决:
$colname_Recordset1 = "1";
if (isset($_GET['sno'])) {
$colname_Recordset1 = (get_magic_quotes_gpc()) ? $_GET['sno'] : addslashes($_GET['sno']);
}
$query_Recordset1 = sprintf("SELECT * FROM pharmacy WHERE sno = %s", $colname_Recordset1);
主要是($_GET['sno']),其中sno是URL传递的参数。