spertuit Posted July 17, 2013 Share Posted July 17, 2013 Can anyone see why my results would return more than 20 rows? $query = "SELECT * FROM mailer "; $limit = "ORDER BY id LIMIT 20 "; $result = mysql_query($query.$limit); if (!$result) { $message = 'Invalid query: ' . mysql_error() . "\n"; $message .= 'Whole query: ' . $query; die($message); } $address = 0; while ($row = mysql_fetch_assoc($result)) { $id=$row["id"]; $email=$row["email"]; $companyID=$row["companyID"]; } Quote Link to comment https://forums.phpfreaks.com/topic/280249-mysql-limit/ Share on other sites More sharing options...
Solution spertuit Posted July 17, 2013 Author Solution Share Posted July 17, 2013 Nevermind, the problem was in the second part of my script. This seems fine. Quote Link to comment https://forums.phpfreaks.com/topic/280249-mysql-limit/#findComment-1441108 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.