Which one is faster?

[MarekS]

Hi,

I have a simple Q: Which one is faster?

<?php
error_reporting(0);
ini_set('display_errors', '0');

require_once 'adodb_lite/adodb.inc.php';

if (!isset($_GET['q']) || (!$q=$_GET['q'])) {
    exit();
}

$db = ADONewConnection('mysql');

$ADODB_FETCH_MODE = ADODB_FETCH_NUM;

if (!$rt = $db->PConnect('localhost', 'test', 'test', 'autocomplete')) {
    exit();
}

if (!$rs = $db->Execute('SELECT v FROM ac WHERE v LIKE "%'.addslashes($q).'%"')) {
    exit();
}

while (!$rs->EOF) {
    echo $rs->fields[0],"\n";
    $rs->MoveNext();
}
?>

vs

<?php
error_reporting(0);
ini_set('display_errors', '0');

require_once 'adodb_lite/adodb.inc.php';

if (isset($_GET['q']) && ($q=$_GET['q'])) {
    $db = ADONewConnection(DB_TYPE);
    
    $ADODB_FETCH_MODE = ADODB_FETCH_NUM;
    
    if ($rt = $db->PConnect('localhost', 'test', 'test', 'autocomplete')) {
        if ($rs = $db->Execute('SELECT v FROM ac WHERE v LIKE "%'.addslashes($q).'%"')) {
            while (!$rs->EOF) {
                echo $rs->fields[0],"\n";
                $rs->MoveNext();
            }
        }
    }
}
?>

Thanks,