I have a table with some categories and a number coresponding with that category.
I also have a big database and I want to change the category name with the number coresponding with that category.I haven't managed to do that.Any ideas?
My program looks like:
$sqlquery="SELECT ID,micro from firme_micro";
$result=mysql_query($sqlquery);
while($data=mysql_fetch_array($result))
{
$sql="UPDATE firme_save SET micro='$data[0]' where firme_save.micro='$data[1]' ";
$resu=mysql_query($sql)or die("not enter");
}
The problem is this is not working,or it's working only for some categories.
I also have some categories like this ski' & snow(for example). ' is giving some problems too.Thanks!