please give me sample mysql queries where each query is embedded with a unique id- can u cites me more examples?

I want to buy an domain name & web hosting service from microsoft officelive. My plan is to create a webste using PHP & MySQL. Does officelive support PHP & MySQL
Actually I wanted to know- does officelive allow to host website that has been created with PHP & MySQL?

I have been using my database to test a program. Now that the program is functional- how do i reset the database but maintain on the tables and parameters. Basically i want to delete all the current data and reset all the id s (on autoincrementt) to 1.
Any reason why I would have to change my mysql calls after this? Now all of a sudden my calls to the database arn t going through and was working a second ago. I run this sql call then use numrows and it is returning 0 when there are in fact rows in the database.

$sql = "SELECT Matches.*- AAMaps.name- ClanInfo.clanname
FROM Matches- AAMaps- ClanInfo
WHERE Matches.clan_id = " . $validentry . "
AND AAMaps.id=Matches.map_id
ORDER BY dateposted DESC LIMIT 3;";

I dopnt understand what mysqls pupose is. Do u connect it to the intenret or somehthing?

Hi-
I have installed Apache- PHP and MySQL on my window XP computer to locally build a website before sending to web hosting. In order to create database name- how do I get phpMyAdmin working like installing a complete suite of Xammp or WAMP. I don t want both of the latter.

I need a free hosting source with PHP and MySQL for a coppermine gallery- and it needs to be able to have FTP for quick image uploading- and I need to find one with the most memory if possible.
The one I ve found so far is byethost.[com] and that s only 250mb.
If anyone could help I d be really greatful.
Thanks.