[SOLVED] query with variables

[SOLVED] query with variables

El Forum
Guest

06-11-2011, 08:22 AM

[eluser]John_Betong_002[/eluser]
Try a variation of this which I have just ran on my localhost:

Code:
SELECT 

  id, title, xrl, SUBSTRING( date, 1, 4 ) AS year

FROM 

  jokes

WHERE 

  SUBSTRING( date, 1, 4 ) = '2011'

ORDER BY 

  date

LIMIT 

  0 , 10

 
Your main problem appears to be enclosing the date in quotes.
 

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