I have this mysql query:\[code\]UPDATE `table`.`wp_12_postmeta` SET `meta_value` = 'yyy' WHERE `wp_12_postmeta`.`meta_id` =5 LIMIT 1 ;\[/code\]How do i incorporate this:
instead of \[code\]wp_12_\[/code\] i want a variable \[code\]$prefix\[/code\] (variable holds wp_4_, wp_3_, etc)
instead of \[code\]yyy\[/code\] i want a value \[code\]$perf\[/code\] (variable is a name )
instead of \[code\]5\[/code\] i want a value \[code\]$meta_id\[/code\] (variable is a nr)
Thank u!P.S.here is what i use and it works:\[code\]$wpdb->query("UPDATE ".$prefix."postmeta SET meta_valuehttp://stackoverflow.com/questions/3614580/= '".$perf."' WHERE meta_id = '".$meta_id."' LIMIT 1 "); \[/code\]Problem is, when i execute this query, severl post meta fields are updated, instead of just one. Ty
