phpMyAdmin中mysql查询语句中分号注意事项

 1 
 2 
 3 
 4 
 5 
 6 
 7 
 8  9php
10$idea = $_POST['idea'];
11$housetype = $_POST['housetype'];
12$style = $_POST['style'];
13$app = $_POST['app'];
14$price = $_POST['price'];
15$pubdate = $_POST['pubdate'];
16# echo $idea, ' ', $housetype, ' ', $style, ' ', $app, ' ', $price, ' ', $pubdate;17$conn = mysql_connect("localhost", "thoupin", "D3w89X7z");
18mysql_select_db("sample");
19$query = "select * from `case` where `idea`='".$idea."'";
2021# housetype22if($housetype!="") {
23$query.=" && `housetype`='".$housetype."'";
24    } 
25# style26if($style!="") {
27$query.=" && `style`='".$style."'";
28    }
29# app30if($app!="") {
31$query.=" && `app`='".$app."'";
32    }
33# price34/*35    if($price!="") {
36        switch($price) {
37            case "A":
38                $query.=" && `price`<50000";
39            break;
40            case "B":
41                $query.=" && `price`>=50000";
42            break;
43        }
44    }
45    # pubdate
4647    if($pubdate!="") {
48        switch($pubdate) {
49            case "A":
50                $query.=" && TO_DAYS(NOW()) - TO_DAYS(`pubdate`)<=7";
51            break;
52            case "B":
53                $query.=" && TO_DAYS(NOW()) - TO_DAYS(`pubdate`)<=30";
54            break;
55            case "C":
56                $query.=" && TO_DAYS(NOW()) - TO_DAYS(`pubdate`)<=91";
57            break;
58            case "D":
59                $query.=" && TO_DAYS(NOW()) - TO_DAYS(`pubdate`)<=183";
60            break;
61        }
62    }
63*/64# result65$query.=" order by `pid` limit 0, 20;";
66     @mysql_query("set names 'utf8'", $conn);
67$result = mysql_query($query, $conn);
68if($result) {
69$rows = mysql_num_rows($result);
70if($rows != 0) {
71while($myrow=mysql_fetch_array($result)) {
72echo '';
73echo "";
74echo "';
80echo "";
81echo ''; 
82            }
83        }
84     } else {
85echo "";
86    }
8788echo "
";
89 ?>
90

                                    
                    
     
                    
                    
                    
     
            
                     
     
                                                               
                 
                 

75                       $myrow[pid] 
76                       $myrow[idea] 
77                       $myrow[style]($myrow[housetype]) 
78                       [$myrow[pubdate]]";
79                 echo '
                 
详细信息
                            


没有符合查找条件的记录!
      
      
91 
92