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.

I want to display a list of 5 upcoming events (from MySQL database) in my module. But i want to add a link at the bottom of the module that says "next 5 events". When a user will click on this link- the next 5 events will be retrieved from the database. I want to do this asynchrounously if possible (AJAX?). Please help!

I want to register a website which has a database also. I want to know where I can do it for cheap ?
Also I want to learn Mysql & php is there any website in which i can learn ?