SQL query for extract data

i have big collection of youtube video data indexing 48,582 in different categorize ...... now i want extract specific categorize video data in export to txt file ..... now i little bit confuses . how it is possible ?



rapid help will be appreciate

 

I don't understand the sentence: from category 176 to vid1?

Anyway I try to help with..what I understand about the current situtation:

the script below select all videos of category id 176

$query = mysql_query("SELECT * FROM your_table WHERE cat1=176");

PHP:

replace your_table with your table name

So the txt part: (continue with the script above)

while ($videos = mysql_fetch_assoc($query) ) {
$content .= $videos['vid1']."\r\n";
// this would save the url of the YT videos and seperate each of them by a newline
// replace the \r\n by \n if your server is linux
}

// now save the string as txt
$handle = fopen("your_filename.txt", "w");
fwrite($handle,"$content");
fclose($handle);

PHP:

Untested. Try if this helps? Its night here.. Good Night =)

 

Thanks for help me ...................it works

 

Your're welcome. I said that i will help..in my store =D

 

SELECT COUNT( * ) AS `Rows` , `tags`
FROM `y8`
GROUP BY `tags`
ORDER BY `tags`