Database related--Please help

Anon

I have installed MySQL and Php running on Apache web server on Solaris platform.Everything(PHP Scripts running fine on the server,Mysql is also running fine with its mysql> prompt)But when i try to do any DML operation (Insert/Update/Delete/Select)on the mysql database using PHP,It displays no errors everything works fine the execution reaches till the end of the code file ....But nothing happens to the database.If you try to Insert no insertion Happens or no Updation/Deletion/Selection happens.I dont know why?
Do i need to configure something?
Please Help

Thanx in Advance.

...This is my Code...

<?php
$conn=mysql_connect("mysqlServer","","");
if($conn==false){
echo mysql_errno(). " : " . mysql_error()."<br>";
exit;
}
$query="INSERT INTO info VALUES('Rajdeep','23','Shivaji Road')"
mysql_select_db("lamp");
mysql_query($query);
print ",,,,,,DONE,,,,,,,,";
?>

Anon

hi,

after your description you have got an existing connection to your server.

to exclude that your query is wrong receive the return of your query

1
2 <?php
3 $result = mysql_query ("SELECT my_col FROM my_tbl")
4 or die ("Invalid query");
5 ?>
6

the var $result may be true (if the query was sucessful) or false.

i hope that will help you

regards,
sebastian

amcgrath

I really can't see anyhting wrong (I don't use MYsql) but just one heads up: Though this is legal (INSERT INTO info VALUES('Rajdeep','23','Shivaji Road')), I would strongly recommed you put the corresponding columns in the sql, if you ever change that table, this query will break...