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

Re: MySQL sorting

2001-05-24 Thread Paul DuBois
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

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 = M