mjahkoh

Download navicat. Its query is simple to implement Try this Try this the tables are /* MySQL Data Transfer Source Host: localhost Source Database: webcrawler Target Host: localhost Target Database: webcrawler Date: 4/13/2008 1:05:55 AM */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for continents -- ---------------------------- CREATE TABLE `continents` ( `continent` varchar(100) default NULL, `continentID` int(11) NOT NULL auto_increment, PRIMARY KEY (`continentID`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; -- ---------------------------- -- Records -- ---------------------------- INSERT INTO `continents` VALUES ('Africa', '1'); INSERT INTO `continents` VALUES ('Europe', '2'); /* MySQL Data Transfer Source Host: localhost Source Database: webcrawler Target Host: localhost Target Database: webcrawler Date: 4/13/2008 1:06:03 AM */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for country -- ---------------------------- CREATE TABLE `country` ( `country` varchar(100) default NULL, `countryid` int(11) NOT NULL auto_increment, `continentID` int(11) default NULL, PRIMARY KEY (`countryid`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; -- ---------------------------- -- Records -- ---------------------------- INSERT INTO `country` VALUES ('England', '1', '2'); INSERT INTO `country` VALUES ('Spain', '2', '2'); INSERT INTO `country` VALUES ('France', '3', '2'); SELECT country.countryid, country.country FROM continents Inner Join country ON continents.continentID = country.continentID WHERE continents.continent = 'Europe'

Simple <?php $extension = strtolower(strrchr($_FILES['mypicture']['name'],".")); $randomnumber = "abc"; $newfilename = $randomnumber . '.' . $extension; ?>

I want to make such a site. What do i need (software or otherwise). Also is it a webcrawler or the seached links are in databases gatheres purposely for that. Thanks