Update column with foreach

[balkan7]

I want to update empty columns in datebase, so i have this table:

 

category

- cid

- cname

- cparent

- cseo

Column cseo is empty i want update it with cname column with seo function.

This foreach doesn't work

 

code is:

<?php
$cats = mysql_query("SELECT * FROM category WHERE cparent ='4' ORDER BY cid DESC");
while ($data = mysql_fetch_array($cats)) {
if ($data['cseo'] == ""){
foreach ($data['cname'] as $seo_names) {
$seo_link = seo($seo_names);
$result = mysql_query("UPDATE category SET cseo='$seo_link' WHERE cid='".$data['cid']."'");
if ($result) { echo "Done!"; }
}
}
}

 

[Drummin]

Correct, $data['cname'] is not an array.

 

What is seo($seo_names)?

[balkan7]

Ok i have seo function for replace names from category like this:

cname: Foo Bar

cseo: foo-bar

 

so i don't know which is the best method to update every cname column to cseo column

[Drummin]

Seems like this should work.

<?php
$cats = mysql_query("SELECT cid, cname FROM category WHERE cparent ='4' ORDER BY cid DESC");
while ($data = mysql_fetch_array($cats)) {
$cname = $data['cname'];
$seo_link = seo($cname);
$result = mysql_query("UPDATE category SET cseo='$seo_link' WHERE cid='".$data['cid']."'");
}
?>

[balkan7]

Yes Working

Thanks !