Running SQl query using php file

[Senti.Jatt]

How can i run sql query from a php file???
for example i want to update

PHP Code:

UPDATE `user` SET `ipaddress` = '1.2.3.4.5' WHERE `userid` =1; 


how can i run this in php file???
i need full code please

[Lynne]

Take a look at other queries written in the vbulletin files and you should see the proper format to do that. Just doing a quick search in my vb directory for UPDATE gives me this (and tons of others) as an example:

PHP Code:

        $vbulletin->db->query_write("
            UPDATE " . TABLE_PREFIX . "user
            SET reputationlevelid = $sql
        "); 


Using that as an example, you should be able to write out yours.

[mad@Max]

somefile.php

PHP Code:

<?php
require_once ('./global.php');
if ($_REQUEST['do'] == 'somedo')
{
    $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET ipaddress = '1.2.3.4.5' WHERE userid = 1");
}
?>

somefile.php?do=somedo

[Senti.Jatt]

^ thanks