Design

Thank you, Barand.

yeah i noticed that and fixed it after i replied ^^ So this should work? : <?php include 'config.php'; include 'opendb.php'; $query = 'CREATE DATABASE xbc'; $result = mysql_query($query); mysql_select_db('xbc') or die('Cannot select database'); $query = 'CREATE TABLE users( ' . ' id int(10) DEFAULT '0' NOT NULL auto_increment, ' . ' username varchar(40), ' . ' password varchar(50), ' . ' regdate varchar(20), ' . ' email varchar(100), ' . ' ip varchar(15), ' . ' flag varchar(1), ' . 'PRIMARY KEY(id))'; 'CREATE TABLE news( ' . ' id int(10) DEFAULT '0' NOT NULL auto_increment, ' . ' author varchar(40), ' . ' title varchar(40), ' . ' content NOT NULL ' . ' date varchar(20) ' . 'PRIMARY KEY(id))'; 'CREATE TABLE maps( ' . ' id int(10) DEFAULT '0' NOT NULL auto_increment, ' . ' author varchar(40), ' . ' title varchar(40) NOT NULL, ' . ' type varchar(20), ' . ' content MEDIUMBLOB NOT NULL, ' . ' size NOT NULL, ' . 'PRIMARY KEY(id))'; $result = mysql_query($query); include 'closedb.php'; ?>

ok thx, I was just making sure that wouldnt conflict with the first 1.

Ok.... so here is my db creation thing right now, I wanna add in 2 other tables to this database, what's the best way to do so? <?php include 'config.php'; include 'opendb.php'; $query = 'CREATE DATABASE xbc'; $result = mysql_query($query); mysql_select_db('xbc') or die('Cannot select database'); $query = 'CREATE TABLE users( ' . ' (id int(10) DEFAULT '0' NOT NULL auto_increment, ' . ' username varchar(40), ' . ' password varchar(50), ' . ' regdate varchar(20), ' . ' email varchar(100), ' . ' ip varchar(12), ' . ' flag varchar(1), ' . 'PRIMARY KEY(id))'; $result = mysql_query($query); include 'closedb.php'; ?> Any help is greatly appreciated.

Pretty cool, I checked it out with a friend, good stuff.

Thanks

What I want to do is have my site so that when a user clicks a link, it uses the $GET method and uses a dynamic title for the target URL. My question is, how would I get this to work, I want it to set the variable for the $GET method, and then load up the same page, but with different content in the main portion of the page. I'd like to figure out to do this before I start the coding of my site, so that I can just implement it as I go. Thanks to anyone who helps me out on this.

I'm thinking you have counter.txt in the wrong place, since you moved your php file, you need to move counter.txt with it

you only want to open the file? in that case, fopen('page.txt',r); will open it in read-only format

still not working... anyone?

you've got a ] at the end of the code, i took that out and the page loaded, still no mail though. lemme take out the quotes again and try

I'll try quotes, maybe that'll work

[code] Parse error: syntax error, unexpected ']' in /home/pc72/public_html/smash/Test.php on line 61 [/code] Same error, different line

well, with my method, you could make a javascript counter or something that counts down or up until the end of the song, when the user presses the 'pause' button, have the counter stop also. once the counter hits a certain number(the end of the song), have it go to the new page. By the way, if you wanna find out the song exact song length, just convert the file type of the song to .WAV, and open it up in the sound recorder program.

getting an error now: [code] Parse error: syntax error, unexpected T_STRING, expecting ']' in /home/pc72/public_html/smash/Test.php on line 54 [/code]