Welcome Guest, Not a member yet? Register   Sign In
Unixtime stamp
#4

[eluser]xwero[/eluser]
What if you do
Code:
$sql="SELECT * FROM threads WHERE 'dsd_title'=\"".$dddd[$i]['url_title']."\" AND 'posted_date'= max('posted_date')";

Edit : ok above code results in an error which i could have known.
But if you first do a query for the highest date and then add that value to the actual query. If you have a database that supports subqueries you can do it in one query.


Messages In This Thread
Unixtime stamp - by El Forum - 09-23-2008, 04:04 AM
Unixtime stamp - by El Forum - 09-23-2008, 04:24 AM
Unixtime stamp - by El Forum - 09-23-2008, 05:07 AM
Unixtime stamp - by El Forum - 09-23-2008, 05:25 AM
Unixtime stamp - by El Forum - 09-23-2008, 05:27 AM
Unixtime stamp - by El Forum - 09-23-2008, 05:36 AM
Unixtime stamp - by El Forum - 09-23-2008, 05:41 AM
Unixtime stamp - by El Forum - 09-23-2008, 06:15 AM



Theme © iAndrew 2016 - Forum software by © MyBB