Jump to content

hvle

Members
  • Posts

    667
  • Joined

  • Last visited

Contact Methods

  • MSN
    hvle75
  • Yahoo
    hvle75

Profile Information

  • Gender
    Not Telling
  • Location
    melbourne, Australia

hvle's Achievements

Member

Member (2/5)

0

Reputation

  1. select t1.idn as matchId,t1.homeTeamId,t1.awayTeamid,t2.teamName as homeTeamName, t3.teamName as awayTeamName from `game` t1 join `team` t2 on t1.homeTeamId=t2.teamId join `team` t3 on t1.awayTeamId=t3.teamId
  2. hi guys, couldn't think of a single query that do this: table 'team' teamID teamName 1 Sharks 2 Red Wings table 'game' gameId homeTeamId awayTeamId 100 1 2 I want a query that return 1 row like this matchId homeTeamId awayTeamId homeTeamName awayTeamName 100 1 2 Sharks Red Wings Any idea?
  3. forget about the indexes notice (they're just notice to help debugging, not error). What do you have in /var/www/html/FatalIndustries/database.php on line 50 ?
  4. Screw Windows, even if you get it to work, it can't be trusted. Here's an alternative: Installl VMWare + Linux Virtual Machine + configure some NAT. You'll have a perfectly good Linux to host the website on, plus it would be most secured.
  5. thanks ratcateme, I figure so, gotta use third party library. customer satisfaction is a pain the a$$
  6. I don't think it is possible but I post here anyway. Who know there are many brilliant mind out there. Thanks
  7. Thanks, I will definitely take a look at sajax
  8. Ajax: will not solve this Some experience I like to share: This is the output buffering in PHP, as btherl pointed out. I wouldn't want to change the good ini settings to get this work. If that's not the case, you can follow btherl instruction. I found that using ob_flush() and flush() can be somewhat help, although not ideally solve my problem.
  9. Hi guys, I have a script running on linux. This script spit out text (stdout) as it run. I want this text to pass directly to browser. I used passthru command to execute the script but browser will wait until this php script finished then display all the output at once. Is there a way to achieve this? thanks
  10. it sould be $_POST["$value"] or $_POST[$value] both above cases would not generate error but it would not return the result you wanted.
  11. Yes, it is possible. You need to make sure the user account that owned by the webserver have access to this folder and open this file like you open a file on the local machine.
  12. Thanks Luca, your answer are as good as any others. I am asking for a book to learn the quick and easy way, but the fact is there is no quick and easy way get to expert. I gotta work on it everyday like you did. Good thing is we have this forum to share our experience. Again, thank for a excellent solution and advice. Huy
  13. mysql_affected_rows([$database_link]) ; I think it won't work correctly because you passed in $Result, which is not a database link. try $updateCounter = mysql_affected_rows($Connection); or maybe just $updateCounter = mysql_affected_rows();
  14. You're definitely right. Thanks
  15. yes, the table filled 600K of records already after 2 weeks. It may look like a lot, but each record is only a few integers, with no text so it's pretty fast. It will eventually overflow after about 4 billions records which is approx 20 years. I intended to keep a 3 years history.
×
×
  • 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.