I'm trying to do these tutorials in a book for php. This one tutorial is making a small basic forum. It nees to access a databse and gave me this sql code...

mysql> create table forum_topics (
	->topic_id int not null primary key auto_increment, 
	->topic_title varchar (150), 
	->topic_create_time datetime,
	->topic_owner varchar (150)
	-> );

mysql> create table forum_posts (
	-> post_id int not null primary key auto_increment, 
	-> topic_id int not null, 
	-> post_text text, 
	-> post_create_time datetime, 
	->post_owner varchar (150)
	-> );

I have no idea what to do with it and the book doesnt say. I tri3ed going to the admin panel in the phpMyAdmin and using a text file with that code in it to create the DB. i got a bunch of errors and it said make sure your using the right syntax for this kind of SQL server. I'm using a program called easyPHP which is like evrything you need to run a small server for testing.

Anyone have any idea what i can do with this code

You have the basic idea down, just use phpMyAdmin to create the db first, then select that db and run the above query against it.

That code will not create the database, You will need to do that first.

The code they gave you is assuming you have mysql command line access. Simply remove the mysql> and -> parts and you should be able to run the queries in phpMyAdmin

I deleted the mysql> parts and all of the -> parts and get a new error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql> create table forum_posts (
post_id int not null prima





nvm i forgot to delete the second mysql> part of it. i guess you shouldnt go to the bar all night anjd try to work on coding

I do get this error when running my PHP page. I'm not sure on how to change user names and passwords. anyone know how to using mysql?

error: Warning: mysql_connect(): Access denied for user 'joeuser'@'localhost' (using password: YES) in c:\program files\easyphp1-8\www\mycoding\topiclist.php on line 3
Access denied for user 'joeuser'@'localhost' (using password: YES)

So did you create a database and user account for the script to run on? I notice in the error msg that you've used 'joeuser', did you create this account? Does the account have create privilages in the database?

I think i figured it out!