Jump to content

isedeasy

Members
  • Posts

    257
  • Joined

  • Last visited

Profile Information

  • Gender
    Not Telling

isedeasy's Achievements

Member

Member (2/5)

0

Reputation

  1. Ummm OK? You really think I would post links to malicious/NSFW sites? I have 250 0dd posts and been a members here for years. The only reason I have posted tinyurl links is because I don't want this thread to show up if a search is done for my domain. Thanks for taking the time to read my thread. Regards edit - I forgot to mention in my first post that the site is HTML5 and I have not got round to IE support.
  2. Hi I have been coding a new web app and would like it bug tested. The website is:- http://tinyurl.com/d7q2hlo Here is confirmation that I own the site:- http://tinyurl.com/caddg2c I have created a login for phpfreaks:- username: phpfreaks password: phpfreaks Please let me know if (when) you find any bugs or if you have any improvements you think I should make. All the text on the site is a first draft, so don't bother checking for grammar/spelling mistakes as it will all be changed Regards
  3. What if it's not today's date I want to add a month to?
  4. I am trying to add 1 month to a certain date from a database, I have searched for a solution and found the following :- <?php $todayDate = date("Y-m-d"); $dateOneMonthAdded = strtotime(date("Y-m-d", strtotime($todayDate)) . "+1 month"); echo date('Y-m-d', $dateOneMonthAdded); ?> This seems like a lot of code to add 1 month to a date? The format I store the date as is:- 2012-05-24 I need to turn this date into:- 2012-06-24 Do I have to keep converting the date like above or is there a way of doing it with less code?
  5. Thank you sir, that is exactly what I was looking for!
  6. I want to have urls that look like the following:- url - www.domain.com/login/ file - /sections/login.php url - www.domain.com/contact/ file - /sections/contact.php my index file just looks for the page name in the query string and includes the appropriate file. I have the following rule that sort of works but I need something that wont lose the rest of the query string. RewriteRule ^([a-zA-Z\_]+)[/]*$ index.php?pl=$1 I need it so that www.domain.com/home/?foo=bar will send my index.php the following vars $_GET['pl']; $_GET['foo']; foo could be anything and the amount of variables that can be passed back needs to be unlimited. Any help would be much appreciated. Thanks
  7. Wow I feel dumb, never knew MySQL had an IF function Working query below SELECT o.opponent_name, COALESCE(SUM(league_points),0) AS `points`, COALESCE((SUM(league_goals_for)-SUM(league_goals_against)),0) AS `goaldifference`, SUM(IF(l.league_points = 3, 1, 0)) AS `wins`, SUM(IF(l.league_points = 1, 1, 0)) AS `losses`, SUM(IF(l.league_points = 0, 1, 0)) AS `draws`, COUNT(l.league_points) AS `played` FROM league l LEFT JOIN opponents o ON o.opponent_id = l.league_team WHERE l.league_season = {$Config['season']['current']} GROUP BY l.league_team ORDER BY points DESC
  8. Hi I have a table which holds all the results for my football teams league, the structure looks like:- CREATE TABLE `league` ( `league_date` int(11) NOT NULL, `league_comp` int(3) NOT NULL, `league_season` int(2) NOT NULL, `league_team` int(4) NOT NULL, `league_points` int(1) NOT NULL, `league_goals_for` int(2) NOT NULL, `league_goals_against` int(2) NOT NULL, `league_home` int(1) NOT NULL, `league_opponent` int(4) NOT NULL, PRIMARY KEY (`league_season`,`league_team`,`league_home`,`league_opponent`) ) ENGINE=InnoDB the information I need to get is as follows:- team name games played wins losses draws points goal difference (the info with a strike-through is not the issue) my query at the moment looks like this $DB->query("SELECT l.*, o.opponent_name, COALESCE(SUM(league_points),0) AS points, COALESCE((SUM(league_goals_for)-SUM(league_goals_against)),0) AS goaldifference FROM league l LEFT JOIN opponents o ON o.opponent_id = l.league_team WHERE l.league_season = {$Config['season']['current']} GROUP BY l.league_team ORDER BY points DESC"); I am having a problem getting the the amount of games played and the amount of each kind of result. the information is in the table because of the `league_points` column (3=win,1=draw,0=loss). Any help in finishing this query would be great, I know I could add extra columns but there must be a way of doing it with the info in the db. It's probably real simple lol
  9. isedeasy

    Wow

    We have known this for years p.s you posted this in the wrong forum, are you using IE by any chance
  10. Congratulations! That is some achievement right there! Can we see your app that won you the title?
  11. Impressive Your old (current) site has issues with navigation links appearing/disappearing depending on what page you are on. I don't like how there is no boundary between the white wrapper and the predominately white background.
  12. Make sure error reporting is on and use firebug to see what the ajax is returning.
  13. First of all you are posting the data and looking for get data in your php code. Also it looks like you are just passing the php script one string try the following:- $.ajax({ type: "POST", data: { name: name, email: email, subject: subject, textarea: textarea }, url: "./include/process_contact.php", success: function(data){ alert(data); } }); <?php $to = "noskiw@hotmail.co.uk"; // I would do some validating here $email = $_POST['email']; $subject = $_POST['subject']; $message = $_POST['textarea']; $headers = "From: {$_POST['name']}"; mail($to, $email, $subject, $message, $headers); echo "Email sent"; //or better yet some json including any error/success ?>
  14. When I tried to register I got the following:- Fatal error: Cannot redeclare geoip_load_shared_mem() (previously declared in /home/eonbux00/public_html/mucove.com/assets/includes/geoip.inc:236) in /home/eonbux00/public_html/mucove.com/assets/includes/geoip.inc on line 252 I then closed the tab
  15. I have a class that I created, halfway down my page I call a function from the class which prints some code and also changes a variable inside the class. It's a search class basically it prints out the search results and saves the total amount of results into the variable. I want to display the amount of results above the results like so:- echo $Search->results; $Search->GetResults('foo'); The problem is that $Search->results will be equal to NULL until the variable is updated in the function GetResults. Hope that makes sense, am I going about this wrong?
×
×
  • 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.