User Profile

1harsh789 · Nov 30 '06, 06:32 PM

I think the best method can be as follow.

Before inserting the new row, you must match the last inserted row with the current day. And if it is changing reset the counter back to 1.

Algorithm can be something like

Code:

SELECT day,counter FROM last inserted row
if (cur_day==1 AND cur_day<>day)
  new_counter = 1
else
  new_counter=counter+1

1harsh789 · Nov 30 '06, 06:12 PM

you need to change your query as follows:

[PHP]mysql_query ("INSERT INTO categories (CategoryName)
VALUES
('".$_POST[CategoryName]."')");[/PHP]

1harsh789 · Oct 6 '06, 04:43 PM

header(Content-type:text/xml; charset='.get_s ettings('blog_c harset')', true);

must be
header('Content-type:text/xml; charset='.get_s ettings('blog_c harset'), true);

1harsh789 · Oct 6 '06, 02:49 PM

SELECT a.loan_serial, a.customer_id, SUM(amount) AS total_amount
FROM LOANS AS a, STATEMENT AS b
WHERE a.customer_id = b.customer_id
GROUP BY a.loan_serial, a.customer_id

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

What is ODBC Query timeout error

Leave a comment: