limiting db selection?

move3rd

This script will call rows that have not been updated today.

How can I call just rows in the catagory news that have not been updated today?


$todaydate = mktime (0,0,0,date("m"),date("d"),date("Y"));

$catagory = "news"

//go to database and get item for today's date if it exists
$dep_list = "SELECT * FROM $DB_TBLName WHERE last_updated = $todaydate";
$result1 = @mysql_query($dep_list, $dep_list_b, $ALT_Connect)
or die("Couldn't execute query #1");

//set var to 'none' so we can check it later
//we'll check if no content for today's date is found in the database
$last_updated = "none";

//start of db loop
while ($row = mysql_fetch_array($result1)) {
	$last_updated = $row['$last_updated'];
	$grabbedContent = $row['content'];

//strip slashes from content
//this is important because addslashes() is used before
//saving the content in the database
$grabbedContent = stripslashes($grabbedContent);
}
//end of db loop

//if there's no content for this date/time saved in the database
//then do somthing else
If($date_updated=="none"){

Thanks

edit- Have I post in the rong place?

cahva

$dep_list = "SELECT * FROM $DB_TBLName WHERE last_updated < UNIX_TIMESTAMP(CURDATE())";

So you dont need to use PHP for the timestamp at all. That query will now grab results older than today.

Also remove the dollar sign from $row['$last_updated']. It should be $row['last_updated'];

move3rd

Originally posted by cahva
$dep_list = "SELECT * FROM $DB_TBLName WHERE last_updated < UNIX_TIMESTAMP(CURDATE())";
So you dont need to use PHP for the timestamp at all. That query will now grab results older than today.

Also remove the dollar sign from $row['$last_updated']. It should be $row['last_updated']; [/B]

Thanks

How do I:

select drom db where catagory = news and last_updated < UNIX_TIMESTAMP(CURDATE())";

cahva

Almost right. Just add simplequotes around the news and it will work:

$dep_list = "select drom $DB_TBLName where catagory = 'news' AND last_updated < UNIX_TIMESTAMP(CURDATE())";

move3rd

Thanks 🆒

I’ve been trying to figure that out all day = exceptionally slow learner! 🙁

Can you at more more?

$dep_list = "select from $DB_TBLName where catagory = 'news' AND title = '$mytitle' AND last_updated < UNIX_TIMESTAMP(CURDATE())";

laserlight

$dep_list = "SELECT * FROM `{$DB_TBLName}`
	WHERE `catagory` = 'news' AND `title` = '{$mytitle}' AND `last_updated` < UNIX_TIMESTAMP(CURDATE())";

Using the braces to enclose the variables (when the string is delimited by double quotes) helps avoid the slowdown due to the variable interpolation.

Using the backticks around column and table names ensure that even if reserved words are used, they will not be a problem.