no hair left need help asap

nakkaya

here is the script i have been trying to execute on my machine as a shell script

#!/usr/bin/php -q
<?php

$id_connect = mysql_connect ("ip","username","pass");
$database = "database";
mysql_select_db($database,$id_connect);

$sql = "SELECT ip FROM stats" ;
$results = mysql_query($sql,$id_connect);
$total = mysql_num_rows ( $results );

$sql = "SELECT ip FROM stats WHERE browser LIKE ('%MSIE%')" ;
$results = mysql_query($sql,$id_connect);
$ms = mysql_num_rows ( $results );

$sql = "SELECT ip FROM stats WHERE browser LIKE ('%netscape%')" ;
$results = mysql_query($sql,$id_connect);
$netscape = mysql_num_rows ( $results );

$sql = "SELECT ip FROM stats WHERE browser LIKE ('%mozilla%')" ;
$results = mysql_query($sql,$id_connect);
$mozilla = mysql_num_rows ( $results );

$sql = "SELECT ip FROM stats WHERE browser LIKE ('%opera%')" ;
$results = mysql_query($sql,$id_connect);
$opera = mysql_num_rows ( $results );

$sql = "SELECT ip FROM stats WHERE browser LIKE ('%WIN%')" ;
$results = mysql_query($sql,$id_connect);
$windows = mysql_num_rows ( $results );

$sql = "SELECT ip FROM stats WHERE browser LIKE ('%linux%')" ;
$results = mysql_query($sql,$id_connect);
$linux = mysql_num_rows ( $results );

print "$total";
print "$windows";
print "$linux";
print "$ms";
print $netscape;
print $mozilla;
print $opera;

?>

cgraz

look at the error message

Warning: Access denied for user: 'username@adsl-34-160-54.hsv.bellsouth.net

the parameters you're using in this line

$id_connect = mysql_connect ("ip","username","pass");

are incorrect.

I'm not sure if you're allowed a hostname in the server location (you can use an ip however). Check all your info and try again. Your username and password could be a problem also.

Cgraz

ultraslacker

$sql = "SELECT ip FROM stats" ; 
 $results = mysql_query($sql,$id_connect); 
 $total = mysql_num_rows ( $results ); 


 $sql = "SELECT ip FROM stats WHERE browser LIKE ('%MSIE%')" ; 
 $results = mysql_query($sql,$id_connect); 
 $ms = mysql_num_rows ( $results ); 

 $sql = "SELECT ip FROM stats WHERE browser LIKE ('%netscape%')" ; 
 $results = mysql_query($sql,$id_connect); 
 $netscape = mysql_num_rows ( $results ); 

 $sql = "SELECT ip FROM stats WHERE browser LIKE ('%mozilla%')" ; 
 $results = mysql_query($sql,$id_connect); 
 $mozilla = mysql_num_rows ( $results ); 

 $sql = "SELECT ip FROM stats WHERE browser LIKE ('%opera%')" ; 
 $results = mysql_query($sql,$id_connect); 
 $opera = mysql_num_rows ( $results ); 


 $sql = "SELECT ip FROM stats WHERE browser LIKE ('%WIN%')" ; 
 $results = mysql_query($sql,$id_connect); 
 $windows = mysql_num_rows ( $results ); 

 $sql = "SELECT ip FROM stats WHERE browser LIKE ('%linux%')" ; 
 $results = mysql_query($sql,$id_connect); 
 $linux = mysql_num_rows ( $results );

Egads man...

Surely you can trim this down...

SELECT COUNT(*) FROM stats GROUP BY BROWSER

[deleted]

"Egads man...

Surely you can trim this down...

SELECT COUNT(*) FROM stats GROUP BY BROWSER"

But that would give a count for every browser type and version, which is different from what he's doing.

He should use the count(*) though!

nakkaya

i am using the same username and pass on the scripts which are on the server and works fine but i can not connect machine thorug my computer

ultraslacker

You have to add permissons for the host you are connecting from -

http://www.mysql.com/doc/en/GRANT.html

nakkaya

when i talked to the tech support they told me i can connect from my local computer