Does anyone see anything wrong with this query? Do I have one of the >, =
or < mixed up? The purpose is to figure out if it is within 14 days of
Christmas AND if there is content for Christmas available. 2 is symbolic
in the database being Christmas. Ron
IF( CURDATE( ) >= DATE_SUB( DATE(2009-
The query from my previous post was only part of a larger query. This is
the entire query:
SELECT GREATEST( IF( CURDATE( ) >= DATE_SUB( DATE( FROM_UNIXTIME(
1239508800 ) ) , INTERVAL LEAST( 14, (
SELECT COUNT( * )
FROM `verse_of_the_day_Bible_verses`
WHERE seasonal_use =1 ) )
DAY )
AND CURDATE(
Hi I am new to this list.
I am in need of some help or direction.
I am new to php and databases, so forgive me if my request seems too
simple.
I am making a database if users and have had much success in getting
it to work however, not all my data is getting shown once I try to
display res
I don't quite understand what your problem is but it looks as if some fields
of the records that show up in phpMySql are empty and that the result page
that you have built does not show them. If that is the case, is there a
where clasue that causes them to not return?
Can you run the query that is
HI,
Thanks for your response. Here is my query. UserID is auto incrament
and UserLastLogin is a current_timestamp.
$query_users = "INSERT INTO users(UserID, Username, UserEmail,
UserPassword, UserFirstName, UserLastName, UserCompany, UserAddress,
UserAddress2, UserCity, UserState, UserCoun