updating strings

[svenski]

Im having real problems updating MYSQL varchar fields with PHP, in short the fields just don't get changed :mad: none of the following work

$query = "UPDATE database_name
SET message_class='TEXT';
WHERE message_id=$message_id";

echo "Mesage class changed to";
echo $message_class;
mysql_query($query);

--- OR ---

$query = "UPDATE database_name
SET message_class=\"TEXT\";
WHERE message_id=$message_id";

--- OR ---

$query = 'UPDATE database_name
SET message_class="TEXT";
WHERE message_id=$message_id';

What am i doing wrong? Any help appreciated,😕 😕

[okuto1973]

Originally posted by svenski
Im having real problems updating MYSQL varchar fields with PHP, in short the fields just don't get changed :mad: none of the following work

$query = "UPDATE database_name
SET message_class='TEXT';
WHERE message_id=$message_id";

echo "Mesage class changed to";
echo $message_class;
mysql_query($query);

--- OR ---

$query = "UPDATE database_name
SET message_class=\"TEXT\";
WHERE message_id=$message_id";

--- OR ---

$query = 'UPDATE database_name
SET message_class="TEXT";
WHERE message_id=$message_id';

What am i doing wrong? Any help appreciated,😕 😕

Try with this:

$query = "UPDATE database_name
	 SET message_class='TEXT'; 
	 WHERE message_id=$message_id";

echo "Mesage class changed to";
echo $message_class;
echo "UPDATE=$query";
mysql_query($query);

And tell me what UPDATE= is.
Try it on your db manually (not using php!) and see where is the error......

[svenski]

hmmm typo in all those (my fault) - extra ; after the SET line. Taking that out still doesn't fix stuff:

UPDATE database_name SET message_class='TEXT' WHERE message_id=382

is what gets echo'ed out and this when put straight in to SQL rather than via PHP works fine. Any more ideas about whats happening?

[okuto1973]

message_id is an autoincremental INT? or a varchar?
If they are data or varchar you have always to use '$variable' in the string query.

Have you created the connection with db?

$db_name='dbname';
$db_user='user';
$db_password='password';

// connessione al DATABASE
$db_conn = mysql_connect("localhost",$db_user,$db_password);
        if (!$db_conn)
                {
                echo "ERRORE !! non riesco a collegarmi al database!";
                exit();
		}

I think yes......
And also.....
try using

$db_update=mysql_db_query($db_name,$query);

instead of

mysql_query($query);

[svenski]

I'm definatley connected as i can alter int fields in this manner, just not varchars.

Tried using

$query = "UPDATE table_name
SET message_class='TEXT'
WHERE message_id=$message_id";

$db_name="database_name";
$db_update=mysql_db_query($db_name,$query);

Still no joy. No error is thrown up, just no update actually occurs. This seems plain weird?

[okuto1973]

Carefully!
One thing is database_name .....and another one the table_name!

Always write the query you want to use and rewrite it on db (without php page) to check if your query is correct!

One thing is :

UPDATE database_name SET message_class='TEXT' WHERE message_id=382

and another one

UPDATE table_name SET message_class='TEXT' WHERE message_id=382

[svenski]

I know, sorry - i wrote DB_name in my early posts as opposefd to table name. Obviously i just changed the names to make it easier, woops:

UPDATE table_name SET message_class='TEXT' WHERE message_id=382

is the format of the SQL which works in an SQL program but not PHP??

[okuto1973]

With this code......

writing the correct dbname,user and password.........

$db_name='dbname'; 
$db_user='user'; 
$db_password='password'; 

// connessione al DATABASE 
$db_conn = mysql_connect("localhost",$db_user,$db_password); 
        if (!$db_conn) 
                { 
                echo "ERROR !! Connection problems!"; 
                exit(); 
        }

echo "Connecting...."

What do you see on browser?

do you use this code to make a connection to db?
or another one?if another post it!

[superwormy]

use mysql_query ($your_query) or die (mysql_error()); so you can see MySQL errors as well.

[svenski]

$hostname = "ipaddress:port";
$database = "databasename";
$username = "dbusername";
$password = "dbuserpassword";
$connect = mysql_pconnect($hostname, $username, $password) or die(mysql_error());

[okuto1973]

Originally posted by svenski
$hostname = "ipaddress:port";
$database = "databasename";
$username = "dbusername";
$password = "dbuserpassword";
$connect = mysql_pconnect($hostname, $username, $password) or die(mysql_error());

Now after that code write this:

$insert="insert table_name (message_class) values ('HELLO')";
echo "insert=$insert";
$db_insert=mysql_db_query($database ,$insert);
echo "Insered?";

To see if you can insert element in table......just to try a select instead of an update.
And tell me.