SQL Help

[gokalpfirat]

database = mysql_connect( "localhost", "root", "ankara", "test1" ) -- connectDB 
if database then 
    outputDebugString ('Connect') 
else 
    outputDebugString ("Trouble") 
end 
result = mysql_query(database, "SELECT first_name, age, gender, @curRank := @curRank + 1 AS rank FROM person p, (SELECT @curRank := 0) r ORDER BY  age; ") -- Execute the query 
  
if result then 
    outputDebugString ('True') 
else 
    outputDebugString ("False") 
end 

It always says True at debugscipt but when I look at mysql table it wont happens. (Note: When I execute this at phpmyadmin it works. But when i execute it at mta it wont.)

[scratcher911]

I don't understand what you mean. SELECT means you can only get data not insert or something like this. It won't change anything in phpmyadmin.

[gokalpfirat]

The (SELECT @curRank := 0) part allows the variable initialization without requiring a separate SET command.