smartguyin

Ya Thanks !! Solved...

Sorry i forgot to post the error.. Insert Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group, in_name, in_address, phone, email, mobile1, mobile2, date, comment) VALUE' at line 1

I have a Form on registration.html through which i trying to get data in mysql through the below php script but there is and mysql syntax error please help me with the below code. <?php $conn = mysql_connect("localhost", "onlinewe_meghraj", "password123") or die(mysql_error()); $db = mysql_select_db("onlinewe_college") or die(mysql_error()); $name1 = $_POST['name1']; $name2 = $_POST['name2']; $year = $_POST['year']; $department = $_POST['deparment']; $group = $_POST['group']; $in_name = $_POST['in_name']; $in_address = $_POST['in_address']; $phone = $_POST['phone']; $email = $_POST['email']; $mobile1 = $_POST['mobile1']; $mobile12 = $_POST['mobile2']; $comment = $_POST['comment']; $result=mysql_query("INSERT INTO register (name1, name2, year, department, group, in_name, in_address, phone, email, mobile1, mobile2, date, comment) VALUES ('$name1', '$name2', '$year', '$department', '$group', '$in_name', '$in_address', '$phone', '$email', '$mobile1', '$mobile2', '".date("Y-m-d h:i:s")."', '$comment')") or die("Insert Error: ".mysql_error()); echo "REGISTRATION DONE"; ?> Please reply. Thank you.

Jesi i am not yelling i mistakely kept the caps on..... if i hurt you i am sorry for those mistakely keeping Caps On..... okay thanks for even trying.... thank you all except jesi... babes i was not Yelling on anyone... and why should i ????????/

YES I DON'T HAVE FUNCTION ON THAT ITS ON OTHER PAGE LIKE BODY.PHP WHICH COMES AFTER HEADER.PHP THE ABOVE CODE IS IN HEADER.PHP SOO  IT DOESN'T HAVE THT FUNCTION ON SAME PAGE

but even if (!function_exists('setup_page')) { echo "NO TITLE"; } is not working .... its not showing NO TITLE...

jesi i know its a poor design i am learning it and this is my first project...  and will get it done correctly next time.. but for now please tell me how can i do tht

can u please explain how to do it coz i have never used tht function before or know how to apply it... please explain

i think error is in this [b]mysql_select_db("krankdcontacts, $db);[/b] while selecting db you forgot [b]"[/b] correct it to [b]mysql_select_db("krankdcontacts", $db);[/b]

still i am not getting it..... i just wanna know if the page is not having [b]setup_page($title)[/b] fucntion then i wanna echo other thing as i explained above

CAN I DO SOME THING LIKE THIS... if (!function setup_page($title)) { echo "NO TITLE"; } i know this code is worng help me with this to use if else statement

CAN I DO SOME THING LIKE THIS... if (!function setup_page($title)) { echo "NO TITLE"; } i know this code is worng help me with this to use if else statement

No NOT yet... thanks for your help.. ok tell me if no function is set for title like setup_page("Search Page");  then how can i echo NO TITLE

no still not getting it [b]NO TITLE[/b] the variable is coming from body.php which is place in index.php after header.php  Soo if some of the pages which the variable is not set...  then i wanna echo [b]NO TITLE[/b] Thanks for helping but still i am not getting it

please explain me i am still not able to use the ELSE IF STATEMENT....  sooo if there is no $title variable sent by another script then it should echo the other thing.. please help