我想用PHP查询显示PHP中特定字段的所有行

Question

I have many different merchant stores like (Nike, Reebok, Adidas, Loto etc) in my table.

I want to retrieve all the information related to one particular store like (ex: Nike) and I want to show all the information related to that Nike store.

My table is like:

+----+--------------+--------------+
| id | store_name   | description  |
+----+--------------+--------------+
|  1 | nike         | dasfdasdfas  |
|  2 | reebok       | dfasdfa      |
|  3 | addidas      | adasdf       |
|  4 | loto         | asdfasfdas   |
|  5 | nike         | sadlfjasldfj |
+----+--------------+--------------+

I wrote the code as:

<?php include ('config.php');
$q = mysql_query("SELECT * FROM `Merchant Store` WHERE store=$store_name");
        while($r=mysql_fetch_array($q)){
      ?>

echo <?php $r ?>

How can I do this? I want all the Nike store related content to be displayed.

Answer 1

$q = mysql_query("SELECT * FROM `coupons` WHERE store='" . $store_name . "'");

Missing single quotes

Also in your table there is not column named store , so posted query retrieving all columns (using * instead of store)

PS. See this post, why not to use mysql extension