UBB.Developers Forums Community Development Programming PHP and Server-side Scripting PHP code to change a signature

I need a php code to do the equivilent of this SQL command:

update w3t_Users set U_Signature = "<img src=http://www.myboard.com/ubbthreads/uploads/picture.jpg>" where U_Username = "troublemaker"

This works! Now when I try to convert that to PHP, phpmyadmin gives me the php equivilent of

$sql = 'update w3t_Users set U_Signature = "<img src=http://www.myboard.com/ubbthreads/uploads/picture.jpg>" where U_Username = "troublemaker"';

Which gives me a parse error. I tried replacing $sql with $query, same problem.

Not sure I follow - that query is correct, you can't do that with just PHP, you need to actually connect to a database send the query to the database. But if you're wanting to do it via ubbthreads, the script would:
- Need to include the library by including main.inc.php (so that it connects to your database, and knows all your database settings.
- Need to have a call to do_query (to actually perform the query).

Example for a 6.5.x forum:

Thanks - that worked. [beat head on desk] Need to include the library by including main.inc.php - Need to include the library by including main.inc.php - Need to include the library by including main.inc.php [/beat head on desk]