Problem to update table in mysql using php

khaja_jab

i am new to php and mysql.
can any one help me
i have 2rows in my table 1. id 2. content
when i am updating single column it was automatically changing all columns in the table.

Here is my Script:

<?php
$hostname="localhost";
$username="";
$password="";
$database="";

// Connect to the database
mysql_connect($hostname, $username, $password) OR DIE("Unable to connect");
mysql_select_db("$database") or die("Unable to select database");

$query="UPDATE test_mysql SET content='" . $_POST['ud_date'] . "'";
$checkresult = mysql_query($query);
if ($checkresult) echo 'update query succeeded';
else echo 'update query failed';

echo $sql;
exit;
?>

can any one help me please..

laserlight

khaja.jab wrote:
i have 2rows in my table 1. id 2. content

Those are columns, not rows.

khaja.jab wrote:
when i am updating single column it was automatically changing all columns in the table.

I think you mean rows, not columns, in which case the reason is that you don't have a WHERE clause specifying which rows to update.

By the way, please post PHP code in [noparse]

[/noparse] bbcode tags.

khaja_jab

can u give me that code please

laserlight

No, because choosing the criteria for selecting rows to update is your decision, not mine.

khaja_jab

laserlight;11005814 wrote:
No, because choosing the criteria for selecting rows to update is your decision, not mine.

sorry this not row these are columns

laserlight

khaja.jab wrote:
sorry this not row these are columns

So... what is the problem?

khaja_jab

the problem is

i was created 2 columns. when i am going to change one column it was changing all columns which i have i was mention id also.

laserlight

khaja.jab wrote:
i was created 2 columns. when i am going to change one column it was changing all columns which i have i was mention id also.

Well, I think you're mistaken. When you change one column but do not specify the other columns, as in your example, only values in that column will be changed. If this is not the case, then the example that you are showing and the code that you are actually running are substantially different.

khaja_jab

can i have the exact code please

laserlight

Something like this:

<?php
$hostname = "localhost";
$username = "";
$password = "";
$database = "";

// Connect to the database
mysql_connect($hostname, $username, $password) OR DIE("Unable to connect");
mysql_select_db("$database") or die("Unable to select database");

if (isset($_POST['ud_date'])) {
    $query = sprintf("UPDATE test_mysql SET content='%s'",
                     mysql_real_escape_string($_POST['ud_date']));
    if (mysql_query($query)) {
        echo 'update query succeeded';
    } else {
        echo 'update query failed';
    }
} else {
    echo 'please submit the form';
}

khaja_jab

no, i am getting same problem. it was updating both.

laserlight

khaja.jab wrote:
no, i am getting same problem. it was updating both.

Sorry, but that is impossible unless you have a very serious bug in your database engine.

That said, I still think that you're confusing row and column. What is a row in a database table? What is a column in a database table?

khaja_jab

boss. i have 2 id's, these id's are auto-increment, so i have 2 id's that is first one is id.no2 second one is id.no14
when i am updating id no. 2 it was changing automatically 14 also. now got my point.

laserlight

khaja.jab wrote:
i have 2 id's, these id's are auto-increment, so i have 2 id's that is first one is id.no2 second one is id.no14
when i am updating id no. 2 it was changing automatically 14 also. now got my point.

Yes. That is, you are confused as to what is a row and what is a column. Basically, you can imagine your database table to be something like this:

+----+---------+
| id | content |
+----+---------+
|  2 |   abc   |
+----+---------+
| 14 |   def   |
+----+---------+

Now, this is a row:

+----+---------+
|  2 |   abc   |
+----+---------+

This is a column:

+---------+
| content |
+---------+
|   abc   |
+---------+
|   def   |
+---------+

What you want to do is update the content column for the row in which the id is 2. However, the query that you are actually running updates the content column for all the rows. Therefore, as I told you earlier, you need a WHERE clause:

$query = sprintf("UPDATE test_mysql SET content='&#37;s' WHERE id=%d",
                 mysql_real_escape_string($_POST['ud_date']),
                 2);

khaja_jab

thanq boss i got. it was working properly thanks a lot ..

khaja_jab

boss one more problem

it was changing only that row.

i want to change all rows.

khaja_jab

i want to change all rows with different content

laserlight

Oh, so you have a bunch of id/content pairs. So, create an array and use it to run the query for each pair in a loop.

khaja_jab

please send me that code.

laserlight

Sorry, but I do not want to spoonfeed you the code. Please attempt it first by yourself.