Display rows

PHP
1

[FONT=“Tahoma”]hello

i have table like this i want to display rows with new dates
in this example want to display two rows with dates (2010)

id|name
-±---------
1|1-1-2009
2|4-5-2009
1|1-5-2010
2|3-4-2010

any help?:shifty:[/FONT]

2

HI this is just simple select query sir , as if you put into your table “Date” and shoot a query like this
"SELECT * FROM TABLE NAME " this will retrieve your id ,name , and date in that format , try this .

3

or SELECT * FROM TABLE WHERE name LIKE ‘%2010%’