PHP SQL query

[jaykappy]

I am passing 2 parameters in my URL to a page.

I want to query on both...IN THE example below I am only querying 1....

how do I change the syntax to query for both the Dept and the Yr

 

100.100.2.31:83/Pageindex.php?Dept=Engineering&Yr=1972

 

Thanks in advance for your help....

 

 

echo $_GET["Dept"];

echo $_GET["Yr"];

 

$query = " 

SELECT 

Id,Yr,ProjectName,Department,Owner,MaplibraryName,

FROM tbl_library

WHERE 

Department = :dept 

ORDER BY 

Yr DESC

"; 

 

$stmt = $db->prepare($query); 

$stmt->execute(array(":dept" => $_GET['Dept']));

Edited June 11, 2013 by jaykappy

[Psycho]

Depends. Do you want records that match the Department AND the year. Or, do you want records that match the Department OR the year?

SELECT Id,Yr,ProjectName,Department,Owner,MaplibraryName,
FROM tbl_library
WHERE Department = :dept 
  AND Yr = :year
ORDER BY Yr DESC

SELECT Id,Yr,ProjectName,Department,Owner,MaplibraryName,
FROM tbl_library
WHERE Department = :dept 
   OR Yr = :year
ORDER BY Yr DESC

$stmt = $db->prepare($query); 
$stmt->execute(array(":dept" => $_GET['Dept'], ":year" => $_GET['Yr']));

Edited June 11, 2013 by Psycho

[jaykappy]

FANTASTIC....I was close....I was missing the AND in the WHERE clause...oops...

but had the $stmt correct in my testing....

 

THANKS FOR YOUR EYES AND HELP....VERY APPRECIATED...

CHEERS.

[jaykappy]

looking back at my $stmt ..... nope I had that incorrect as well....

 

THANKS AGAIN...