[Resolved] SQL combine

[kenhess]

What the heck is wrong with this?

$sqla = "SELECT
SERVERS.Project,
SERVERS.Link,
SERVERS.Name,
DASHBOARD.SERVER,
DASHBOARD.NAME AS DNAME,
DASHBOARD.CPU,
DASHBOARD.MEMORY,
DASHBOARD.DISK,
DASHBOARD.DI
FROM
SERVERS
INNER JOIN DASHBOARD ON (SERVERS.Name = DASHBOARD.NAME)
WHERE
DASHBOARD.SERVER LIKE '%.$DATE' AND SERVERS.Project = '$projects[0]'";

$sql = $sqla;

for($i=1;$i < $proj_count; $i++) {

$sql[$i]= " OR DASHBOARD.SERVER LIKE '%.$DATE' AND SERVERS.Project = '$projects[$i]'";
$sql .= $sql[$i];
}
$sqlb = " ORDER BY SERVERS.Project,DASHBOARD.NAME ASC";
$sql .= $sqlb;

echo "<P>";
echo $sql;

it won't add in my $sql[$i] pieces.

[stevesweetland]

$proj_count is set, right?

plus youv initially set $sql to be a string, then you're trying to add array elements to it...

instead of

for($i=1;$i < $proj_count; $i++) { 

$sql[$i]= " OR DASHBOARD.SERVER LIKE '%.$DATE' AND SERVERS.Project = '$projects[$i]'"; 
$sql .= $sql[$i]; 
} 
$sqlb = " ORDER BY SERVERS.Project,DASHBOARD.NAME ASC"; 
$sql .= $sqlb;

try

for($i=1;$i < $proj_count; $i++) { 
  $sql .= " OR DASHBOARD.SERVER LIKE '%.$DATE' AND SERVERS.Project = '".$projects[$i]."'"; 
} 
$sql .= " ORDER BY SERVERS.Project,DASHBOARD.NAME ASC"; 

[kenhess]

Thanks...that worked perfectly!!!