sql error 1

[ascikey]

when i issue the following query i get "Lookup failed: Unknown column 'B753' in 'where clause'" but B753 is a value in the $value var.
does anybody know why this is?

foreach ($_POST['dvd'] as $value)
{
  # make a SQL query specific to the dvd
 $query = "SELECT * FROM video WHERE video.Code= ". $value;
 $result = mysql_query($query) OR die("Lookup failed: ".mysql_error());
 $row = mysql_fetch_assoc($result);
 # process the record now
 foreach($row as $key=>$val)
 {
    echo 'key is '. $key .' and val is '. $val;
 }
}

thx

 

[Dweezel]

Is it the space between the period and the "$value"?

 

[ascikey]

thx Dweezel but didnt seem to make much difference

foreach ($_POST['dvd'] as $value)
{
  # make a SQL query specific to the dvd
  $query = "SELECT * FROM video WHERE video.Code= ".$value;
  $result = mysql_query($query) OR die("Lookup failed: ".mysql_error());
  $row = mysql_fetch_assoc($result);
  # process the record now
  foreach($row as $key=>$val)
  {
    echo 'key is '. $key .' and val is '. $val;
  }
}

 

[Dweezel]

Try writing the =".$value bit like this:
=$value";

As it's in double quotes it should still evaluate your variable properly.

I'm clutching at straws though m8. I'm too tired to be of any use I think

 

[DRJ478]

Fortunately this is an easy answer - and basic:

SQL statements require strings to be enclosed in quotes. Otherwise the literal is interpreted as a SQL meta idenfifier, such as a column name.
Lets say the value is B753

$query = "SELECT * FROM video WHERE video.Code= ". $value;
# evaluates as:
SELECT * FROM video WHERE video.Code = B753
# whereas it should be
$query = "SELECT * FROM video WHERE video.Code= [COLOR=red]'[/color]". $value .[COLOR=red]"'"[/color];
# evaluates as
SELECT * FROM video WHERE video.Code = 'B753'

That's all. If you look at the wrong statement you can see that the SQL interprets B753 as a column name in the specific spot it is in the statement. And, as there is no such column, it fails.

 

[ascikey]

i see, again u solve my probem thx very much

 

[ascikey]

I had a few problems with that but here is what i ended up with

$mark =  "'";
$temp =$mark . $value . $mark;
$query = "SELECT * FROM video WHERE video.Code=$temp";

thx all