CoderGenius

i would never have thought of that... Thanks so much! it works perfectly now!!! ill prolly go in an change those column names now, so i wont accidentally forget those ticks later...

wow, i cant believe i forgot to put that in there... ok here's the error its generating:

oh an i forgot to mention before, tho i doubt it has anything to do with my problem (its just one of the guidline thingys) im using MySQL version 5.0

oops... i was trying something out earlier an accidentally forgot to put the quotes back in... but it still doesn't work with them added... heres how the code should actually look: if($ready == "Send"){//SEND WAS CLICKED $check=mysql_query("SELECT * FROM players WHERE id='$to'"); $rowcheck=mysql_fetch_array($check); if($rowcheck['user'] == ""){ ?> <script language="JavaScript"> <!-- alert("That player does not exist."); //--> </script> <?php }else{ mysql_query("INSERT INTO messages (to,from,subject,message) VALUES('$to','$from','$subject','$message')"); goTown("Message Sent!"); }

I've been working on a new online game for a few weeks now, an am in the middle of trying to set up a simple messaging system. Right now I'm using a simple Table with columns for id, to, from, subject, message, timesent, and read. my problem is that when i try to insert new messages into the table, they simply never are inserted! I've been checking my syntax for a few days now, an I'm baffled as to why this statement wont work... Here is the portion of the code that isn't working: if($ready == "Send"){//SEND WAS CLICKED $check=mysql_query("SELECT * FROM players WHERE id='$to'"); $rowcheck=mysql_fetch_array($check); if($rowcheck['user'] == ""){ ?> <script language="JavaScript"> <!-- alert("That player does not exist."); //--> </script> <?php }else{ mysql_query("INSERT INTO messages (to,from,subject,message) VALUES($to,$from,$subject,$message);"); goTown("Message Sent!"); } }//IF SEND WAS CLICKED The problem is in the insert statement i believe. I've tested the query_fetch_array, and it is in fact returning the correct user that has been specified in the 'to' field. and the function 'goTown' is working, as it is sending the alert that the message was successfully sent. Any help would be greatly appreciated! PS, if you wanna see the code in action, the game I'm working on is actually online, an playable (except the messaging of course ) heres the URL right now: http://www.videogamenewz.com/LR

Hey, I've been trying to find out how to create one of those menu bars that seem to hover at the top corner of a web page like: http://wolfwacky.com/immain.html any help would be much appreciated

Hey, I have been trying to find out how to make those menu bars that hover at the top left of the page, even when you scroll down like on: http://www.milonic.com/mfa/2003-October/002808.html thanks for any help

oh ya and you can change the height and width to whatever size you need. (making them both zero makes it Invisible)

Well I'm not positive about the firefox plugin error, but this should work in all browsers: [hr] [pre]<embed src="Beethoven's Symphony No. 9 (Scherzo).wma" autostart="true" loop="true" width="500" height="100"> </embed> <noembed> <bgsound src="Beethoven's Symphony No. 9 (Scherzo).wma" loop="infinite"> </noembed>[/pre] [hr] just use your sound file instead of that one. the noembed tags are so that older versions of IE can use it, and it keeps newer versions of IE from reading it and the embeded one and getting an error. Hope this helps