Fw: [PHP] MySQL error... but it works!!??

----- Original Message ----- From: "Bas van Rooijen" <bvr@xs4all.nl> To: "Adam Baratz" <Adam_Baratz@msn.com> 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: php-general-unsubscribe@lists.php.net > >For additional commands, e-mail: php-general-help@lists.php.net > >To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > > >