input SQL data through text box and get nothing?

[marslee@hotmail.com]

I want to add SQL command through a textbox in the form using post
method,but when i execute the following file, nothing is added to the
database.
I can add
$sqlol = "update acc_account
set user_name='k'
where accountid=1";
to the database if it was added to the file but when i use $result =
mysql_query($sq l); which execute the query, it get nothing. However,
the $sql statement do print out on the screen using print.

Any idea?

<?php
$conn=mysql_con nect('localhost ', 'shytr8');

if(!$conn)
{print "Error- Could not connect to MYSQL";
exit;}

$er=mysql_selec t_db("test");

if(!$er){
print "Error- Could not create er";
$query = "CREATE DATABASE test";
mysql_query($qu ery);}



$sql=$_POST[SQLcommand];
$result = mysql_query($sq l);
?>

[Jerry Stuckle]

Re: input SQL data through text box and get nothing?

marslee@hotmail .com wrote:[color=blue]
> I want to add SQL command through a textbox in the form using post
> method,but when i execute the following file, nothing is added to the
> database.
> I can add
> $sqlol = "update acc_account
> set user_name='k'
> where accountid=1";
> to the database if it was added to the file but when i use $result =
> mysql_query($sq l); which execute the query, it get nothing. However,
> the $sql statement do print out on the screen using print.
>
> Any idea?
>
> <?php
> $conn=mysql_con nect('localhost ', 'shytr8');
>
> if(!$conn)
> {print "Error- Could not connect to MYSQL";
> exit;}
>
> $er=mysql_selec t_db("test");
>
> if(!$er){
> print "Error- Could not create er";
> $query = "CREATE DATABASE test";
> mysql_query($qu ery);}
>
>
>
> $sql=$_POST[SQLcommand];
> $result = mysql_query($sq l);
> ?>
>[/color]


What's the result from mysql_query?

if (!$result)
echo mysql_error();


--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===