mysql help

[Anon]

i having problem wit mysql databases plz add me to msn ( if u have ) and help me! thx...

[Anon]

ah forgot to write email...
[e-mail]

[Anon]

Unfortunatelly, I don't have hotmail account. Can you post your question so that we may help you?

Solomon

[Anon]

erm well...ok...
got this problem..

Warning: mysql_fetch_field(): supplied argument is not a valid MySQL result resource in C:\webserver\webservermanager\sacred\createdb.php on line 9

Warning: mysql_fetch_field(): supplied argument is not a valid MySQL result resource in C:\webserver\webservermanager\sacred\createdb.php on line 10

and well the server supports mysql

heres a example of mysql script

<?
mysql_connect("localhost","sacred","21233134");
mysql_create_db("players");
mysql_select_db("players");
$query1="CREATE TABLE players2(name CHAR(255), email CHAR(255)";
$query="INSERT INTO players2(name, email) VALUES('Sacred Priest','[e-mail]')";
$query=stripslashes($query);
$results=mysql_db_query("players","select * from players2");
$name=mysql_fetch_field($results,"name");
$email=mysql_fetch_field($results,"email");
mysql_close();

echo "<b>$name<br>$email</b>";

?>

i want to display the datas out but i got that problem so help me...thx

[fitzbean]

$query1="CREATE TABLE players2(name CHAR(255), email CHAR(255))";

You forgot the ")" at the end of this before the quote, resulting in invalid SQL and thus later on when you try to reference the table it's not there, cause it was never created.

[Anon]

oh thanks

[Anon]

i still got the same problem 🙁

[Anon]

$query1="CREATE TABLE players2(name CHAR(255), email CHAR(255)";

Should look like:

$query1="CREATE TABLE players2(name CHAR(255), email CHAR(255), Primary Key (name))";

As far as I understand MySQL NEEDS to have a Primary Key defined. Or nothing will work. That might do the trick. If not let us know. Thanks!
Me