PHP if function

Question

I am using a PHP function to pull some information into a list for me - and it pulls all of it, but the sort is not working and I have messed with the LIMIT and it doesn't work as well...

if(strtolower($term) == 'feature') {
    $query = "select * FROM $table WHERE (tags LIKE 'feature') ORDER BY rid DESC     LIMIT 1";
}

I don't understand what the problem is. what are you expecting vs what are you actually getting? — thescientist, Mar 20 '14 at 21:04
well i want it to order these in descending order and it's not functioning - the order is random actually, and the limit does nothing — jacob, Mar 20 '14 at 21:05

score 2 · Accepted Answer · answered Mar 20 '14 at 21:06

I think you are wanting to use some % operators eg these will match anything in your like statement.

Match any tag that has the word feature in it, other letters might be on left and right of word.

$query = "select * FROM $table WHERE (tags LIKE '%feature%') ORDER BY rid DESC     LIMIT 1";

Match any tag that has that start with feature and may have other words or letters after

$query = "select * FROM $table WHERE (tags LIKE 'feature%') ORDER BY rid DESC     LIMIT 1";

Got it. Thank you. I knew it had to be something simple... Thank you John. — jacob, Mar 20 '14 at 21:08

PHP if function

1 Answers1