Posted by My Pet Programmer on 12/24/07 16:29

paul814@excite.com said:
[snip]
>
> $today = date("M j, Y,");
> echo $today; (this displays like: Dec 24, 2007,)
>
> and then that is why my query looks like this:
> $sql = "SELECT * FROM editorial WHERE editorialdate LIKE '$today%' ";
>
> So basically select everything from editorial where the editorialdate
> field is like Dec 24, 2007,

Oh, no, don't get me wrong, I know what you're doing in the code, I'm
just curious what you're actually getting for records in the page. When
you print $txt and nothing comes out, I start to think things aren't
coming out of the DB. Try just echoing the mysql_num_rows call to the
page, see what you come up with.

print_r is a variable dumper, and the syntax is:
print_r($variable);

Doing that extracts all the info about a variable and prints to the
screen for you.

~A!

[Back to original message]