probably really stupid and obvious, but...

dannysdancin

Just starting to teach myself MySQL/PHP - I have created a new database and now I want to create some tables in it.
What is the line of SQL to switch to that database so I can use create table?

OhLordy

use database_name;
if you are accessing from inside mysql
$db=mysql_select_db($database,$conn);

HTH
Rob

dannysdancin

Wow, thanks! instant service!

rbudj

I too am new and trying to learn PHP and MYsql. Having a hard time finding the right book and resources. Just thought I would ask to see what books and resources you are using to learn from scratch.

dannysdancin

I've been given "PHP and MySQL for Dummies" by J. Valade to work with, assumes a basic knowledge of HTML but nothing else and includes PHP and MySQL software on CD, which would have saved me the downloads if I'd known in advance.

Main criticisms I have of the book so far, although I only started today so not conclusive:

(1) it assumes global register is turned on by default, which is NOT the default setting in the latest version of PHP, so causes problems with the sample code in the book. But I worked out how to solve this myself, by finding out about superglobals from php.net

(2) it didn't explain the one very simple but crucial question I did have

On the other hand, it's cheap!