unkn0wndj

[!--quoteo(post=358605:date=Mar 26 2006, 02:06 PM:name=wickning1)--][div class=\'quotetop\']QUOTE(wickning1 @ Mar 26 2006, 02:06 PM) [snapback]358605[/snapback][/div][div class=\'quotemain\'][!--quotec--] Try $count = mysql_result($mnum, 0, 0); [/quote] Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/vhosts/www.nowiby.com/templates/topnav.php on line 20

Doesnt say anything maybe my command is wrong ;\

mysql_result(): supplied argument is not a valid MySQL result resource in /home/vhosts/www.nowiby.com/templates/topnav.php on line 20

[!--quoteo(post=358465:date=Mar 25 2006, 11:51 PM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ Mar 25 2006, 11:51 PM) [snapback]358465[/snapback][/div][div class=\'quotemain\'][!--quotec--] Assuming you just need the count, and not the actual messages, then the following should suffice: [code]SELECT COUNT(*) AS cnt FROM messages WHERE msg_recieverid='$_SESSION[usrid]' AND msg_read ='U'[/code] Then pull back the single row containing the count with mysql_fetch_array(). [/quote] Sorry i dont understand what you mean by " Then pull back the single row containing the count with mysql_fetch_array()." Could you please copy what the code needs to contain for that to work :) oh btw the recieverid is a number

Alright I was wanting to pull information from a MySQL database. Heres the code im using [code]$mnum = mysql_query("select * from messages where msg_recieverid='$_SESSION[usrid]'"); $mnumber = mysql_num_rows($mnum);[/code] Alright so I was wondering.. I need to have the msg_recieverid still included because that's what tells it to pull only from their ID, but what I really need to know is msg_read='U' because that says that the message is unread and thats the whole purpose of it. So how can I make a command that lets me pull the number of msg_read='U' that someone has for their msg_recieverid.. Please help

Oh im sorry i dont really know what to post but i fixed that by creating another watermark.php and taking out the watermark. Now whenever I send messages to another user it puts them in their outbox instead of inbox.. ahhh i know i should post code but where? lol and the comments are being weird also

Alright I have a picture rating/community site. On one of the scripts (phpThumb.php) doesn't want to display the images. My other file (watermark.php) displays them fine. Im not sure whats wrong ;\ [a href=\"http://nowiby.com\" target=\"_blank\"]http://nowiby.com[/a] Thanks

Alright I have a picture rating/community site. On one of the scripts (phpThumb.php) doesn't want to display the images. My other file (watermark.php) displays them fine. Im not sure whats wrong ;\ [a href=\"http://nowiby.com\" target=\"_blank\"]http://nowiby.com[/a] Thanks

[!--quoteo(post=353669:date=Mar 10 2006, 12:53 PM:name=AV1611)--][div class=\'quotetop\']QUOTE(AV1611 @ Mar 10 2006, 12:53 PM) [snapback]353669[/snapback][/div][div class=\'quotemain\'][!--quotec--] Question 1: Did you just move from a Windows based server to a Linux based server? If you did, you will find that Windows doesn't care about CaPiToLs in URL's, but Linux DOES! I had to convert a TON of scripts when I made the switch recently. It also look like when you got to the formums, you get this message: which I take as you have not properly corrected you URL mappings in your scripts to match your new server URL's... If I could see a couple of lines of code, maybe includes/queries.php and index.php??? [/quote] Sure do you have an IM program for us to talk?

bump

[!--quoteo(post=353172:date=Mar 9 2006, 02:06 AM:name=txmedic03)--][div class=\'quotetop\']QUOTE(txmedic03 @ Mar 9 2006, 02:06 AM) [snapback]353172[/snapback][/div][div class=\'quotemain\'][!--quotec--] lol I'll do what I can to help if you let me know what the situation is. [/quote] check out [a href=\"http://nowiby.com\" target=\"_blank\"]http://nowiby.com[/a] .. there are a few errors here and there

yea now that problem is fixed but theres a few other little ones from transferring.. can anyone help me lol Ill give you a godaddy domain for some help.

My site was running fine until i switched hosts now its displaying [code]Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/vhosts/www.nowiby.com/templates/topnav.php on line 12 Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/vhosts/www.nowiby.com/templates/topnav.php on line 17 query failed : select count(*) as online from login_online where status=1 and last_visit > subdate(now(), Interval 30 MINUTE) order by last_visit desc[/code] Here is line 12 and 17 [code] Line 12 $countnew = mysql_num_rows(mysql_query("select * from members where adv_approved=0")); Line 17 $result = mysql_query("select adv_picture,adv_approved,adv_rejectreason,adv_picture2,adv_picture3,adv_picture4,adv_picture5,adv_picture6,adv_picture7,suspend from members where mem_userid='$Sess_UserId'"); $pic = mysql_fetch_row($result); [/code] Please help