----- Original Message -----
From: "Bas van Rooijen" <[EMAIL PROTECTED]>
To: "Adam Baratz" <[EMAIL PROTECTED]>
Sent: Saturday, January 05, 2002 4:39 PM
Subject: Re: [PHP] MySQL error... but it works!!??
>
> maybe try:
>
> if (!$result)
> {
> echo(mysql_error());
> }
>
> bvr.
> On Sat, 5 Jan 2002 15:55:39 -0500, Adam Baratz wrote:
>
> >> Does anyone have any idea why this is giving me a "Warning: Supplied
> >> argument is not a valid MySQL result resource in..." error?
> >
> >You'll have to give more code, which line you get that error from, etc.,
to
> >give us a better idea why it's "not working."
> >
> >However, a quick tip:
> >
> >> $crdate = date("Y-m-d");
> >> $result = mysql_query("SELECT * FROM sites WHERE creation_date =
'$crdate'
> >> AND status = 'T'");
> >
> >These two lines can be condensed since MySQL has a built-in function to
get
> >the current time/date:
> >
> >SELECT * FROM sites WHERE creation_date = NOW() AND status = 'T'
> >
> >-Adam
> >
> >
> >--
> >PHP General Mailing List (http://www.php.net/)
> >To unsubscribe, e-mail: [EMAIL PROTECTED]
> >For additional commands, e-mail: [EMAIL PROTECTED]
> >To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> >
>
>
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
