MYSQL error while inserting data using php -
i practicing php , sql. @ stage when i'm trying enter record table 2 exiting records. doesn't add , show error
"you have error in sql syntax; check manual corresponds mysql server version right syntax use near '=('aqeela','nasreen','hakeem chattah')' @ line 1"
why not entering record in data base. there syntax error?
$username="root"; $pass=""; $database="addressbook"; $server="127.0.0.1"; $con=mysql_connect($server,$username,$pass); $db_found=mysql_select_db($database,$con); if($db_found) { $sql_insert="insert table_address_book(f_name,l_name,address) values=('aqeela','nasreen','hakeem chattah')"; $result=mysql_query($sql_insert); if(!$result){ print "sorry cannot proceed request<br>".mysql_error(); } else { // print "recorded entered successfuly<br>"; // print "now databases after editing are<br><br>"; $new_sql="select*from table_address_book"; $result_after_editing=mysql_query($new_sql); while($db_field_edited=mysql_fetch_assoc($result_after_editing)) { print $db_field_edited['id']."<br>"; print $db_field_edited['f_name']."<br>"; print $db_field_edited['l_name']."<br>"; print $db_field_edited['address']."<br>"; print "<br><br><br>"; } mysql_close($con); } } else { die("unable connect database ".mysql_error()); }
the error shows place error in syntax occur.
remove =
insert table_address_book(f_name,l_name,address) values('aqeela','nasreen','hakeem chattah')" 
Comments
Post a Comment