X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-chk_regs.php;h=234d0029c7fa506e0b16819f9873c748f6ea5afd;hb=22a33b87f9894a94efb71de7630f12129e34f83b;hp=db2c6657df0343676f230ef73fd54de4a0ed50b2;hpb=056162fe45aa0d850bb22870e1caf9595a847a9b;p=mailer.git

diff --git a/inc/modules/admin/what-chk_regs.php b/inc/modules/admin/what-chk_regs.php
index db2c6657df..234d0029c7 100644
--- a/inc/modules/admin/what-chk_regs.php
+++ b/inc/modules/admin/what-chk_regs.php
@@ -41,7 +41,10 @@ if ((!defined('__SECURITY')) || (!IS_ADMIN())) {
 ADD_DESCR ("admin", basename(__FILE__));
 
 // Check for accounts
-$result = SQL_QUERY("SELECT userid, gender, surname, family, email, REMOTE_ADDR, refid, user_hash FROM "._MYSQL_PREFIX."_user_data WHERE status='UNCONFIRMED' ORDER BY userid", __FILE__, __LINE__);
+$result = SQL_QUERY("SELECT userid, gender, surname, family, email, REMOTE_ADDR, refid, user_hash
+FROM `"._MYSQL_PREFIX."_user_data`
+WHERE status='UNCONFIRMED'
+ORDER BY userid ASC", __FILE__, __LINE__);
 
 if (SQL_NUMROWS($result) > 0) {
 	// We have some (new?) registrations!