The problem is that this line is not telling MySQL that I want it to select
only the fields where the EventMonth = May. Displaying the other fields is
not a problem at this time.
At 09:54 PM 5/24/2001 -0500, you wrote:
>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, [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php