vendredi 14 mai 2021

recieving error while inserting int value as varchar in mysql

getting a syntax error when trying to insert some data.

Telling that i am storing a int value for flaw_val and am storing it in a varchar type in my database. I think this is where error is. Help me figure the thing up.Also tell how to fix it up.

Main code:

$flawquery = "insert into flawed_data (serial_id,main_title,url_title,company,hosted_at,links_sup,flaw_dis,flaw_val,flaw_sol,file_name,current_date,current_time,name,username,email) values ('$serial_id' , '$title' , '$url_title' , '$company' , '$hosted_at' , '$links_supported' , '$flaw' , '$flaw_val' , '$flaw_sol' , '$fileNameNew' , '$current_date' , '$current_time' , '$name' , '$username' , '$email') ";

Thanks in advance.

Aucun commentaire:

Enregistrer un commentaire