[SOLVED] Query Problem

[syclonefx]

I need help I am getting this error.

 

Unknown column 'popwarner' in 'where clause'

 

Here is my Query:

<?php
$VidCat = ($row_rsCategory['CategoryTitle']);
$query1 = sprintf("SELECT * FROM videos WHERE Active = 1 AND Category = %s",mysql_real_escape_string($VidCat));
$result = mysql_query($query1) or die(mysql_error());
while ($row = mysql_fetch_assoc($result)) {
echo '<span class=""><a href="video_pl.php?video_ID=' . $row['video_ID'] . '" class="" title="' .$row['VideoTitle']. '">' .$row['VideoTitle']. '</a></span><br />';
}
?>

 

If I change my query to this:

<?php
$VidCat = ($row_rsCategory['CategoryTitle']);
$query1 = sprintf("SELECT * FROM videos WHERE Category = 'popwarner'");
$result = mysql_query($query1) or die(mysql_error());
while ($row = mysql_fetch_assoc($result)) {
echo '<span class=""><a href="video_pl.php?video_ID=' . $row['video_ID'] . '" class="" title="' .$row['VideoTitle']. '">' .$row['VideoTitle']. '</a></span><br />';
}
?>

Everything works fine.

[Ken2k7]

Okay so what's the help that you need now?

[phpSensei]

What does valued does $vidcat contain?

[matthewhaworth]

It's always best to print out your query as a form of debugging add. 

 

<?php
echo $query1;
?>

 

Before the query is executed and the problem may become obvious to you .

[syclonefx]

It's always best to print out your query as a form of debugging add. 

 

<?php
echo $query1;
?>

 

Before the query is executed and the problem may become obvious to you .

 

Thanks matthewhaworth I got it..

 

%s should have been '%s'

 

<?php
$VidCat = ($row_rsCategory['CategoryTitle']);
$query1 = sprintf("SELECT * FROM videos WHERE Active = 1 AND Category = '%s'",mysql_real_escape_string($VidCat));
//echo ($query1). '<br>';
$result = mysql_query($query1) or die(mysql_error());
while ($row = mysql_fetch_assoc($result)) {
echo '<span class=""><a href="video_pl.php?video_ID=' . $row['video_ID'] . '" class="" title="' .$row['VideoTitle']. '">' .$row['VideoTitle']. '</a></span><br />';
}
?>