view certain data..

[waniey]

i have alarm table, in alarm tbl have attribute date,consumer and description. i want to display all the data but the description, i want to calculate certain data. for example, in descripton have data no alarm,no flow,negatif flow, meter-under size. i want to display all the description but for meter under size, i want to calculate if there is two data in 24 hours and 10 days within a month,then the meter under size will display. How can i write the code,anyone can help me..?

[sharad_impinge]

please clarify your question.

is it the text data in Description field, on which you want to do calculation, or you want to show some part of your description depend upon time.
is description is a Text type field?

[waniey]

yes, i want to show some description depend upon time and also show all the others descriptions. Only one descriptions have the calculation, all the data (description) will be view in one table. description is a Text type field. i want to display all data but for some data, i must calculate before display. can u understand?

[sharad_impinge]

How are you with the database queries?
You need to write different queries for that, i show you basic structure for those queries.

$q1=mysql_query("Select metersize,description where date BETWEEN 'currentdate' AND '24agodate'");
$number1 = mysql_num_rows($q1);

if($number1 > =2)
{
$results = mysql_fetch_array($q);
forech($results as $result)
{
print description here
}
}

follow the same process for a month, for that just change take the date of 30days ago in the query.

if you don't get this process then give you database structure in next reply.🙂