I'm trying to make a wordpress plugin and i came over a problem.
The problem is with an update query which i can't figure out why it isn't working. The query should update a non wordpress table
global $wpdb;
$sql ="UPDATE $lmdisp_table_name
SET `".$lmdisp_nume."`=".$nume.",
`".$lmdisp_departament."` = ".$dep.",
`".$lmdisp_an."` = ".$an.",
`".$lmdisp_grupaserie."` = ".$grupa.",
`".$lmdisp_tel."` = ".$tel."' ,
`".$lmdisp_email."` = ".$email.",
`".$lmdisp_fb."` = ".$fb.",
`".$lmdisp_tw."` = ".$tw.",
`".$lmdisp_linked."` = ".$linked.",
`".$lmdisp_freel."` = ".$freel.",
`".$lmdisp_blog."` = ".$blog.",
`".$lmdisp_memyear."` = ".$memyear.",
`".$lmdisp_fctlse."` = ".$fct.",
`".$lmdisp_evlse."` = ".$evlse.",
`".$lmdisp_skills."` = ".$skills.",
`".$lmdisp_avatar."` = ".$avatar.",
`".$lmdisp_cv."` = ".$cv."
WHERE `".$lmdisp_id."` = ".$id."";
$rez = $wpdb->query($sql);
A little help ?:(
Try SQL Query like this:-
<?php
global $wpdb;
$sql ="UPDATE $lmdisp_table_name
SET `".$lmdisp_nume."`= '".$nume."',
`".$lmdisp_departament."` = '".$dep."',
`".$lmdisp_an."` = '".$an."',
`".$lmdisp_grupaserie."` = '".$grupa."',
`".$lmdisp_tel."` = '".$tel."' ,
`".$lmdisp_email."` = '".$email."',
`".$lmdisp_fb."` = '".$fb."',
`".$lmdisp_tw."` = '".$tw."',
`".$lmdisp_linked."` = '".$linked."',
`".$lmdisp_freel."` = '".$freel."',
`".$lmdisp_blog."` = '".$blog."',
`".$lmdisp_memyear."` = '".$memyear."',
`".$lmdisp_fctlse."` = '".$fct."',
`".$lmdisp_evlse."` = '".$evlse."',
`".$lmdisp_skills."` = '".$skills."',
`".$lmdisp_avatar."` = '".$avatar."',
`".$lmdisp_cv."` = '".$cv."'
WHERE `".$lmdisp_id."` = '".$id."'";
$rez = $wpdb->query($sql);
Hope it will work.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With