Enjoy an ad free experience by logging in. Not a member yet?
Register .
PM User | 1
New Coder
Join Date: Aug 2010
Posts: 36
Thanks: 8
Thanked 0 Times in 0 Posts
Create message problem
Hey,
I have a problem with senting a message.
Can you please read over my code and tell me whats wrong?
Heres the html web ink
http://www.triplenines.com/create_message.php
and heres the code
PHP Code:
<?php
();
$toplinks = "" ;
$_SESSION [ 'id' ])) {
$userid = $_SESSION [ 'id' ];
$username = $_SESSION [ 'username' ];
$toplinks = '<a href="member_profile.php?id=' . $userid . '">' . $username . '</a> •
;
$toplinks = '<a href="join_form.php"><input type="submit" name="Register" value="Register" /><a href="login.php"><input type="submit" name="Login" value="Login" /></a>' ;
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<?php echo $toplinks ; ?> </p>
<?php
if ( $username ){
"<div id='box'>
;
////////////////////////////////////////////////////////////////////
$form = "<form action='create_message.php' method='POST'><table>
;
$_POST [ 'sendbutton' ]){
$sendtouser = $_POST [ 'sendtouser' ];
$subject = $_POST [ 'subject' ];
$content = $_POST [ 'content' ];
$sendtouser == "Username of the person revieving your message" )
$sendtouser = "" ;
$subject == "Message Subject" )
$subject = "" ;
$content == "Message Content" )
$content = "" ;
$sendtouser && $subject && $content ){
'connect_to_mysql.php' );
$query = mysql_query ( "SELECT * FROM users WHERE username='$sendtouser'" );
$numrows = mysql_num_rows ( $query );
$numrows == 1 ){
$row = mysql_fetch_assoc ( $query );
$to_id = $row [ 'id' ];
$to_user = $row [ 'username' ];
$date = date ( "M d, Y" );
$query = mysql_query ( "SELECT * FROM messages WHERE content='$content' AND to_id='$to_id' AND from_id='$userid' AND date='$date'" );
$numrows = mysql_num_rows ( $query );
$numrows == 0 ){
mysql_query ( "INSERT INTO messages VALUES ('', '$to_user', '$to_id', '$username', '$userid', '$subject', '$content', '$date')" );
"You message has been sent. <a href='inbox.php'>Click here</a> to view your inbox." ;
"You can not resend the same message.$form" ;
"The username you have entered is invalid.$form" ;
"You did not fill in the entire messsage form.$form" ;
"$form" ;
////////////////////////////////////////////////////////////////////
echo "</div>
;
"</div>" ;
"<center><h2><font color='red'>You must be logged in to view this page.</font></h2></center>" ;
'connect_to_mysql.php' ); ?>
</h3>
PM User | 2
Master Coder
Join Date: Jun 2003
Location: Cottage Grove, Minnesota
Posts: 9,055
Thanks: 8
Thanked 1,032 Times in 1,023 Posts
We can't see it without logging in.
Users who have thanked mlseim for this post:
PM User | 3
New Coder
Join Date: Aug 2010
Posts: 36
Thanks: 8
Thanked 0 Times in 0 Posts
Use the username test
PM User | 5
Master Coder
Join Date: Jun 2003
Location: Cottage Grove, Minnesota
Posts: 9,055
Thanks: 8
Thanked 1,032 Times in 1,023 Posts
The login page won't open with IE8, so I had to use FF to get the login page.$numrows = mysql_num_rows($query); Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/triplen1/public_html/create_message.php on line 311
Users who have thanked mlseim for this post:
PM User | 6
New Coder
Join Date: Aug 2010
Posts: 36
Thanks: 8
Thanked 0 Times in 0 Posts
here is my code for connect_to_mysql
PHP Code:
<?php
= "localhost" ;
$db_username = "********" ;
$db_pass = "*********" ;
$db_name = "triplen1_imga1" ;
mysql_connect ( "$db_host" , "$db_username" , "$db_pass" ) or die( mysql_error ());
mysql_select_db ( "$db_name" ) or die( "no database by that name" );
?>
the *** are my username and password i use for my cpanel
PM User | 7
Master Coder
Join Date: Jun 2003
Location: Cottage Grove, Minnesota
Posts: 9,055
Thanks: 8
Thanked 1,032 Times in 1,023 Posts
Inside "triplen1_imga1" is a table called "users", and within that table is a column called "username"?
Users who have thanked mlseim for this post:
PM User | 8
New Coder
Join Date: Aug 2010
Posts: 36
Thanks: 8
Thanked 0 Times in 0 Posts
There is a table called members not users is that what is wrong? by the way can i add you as a friend?
PM User | 9
Master Coder
Join Date: Jun 2003
Location: Cottage Grove, Minnesota
Posts: 9,055
Thanks: 8
Thanked 1,032 Times in 1,023 Posts
See the red below ... the table called 'users' doesn't exist in your database 'triplen1_imga1' ...users
PM User | 10
New Coder
Join Date: Aug 2010
Posts: 36
Thanks: 8
Thanked 0 Times in 0 Posts
Oh thanks
i'm a idiot
Jump To Top of Thread
Thread Tools
Rate This Thread
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
All times are GMT +1. The time now is 01:52 AM .
Advertisement
Log in to turn off these ads.
Before you post, read our: 
i'm a idiot
