MySQL sorting

2001-05-24 Thread Tim Thorburn
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 =

Re: MySQL sorting

2001-05-24 Thread Tim Thorburn
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