| Server IP : 51.89.169.208 / Your IP : 18.216.230.65 Web Server : Apache System : Linux ns3209505.ip-198-244-202.eu 4.18.0-553.27.1.el8_10.x86_64 #1 SMP Tue Nov 5 04:50:16 EST 2024 x86_64 User : yellowleaf ( 1019) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/yellowleaf/public_html/ |
Upload File : |
<?
include '../connect.php';
$area_sql = mysql_query("SELECT * FROM cats WHERE pop='0'");
$count = mysql_num_rows($area_sql); echo "$count FOUND<br><br>";
while($area_row = mysql_fetch_array($area_sql)){
$catId=$area_row['cat_id'];
$cat_name=$area_row['cat_name'];
$singular= str_replace("Classes","Class", $cat_name);
if (preg_match("/Classes$/", $cat_name)) {
$q3 = "UPDATE cats SET
cat_singular = '$singular',
title = '$cat_name'
WHERE cat_id = '$catId'";
$r3 = mysql_query($q3) or die(mysql_error());
echo "done $catId - $cat_name - $singular<br>";
}
}
?>