PC Nerd

ok, thanks age is text BUT the security number ( all of this is the format in the database) is of an integar format, so ill change it and let you know what happens as using the single quotes instead of double quotes, i dont understand???

ok i redid the new player entry, using the field name as the actual input ( or as close as i could get) and i still got the error.  heres the output, after  my personal message ( ie this is generated by php) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''User_Name', 'Password', 'Email', 'Security_Number', 'F_Name', 'L_Name', 'Age') ' at line 2SQL= INSERT INTO General_Stats ('User_Name', 'Password', 'Email', 'Security_Number', 'F_Name', 'L_Name', 'Age') VALUES ('User_Name', 'Password', 'email@localhost.com', '9069 - 207 - 876', 'FName', 'LName', '30 - 50')

ok, thats actually an error on my behalf when i blanked out the actual details, sorry, if you want me to ad in another ***** then i will but i dont see any point

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''User_Name', 'Password', 'Email', 'Security_Number', 'F_Name', 'L_Name', 'Age') ' at line 2SQL= INSERT INTO General_Stats ('User_Name', 'Password', 'Email', 'Security_Number', 'F_Name', 'L_Name', 'Age') VALUES ('*****', '*****', '*****', '*****', '*****', '*****') ive blanked out the actual details, but i checked them, and therye all correctly passed to the page etc.....

ok, this is what i got.  "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''User_Name', 'Password', 'Email', 'Security_Number', 'F_Name', 'L_Name', 'Age') ' at line 2"

!!! where is this??? database_link.inc OR New_PLayer_create.php????????????!!!!!!!!!!!!!!!!!!!!!!!!!!!!!1

is this in database_link.inc or the New_Player_Create.php

when iput it the other way around, i get an error, anyother ideas???

glad i could help

is the $total variable text or an integar.  if its text, make it an integar and that will allow you to do math orrerations on it, if its text, thats why it didnt work, becauase your deviding text by a number which obviously wont work

please can someone help me, i have no idea whatso ever about this, i am completely stumped

1.  how 2. what the code to edit the $_POST array ie add entries to it

no its easy..... i think all you would bave to do, is once you have the kb count of the file length, you do something like this [code] $total2 = total / 1024; if($total2 > 1) { echo $total2; echo "KB</b> of your total file size allowance</p>";} [/code] you could use another else if () { } for GB if you really needed good luck

if i was to start passing information from page to page using the $_POST array, can javascript read these arrays, or qould it have to read on the server, and given to javascript as text input???

but by specifying specific IP address' those people with dynamic IP addresses changeing each time they connect, they wont be able to login or use the site.  besides, if worst comes to worst, you could alwayz delete those users who are abusing the system, and theyre details, so like there em ail address cant be used to sign up anymore.  and then you might be able to write some code that searches the database for email addresses that are reasonabily similar to those that are blocked, and it would bring it to the administrators attention ( ie you , and you could manually see other stuff about that user, or block it or do as you see fit.  that might help to stop it.  but if its just an automated script doing the harm, you could either use the graphic verification login, or run a proper validation, like stripping speciall characters and replacing them, that way, any code that is entered into a field, will only be able to be displayed as text, and wont be able to do anhthing else.  or you could limit the text enrty character length, so that anything of a script sized character length enetered into the field, wont be accepted, and will be forced to enter the script many times, different bits in different fields, therefore stopping the full script from being entered an d being used on the server hope this all helps

well i dont quite understand your last question, but the "desc" at the end of the query means that if you have a table that looks like this: ID    User_Name 1.      User1 2.      User2 3.      User3 then you query it by going "SORT BY ID, User_Name desc" ( this meaning sort bi ID first and if record id is == to another record, then sort by User_Name in that record...), youll get these results: ID    User_Name 3.      User3 2.      User2 1.      User1 im 99% sure of this, but id like someon to back me up anywayz, try in on your code and see if it works, if not, then let us know, and well come up with another possible solution Good Luck I hope that helps

[code] [codeSELECT Company, OrderNumber FROM Orders ORDER BY Company][/code] thats copied from http://www.w3schools.com/sql/sql_orderby.asp yes, your guess was correct.  go the website above for more information.  hope it helps

um, the image verification you mentioned, doesnt necisarily need a ip address record to be saved.  i use this sort of verification on my website im building, so its stops automated scripts from logging in and doing harm, as you discribed.  ( this would only work, if this spam is being generated by an automated script, and no in person using copy and paste in messages) heres the code for mine, although i have hand made the images using photoshop, so it would require some effort.  also, i use xampp for my server but in its administration there is sample code for an image generator, that create a picture using text imput from the user, ( so you could add random characters to the variable to make it possible ( its just an idea)).  i wont post the xampp script here, becauaswe i dont know about whether itll brech copyright, but if you donwload xampp, ( its only like 20 or 30 MB i think) you can check it for your self. this is the code ive written [code] <?PHP $num = rand(1,6); echo "<img src = 'Graphics/Logins/B_A-Login_$num.gif' alt = 'Security Login' width = '70%' hight = '70%'>"; ?> [/code] within that code, the images are saved wuth names such as "B_A-Login_1.gif" and the number increments, so the random mnumber variable just selects it like that.  good luch, and i hope that xampp suggestion works out....

does anyone have any ideas for this error.  i really dont know what to do from here.  if no one knows, just say so, but i would really appreciate you guys helping me solve this, or else letting me know that no one knows whats wrong in my scipt.... pleaase.

my favourite way of learning a new computing language such as php, or more resently javascript, is to find a comparison table of key words, like defineing variables and control statements.  becauase i already know a little bit about quite a few languages, this helps me becauase i can compare it so something i already know.  i dont know anywhere tha has something like that, but good luck anyway

is you send the email in html format, and not plain text, the html tags for formatting should work.  could someone confirm this for me, becauase im not 100% sure

i dont know much about this area, but it sounds as though your accepting the cookies from your actual browser, but a firewall or something similar may actually be blocking them.  sorry i cant be much more help, good luck

thanks everyone, i apprecite your help

thanks for your fast response.  ill try it and let you know if it doesnt work

thanks, thats loads of help i know this isnt php, but would i be able to create the .ico file from adobe photoshop, if i cut the image down to the right size??? and once i have the .cio file how do i include it in my codeing