  | |  | Select problem | Select problem 2005-02-22 - By Wade
Back 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@(protected)
<*> 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=mysql@(protected)
Earn $52 per hosting referral at Lunarpages.
|
|
 |