Display multiple rows?

[move3rd]

I'm would like to display all rows that contain $product:

 
<?
$product = "delta_44";

$conn = mysql_connect("localhost", "admin", "");

if (!$conn) {
   echo "Unable to connect to DB: " . mysql_error();
   exit;
}

if (!mysql_select_db("compare_price")) {
   echo "Unable to select mydbname: " . mysql_error();
   exit;
}

$sql = "SELECT * FROM `audio_interface` WHERE `product` = $product";

$result = mysql_query($sql);

if (!$result) {
   echo "Could not successfully run query ($sql) from DB: " . mysql_error();
   exit;
}

if (mysql_num_rows($result) == 0) {
   echo "No rows found, nothing to print so am exiting";
   exit;
}

while ($row = mysql_fetch_array($result)) {
extract($row) 
 ?>

<table width='800'>
<tr>
 <td width='122'><a href='<? echo "$product_url"; ?>'><? echo "$store"; ?></a></td>
    <td width='666'><? echo "$price"; ?></td>
  </tr>
</table>
<?
}
mysql_free_result($result);
?> 

I'm getting this error:

Could not successfully run query (SELECT * FROM audio_interface WHERE product = delta_44) from DB: Unknown column 'delta_44' in 'where clause'

It seems to be looing for a colum named $product rather than a row containg $product.

Must be a problem with the sql call but I can not figure it out.

[lanjoky]

where u have

$sql = "SELECT * FROM `audio_interface` WHERE `product` = $product"; 

try ...

$sql = "SELECT * FROM audio_interface WHERE product = ".$product; 

[move3rd]

Thanks

I tried:

 
$sql = "SELECT * FROM audio_interface WHERE product = ".$product; 

But it give's the same error.

[lanjoky]

try

$sql = "SELECT * FROM audio_interface WHERE product = '".$product."'";

[move3rd]

Thats the one! 😃

I dont think I understand the problem though!

Could you explain?

Thanks for your help🙂

[move3rd]

Is that variables are only parsed when inside double brackets?😕

[lanjoky]

Originally posted by lanjoky
try

$sql = "SELECT * FROM audio_interface WHERE product = '".$product."'";

[/B]

Couple of things that messed ya up:

1. names of tables / columns are not to be in quotes
2. when refering to a column that is text you must have quotes around the value you are using to compare.
3. when using a php varaible .... you cannot call it from inside a set of quotes.

HTH

[laserlight]

Actually, table and column names should be enclosed in backticks (not single quotes), so move3rd is correct in that area.
The problem was that the value was not enclosed in single quotes, causing it to be interpreted as a column name.

The solution is simple:

$sql = "SELECT * FROM `audio_interface` WHERE `product` = '{$product}'";

Aside from enclosing the value in single quotes, I have taken the liberty to enclosed the PHP variable in braces so that parsing can be faster.