Help With Php Coding Please

[Rakim]

hi i have posted one forum already heres my new one lol

i am coding a website in php with a clan members section could you please help me here is my code i want to add the information to a MySQL database.

---

add_new_member.php <---My Form

<form name="links" method="post" action="add_member.php">
<p>Member Name :
<input type="text" name="mname">
<br>
<br>
Rank :
<input type="text" name="rank">
<br>
<br>
Real Name :
<input type="text" name="name">
<br>
<br>
E-Mail Address :
<input type="text" name="mail">
<br>
<br>
MSN Messenger Address :
<input type="text" name="msn">
<br>
<br>
Male/Female :
<input type="text" name="mf">
<br>
<br>
Date Joined :
<input type="text" name="dj">
<br>
<br>
Country :
<input type="text" name="frm">
<br>
<br>
Town/City :
<input type="text" name="city">
<br>
<br>
Age :
<input type="text" name="age">
<br>
<br>
Favorite Saying :
<input type="text" name="line">
<br>
<br>
Favorite Map/Level :
<input type="text" name="map">
<br>
<br>
Image URL :
<input type="text" name="img">
</p>
<p>
<input type="submit" name="Submit" value="Submit">
</p></form>

---

add_member.php <-- process form where the problem is.

<?php
include "config.php";

$db = mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db ($db_name) or die ("Cannot connect to database");
$query = "INSERT INTO members (mname , rank , name , mail , msn , mf , dj , frm , city , age , line , map , img)
VALUES('".$POST['mname']."','".$POST['rank']."', '".$POST['name']."', '".$POST['mail']."', '".$POST['msn']."', '".$POST['mf']."', '".$POST['dj']."', '".$POST['frm']."', '".$POST['city']."', '".$POST['age']."', '".$POST['line']."', '".$POST['map']."', '".$_POST['img']."' )";
$result = mysql_query($query);
if (!mysql_affected_rows()){
echo ("Recruit NOT Added.\nQuery $query is wrong");
$query=mysql_query("SELECT FROM members")
$count=mysql_num_rows($query);
echo "There are $count rows in the database";
}
else {
echo ("New Recruit Added.\nYour query $query is correct");
$query=mysql_query("SELECT FROM members")
$count=mysql_num_rows($query);
echo "There are $count rows in the database";
}
?>

---

please help thanks.

[kevinsequeira]

what is the error you are getting ?

reg
kevin