I know this is a simple query - i've been looking everywhere in the web for the solution but cannot seem to find it. If any one could help me that would be great.

In my table named Title - i want to replace all blank spaces (" ") with " " in the TITLEID field.

I also want to add values to the Price row dependant on values in the Dealer_price row. For example i want to insert into Price field "20" only where the Dealer_price is "15".

How do i do this? if you need me to explain more clearly then please let me know.

Thanks

<?

$var = mysql_query("SELECT * FROM Title");
while ($arr = mysql_fetch_array($var)){
$temp = $arr[TITLEID];
$titleid = str_replace(' ', '&nbsp;', $arr[TITLEID]);
mysql_query("UPDATE Title SET TITLEID='$titleid' WHERE TITLEID='$temp'")
}

?>

The code above will replace all of the spaces in your title ID's and change them to &nbsp;'s. As for the other query, I'm not sure what you want, so I'll just write a small thing to make the dealer price a percentage of that of the price.

<?

$percentageoff = '.25'; // Dealer gets 25% off!
$var = mysql_query("SELECT * FROM Title");
while ($arr = mysql_fetch_Array($var)){
$dealerprice = $arr[price]*$percentageoff;
mysql_query("UPDATE Title SET Dealer_price='$dealerpice' WHERE Price='$arr[price]'");
}

?>

That code should change all of the dealer prices to 25% (in your example, 15/20 = 25% off) of the regular price posted, you can change the value of $percentageoff to whatever you'd like.