quote:

---

Originally posted by Ian
Nothing wrong with splitting the queries and a load of OR WHERE, apart from perhaps a bit of speed.

FULLTEXT is also an option.

---

code:


$words = split(" ", $s);

$count = count(explode(" ", $s));

$c='0';

while ($c < $count)

{

$or = $or . "OR " . $where .  " LIKE '%" . $words[$c] . "%' ";

$c++;

}		



		$sql = "SELECT p.pic_id, p.pic_title, p.pic_desc, p.pic_user_id, p.pic_username, p.pic_time, p.pic_cat_id, p.pic_approval, p.pic_file_name, p.pic_thumbnail, c.cat_id, c.cat_title, c.cat_user_id

				FROM " . ALBUM_TABLE . ' AS p,' . ALBUM_CAT_TABLE . " AS c

				WHERE p.pic_approval = 1

					AND " . $where .  " LIKE '%" . $s . "%'

					$or

					AND p.pic_cat_id = c.cat_id

					AND c.cat_view_level <> '3'

				ORDER BY p.pic_time DESC";

quote:

---

Originally posted by James
Is there a limit on the length of a PHP string? I'm not hot on PHP. C# FTW

Can you trace out the SQL thats crashing and then run it directly in MySQL to see if its a DB or Code issue?

---