Re: How I get 0 values from query ?

[Tim Vantag]

Sorry felix. My problem isin't zero value any more.

Actually my problem is:

When I try to get table.date(s_time) value I get error:

DBD::mysql::st execute failed: Column 's_time' in field list is ambiguous at ./test.pl line 75.

table

id   s_time
1    2007-01-09 10:15:01
2    2007-01-09 15:08:15

And what I really need would be day and month, but I don't know is it possible to get that information, so now I try to take date(start_time), but It wont work:

sql_query ="SELECT table.date(s_time), name from table1,table where...