see this, i have modified your code.. it is working fine now... and i have write some more piece of code where they have needed to come out from errors..
hello see this example will help you: t1 table having 4 columns like year,month,day,points... year month day points 2000 01 01 1 2000 01 20 3 2000 01 02 5 2000 02 23 10
then here im calculting total point per month... here is the query:
SELECT year,
MONTH , sum( points ) AS points
FROM t1
GROUP BY year,
MONTH
it will print: year month points 2000 01 8 2000 02 15
hello vssp... there is a function called SUM in mysql to calculate total of any numerical column...and if you want to calculate per month,then use limit by 30 days...or created_date < last day of month... see this link for your reference: http://www.tizag.com/mysqlTutorial/mysqlsum.php
It really depends on what you are trying to do, and versus what. MySQL versus Access? MySQL versus Oracle? MySQL versus DB2? MySQL versus a spreadsheet? MySQL is good for web apps, integrates nicely with PHP, and as its community server is free
There are really no disadvantages to using a database. I use a MySQL database and PHP to interpret the information. The advantages of a database are numerous.
1. You can keep a LOT of information strored for your website in a database and have it accessed as needed. For instance, someone can search your database for a certain item, name, etc.
2. You can store actual HTML pages in the database so instead of making 10 html pages, you create one PHP page and pull the data needed pertaining to the users criteria.
3. You can not only store information, but sort it as well. For instance, get information for a certain state or person only.
The best way to describe a database is its like a telephone book. The book is the database, the whitepages are a table and the listings are rows in the table. So, you would have a column for lastname, first name, address, city, state, zip, etc. Then each persons information is added to the table row. Then, if someone wants listings for Jones, the PHP pulls the last names that match Jones and all the information associated with it. Or just the letter L and so on.
The phone book is just an example and it can apply to just about anything. A clothing store, cd collection, etc.
In conclusion, its an awesome web tool for any site and its well worth looking into. I would suggest using …
i think it is difficult to remeber ordered details for somany days using sessions... i mean: we can use sessions to store our order details temporarily ..means we can use sessions instead of inserting them into temporders table... i think it is difficult to use sessions to store whole ordered details for so many days....
Finally what i wan to tell is: we can use sessions upto add an item to cart,,then next it is difficult....
By HTML and CSS you can design a good web site ... i think these are essential an enough... but for your logos and some buttons ,you have to know the photoshop...And need flash to show aour site little bit better...but it takes time to load...
echo $s="SELECT * FROM test_table";
$sql = mysql_query($s);exit;
then see what echoed in your page...and execute that query in your database...then we will get what the error.. other wise go for another option... reply with what happened...
1.any space is there before the session_start(); function..Means it sholu be the first line of your application... 2.dont use session_start(); as twice (in your main application and in your included application)
DELETE tablename
FROM tablename,
(SELECT MAX(uid) AS dupid,COUNT(uid) AS dupcnt
FROM tablename
GROUP BY id,url HAVING dupcnt>1)
AS dups
WHERE tablename.uid=dups.dupid;
Here is an example:
uid id url
1 20 google.com
2 25 yahoo.com
3 20 google.com
4 25 yahoo.com
5 20 google.com
The above query would delete uid 4 and 5 on the first run and ui 3 on the second run.
hey you have to make some design with text boxes for entering user data..and insert them in a data base table...and then provide login to them by checking database values...using mysql queries...
