Search the Community
Showing results for tags 'messaging system php mysql'.
Found 1 result
-
Hi guys I am creating a php mysql private messaging system. I am having great difficulty on probably the simplest of matters. When sending a message to another user, I have inserted a drop down list of all the users on the database under the 'to users name'. This works, but however, when I send the message, the 'messageTo' field in the database doesn't populate with the userID i sent the message to. Any solutions possible? Thankyou! <?php include 'gradnetconn.php'; require_once ('webpage.class.php'); session_start(); ?> <form action="send.php" method="post" name="sendpm"> <table> <tr> <td> To Users Name </td> <td> <select name="messageTo" id="messageTo" /> <option value = <?php $sql = "SELECT * FROM gn_users"; $queryresult = mysql_query($sql) or die (mysql_error()); while($row = mysql_fetch_assoc($queryresult)){ $userFirstName= $row['userFirstName']; $userSurname = $row['userSurname']; echo "<option value = $userFirstName > $userSurname</option>\n"; } mysql_free_result($queryresult); ?></option> </td> </tr> <tr> <td> Subject </td> <td> <input type="text" name="messageSubject" id="messageSubject" /> </td> </tr> <tr> <td> Message </td> <td> <textarea name="messageBody" cols="60" rows="10" id="messageBody"></textarea> </td> </tr> <tr> <td colspan="2"> <input type="submit" value="Send PM" /> </td> </tr> </table> </form>
