Jump to content

shivabharat

Members
  • Posts

    371
  • Joined

  • Last visited

    Never

Contact Methods

  • AIM
    shivabharat
  • MSN
    archieandrew@hotmail.com
  • ICQ
    315407114
  • Yahoo
    shivabharat

Profile Information

  • Gender
    Not Telling
  • Location
    Chennai, India

shivabharat's Achievements

Member

Member (2/5)

0

Reputation

  1. Hi, Why dont you try to use the windows installer which is simple and easy. http://in.php.net/releases/index.php
  2. Dont try it folks this is just another trick.
  3. You can set the privelage that the user will have on the database. Refer manual to set the privelage. You can also store the database that the user will be accesing along with the user name and password. You can retrive this information and make him access the database thats is specified.
  4. First thing Please DOnt double post ..... Now to your question You can use DATE_ADD function which is quiet handy select DATE_ADD(\'2004-01-11\',INTERVAL 7 DAY) We know a week has 7 days The above query will add 7 days to the given date The result of the above query would be 2004-01-18 Now you have to save the result and add till the date difference is ZERO SELECT (TO_DAYS(\'2004-04-17\')-TO_DAYS(\'2004-01-11\')) This query will give the date difference which is 97 So you need to maintain a variable which would also subtract \"7\" from this total and also add to the date. So when the result is ZERO it means that you have finished. I hope I am clear
  5. I am not quite clear with your 1st question 1. select (absentdays + presntdays) as total from students Now in the above query absentdays and presentdays are two fields in my table and I add them using the query. So my code will be like this while ($row = mysql_fetch_array($sql)) { echo $row[\'total\']; } The trick is I am using total as an alias name to the two colums that are added. I hope I am clear. 2. You can use the round fucntion in PHP to do this $a = round(1.967,2) Will return 1.97
  6. Try this http://www.hotscripts.com/Detailed/25779.html
  7. Have a look at this http://www.mysql.com/doc/en/Backup.html
  8. This code will delete the entries which belongs to \"123.123.com\" delete from <table-name> where remotehost=\'123.123.com\'
  9. Never mix $_SESSION and session_register() http://www.phpfreaks.com/forums/viewtopic.php?t=10842 See this link http://www.phpfreaks.com/forums/viewtopic.php?t=7632 Also there are lot of posting available about sessions have a look at them.
  10. Whats price ? here you should have used $price in your query if its being collect from another form. also when collecting values from a form you need to use the $_POST or $_GET. Enusre that you are collecting the value.
  11. Try it this way SELECT SUM(val) as xx from mydata You shouldn\'t use the quotes.
  12. I havent quite understood what you well. But you sound like using a GROUP CLAUSE in mysql . Check manual for more details. http://www.phpfreaks.com/mysqlmanual.php her is an example select fdate,SUM(goals) from <table_name> group by fdate Thsi query will display the date and the total. Dates that are same are grouped as one and only one entry is shown.
  13. Have a look at this http://www.phpfreaks.com/forums/viewtopic....1971&highlight= Next time before you post we recommend you to use the search. Thanks!
  14. Try this To see the commands list
  15. Oops!! You are right I mistook the shell as mysql prompt . Thanks for your input.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.