List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 25 2001 2:54am
Subject:Re: MySQL sorting
View as plain text  
At 9:49 PM -0500 5/24/01, Tim Thorburn wrote:
>Hi,
>
>I'm using PHP to pull information out of my MySQL database - 
>although its not entirely working.
>
>Here is the line:
>
>$result = mysql_query("SELECT * FROM comcal2001 WHERE id=$id and 
>EventMonth='May'",$db);
>
>What I'd like this to do is select all the fields in my database 
>where the month = May and display them on the screen.  However, it 
>displays every field.

The line above doesn't display anything.  You're describing a problem that
doesn't relate to the code you're showing, as far as I can tell.  Can you
be more specific? PHP won't display anything except what you tell it to...

>
>Could someone shed some light on this for me?
>
>Thanks
>-Tim


-- 
Paul DuBois, paul@stripped
Thread
MySQL sortingTim Thorburn25 May
  • Re: MySQL sortingPaul DuBois25 May
    • Re: MySQL sortingTim Thorburn25 May