Connects to MYSQL, but can't insert data?

[Dissonance]

Well, I'm trying to get a script to insert some form data into a mysql database. Config.php contains the MYSQL connect, and I've echo'd $link and it's connected.

Register.php

<?php
include ('config.php');

$user=$_POST['username'];
$pass=$_POST['password'];
$md5pass = md5('$pass');

mysql_select_db("news");

$query = "INSERT INTO `users` ( `id` , `username` , `password` ) VALUES ( '', `".$user."` , `".$md5pass."`)";
mysql_query ($query);



// header('Location: index.php');
?>

 

[sleipnir214]

Your query, for some reason, is failing. The trouble is, your code performs no error-trapping. The minimum necessary error-trapping that will give you debugging information is to change the line:

mysql_query ($query);

to read:

mysql_query ($query) or die(mysql_error());


Also, see my FAQ titled "Debugging PHP code" in this forum: faq434-2999


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[ChrisHirst]

does the id column happen to be an autonumber ?



Chris.

Indifference will be the downfall of mankind, but who cares?

http://www.candsdesign.co.uk

A website that proves the cobblers kids adage.

http://www.cram-system.com

Nightclub counting systems

So long, and thanks for all the fish.

 

[Dissonance]

Yea, the Id column is autonumber.

 

[ChrisHirst]

there's your problem then!


you cannot put autonumber columns into a update or insert query.



Chris.

Indifference will be the downfall of mankind, but who cares?

http://www.candsdesign.co.uk

A website that proves the cobblers kids adage.

http://www.cram-system.com

Nightclub counting systems

So long, and thanks for all the fish.