Using MySQL UPDATE, I need help.

[EM @MAJ.com]

I have this code ...

// connect to database
$sqlQuery = "SELECT * FROM table WHERE fieldname1= -123456 ORDER BY id DESC LIMIT 1";

[successfully executed my programming routine here.]

At the end of php script, I added this command to update the fieldname 'type' value to test4
$sqlQuery = "UPDATE `table` SET `type`='test4' WHERE fieldname1=-123456 ORDER BY id DESC LIMIT 1";

The UPDATE is not working. I suppose to see updated data for type=test4. What I'm missing here?

Thank you in advance.
EM

 

[Mr.Domains]

You are setting up your query string $sqlQuery, but are you actually executing it? In your code, you are not actually running the query.

$sqlQuery = "UPDATE table SET type='test4' WHERE fieldname1='-123456' ORDER BY id DESC LIMIT 1";
$result = mysql_query($sqlQuery) or die(mysql_error());

 

[EM @MAJ.com]

Cheers to you Neil. It works. I'm getting old ...

Thank you for taking the time to post a solution.

Regards,
EM @ KING.NET

 

[Mr.Domains]

No worries, glad I could help...