mysql query

[alin19]

let's say i have a database

 

 

 

jannet    january    1

jannet    january    2

                            .....

jannet    february  1

                ......

 

mary      ianuary

mary      february

 

lee          ianuary

lee          february 

 

 

 

can i make a query like this: ?

 

 

SELECT * FROM `year2008` where month=january AND day=3  LIMIT 0 , 30  ?

 

[pdkv2]

The database structure you have given is not clear enough to solve your query.

 

[Prismatic]

let's say i have a database

 

 

 

jannet    january    1

jannet    january    2

                            .....

jannet    february  1

                ......

 

mary      ianuary

mary      february

 

lee          ianuary

lee          february 

 

 

 

can i make a query like this: ?

 

 

SELECT * FROM `year2008` where month=january AND day=3  LIMIT 0 , 30  ?

 

 

Well, the query will run as long as your table "year2008' has a month, and day field.

 

The query should actually look like this

 

SELECT * FROM `year2008` where month='january' AND day=3  LIMIT 0 , 30

[alin19]

$query="SELECT data FROM `year2008` WHERE data='14-ian-08' AND 'nr.cupoane'='2'  LIMIT 0 , 30";  -doesn't work

 

 

$query="SELECT data FROM `year2008` WHERE data='14-ian-08'  LIMIT 0 , 30";- works

 

 

and i have :

 

                         

 

                          data            nr.cupoane

        Edit  Delete  8-ian-08  4 

Edit Delete 9-ian-08 8

Edit Delete 10-ian-08 12

Edit Delete 11-ian-08 2

Edit Delete 14-ian-08 2

Edit Delete 15-ian-08 3