I need a php code to do the equivilent of this SQL command:<br /><br />update w3t_Users set U_Signature = "<img src=http://www.myboard.com/ubbthreads/uploads/picture.jpg>" where U_Username = "troublemaker"<br /><br />This works! Now when I try to convert that to PHP, phpmyadmin gives me the php equivilent of <br /><br />$sql = 'update w3t_Users set U_Signature = "<img src=http://www.myboard.com/ubbthreads/uploads/picture.jpg>" where U_Username = "troublemaker"';<br /><br />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:<br />- Need to include the library by including main.inc.php (so that it connects to your database, and knows all your database settings.<br />- Need to have a call to do_query (to actually perform the query).<br /><br />Example for a 6.5.x forum:<br /><br />

Thanks - that worked. <img src="http://www.ubbdev.com/forum/images/graemlins/cool.gif" alt="" /> [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]