SQL statement help

[princelindie]

i trying to read data from quite a few tables.. Now the statement works well except when i include the where e.equipmentLocationID = l.equipmentLocationID AND e.cabinetID = c.cabinetID AND e.equipmentOsID= osy.equipmentOsID AND e.equipmentServiceLevelID = s.equipmentServiceLevelID AND e.equipmentTypeID = eq.equipmentTypeID . But i need to include since the output i want is not the ID but the field.
I am using PHP...

$query = "select e.equipmentName, e.equipmentSerTagNum,l.location,c.name , osy.osName , s.type, e.hardwareDescription,e.macAddress,e.rackNum, eq.type,e.hostServerName,e.updatedDate,e.warrantyStartDate, e.warrantyEndDate ,e.equipmentBrand,e.equipmentApplication
        from equipmentInfo as e, equipmentLocation as l, cabinet as c, os as osy ,serviceLevelType as s, equipmentType as eq
 
where e.equipmentLocationID = l.equipmentLocationID AND e.cabinetID = c.cabinetID AND e.equipmentOsID= osy.equipmentOsID AND e.equipmentServiceLevelID = s.equipmentServiceLevelID AND e.equipmentTypeID = eq.equipmentTypeID 
 
And e.equipmentName like \"%$trimmed%\" or  e.equipmentSerTagNum like \"%$trimmed%\"  
  order by e.equipmentName"; 
 
 
 

[ronverdonk]

Do you get an error, and which one, or is the SQL statement executed without taking the WHERE clause ? Do you have a [php]or die("error ".mysql_error());[/php] to catch errors? If not surre show the PHP mysql_* command used.

Ronald

[princelindie]

connect();
 
 
// Build SQL Query  
 
$query = "select e.equipmentName, e.equipmentSerTagNum,l.location,c.name , osy.osName , s.type, e.hardwareDescription,e.macAddress,e.rackNum, eq.type,e.hostServerName,e.updatedDate,e.warrantyStartDate, e.warrantyEndDate ,e.equipmentBrand,e.equipmentApplication
        from equipmentInfo as e, equipmentLocation as l, cabinet as c, os as osy ,serviceLevelType as s, equipmentType as eq
 
        where e.equipmentLocationID = l.equipmentLocationID AND e.cabinetID = c.cabinetID AND e.equipmentOsID= osy.equipmentOsID AND e.equipmentServiceLevelID = s.equipmentServiceLevelID AND e.equipmentTypeID = eq.equipmentTypeID 
 
        AND e.equipmentName like \"%$trimmed%\" or  e.equipmentSerTagNum like \"%$trimmed%\"  
  order by e.equipmentName" or die("error".mysql_error()); 
 
 
 $numresults=mysql_query($query);
 
 

[ronverdonk]

So?? see my last post. Do you get an error or is the statement just executed without anything returning?

Ronald

[princelindie]

So?? see my last post. Do you get an error or is the statement just executed without anything returning?

Ronald

it executed without anything returning

[ronverdonk]

So the statement is correct and working. To me it looks like there is no database result to be returned from that statetement.

Ronald

[princelindie]

i getting results without the following statement.

 where e.equipmentLocationID = l.equipmentLocationID AND e.cabinetID = c.cabinetID AND e.equipmentOsID= osy.equipmentOsID AND e.equipmentServiceLevelID = s.equipmentServiceLevelID AND e.equipmentTypeID = eq.equipmentTypeID 
 

but i need to include it for the outpuit i looking for..
whenever i include it returns nothing...

[ronverdonk]

Then NOTHING matches that where clause. The combination of these restrictions is not there.

When you are pertinent that there must be a result, then do some debugging.

Have you tried to issue the WHERE clause with fewer restrictions? Like starting with the first one and see what is returned. If anything is returned, gradually expand the where clause until it returns nothing?

Ronald