Problem with query

[Perad]

I have 2 columns, descriptions and page. I want to find the images where page = $page and descriptions = header. However my query doesn't appear to be checking anything after the AND statement and thus is bringing back everything whether the discription is header or not.

 

What am i doing wrong?

 

$sql = "SELECT * FROM images WHERE page='$page' AND descriptions='header'";

[MadTechie]

can you echo $sql and post the results please

[Perad]

echo $sql = SELECT * FROM images WHERE page='portfolio' AND descriptions='header'

echo $result = Resource id #7

 

edit: complete statement is as follows.

$sql = "SELECT * FROM images WHERE page='$page' AND descriptions='header'";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc ($result)) {
$imageurl[] = $row['imagename'] . '.' . $row['type'];
}

[AndyB]

and ...

 

[Perad]

Sorry, i don't understand.

[AndyB]

And what is the problem with it?  You already know that the query string is what you expect (since you used to have a line to echo $sql - didn't you?).  So what isn't it doing?

[Perad]

It is gathering all of the results where the page is portfolio instead of all the results where the page is portfolio and the description is header.

 

This means it is returning to many results.

[MadTechie]

try this

 

<?php
$sql = "SELECT * FROM images WHERE page='$page' AND descriptions='header'";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc ($result)) {
$imageurl[] = $row['imagename'] . '.' . $row['type'];
if($row['descriptions']!="header"){die("ERROR");}
}
?>

 

what happens