[SOLVED] query with variables

[SOLVED] query with variables

El Forum
Guest

06-11-2011, 07:00 AM

[eluser]John_Betong_002[/eluser]
Try this:

Code:
SELECT 

   id, 

   title, 

   preview, 

   SUBSTRING(‘date’, 1, 4) as year, 

   SUBSTRING(‘date’, 6, 2) as month, 

   seo_title 

FROM 

   articles 

WHERE (year =‘2011’ AND month =‘05’)

Messages In This Thread

[SOLVED] query with variables - by El Forum - 06-11-2011, 06:24 AM

[SOLVED] query with variables - by El Forum - 06-11-2011, 06:48 AM

[SOLVED] query with variables - by El Forum - 06-11-2011, 07:00 AM

[SOLVED] query with variables - by El Forum - 06-11-2011, 07:43 AM

[SOLVED] query with variables - by El Forum - 06-11-2011, 08:22 AM

[SOLVED] query with variables - by El Forum - 06-11-2011, 08:35 AM

[SOLVED] query with variables - by El Forum - 06-11-2011, 08:43 AM

[SOLVED] query with variables - by El Forum - 06-11-2011, 08:44 AM

[SOLVED] query with variables - by El Forum - 06-11-2011, 08:45 AM