PHP Form and Database Help Please

[mattyb15]

Okay. I'm a php newbie.

I have a form where the user enters their name.

I then on the next form I want it to access the database and add 1 to the row named 'number' that matches the persons name that they previously entered. If the name does not exist, I want it to create new data for that person.

Any help would be much appreciated.

[nikesh.yadav]

wat u need code or suggestion?

[nikesh.yadav]

if u need suggestion....

first u check weather the data is present or not.
if not then insert a new row.

[mattyb15]

The code would be great. I'm new to PHP and don't really know how to use it properly yet.

[nikesh.yadav]

$result=mysql_query('select * from user where table='.$user_id.'');
if(mysql_num_rows($result) == 0){
$insert_user= 'insert into user set id='.$user_id.'';
mysql_query($insert_user) || die(mysql_error());
}

modify as ur enties

[nikesh.yadav]

sorry forgot last enrty

$result=mysql_query('select * from tablename where id='.$user_id.'');
if(mysql_num_rows($result) == 0){
$insert_user= 'insert into tablename set id='.$user_id.'';
mysql_query($insert_user) || die(mysql_error());
}

modify as ur enties

[mattyb15]

Sorry, but how would I go about adding one to that persons 'number' row?

[Shanti C]

i think you are not complete with your posts.....

Please provide your thread clearly...

[mattyb15]

This is my code so far.

$name = $_REQUEST['name'];
  $set = $_REQUEST['set'];
  $email = $_REQUEST['email'];

$con = mysql_connect("XXXXXXXXXXXXXX","XXXXXXX","XXXXX");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("a6114672_dope", $con);

$result=mysql_query('select * from turf_table where id='.$name.'');
if(mysql_num_rows($result) == 0){
$insert_user= 'insert into turf_table set id='.$name.'';
mysql_query($insert_user) || die(mysql_error());
}

mysql_close($con);

[mattyb15]

For example, my data table is:

Name: Number:
Matthew 20

And I want to add 1 to the number in the number column.

[Shanti C]

i don't understand what do you want???

[Shanti C]

you want add 1 to number or update number field with 1

[mattyb15]

add 1 to the number for the person who enters their name in the form.

[Shanti C]

then write qury like:

$result="update turf_table set number=(number+1) where id='.$name.'";

[mattyb15]

Ahh, thank you very much. I am testing it now.

[mattyb15]

So this should work?

$result="update turf_table set number=(number+1) where id='.$name.'";

mysql_query($result) || die(mysql_error());

[Shanti C]

yes....

[mattyb15]

Okay, well the code parsed with no errors, but 1 did not get added.

$name = $_REQUEST['name'];
  $set = $_REQUEST['set'];
  $email = $_REQUEST['email'];

$con = mysql_connect("xxxxxxxxxxx","xxxxxxx","xxxxxxx");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("a6114672_dope", $con);

$result="update turf_table set number=(number+1) where name='.$name.'";

mysql_query($result) || die(mysql_error());


mysql_close($con);

[Shanti C]

just echo this query like..

echo $result="update turf_table set number=(number+1) where name='.$name.'";
exit;

and copy and paste that query at your database..
tel me what you got there....

or post your table structure...

[mattyb15]

Error

SQL query:

echo $result = "update turf_table set number=(number+1) where name='.$name.'"

MySQL said: Documentation
#1064 - 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 'echo $result="update turf_table set number=(number+1) where name='.$name.'"' at line 1