"Nestor Florez" <[EMAIL PROTECTED]> wrote: > > I have a php web application that has an admin page for inserting course = > records and one for selecting course records=20 > and a client page for selecting course record. =20 > In the admin side I insert records with an "insert into Course_Eng" and I = > select records witha "select * from Course_Eng" > In the client side I get records witha "select * from course_eng" > > The kicker is that my client webbased select will only return 40 records = > (no limits are being use) but my admin > webbased select returns 200 records. I SSH into the server and when I = > check the table "desc course_eng" > look good. > After scraching my head several times I found out that if manually typed = > on the server > my select statement as "select * from Course_Eng" I would get 200 records = > back, but if I > typed "select * from course_eng" I would get 40 records. > > Is this a bug? or a feature? > > Whe I did a "show tables;", the table name is "course_eng" ther was no = > table "Course_Eng" > > If I remember correct in the SQL syntax the case should not matter? > > I change all my inserts and selects to "Course_Eng" that seem to work and = > returned me the most records > My server is a Mac OS 10.2 and the Mysql version is "server version: = > 4.0.16" >
"SELECT * FROM course_eng" is the exact query that you use? Check with SELECT @@session.sql_select_limit that it's not SQL_SELECT_LIMIT issue. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
