odbc_exec problem in mysql

[sharal]

hi forum
i was working with odbc and used odbc_exec(). but when i used this in mysql this is not working i also used mysql_query() but this is not working too
here is the code

$id;
$sr;
$cs='fa';
$q2="SELECT MAX(ser) AS mxid FROM (SELECT * FROM Table1 AS T2 where subject='".$cs. "')";
if(!($result = mysql_query($q2))){
echo "whoooooooooooooooooooooops";
}// or die();
else{
while(mysql_fetch_row($result)){
$sr=mysql_result($result, "mxid");
echo "MAX IS ".$sr; 
}

[kireol]

you need to connect and select a DB with the above method

$conn = mysql_connect("localhost","username","password");
      mysql_select_db("database",$conn);

[sharal]

$conn = mysql_connect("localhost","username","password"); mysql_select_db("database",$conn); i have used that but problem is in query

[kireol]

what is "not working" then. please supply error codes.

[sharal]

There is no error message but whoooooooooooooooops

[kireol]

there is an error message. You are ignoring it.

The problem is your SQL

$q2="SELECT MAX(ser) AS mxid FROM (SELECT * FROM Table1 where subject='".$cs. "')  AS T2";

this is your solution

[sharal]

Oh thanxxx its working