Hi,
I've run into absolute brickwall and am really desprate for your help please. I have a MYSQL Database with two Tables called user_comment and the second user_table. When a user register with the site, their details are kept in the user_table. the second table user_comment is so that users who are registered on the user_table can leave comments which will be passed into the user_comment table. HERE IS THE CODE FOR THE SECOND PART, CHECKING IF A USER'S EMAIL EXIST IN the user_table IF SO, PUX THESE DATA INTO user_comment TABLE. PLEASE CAN ANYONE SPOT WHAT IS WRONG WITH THE CODE???
undefined <?php require 'db.private'; ?> <html> <head> <title> Gizmo® Electronics - Login</title> </head> <body> <table width="100%"> <tr><td> <?php $connection = mysql_connect($hostname,$username,$password); mysql_select_db($databaseName, $connection); $submit = $_POST; $comment = $_POST; $email = $_POST; if(isset($submit)) { //if(isset($submit)) { // check if user exists in the database $query = mysql_query("SELECT email FROM user_table WHERE email = '".$email."'"); //$num_rows = mysql_num_rows($query_email); //if(!$num_rows) die('Gizmerror!! Either you have typed your USERNAME and or Your PASSWORD incorrectly or you have not registered to access this pages. <p><font color="red" size="+1"><center> Please Try Again</center> </font></p>'); //mysql_query ( "INSERT INTO user_comment (email, comment) VALUES ('$email', '$comment'); $insert = "INSERT INTO user_comment SET email = '$email', comment = '$comment'"; //mysql_query($insert); //$row_comment = mysql_fetch_Array($query); die("<META http-equiv=\"Refresh\" content=\"0;url=commentdisplay.php\">"); //die("Thank you for registering. Your Registration was Successful! You can now login"); //$insert = "INSERT INTO user_comment SET //comment = '$comment'"; //mysql_query($insert); die("Thank you for registering. Your Registration was Successful! You can now login"); //} //echo mysql_error(); //mysql_close(); } ?> <center> <form action="comment.php" method="post"> <table summary="comment page"> <tr> <td><label for="comment">Your Comment:</label></td> <td><textarea name="comment" cols="70" rows="5" wrap="VIRTUAL" id="comment" value="comment"></textarea><br /></td> </tr> <tr> <td><label for="email">Email Address:</label></td> <td><input type="text" id="email" name="email" value="type ur email here"></td> </tr> <tr> <td><input type="submit" name="submit" /></td> </tr> </table> </form> <p><a href="home.htm">...or return to our Homepage</a></p> </td> </tr> </table> </body> </html> THANK YOU, I REALLY APPRECIATE YOUR TIME AND EFFORT.
:confused:
