mysql_fetch_assoc(): supplied arg..... error

[forumnz]

What could be causing this?

include('dbcon.php');

$sql = "SELECT buzzname FROM cmads WHERE buzzname LIKE '%" . $_POST['search'] . "%' OR WHERE keywords LIKE '%" . $_POST['search'] . "%' LIMIT 12";
$rs = mysql_query($sql);

?>

<ul>

<? while($data = mysql_fetch_assoc($rs)) { ?>
  <li><? echo stripslashes($data['buzzname']);?></li>
<? } ?>

</ul>

 

Thank you,

Sam.

[revraz]

Change

$rs = mysql_query($sql);

 

to

 

$rs = mysql_query($sql) or die ("Error in query: $sql. " . mysql_error());

 

Then you'll see what error you have in your $sql statement.

[revraz]

Looks like one too many WHEREs to me

 

WHERE buzzname LIKE '%" . $_POST['search'] . "%' OR keywords LIKE '%" . $_POST['search'] . "%' LIMIT 12";

[redarrow]

try this........

 

(| Bitwise OR added)

 

<?php
$sql = "SELECT buzzname FROM cmads 
WHERE buzzname LIKE '%" . $_POST['search'] . "%' | keywords LIKE '%" .
$_POST['search'] . "%' LIMIT 12";
$rs = mysql_query($sql);
?>