mysql wont cxreate database!!!!

[Versable]

um ok dis what i did

<?php



$db = mysql_connect("localhost", "user", "pass");

mysql_select_db("DB_NAME");
$result = mysql_query("SELECT * FROM clanpagemembers");

if ($myrow = mysql_fetch_array($result)) {

  do {

printf("<a href=\"%s?id=%s\">%s %s</a><br>\n", $PHP_SELF, $myrow["name"], $myrow["password"], $myrow["icq"]);

  } while ($myrow = mysql_fetch_array($result));

} else {

  echo "Records not found, Creating table!!!!";	
  mysql_query("CREATE TABLE clanpagemembers (
  id tinyint(4) DEFAULT '0' NOT NULL AUTO_INCREMENT,
  name varchar(50),  location varchar(255),  favmap varchar(50),
  favweap varchar(50),  aim varchar(50),  icq varchar(50),
  homepage varchar(255), msn varchar(50),  avatar varchar
(255),  signature(255),  clanmember varchar(1),  post varchar(1),  

password(100),  PRIMARY KEY (id),  UNIQUE id (id));
               INSERT INTO clanpagemembers VALUES (1,'test','test','test','test','test',test','test','[e-mail]','0','0','1','1','nononono')");
}
?>

i get a

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /path/to/install.php on line 14
Records not found, Creating table!!!!

error

Plz help??

[rIkLuNd]

mysql_query("CREATE TABLE clanpagemembers(
id tinyint(4) DEFAULT '0' NOT NULL AUTO_INCREMENT,
name varchar(50),
location varchar(255),
favmap varchar(50),
favweap varchar(50),
aim varchar(50),
icq varchar(50),
homepage varchar(255),
msn varchar(50),
avatar varchar(255),
signature(255),
clanmember varchar(1),
post varchar(1),
password(100),
PRIMARY KEY (id),
UNIQUE id (id)
);

INSERT INTO clanpagemembers(id,name,location,favmap,favweap,aim,icq,homepage,msn,avatar,
signature,clanmember,post,password) VALUES ('1',
'test','test','test','test','test','test','test',
'test','[e-mail]','0','0','1','1','nononono')");

[hand]

<?php 
$db = mysql_connect("localhost", "user", "pass");  

mysql_select_db("test"); 

@$result = mysql_query("SELECT * FROM clanpagemembers"); 

if (@mysql_num_rows($result) > 0) {
	while ($myrow = mysql_fetch_array($result)) {
		printf("<a href=\"%s?id=%s\">%s %s</a><br>\n", $PHP_SELF, $myrow["name"], $myrow["password"], $myrow["icq"]); 
	}
} else { 
	echo "Records not found, Creating table!!!!"; 
	mysql_query("CREATE TABLE clanpagemembers (
					id tinyint(4) DEFAULT '0' NOT NULL AUTO_INCREMENT,
					name varchar(50),
					location varchar(255),
					favmap varchar(50),
					favweap varchar(50),
					aim varchar(50),
					icq varchar(50),
					homepage varchar(255),
					msn varchar(50),
					avatar varchar(255),
					signature varchar(255),
					clanmember varchar(1),
					post varchar(1),
					password varchar(100),
					PRIMARY KEY (id),
					UNIQUE id (id))")
				or print "&gt;&gt;&gt; MySQL-Error: ".mysql_errno()." -&gt; ".mysql_error()."<br>\n";
	mysql_query("INSERT INTO clanpagemembers VALUES
					(1,'test','test','test','test',
					'test','test',
					'test','[e-mail]',
					'0','0','1','1','nononono')")
				or print "&gt;&gt;&gt; MySQL-Error: ".mysql_errno()." -&gt; ".mysql_error()."<br>\n"; 
} 
?> 

[Versable]

Now im getting a

Records not found, Creating table!!!!>>> MySQL-Error: 1046 -> No Database Selected

MySQL-Error: 1046 -> No Database Selected

Error? Anybody any idea? I used hands code

[Versable]

Common help me out plz

[darfbobo]

The only thing I see that might be a problem is you need to change:

mysql_select_db("DB_NAME");

-to-

mysql_select_db("DB_NAME",$db);

Hope that helps..
~Brian

[Versable]

OMG

THANK YOU SO MUCH!

I WAS GONNE GIVE UP THAT ONE BUT THX TO YALL IT WORKIN! AHAHAHAHAHHAHAHAHHAHAHAHAHHAHAHAHAH