i have a script which is done, but i keep getting 2 errors on 2 pages. the errors are:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mpsites/public_html/wb/admin/list_marketing.php on line 134
&
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mpsites/public_html/wb/admin/list_marketing.php on line 145
for the 2 above errors, the following coding is found at and around that line(s) (numbered)
132) $query="select fld_marketing_id,fld_marketing_title,fld_marketing_desc,fld_sent_flg,fld_day_number from tbl_marketing_master order by fld_marketing_id";
133) $res=mysql_query($query);
134) $num_rows_marketing=mysql_num_rows($res);
135) $page_no = $_GET['page_no'];
136) $limit = 10;
137) $total=$num_rows_marketing;
138) $pager = Pager::getPagerData($total, $limit, $page_no);
139) $offset = $pager->offset;
140) $limit = $pager->limit;
141) $page_no = $pager->page_no;
142) $numPages=$pager->numPages;
143) $query="select fld_marketing_id,fld_marketing_title,fld_marketing_desc,fld_sent_flg,fld_day_number from tbl_marketing_master order by fld_marketing_id limit $offset, $limit";
144) $res_pagewise=mysql_query($query);
145) $num_rows__pagewise_marketing=mysql_num_rows($res_pagewise);
146) for($i=0;$i<$num_rows__pagewise_marketing;$i++)
147) {
Any help at all will help on theses errors. (the numbers next to the php coding is just to show what line it is, there not actaully in the coding.
Thank You in advance.
MP05
