help me!

Anon

I have no problem connecting to the mysql server and setting the database active. The problem is anything I do after that does not work and gives me errors!!

I tried to create a table, failed. So I tried it in PHPmyAdmin and it worked but gave me a few errors in the beginning.

So then I tried to insert and delete the table from my php script but that failed.

All the previous scripts I created don't work and I know they work because I they worked on a previous host.

Do you know if the configuration file for the new host is different or something. Anyone have any ideas.

THe old host gave me a lot of trouble and didn't give much support, thats why I left them. Plus their pricing was outrageous!

Please give me some ideas why this may be the reason. Could it be PHP too maybe? Why would phpMyAdmin work though?

Thanks!

Anon

phpMyAdmin works because it is coded correctly.

please post your code so i can tell you what is wrong with it.

"Do you know if the configuration file for the new host is different or something."

unless you show me both configuration files i couldn't tell you that either.

Anon

mysql_connect("localhost", "username", "password") {
// the above line works

mysql_select_db ("database");
// the above line works also

mysql_query ("CREATE TABLE tablename(email CHAR(255)") or print "error";
// the above line gives me an error

mysql_close();

and don't judge my coding.. i've been programming in PHP and MySQL for over a year.

All my scripts work on other hosts that I have been with, except for this.

So tell my why phpMyAdmin works, and my custom coding doesn't?

Anon

"and don't judge my coding.. i've been programming in PHP and MySQL for over a year."

i don't really understand what you are saying? don't say its wrong because i am smart, or it might be wrong because i am a newbie... either way, you are missing a paren on that statement.

a trick i use is keep a running count... for every left paren, add one, for every right paren subtract one... if you don't end up with 0 you are fucked.

mysql_query ("CREATE TABLE tablename(email CHAR(255))") or print "error";

should work fine.

Anon

in my program ihave the extra ). So why does phpMyAdmin work, and not mine. ALl my scripts worked on my other hosts.

How come not this one, but phpmyadmin works?

Anon

phpmyadmin works because it doesn't use your code... it uses code with the correct number of parens.

your code worked on your other host probably because they had error levels set differently.

jc94062

"THe old host gave me a lot of trouble and didn't give much support, thats why I left them. Plus their pricing was outrageous!"

A lot of trouble?
If they have their error checked set so low it allows you to open 3 and close 2 sets of brackets they must be!

If you do have problems I use the below method, easier to check for errors :-)

$table = "CREATE TABLE test (
id tinyint(4) NOT NULL auto_increment,
name varchar(30),
PRIMARY KEY (id),
UNIQUE id (id)
)";
$result = mysql_query($table);
if ($result) {echo "Table $name created";}
else {
echo("<P>Error: " .
mysql_error() . "</P>");
exit(); }
}

Btw, you mentioned you'd be coding for a year or more, did you mean that as a long or short time?

Happy coding.

Anon

What I had typed on phpbuilder i know was a mistake. BUT IN MY CODE, THERE ISN"T ANYTHING MISSING!!! MY PREVIOUS HOSTS SAID THAT ERRORS WERE SET NORMAL LIKE EVERYONE ELSE. SO STOP SAYING ITS MY CODE!!!

GEEZ!!!

SO CAN ANYONE TELL ME WHY PHP ADMIN WORKS AND NOT MY CODE. I KNOW FOR A FACT THAT MY CODE IS CORRECT!!! IF IT WAS THE ERROR SETTING, I"M SURE 3 HOSTS WOULDN"T HAVE THE SAME ERROR SETTING IF THEY DID HAVE IT SET DIFFERENT!!

SO SOMEONE PLEASE EXPLAIN TO ME WHY IT DOESN'T WORK!!!

THANKS!

ps. sorry for all the caps, I explained that i made the error before in phpbuilder.com and not my script, so why ARE YOU STILL TELLING ME ITS MY CODE!!!

Anon

James, I guess one year of coding is a quite a lot. Not saying its been my entire life, but that's the actual time that i've been doing it professionaly (as a business). I've been coding php for over 1 1/2 if you want to know exactly when I started..

Anon

because the code you posted didn't have the right number of parens...

stop talking about phpmyadmin, because of course that will work...

ex:

<?php
print("blah";
?>

will give me an error obviously because i don't have the right amount of parens, but let me check... yup... phpmyadmin still works fine! it uses its OWN CODE, not yours.

your error IS the number of parens. don't be stubborn and refuse to fix it... just hit shift, and the 0 key and your problems will go away.

Anon

LISTEN TO MY WORDS.

THE CODE IN MY PROGRAM IS CORRECT!!!

here ya go, i copied it so i wouldn't have made any typos!!

mysql_connect("localhost", "username", "password");

mysql_select_db("database");

mysql_query("CREATE TABLE tablename(rowid INT PRIMARY KEY AUTO_INCREMENT, email CHAR(255))");

mysql_close();

NOW PLEASE TELL ME WHY IT DOESN'T WORK!

Anon

LISTEN TO MY WORDS.

THE CODE IN YOUR PROGRAM IS INCORRECT!!!

primary keys can't be null...

mysql_connect("localhost", "username", "password");
mysql_select_db("database");
mysql_query("CREATE TABLE tablename(rowid INT NOT NULL PRIMARY KEY auto_increment, email CHAR(255))");
mysql_close();

boo yah. and email should probably be a varchar(255) to save memory.

in the future paste EXACT CODE, ask DIRECT questions and don't be stubborn, please.

Anon

well according to what i read from mysql and what others told me, 'not null' will be automatically be inserted when creating the table if you do not enter anything. In all my php books, all my forums i've visited to, all those php.resourcindex.com sites, i've never seen them use it.

anyways. I used not null like you told me and it still doesn't work.

Since you seem so smart about it, write something that will work.. then i'll test it out!

"boo yah"