Select * FROM ... WHERE DAYOFWEEK(datecol)=7
-Original Message-
From: Ben Miller [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 05, 2008 8:10 PM
To: PHP. DB Mail List
Subject: [PHP-DB] Date Translation in MySQL
I'm looking for a quick and simple way to query a MySQL database by date, or
7;
AND GROUP_CONCAT('name') like 'vegetarian'
group by taggings.id
You probably awnt a LEFT JOIN instead of a
Simcha Younger
-Original Message-
From: Catharsis [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 11, 2008 1:41 PM
To: ph
I did a little testing, and this should work better:
Select...
From...
group by taggings.id
HAVING GROUP_CONCAT('name') like 'soup'
AND GROUP_CONCAT('name') like 'vegetarian'
Simcha Younger
-Original Message-
From: Catharsis [mailto:[EMAIL
}
>
> }
>
> }
>
> The results I am getting are incomplete, it
Phone,
> > Email
> > )
> > VALUES (
> > $_POST[Class_ID],
> > $_POST[prid],
> > '%s',".
You need double-quotes here,
\"%s\",
> > parseNull($_POST['Company']).",
> > '$_POST[Phone]'
p variables.
>
>
> // I think this is where I am having issues.
>
try instead
';
?>
--
Simcha Younger
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
exit;
> }
It sounds like the password is not set in the database. What do you get if you
dump the result of your first query?
Also, you should avoid extract, it litters your code with dead and untraceable
variables. Use $array['msg_Passowrd'] instead.
--
Simcha Younger
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
