Re: MySQL gurus - easy one.

2002-01-28 Thread Sherwin Ang
Hello Odhiambo, Seems like From and To are MySQL reserved words. http://www.mysql.com/doc/R/e/Reserved_words.html Thanks, Sherwin Ang Web Programmer / Systems Administrator Alchemy Solutions http://www.alchemy.com.ph Creative. Technology. Tridel Technologies, Inc. 7th Floor Hanston Building

Re: print database schema

2002-01-28 Thread Sherwin Ang
for mysql. Hope that helps. Thanks, Sherwin Ang Web Programmer / Systems Administrator Alchemy Solutions http://www.alchemy.com.ph Creative. Technology. Tridel Technologies, Inc. 7th Floor Hanston Building Emerald Ave., Ortigas Center Pasig City Tel: (632) 634-5141/ (632) 634-5140 Local 1040

Re: can login only as root

2002-01-19 Thread Sherwin Ang
check out the docs at http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm inistration.html#GRANT Thanks, Sherwin Ang Web Programmer / Systems Administrator Alchemy Solutions http://www.alchemy.com.ph Creative. Technology. Tridel Technologies, Inc. 7th Floor Hanston

Re: Access Denied!

2002-01-10 Thread Sherwin Ang
You dont have the FILE privileges. http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm inistration.html#GRANT Thanks, Sherwin Ang Web Programmer / Systems Administrator Alchemy Solutions http://www.alchemy.com.ph Creative. Technology. Tridel Technologies, Inc. 7th

Re: Niebie again

2002-01-09 Thread Sherwin Ang
ame values (1,"John"); insert into name values (2,"George"); insert into name values (3,"Chris"); insert into name values (4,"Patrick"); Regards, Sherwin Ang Web Programmer / Systems Administrator Alchemy Solutions http://www.alchemy.com.ph Creative. Techn

Re: mySQL security

2002-01-09 Thread Sherwin Ang
s in detail at http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm inistration.html#GRANT Thanks, Sherwin Ang Web Programmer / Systems Administrator Alchemy Solutions http://www.alchemy.com.ph Creative. Technology. Tridel Technologies, Inc. 7th Floor Hanston Building Emerald Ave., O

Re: apostrophe's in PHP & MySQL

2002-01-09 Thread Sherwin Ang
another approach is using the str_replace() function, just replace the single quote ' with two single quotes '' and database inserts should be fine. http://www.php.net/manual/en/function.str-replace.php Regards, Sherwin Ang Web Programmer / Systems Administrator Alchemy

Re: Host Access denied

2001-08-03 Thread Sherwin Ang
It looks like you dont have the correct privileges on your mysql server to connect from a specified host. Look at the Grant function in mysql manual for more info Sherwin Ang Web Programmer Yesmynet Internet - Original Message - From: Mike <[EMAIL PROTECTED]> To: MySQLList &

Re: Connection to remote Mysql Server.

2001-01-24 Thread Sherwin Ang
Rajesh Prakasan I use this free and lighweight SSH client for win32 to access my remote mysql servers on linux check it out at http://www.chiark.greenend.org.uk/~sgtatham/putty/ -Sherwin Yesmynet Internet #mysql - undernet irc - Original Message - From: "Rajesh Prakasan" <[EMAIL