26.03.2011, 19:40
oh lol you're right (donya) didn't notice I forgot the value...
anyway lewwy your code returned the error that mysql_num_rows() was called when no querry was stored or so..
so finally I got to this:
which works well 
anyway lewwy your code returned the error that mysql_num_rows() was called when no querry was stored or so..
so finally I got to this:
pawn Код:
format(query, sizeof(query), "SELECT * FROM `Houses`");
mysql_query(query);
mysql_store_result();
format(query, sizeof(query), "INSERT INTO `Houses` (`id`, `Price`, `x`, `y`, `z`) VALUES (%d, %d, '%f', '%f', '%f')", (mysql_num_rows() + 1), price, x, y, z);
mysql_free_result();
mysql_query(query);