If you are going to be doing anything with MySQL I highly recommend installing PHPMyAdmin on your server, or using a host that has it installed (
www.ionichost.com is a free PHP host with MySQL, but the ads are REALLY annoying. Dreamhost is one of the best hosts I have found, US$10pm for 3 domains fully hosted and maxed out with cool features).
In my experience, when you are getting started, you have enough to learn about SQL and PHP without having to learn about configuring your server as well.
It's going to be hard to give you SQL commands without being able to see your Table design. Here are a couple of snippets you can use to get data in and out of a database.
BTW, this is all documented in the PHP manual etc.
Putting data in...
PHP Code:
$query = "INSERT INTO tablename SET fieldname1='$fieldvalue1',fieldname2='$fieldvalue2'";
$result = mysql_query($query) or die ('The Query Failed');
Usually you will use a HTML form for getting data into a database.
Getting data out
PHP Code:
$query = "SELECT fieldname1, fieldname2 FROM tablename WHERE 1";
$result = mysql_query($query) or die ('The Query Failed');
while ($ary = mysql_fetch_assoc($result)) {
while (list($key,$val) = each($ary)) {$$key = $val;}
//This code will be repeated for each record that is returned
echo "Value of 'Field1' is $field1 <br>\n";
}
But really mate (and don't take this the wrong way) you are asking for specific information, but you aren't being all that specific on what you actually need. A bit of planning will go a long way, and I'm sure that if you can let us know what you are trying to achieve (screenshots of a mockup wold be good) then you will get some good advice in return. My 2c.
Dev Shed Forums Sponsor:
January 6th, 2004, 04:32 PM
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
