kai555
-
Posts
7 -
Joined
-
Last visited
Never
Everything posted by kai555
-
how to create two dropdown menu linking each other?
kai555 replied to mtvaran's topic in Javascript Help
Hi The best way to this would be to use Ajax to populate the second drop down as soon as the user selected from the first one -
php script exection on closing of browser window
kai555 replied to habib009pk's topic in Applications
Hi try <html> <head> <title>Detecting browser close in IE</title> <script type="text/javascript"> function doUnload() { alert("Window is closed."); } </script> </head> <body onunload="doUnload()"> <p> Check which action detects browser window close: <ol> <li>Click this <a href="#" onclick="location.reload();return false">Refresh</a> link or the browser's Refresh button</li> <li>Navigate away from this page through a <a href="http://www.codingforums.com/">link</a></li> <li>Type another URL in the address bar</li> <li>Click Back or Forward button</li> <li>Click the Close (X) button in the top-rightmost corner of the browser</li> <li>Click the IE icon in the top-leftmost corner and choose Close. Or simply double-click the icon</li> <li>Press Alt+F4 key</li> </ol> </p> <p>In IE, the last 3 actions are correctly detected by the <a href="#" onclick="alert(doUnload);return false">javascript code</a> inside this page as browser close.</p> </body> </html> -
Hi The great thing about joomla is that there is just about a plugin for everything. from easy form builders to community management. Joomla is also already optimized for search engines so you don't have to worry about that. But like the others said. If you want to learn, its better to create your own.
-
A problem with select and count function in the same query...
kai555 replied to avdzm's topic in MySQL Help
Hi when you use sum() you have and you select other columns you mysql doesn't know how to handle these other column with the sum eg Table test val | String 1 | test 1 | test 2 | test2 now selectting sum(val),String ..... now mysql doesn't know if you want it to return 4 or if you want it to return 2 for test and 2 for test2. So to solve this you have to group by the other columns select sum(val),String from table group by String this will give sum | String 2 | test 2 | test2 Hope this helped -
Hi. using SUM is fine but you need to do a join to the members table select sum(items.item_value) as total from items,members where members.item=itmes.item_id and members.member_owner=<place the owner you are summing for here> if you want to get a list of all owners and their totals youl need a group by select sum(items.item_value) as total,members.member_id from items,members where members.item=itmes.item_id group by members.member_id. Hope this solves your problem.
-
MySql - How do I count the Total Number of Different Enum / Set Types?
kai555 replied to BioBob's topic in MySQL Help
Hi I assume you have each type of fruit more than once in your table? I think what you are looking for is: SELECT COUNT(DISTINCT column_name) as c FROM table_name -
Hi You can use int filemtime ( string $filename ) to get when a file was last modified. It returns a unix time stamp that you can give to date() to process further. You can use opendir() to open a handle to you directory and then use readdir($handle) to cycle through all files in your folder. Hope this helped.