How to call a Profile field in a php file?

[Adrian Schneider]

Pretty much, yes.

You actually need to run a while. Try this:

PHP Code:

$query = $DB_site->query("SELECT fieldX FROM userfield");
while($array=$DB_site->fetch_array($query))
{
    $webcamurl = $array['fieldX'];
    // Declare anything else here
    $webcamurlbit .= "$webcamurl" . '<BR>';
} 


Or a template based one:

PHP Code:

$query = $DB_site->query("SELECT fieldX FROM userfield");
while($array=$DB_site->fetch_array($query))
{
    $webcamurl = $array['fieldX'];
    // Declare anything else here
    eval('$variable = "' . fetch_template('template_name') . '";');
} 


For the second one, you'd create a template and inlclude anything you want repeated inside of it (could be rows of a table (including the $webcamurl)). Then just insert $variable into your main template, and it will repeat the contents.

Edit: by the way, if your php file isn't associated with vBulletin (doesn't include global.php) you have to use mysql_query instead of $DB_site->query and mysql_fetch_array instead of DB_site->fetch_array. Also, if this is the case, you can't use templates, obviously.