PHP danna kauru hari udaw karannooooo!!!!

[isuru143]

Ane PHP danna kauru hari meheta enna!
Mata udawawak karanna!!

Mage Script ekaka mehema error ekak enawa!!!

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 'call from hl_news' at line 1

Kauru hari udaw karanda!!! Plzzzz

 

[Dhananjaya007]

code eka dapan machan

 

[sri_lion]

Oyage "call from hl_news" kiyana SQL eke awulak, oyage code ekama daanna balanna poddak... error eken kiyanna amarui!

 

[sri_lion]

Hmm.... shouldn't it be "SELECT FROM...."??

 

[Burampi]

code 1 ewapan balala kiyannam kollo

 

[isuru143]

<?
/***********************************************************************/
/*                                                                     */
/*  This file is created by deZender                                   */
/*                                                                     */
/*  deZender (Decoder for Zend Encoder/SafeGuard):                     */
/*    Version:      0.9.3.0                                            */
/*    Author:       qinvent.com                                        */
/*    Release on:   2005.11.12                                         */
/*                                                                     */
/***********************************************************************/


  if (($settings['news_box'] AND ($frm['a'] == '' OR $frm['a'] == 'home')))
  {
    $max_news = (0 < $settings['last_news_count'] ? $settings['last_news_count'] : 5);
    $q = '' . 'select 
                 *,
                 date_format(date, \'%b-%e-%Y %r\') as d
           from 
                 hl_news 
           where
                 (expiration = 0 || (date + interval expiration day >= current_date))
           order by 
                 date desc
           limit 
                 0, ' . $max_news;
    ($sth = mysql_query ($q) OR print mysql_error ());
    $news = array ();
    while ($row = mysql_fetch_array ($sth))
    {
      if ($row['small_text'] == '')
      {
        $row['full_text'] = strip_tags ($row['full_text']);
        $row['small_text'] = preg_replace ('/^(.{100,120})\\s.*/', '' . '$1...', $row['full_text']);
      }

      $row['small_text'] = preg_replace ('/
/', '<br>', $row['small_text']);
      array_push ($news, $row);
    }

    if (sizeof ($news) == 0)
    {
      $settings['news_box'] = 0;
      $smarty->assign ('settings', $settings);
    }
    else
    {
      $smarty->assign ('news', $news);
    }
  }
  else
  {
    $settings['news_box'] = 0;
    $smarty->assign ('settings', $settings);
  }

?>

 

[sri_lion]

Try,

$q  = "SELECT date_format(date, \'%b-%e-%Y %r\') AS d FROM hl_news WHERE (expiration = 0 || (date + interval expiration day >= current_date)) ORDER BY date DESC limit".$max_news;

If doesn't work, post the error!