posting vars...

gat

could any one tell me why this reg form may not be working??


<?
mysql_connect("localhost","ukart","***"); 
mysql_select_db("ukart"); 

if(isset($_POST['Submit']))  { 
$username = $_POST['username']; 
$password = $_POST['password']; 
$location = $_POST['location']; 
$email = $_POST['email']; 
$biog = $_POST['biog']; 

$query = mysql_query("INSERT into USERS username, password, location, email, biog VALUES '$username','$password','$location','$email','$biog'")

} 
else echo 'nothing submitted!'; 
?>

leatherback

Try like this (With or without the enters i have added):

$query = mysql_query("INSERT into USERS 
(
username, password, location, email, biog
)
 VALUES  

(
'$username','$password','$location','$email','$biog'
)
") ;

njm

gat,

It's always a good idea to

$query = mysql_query('...') or die(mysql_error());

see what mysql_error says, if anything.

I think though, that you might need brackets around the field names and values in your SQL statement.

hth, njm

gat

ok cool, so now im taking the data into mysql...

however, i was wondering what TYPE i should set the fields as. Because "biog" i would like to take up to 300 characters. its currently set as TEXT and is only taking in 1 char each time i register.

this is the table

USERS
user_id (int(8), primary key, auto_inc)
username - varchar(11)
password - varchar(32)
location - text
email - text
biog - text

should i change the bottom 3 to other TYPES?
thanks

for some reason no matter how much i type in "biog" when i go to phpmyadmin, its only inserted "g"

any ideas?

njm

If you're sure that the biog field could be up to 300 characters, then you'll need to use a TEXT field, because VARCHAR/CHAR only have a maximum size of 255. The other fields could be set to VARCHAR(x). Have a look here for more info.

hth, njm

gat

thanks njm, i just saw that i should be using text...
also wondering, how to MD5 the password, as when the pass gets inserted, its just normal text, not encrypted even though its set to in mysql

to see whats going on......here is a link

http://art.uk-graffiti.co.uk/login.php

user = please
pass = help

njm

Use the mySQL md5() function when inserting the password, and the same function when checking on login.
Here's roughly what I use:

$sql = 'insert into users set user="'.$_POST['user'].'" ,'
							.'name="'.$_POST['fname'].'" ,'
							.'email="'.$_POST['email'].'" ,'
							.'passwd=md5("'.$_POST['pwd1'].'");

then when logging in, something like:

	$sql = 'select * from users where user="'.$_POST['uid'].'" and passwd = md5("'.$_POST['pwd'].'")';

hth, njm