Although Yahoo is used as search engine much less than Google, it should not be omitted. Unlike the Google sitemap, where we created xml file, in this case we create a simple text file with list of all indexed-to-be URLs. (This file could be used instead of the regular Google sitemap but NOT recommended).

Now, open your favorite text editor and paste the bolded code bellow:

<?

// Connecting, selecting database
$link = mysql_connect(’localhost’, ‘db_username’, ‘db_pass’)
//db_username is the database username; db_pass is the database password
or die(’Could not connect: ‘ . mysql_error());
mysql_select_db(’data_base_name’) or die(’Could not select database’);
//data_base_name is the DB you connect to

// Performing SQL query
$query = ‘SELECT item_id FROM db_table_name WHERE some_condition=1′;
$result = mysql_query($query) or die(’Query failed: ‘ . mysql_error());

// Printing results in HTML
header (”Content-type: text/plain”);
while ($line = mysql_fetch_array($result, MYSQL_ASSOC))
{
foreach ($line as $col_value)
{
echo “http://yoursite.com/url.php?id=$col_value\n”;
}
}

// Free resultset
mysql_free_result($result);

// Closing connection
mysql_close($link);

?>

You will hate to change the username, password for MySQL database, and If you use a hosting company like godaddy, for example, you will have to change localhost also. Something like pXXmysqlYY.secureserver.net. Second change concerns URLs, which is ih this type http://yoursite.com/url.php?id=XYZ. After all this changes, save the file as urllist.php, and upload it in your site’s ROOT directory. Before you submit it to Yahoo you will have to make one more step - “rewiting” the URL of the sitemap in .htaccess this way:

Find

Options +FollowSymlinks -Indexes
RewriteEngine On

on next line place:

RewriteRule ^/urllist.txt /urllist.php [L]

Now your http://yoursite.com/urllist.txt file is ready for submission.