hi, new to the list so here goes! i have mysql version 3.23.38 installed on a win98 pc running apache with php 4 installed. i am working through the book and so have created a database called 'test'. i have also put a server, user and password into the mysql database. i have connected to this using php code. then i recreated a second database called guest. when i try to connect to this i get a cant select message from my php code. i have tried different names and flushing the privileges but nothing i do will help. i have also deleted all the databases and recreated them and agin, the only one i can connect to is one called test!!!! this is driving me mad!! does anyone have any ideas?? cheers, jake 28 23a great queen street london wc2b 5bb t 020 7404 4828 f 0870 164 3109 [EMAIL PROTECTED] m 07931 507 442 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php