Re: Not able to add data to a MySQL database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



You've got errors in your SQL.
For once, table-names should not be quoted (with single or double quotes), same goes for column names ('uname' and 'access' in your example).


Easiest way to find out without asking is to add a call to mysql_error(), so called "error handling"...! That would've told you about the syntax errors. Fix those, and it should work just fine

- tul

Vaibhav Sibal wrote:

Hi,
I am not able to insert data into my mysql database using php even if
i use a simple code as follows :
<?php
$link=mysql_connect("localhost","username","password");
mysql_select_db("test_db");
$query="INSERT INTO 'login' ('uname','access') VALUES ('try','super')";
mysql_query($query,$link);
?>

even after running this code on the server, there was no change in the
mysql database as seen by the phpmyadmin. Ive tried it with another
file and another table, but its not just happening. Though earlier
attempts with Mysql had worked, but those only involved reading data
from the database and I havent been able to write to it even once
since I have started working. Please help me out with this, in case
there is some information that I should have provided here and its not
there please ask for it, I will be more than happy to provide it.

Thanks
Vaibhav

-- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Database Programming]     [PHP Install]     [Kernel Newbies]     [Yosemite Forum]     [PHP Books]

  Powered by Linux