Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MaxDB - Everything about MaxDB, formerly known as SAP DB
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
MySQL++ - Programming with the C++ API to MySQL
ODBC - ODBC with the MySQL Connector/ODBC driver
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
mysql openssl Question
mysql:it 's a db not a dbms how it 's possible?!
Does the binary log enabling affect the MySQL performances?
Strange behavior, Table Level Permission
FULLTEXT query format question
Preventing Duplicate Entries
Comparing and writing out BLOBS
Executing MySQL Commands From Within C Program
Can 't access mysql after kernel upgrade
Mysql 4 0 Oracle Stored Procedure Trigger Conversion
Downgrade Mysql from 4 to 3 23
MySQL Cluster Software
mysql test 4 1 fails with the gis test
ERROR 2002: Can 't connect to local MySQL server through socket
Getting Identity after INSERT
Update one field with more fields from another table
ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
mysql have same function mthod as Oracle decode()
 
Search:  
Power your search with and, or, +, -, or "some phrase" operators.
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.