Jump to content

Arenium

Staff Alumni
  • Posts

    111
  • Joined

  • Last visited

    Never

About Arenium

  • Birthday 06/23/1989

Contact Methods

  • AIM
    martinman689

Profile Information

  • Gender
    Not Telling
  • Location
    Massachusetts

Arenium's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Using PHP? What do you mean? I use Crystal Reports Developer (XI) at work, and typically you just connect to your datasource through an ODBC or ADO type of DSN. PHP plays absolutely no role whatsoever in this process.
  2. When it comes to "controlling" the web crawlers, the closest you can get is to use robots.txt to pass information and parameters on to the spiders. Google for it. (Hah, irony)
  3. My favorite intro to JOINs: [a href=\"http://hashmysql.org/index.php?title=Introduction_to_Joins\" target=\"_blank\"]Intro[/a]; [a href=\"http://hashmysql.org/index.php?title=More_Advanced_Joins\" target=\"_blank\"]More Advanced[/a]. With a little bit of knowledge you can certainly accomplish this join entirely on your own. And since this is a learning exercise, that is the idea, no?
  4. Apparently you're not the first person to have this dilemma: [a href=\"http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html\" target=\"_blank\"]See here[/a].
  5. See the MySQL Data Retrieval section of the PHPFreaks FAQ linked in my signature.
  6. I don't mean to one-up anybody, but the general method for accomplishing this is through the use of the two functions date and strtotime: $date = "2004-06-23"; // Whatever you pull from your database echo date('M d, Y', strtotime($date)); // Should output "Jun 23, 2004"
  7. Arenium

    Queries

    It'd be far easier on the server to do it the way you suggest. Once the new entry has been added to the database, initiate another script that basically generates a static HTML page from whatever queries you would normally run to display the entries to the user. There even exists a tutorial on this site for the same purpose. If you feel like searching, it's there, but you seem to have a grasp of the concept--go for it.
  8. You've opened a can of worms. It's official! Enjoy the following thread and all the links within it. [a href=\"http://www.phpfreaks.com/forums/index.php?showtopic=63832\" target=\"_blank\"]http://www.phpfreaks.com/forums/index.php?showtopic=63832[/a]
  9. You're using phpMyAdmin, it couldn't get simpler. Just click on the "Export" button after choosing a table, select your options, and there you go. Just execute the SQL file on your target server.
  10. It should be: [!--PHP-Head--][div class=\'phptop\']PHP[/div][div class=\'phpmain\'][!--PHP-EHead--] \"INSERT INTO woodcutting( tree, exp ) VALUES( \'$tree\', \'$exp\')\"; [/span][!--PHP-Foot--][/div][!--PHP-EFoot--] Also, why is your exp field a VARCHAR type? Shouldn't you just use INT? Thirdly, I'll bet it takes a lot more time to work out this script than just manually enter the data either with phpMyAdmin or the MySQL command prompt.
  11. No it doesn't. INSERT should never overwrite (UPDATE) or replace (REPLACE) any records in your table. Even so, it's in your best interest to create a unique id field. It will probably come in handy later on when dealing with intertable relations, and it's good bookkeeping practice anyways.
  12. I'll take whatever my future roommate has Though I suppose if I had to choose, I'd go Sony, just because they've been consistently excellent in terms of game quality, and that's what matters. I couldn't care less about all the "extra" features. I think the marketing team got it wrong; should be "extraneous". There already are devices that can play music and watch TV and record TV on and manage your digital photos and videos on: It's called a computer. Consoles should exist solely for the purpose of group entertainment.
  13. I'm pretty sure most of the mods know my name, but for the other 23,700 members that don't, it's Kevin. And for those who don't know my age, it's not more than one click away from this page
  14. While I'm normally against the standard piece of PHP literature. this new book seems like a must-read for the advanced crowd.
×
×
  • 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.