Jump to content


  • Posts

  • Joined

  • Last visited


Everything posted by dreamwest

  1. 1. banjo kazooie!! its a classic 2. shadowman and on snes the almighty terranigma
  2. Is this funny or am i just a sick little boy? http://www.youtube.com/watch?v=kxZRKr7fVkg I find it quite hilarious!
  3. An rss feed is an API, its really that simple - you can make it any type of application http://site.com/example.php: (on your site) <?php $go = $_GET['q']; echo $go; ?> On the developers site echo file_get_contents('http://site.com/example.php?q=funny'); Which will output "funny" on the developers site Thats all an API is
  4. Dont have any of them. If you want to make a search engine start with this crawler, it can index 1000's of urls in seconds http://www.wizecho.com/nav=scripts&s=spider
  5. url: varchar 255 id: bigint 11 desc: text meta: varchar 255 scan: tinyint 1 , default 0 (0 for url not in database already, 1 for it being there) index the desc and meta fields otherwise make desc fulltext and have a search engine type results based on how many times the keyword is in the description (content)
  6. Dont store any files on your server or youll get nicked, just index them and point your mp3 player to the file. Findtail has the same structure http://www.findtail.com/type=MP3
  7. you should still GROUP BY when selecting distinct eg: SELECT DISTINCT * FROM `table` WHERE `title`='funny' GROUP BY `title`
  8. It just means your csv dosnt have a value for that field your inserting. Itll be one of your blank fields thats causing the problem. You should "As defined" your field default and give it some default value.
  9. In phpmyadmin select "structure" then look for the "T" hover over it and it will say "fulltext"
  10. Have you made title and tag fields fulltext? Also im not sure if you can match 2 fields try OR instead $query="SELECT * FROM `tutorials` WHERE MATCH `title` AGAINST ('{$searchform}') OR MATCH `tags` AGAINST('{$searchform}') ";
  11. just a guess, but itll remove all whitespace in a string making it into 1 line of code
  12. strip($text, $replace = ' ') { return preg_replace('!\s+!', $replace, $text); }
  13. http://www.wizecho.com/nav=scripts&s=ajax_form
  14. <?php //select query //assign data $check = $row['check']; ?> <input type='checkbox' name='fin' <?php if($check == 1){echo 'checked';}?> > Checkbox
  15. I hate sims - it makes one scream out for a real life!
  16. In 2000 - 2002 "A current affair" showed a fat software developer who had stuck it rich creating some kind of software in Australia, all i can remember is that the reporter asked him if he would like to say anything to the world and he said "Look girls - im here", he also had 7 or so employees at the time. Did anyone else see this or know what he might have developed??
  17. At the top of your php script - once the capatcha has been confirmed then you can process the form
  18. Smarty! All the cool programmers use it Otherwise just include it in php <?php include('header.php'); //other stuff ?>
  19. Just think about all the fun your missing out on by learning another language. AND Calling functions with a simple deliminator {$smarty|function}......it sends chills down my spine
  20. PHP: $title = 'test'; //variable example $arr[] = array('id' => 10, 'title' => $title); $smarty->assign( 'arr', $arr); TEMPLATE: {section name=i loop=$arr} {$arr[i].id}<br> {$arr[i].title}<br> etc.... {/section}
  21. Yea, I got that, thank you!! I am just curious on why he thinks the other way is faster and it'snot finding like it's finding the exact which i don't need in the first place,lol How old are you? 12yo? SELECT * FROM `table` WHERE `row` LIKE '%Silvin%' OR `row` LIKE '%wts%' and SELECT * FROM `table` WHERE MATCH `row` AGAINST( 'Silvin wts') Will produce the same result....except MATCH doesnt have to scan the database to find a like and it IS faster BOOYA!
  22. Your funny! But enough with the comedy man.......Your kidding about which is faster right?
  23. who says it's faster? do you have proof? your nothing to me w/o proof HA! nice try - im not writing the script for you. The only proof you need is my experience with large databases
  24. You can also use MATCH `field` AGAINST('{$query}') Which is alot faster than scanning the database with `field` like '%{$query}%'
  • 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.