Select problem

Select problem

am 23.02.2005 03:02:19 von Wade

02222005 1858 GMT-6

I created this little script for a teacher at the local school. Its just
really simple for him to keep track of practice times for orchestra
students.

It worked fine until today and now it wont select correctly.

My History pane in the MySQL Control Center states:
SELECT * FROM 'practice'

and this is the code:

$current_month = date('F');
$date = date('d');
$sql = "SELECT P_Time FROM practice WHERE Month = '$current_month'
AND Date = '$date' ";


Im not sure what has happened. I have checked the code and nothing is
different from the schools computer to my computer but then I started
playing around on my test machine and its not working here either.

According to the History SELECT * FROM practice is the only thing being
chose.

Wade




[Non-text portions of this message have been removed]



The PHP_mySQL group is dedicated to learn more about the PHP_mySQL web database possibilities through group learning.
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php_mysql/

<*> To unsubscribe from this group, send an email to:
php_mysql-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/








--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org