написал так -
" SELECT * FROM tbl_cars WHERE `dealer_id`=\'$dealer_id\' ORDER BY RAND (`id`) "
пишет
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'(`id`)\' at line 1