GoFuckYourself.com - Adult Webmaster Forum - View Single Post

cooldude7 · 08-07-2011, 06:42 AM

this is the original query and it throws whole data,

$result = mysql_query("SELECT content.*, content_views.views AS views FROM content, content_views WHERE content_views.content = content.record_num AND content.approved = 2 AND content.enabled = 1 ORDER BY encoded_date");

so i want to limit the values from column record_num from say 1 to 20k.
record_num is kind of index so i can limit the output .

how do i do this ?

thanks for your time.

08-07-2011, 06:42 AM
cooldude7 Confirmed User Industry Role: Join Date: Nov 2009 Location: Heaven Posts: 4,306	mysql query, help needed, this is the original query and it throws whole data, $result = mysql_query("SELECT content., content_views.views AS views FROM content, content_views WHERE content_views.content = content.record_num AND content.approved = 2 AND content.enabled = 1 ORDER BY encoded_date"); so i want to limit the values from column record_num* from say 1 to 20k. record_num is kind of index so i can limit the output . how do i do this ? thanks for your time. Last edited by cooldude7; 08-07-2011 at 06:43 AM..