I am making a fix script for a site statistics script I am using and I have the following code. When I run it I get no errors and when I go to my site with the error "online.myi" and it doesnt fix it?
<?php
$db_user='rksu******'; // Fill in with your mysql database information
$db_pass='XXXXXXXXXX';
$db_host='localhost';
$db_name='counter';
$mysql_access = mysql_connect($db_host,$db_user,$db_pass);
mysql_query("repair table online;", $mysql_access);
?>try removing the semi-colon after the query.mysql_query("repair table online;", $mysql_access);
also you never selected the db.
mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db($db_name);
<?php
$db_user='rksu******'; // Fill in with your mysql database information
$db_pass='XXXXXXXXXX';
$db_host='localhost';
$db_name='counter';
$mysql_access = mysql_connect($db_host,$db_user,$db_pass);
mysql_query("repair table online;", $mysql_access);
?>try removing the semi-colon after the query.mysql_query("repair table online;", $mysql_access);
also you never selected the db.
mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db($db_name);