[RESOLVED] sql or php problem?????

[PlaGuE]

okay i have a script im making for when i dont wana get into PHPmyAdmin.

heres the code

if(isset($_POST['add_query_command']))

{

$result = mysql_query( $_POST['sql_info'])
or die(mysql_error());

switch(mysql_errno()) {
case 1050:
break;

case 0:
echo"Query Sucessfull";
break;

default:
die(mysql_error());
break;
}
}

elseif(isset($_GET['sql_help']))

{

echo"The Help File is being thought up and written as you read.";

}

else

{
echo"<form name=sqlinfo method=post action=$PHP_SELF>
Write your SQL statements/queries in the textarea below:
<table width=38% border=0 cellspacing=0 cellpadding=0>
<tr>
<th scope=row>
<div align=center>
<textarea name=sql_info cols=70 rows=30></textarea>
<input name=add_query_command type=submit value=Insert>
<input name=clearsql type=reset id=clearsql value=Clear>
<a href='$PHP_SELF?sql_help'>SQL HELP</a>
</div>
</th>
</tr>
</table>
</form>
";
}


I get no errors until i try and submit... and its not a bad code error... its a mysql error...

how can i fix it so that it works... if i cant get this to work... ill just go back to making a php file and hardcoding the "CREATE" and "INSERT" values in.

BTW: I didnt include the mysql_connect() stuff..

[PlaGuE]

BUMP... oops did i do that.

[PlaGuE]

anyone know what could be the problem?

[{yak}]

I copy and pasted your exact code,and it seems to be working for me, assuming I'm typing in the same values you are. Can you give an example of the query you're typing in thats erroring out.

[PlaGuE]

i fixed it with a $result = mysql_query(stripslashes( $_POST['sql_info'])) or die(mysl_error());

hmm even the simplest query wouldnt work... with the posted code... IE CREATE TABLE dumb (id mediumin(11))

then i stuck strip slashes in.. and it worked... wierd...