if ( q && mysql_num_rows( q ) > 0 )

THANKXXXXXXX
worked :}
(Why didn,t i think of that >.<)

thankx for the mysql sockets
one question how can we use mysql_fetch_assoc which stores all the data in arrays so very useful if used with loops in php
but in squirrel i don,t understand the arguments.According to your post
mysql_fetch_assoc( mysql_connect(szServer,szUser,szPass,szDatabase) );
but in php it is
mysql_fetch_assoc( mysql_query( SELECT 'blah' FROM 'blah' (etc) ) );
so can u please tell me the correct arguments to use SELECT function as sqlite had GetSQLColumnData(querysql(query) ); to get SELECT query
i will show u some of my codes that i used in php 
<?php
$db = mysql_connect('localhost','root','mypass');
$mydb = mysql_select_db('sk');
function getip($name){
$sql = "SELECT * FROM testaccount where name = '$name'";
$row = mysql_fetch_assoc( mysql_query($sql) );
$ip = $row['IP'];
return $ip;
}
echo $getip = getip('sk');

?>this above code works good for php page but now check it out for squirrel
function onScriptLoad()
{
    stats <- array( GetMaxPlayers(), null );
db <- mysql_connect("localhost","root","mypass","Sk");
}
function getip(player){
local sql = "SELECT * FROM 'testaccount' where 'Name' = '"+player.Name+"'";
local row = mysql_fetch_assoc( mysql_query(db,sql) );
local ip =  row["IP"];
return ip;
}
function onPlayerCommand( player , cmd , text){
if ( cmd == "myip"){
local myip = getip(player);
MessagePlayer("Your last used ip was : " + myip,player);
}
Note = 'mypass' is not my original pass.
not its just a test server so i m just testing to use select query fucntion in squirrel which i m not able to do successfully >.<.
so ysc123 can u please tell me any alternative way to do it? or just fix the code that i provided..

i wanted to use mysql database managed by phpmyadmin on my server.After connecting mysql plugin i used
OnScriptLoad(){
some of my own shity functions and then
mysql_connect("localhost","root","Sk",NULL);
}
so
localhost = my Server
root = my username(on sercver)
Sk = my database
NULL = password which in this case is not present
but after loading the executable file it says invalid argument.
this mysql_connect(); function is taken from php i don,t know how can i connect MySQL database i know that function mysql_connect works but i don,t know the exact arguments of this functions in squirrel so can any one can please tell me the how can i use this function in my 0.4 server.
Note = i m just testing my server in localhost (xampp).
so can any one tell me how can i connect my[ ] MySQL database in my server.