Newbie Question about working with datetime column
Im using the NOW() function to store the date and time in my database table that a person fills out my form. But I noticed that its 2002-01-07 11:51pm but the time shows up as 2002-01-08 01:51:18. It appears to be two hours off. How can I adjust the time to match my time zone? Always an Email Away Kevin Campbell Chief Executive Officer The Club Mix, Inc. http://www.theclubmix.com
Newbie Question: Data Type Choice
Whats the best data type to use for storing guest book comments in my database table. Always an Email Away Kevin Campbell Chief Executive Officer The Club Mix, Inc. http://www.theclubmix.com
Newbie Question: Float Type Range
Im using a field in a form to record money values: 0.00 9000.00 in my database table. Im planning on using float(4,2). Does the 4 mean the maximum number of digits before the decimal and the 2 the number of digits after the decimal. Always an Email Away Kevin Campbell Chief Executive Officer The Club Mix, Inc. http://www.theclubmix.com
Learning how to write good WHERE clauses
Im new to MySQL and it seems that a big part of this is knowing how to write the right conditional clause to get the results you want. Anybody know where some good articles are on learning how to write good WHERE CLAUSES, I always know what I want to get but Im still not sure how to map that into a WHERE statement, especially when its a Join Select. Any help would be greatly appreciated Thanks. Always an Email Away Kevin Campbell Chief Executive Officer The Club Mix, Inc. http://www.theclubmix.com
Each user have only see databases they have access too
Im running MySQL on my Win98 Desktop and Ive created a new user and only granted access to one database, but when I use myPhpAdmin the user can still see all the databases. What can I do so that each user only see the databases they have access too. Always an Email Away Kevin Campbell Chief Executive Officer The Club Mix, Inc. http://www.theclubmix.com