WHERE question

cheeks2k

Hi, am building an image gallery with PHP & SQL, but have run into a problem

When I want to call all my images from the DB the program runs fine, but when I put a WHERE into the line it grinds to a halt. Here's my line:

$page = "webcam";
$sql = "select name,width,height,gallery where gallery=".$page." from new_gallery LIMIT ".($start*$photos_per_page).",".$photos_per_page."";

The table is called new_gallery, and I'm trying to select from a Text field all images with the value "webcam".

I've tried using it with Integers as well and still can't get it to work. Any help?

notionlogic

The WHERE statement comes after the FROM statement...

like this:
$sql = "select name,width,height,gallery from new_gallery where gallery=".$page." LIMIT ".($start*$photos_per_page).",".$photos_per_page."";

cheeks2k

That still doesn't seem to work; here's more code:

$page = "webcam";
$sql = "select name,width,height,gallery from new_gallery where gallery=".$page." LIMIT ".($start*$photos_per_page).",".$photos_per_page."";
$rs = mysql_query($sql,$conn);
// init i (as counter of the displayed table fields:
$i = $start;
$prev_start = $start - $photos_per_page;
$next_start = $start + $photos_per_page;

// START TABLE HERE:
echo "<table cellpadding=\"0\" align=\"center\" cellspacing=\"10\" width=\"200\" border=\"0\">";
while ($photos = mysql_fetch_array($rs) )
{

When the WHERE line is in place, it gives me the error:

Supplied argument is not a valid MySQL result resource in /host/c/h/e/p/o/r/cheeks2k.port5.com/gallery/new_gallery4.php on line 44

(Line 44 is the WHILE loop)

notionlogic

Sounds like the query isn't working properly - have you tried echoing it out to the screen so you can cut/paste it into something like phpMyAdmin ?

cheeks2k

Haven't tried that... but the frustrating thing is that it works fine when the 'WHERE' query is not included. If I put

$sql = "select name,width,height,gallery from new_gallery LIMIT ".($start*$photos_per_page).",".$photos_per_page."";

Then the page displays as I want it to; it's only the WHERE that's off.

Have just ECHOed them out and they seem fine; why is the WHERE not working??? Have I got the syntax wrong as it's a string?

cheeks2k

Don't worry, have solved this myself! Because $page is a text string, I had to put quotes around it:

$sql = "select name,width,height,gallery from new_gallery where gallery=\"".$page."\" LIMIT ".($start*$photos_per_page).",".$photos_per_page."";

Thanks for your help anyway - just musing out loud got it solved!

notionlogic

Have I got the syntax wrong as it's a string?

Of course! How could I have missed it :o

String values must be enclosed in single quotes (e.g. where gallery='".$page."' )

Guess I failed this test then!😃