[vivabensmith]

HTML Code:

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 ''newspage' WHERE (TO_DAYS(NOW()) - TO_DAYS('date_entered')) > 10)' at line 1

Hi all im getting the above error message from the code below? Im I missing anything as im new to date selecting in mysql?

PHP Code:

$query = "SELECT * FROM 'newspage' WHERE (TO_DAYS(NOW()) - TO_DAYS('date_entered')) > 10)"; 

[Nico]

Remove the single quotes around the table name.

[vivabensmith]

Thanks Nico!

date_entered

2007-09-25 21:47:49
2007-09-13 19:34:30
2007-09-13 19:29:48
2007-09-25 21:46:31

Im trying to select items from 'newspage' from the last 30 days, this should display all the above records?

$query = "SELECT * FROM newspage WHERE (TO_DAYS(NOW()) - TO_DAYS('date_entered') > 30)";

But its not?

PHP Code:

<?php 

// function

function trunc($phrase, $max_words) 

{ 

   $phrase_array = explode(' ',$phrase); 

   if(count($phrase_array) > $max_words && $max_words > 0) 

      $phrase = implode(' ',array_slice($phrase_array, 0, $max_words)).'...';

   return $phrase; 

}

// function







$page_title = 'viewnews'; 

        require_once ('../mysql_connect.php'); // Connect to the db. 

 



$imagesize='height="50" width="50"';



$alignright='right';

 

$query = "SELECT * FROM newspage WHERE (TO_DAYS(NOW()) - TO_DAYS('date_entered') > 30)";

if ($result = @mysql_query ($query))

{

    $num = mysql_num_rows($result);

}

else

{

    echo mysql_error();

}

      

      

       



    if ($num > 0) { // If num     

           

    while ($myrow = mysql_fetch_array($result, MYSQL_ASSOC)) { //While



    $newsText=(htmlspecialchars(strip_tags($myrow['news'])));

    $firstImage='uploads/'.$myrow['file1'].'';

    

               

      if(!empty($myrow['file1'])){ // ok an image exists

             if(file_exists($firstImage)){ // ok image exists in the folder as well so display

         echo '<p class="bold" align="left">' .$myrow['heading'] .'</p><p align="left"><img ' . $imagesize .' src="uploads/'.$myrow['file1'] .'" align="'.$alignright .'"/>'. trunc($myrow['news'],10).'</p>';

         echo'<a href="#top">full details</a>';

            echo '<br />  ';

            echo'<hr />';

        }

     } else {

      echo'<p class="bold" align="left">' .$myrow['heading'] .'</p><p align="left">'. trunc($myrow['news'],10).'</p>';

      echo'<a href="#top">full details</a>';

         echo '<br />  ';

         echo'<hr />';

     }

         

         

   } //End of if num

  } //End of while



    

    else { /// if db not run display error 

    echo '<table align="center" cellspacing="0" cellpadding="5">';

    echo'<td><span class = "style1">Sorry, no records found!</span></td>';

    echo '</table>';

    

    

} 



?>