CODEWITHSUNDEEP
phpmysql
user3109875
user3109875

Reputation: 828

How to select all from table and skip some row with a certain value

im trying to select all and skip some row.

There's some syntax error on this line, i don't know what im doing wrong.

SELECT * FROM ads WHERE bbookschool like '$data' && WHERE bbookname != 'TEST' ORDER BY time desc

MORE CODE

$data = preg_replace ('#[^a-zA-Z0.-_% ]#i', '', $_POST['data']);
$Result = mysql_query("SELECT * FROM ads WHERE bbookschool like '$data' && WHERE bbookname != 'TEST0160' ORDER BY time desc")
 or die (mysql_error());
while($row = mysql_fetch_array($Result)){
require 'book_ad.php';
$adCondition = (!empty($row['bbookname'])) ? $ad : '';  
echo $adCondition;   
         }

Thanks.

Upvotes: 0

Views: 155

Answers (4)

Krishna
Krishna

Reputation: 438

Try this.

SELECT * FROM ads WHERE bbookschool like '%$data%' AND bbookname != 'TEST' ORDER BY time desc

Upvotes: 0

user1844933
user1844933

Reputation: 3417

Try this

SELECT * FROM ads WHERE `bbookschool` like '%$data%' && bbookname != 'TEST' ORDER BY `time` desc

Upvotes: 0

Peon
Peon

Reputation: 8020

You need to use WHERE only once:

SELECT
    *
FROM
    ads
WHERE
    bbookschool LIKE '$data'
    && bbookname != 'TEST'
ORDER BY
    `time` DESC;

Also, set % around $data, if you want to search for words containing the string in $data:

bbookschool LIKE '%$data%'

PS: I believe time is also a reserved word, so add back-quotes ( ` ) around it.

Upvotes: 1

Sal00m
Sal00m

Reputation: 2916

Change the query for this one:

SELECT * FROM ads WHERE bbookschool like '$data' AND bbookname != 'TEST' ORDER BY time desc

Upvotes: 0

Related Questions