Mark Hensler — Fri, 15 Nov 2002 07:19:32 +0000

For a speed boost, try using this:
"SELECT * FROM cp_pages WHERE INSTR(content,'$item') LIMIT 0, 30"

INSTR() is a basic string comparison, while LIKE uses basic pattern matching ( '_' = single char; '*' = 0 or more chars).

Also note about INSTR(): This function is multi-byte safe. In MySQL 3.23 this function is case sensitive, while in 4.0 it's only case-sensitive if either argument is a binary string.

mySQL Docs:
6.3.2 String Functions: INSTR()
6.3.2.1 String Comparison Functions: LIKE

zollet — Fri, 15 Nov 2002 02:44:22 +0000

Actually in MySQL wildcard is % not * so the correct MySQL query would be...

<?php
$data = mysql_query(\"SELECT * FROM cp_pages WHERE content LIKE '%$item%' LIMIT 0, 30\");
?>

Also I suggest you use mysql_fetch_assoc() instead of mysql_fetch_array() if you're only going to use $row["name"] and not $row[0]

Peter J. Boettcher — Fri, 15 Nov 2002 02:37:05 +0000

Era,

I'm not familiar with PHP but I don't think you have to put single quotes in your select statement:

"SELECT * FROM `cp_pages` WHERE `content` LIKE '*$item*' LIMIT 0, 30"

Try:

"SELECT * FROM cp_pages WHERE content LIKE '" + $item + "' LIMIT 0, 30"

I'm not sure about the + $item + part, just coded it like JavaScript, maybe a php person could chime in?