Re: MySQL Error

I did that and it didn't output anything... ----- Original Message ----- From: "Brad Bonkoski" <bbonkosk@tampabay.rr.com> To: "Stephen" <webmaster@melchior.us> Cc: "PHP List" <php-general@lists.php.net> Sent: Sunday, December 01, 2002 2:55 PM Subject: Re: [PHP] MySQL Error > Perhaps you should try and do some error checking on the mysql_select_db() > function, like printing out mysql_error(). > > Also, for the permissions issues, mysql has a very comprehensive online > documentation on user permissions. Check them out, you may also wish to try > and connect to the database with a different user? > http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm inistration.html#Adding_users > > HTH > -Brad > > Stephen wrote: > > > Hello, > > > > I just recently switched to IIS from Apache since IIS came with Windows XP > > and I just love Microsoft. I installed PHP and MySQL with no problems but > > when I tried accessing a table, I got this error: > > > > No Database Selected > > > > In my script, I have this: > > > > $hostname_default = "localhost"; > > $database_default = "check"; > > $username_default = "root"; > > $password_default = " **taken out for known reasons** "; > > $default = mysql_pconnect($hostname_default, $username_default, > > $password_default) or die(mysql_error()); > > mysql_select_db($database_default, $default); > > $query_update = "SELECT * FROM updates ORDER BY date > > DESC LIMIT 1"; > > $update = mysql_query($query_update, $default) or die(mysql_error()); > > $row_update = mysql_fetch_assoc($update); > > $totalRows_update = mysql_num_rows($update); > > > > I don't see where it's gone wrong! My database name is check and phpMyAdmin > > can get to it just fine. Also, how can I set it up so MySQL allows the user > > name root and no password acessable through localhost? I accidently changed > > it to only allow username root, with password... > > > > Thanks, > > Stephen Craton > > http://www.melchior.us > > > > "What is a dreamer that can not persevere?" -- > > http://www.melchior.us > > > ------------------------------------------------------------------------ > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >