need help updating one field in mysql in entire table - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

gibsongk55 · 06-19-2010, 11:31 AM

Hi,

I'm not good with mysql. I need an example that i can make work.

I have one field in a table I need to read which is the URL and I need to check the URL with a php script and get the current Google PR and update another field that holds the PR in that row that corresponds with that URL field. I need to do this for every row in the entire table. I already have the include script to check the current PR value.

Thanks in advance for any help.

Gibs

lovesummer · 08-05-2010, 08:31 AM

It is hard to say how to use php, you can learn it from DVD books. sorry can not help you.

jalicia18 · 01-24-2011, 12:10 AM

Use a cron job set always or everyday to run the script.

Quote:

while(blahblah)
{
$weburl = $row[site];
$prweb = GetGooglePR($weburl);

$sql = "UPDATE tablename SET prfield='$prweb' WHERE urlfield LIKE '$weburl'";
$query = mysql_query($sql);
}