Gregg Posted August 30, 2006 Share Posted August 30, 2006 Ok, the way i have it set up is when a user clicks the "mail me" link it echos there name in the compose form but i want to make also make it so they can compose a new mail, without the id link.Its set up to get a name from there favorites, then a new compose but keeps getting an error: ???[code]Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/public_html/datingsite/compose.php on line 134"Witch Is: $rowuser=mysql_fetch_object($ruser);"[/code]Here is the php, any thoughts.[code]<? include("cookie.php");include("connect.php");if(!ereg("read_message",$HTTP_REFERER)){ include("checksubscription.php");}if($send){ if($send==$UsErCoOkIe) header("location:message.php?30");}if($submit){ if($sendto) { $quser1=mysql_query("select * from users where identity='$sendto'",$db); $ruser1=mysql_fetch_object($quser1); if($original) $subject="RE: $subject"; $to_client_id=$ruser1->userid; } $rcuser=mysql_query("select * from users where identity='$UsErCoOkIe'",$db); $rowcuser=mysql_fetch_object($rcuser); $cuser=$rowcuser->identity; $body=$body."\n\n"; $remail=mysql_query("select email from users where userid='$to_client_id'",$db); $rowemail=mysql_fetch_object($remail); $email=$rowemail->email; if(!$subject) { $subject="[None]"; } $que="insert into inbox(title,msg,userid,sender,time) values('$subject','$body','$to_client_id','$cuser',now())"; mysql_query($que,$db); mysql_query("insert into outbox(title,msg,userid,sender,time) values('$subject','$body','$to_client_id','$cuser',now())",$db); mysql_query("insert into email(userid,sender,time) values('$to_client_id','$cuser',now())",$db);// Edit the following variables to customize the message sent to the recipient $sub="New mail in your dating account"; $url=$SITE_URL."login.php"; $content="There is new mail in your account at darkwaterstusio.net dating To check the mail visit http://darkwaterstudio.net/datingsite/index.php"; $from="webmaster@darkwaterstudio.net"; sendmail($email,$sub,$content,$from); // You should not need to edit any active code beneath this line header("location:message.php?19");} ?>[/code]The Form:[code]<FORM method=post name=CFForm_1> <table border=0 cellspacing=5 class=blue_text> <tbody> <tr> <td align=right bgcolor="#E1E1E1" class="big_txt">To:</td> <?if($send){?> <td bgcolor="#E1E1E1" class="normal_txt"><input type="text" name="sendto" value=<?echo $send?>> </td> <?}else{?> <td bgcolor="#E1E1E1" class="normal_txt"><? $quser="select * from users where username='$UsErCoOkIe'"; $ruser=mysql_query($quser,$db); $rowuser=mysql_fetch_object($ruser); $userid=$rowuser->userid; $query="select * from lovebasket where userid='$userid'"; $rto=mysql_query($query,$db); ?> <select name=to_client_id> <option value="">Select</option> <? while($rowto=mysql_fetch_object($rto)) { $quser="select * from users where userid='$rowto->loveid'"; $ruser=mysql_query($quser,$db); $rowuser=mysql_fetch_object($ruser); $name=$rowuser->identity;?> <option selected value=<?echo $rowto->loveid?>> <?echo $name?> </option> <?}?> </select> (from your Favourites) </td> <?}?> </tr> <tr> <td align=right class="big_txt">Subject:</td> <td class="normal_txt"><input maxlength=48 name=subject size=48> </td> </tr> <tr> <td align=right valign=top bgcolor="#F7F7F7" class="big_txt">Your Message:</td> <td bgcolor="#F7F7F7" class="normal_txt"><textarea class=general_text cols=50 name=body rows=10><? if($original){echo "\n\n"; for($i=0; $i<30;$i++){ echo "-";}echo "\n";?>Original Message:<?echo "\n"."\n";?><?echo stripslashes($original);}?></textarea> </td> </tr> <tr> <td align=middle colspan=2><input name="imageField" type="image" src="images/send_me.jpg" width="81" height="13" border="0"> <input type=hidden name=submit value="Send message"> <?if($original){?> <input type=hidden name=original value="<?echo $original?>"> <?}?> </td> </tr> </tbody> </table> </FORM>[/code] ::) Quote Link to comment Share on other sites More sharing options...
Gregg Posted August 31, 2006 Author Share Posted August 31, 2006 Any help on fixing this error would be mutch apreciated! :P Quote Link to comment Share on other sites More sharing options...
Gregg Posted August 31, 2006 Author Share Posted August 31, 2006 Well thanks for all the help guys... Oh wait i fixed it my self haha.I used this instead of the menu cause it seems no one know how to make it work:<input type="text" name="sendto" value=<?echo $send?>>Now its ok but might be hard for people who dont knoe users ID Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.