Date: 07/11/05 (PHP Community)    Keywords: php, mysql, sql

I need some help with a query I'm trying to create to send to MySQL. The problems are on the PHP side, so I'm posting here rather than at mysql.

I have an array of starting letters. I'm trying to select all projects that start with a letter in an array. The array will have at least one letter, possibly more.

Here is the code that's causing me confusion:

foreach ($startlet as $let){
   $sql.=" $projectcolumn[title] LIKE '".$let."%'";
}

$i=0;
	while ($i<(count($startlet)-1)){
		$sql.=" $projectcolumn[title] LIKE '".$startlet[$i]."%' OR";
		$i++;
	}
	$sql.=" $projectcolumn[title] LIKE '".$startlet[$i]."%'";

Source: http://www.livejournal.com/community/php/317164.html