|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Inserting into Mysql tables.
HI
I am using PHP with IIS server and Mysql Now i can extract information from my database which is located on the root directory of my local host. However when i try to insert some values into the tables from a php page i am not successfull. So i can extract information from but NOT insert to TABLE. PLEASE HELP |
|
#2
|
|||
|
|||
|
RE: Inserting into Mysql tables.
by the way i am using windows 2000 not Linux
Windows 2000 |
|
#3
|
|||
|
|||
|
RE: Inserting into Mysql tables.
d'uh... u dont have to mention that..
people do not use IIS on linux.. hehehe (correct me if i'm wrong..) anyway, bout ur question... are u sure you have the right permission on your Database? if ur using a root access.. or a username that has privellage (Write) on the table / db.. than everything should be fine.. Or maybe ur IIS access.. perhaps, it's ur code dude... i dont know dude.. i'm practically new too... anyway, hope my suggestion helps.. good luck though... take care.. -jassh |
|
#4
|
|||
|
|||
|
RE: Inserting into Mysql tables.
how do i check for write permissions on the user?---i am using root.
|
|
#5
|
|||
|
|||
|
RE: Inserting into Mysql tables.
here is my code.
Username and pasword are defined but i left them out here. $db = mysql_connect("localhost", $dbuser, $dbpass); $dbb =mysql_select_db("database03",$db); $query = "INSERT INTO employees VALUES($num,$first,$last)"; $result = mysql_query("SELECT * FROM employees",$db); printf("First Name: %s<br>n", @ mysql_result($result,2,"first")); printf("Last Name: %s<br>n", @ mysql_result($result,2,"last")); |
![]() |
| Viewing: Codewalkers Forums > Other Technologies > Database Help > Inserting into Mysql tables. |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|