[Rachael]

Try changing the hyphen to an underscore, I don't think you can use hyphens in column names.
(thanks Doefler)

You need to store the result.
mysql_fetch will return 0 if there are no more rows in the result.
so use

pawn Код:

mysql_store_result(connection);
while(mysql_fetch_row_format(,variable," ",connection))
{
     //process data ( try sscanf )
}
mysql_free_result(connection);