Justtechjobs.com Find a programming school near you






Online Campus Both


php4-beta | 199912

[PHP4BETA] Searching a MySQL DB... From: Matt Greene (matt <email protected>)
Date: 12/20/99

Ok this doesnt have a lot to do with php but it uses it and i figured the
people on this list are also mysql experts also. :)

What i am asking is how can i search a column for any data that begins with
a certain letter. in other words use wildkards or somthing?

This example most likely does not work but this is just here to show you a
little mroe of what i mean:

$query = "SELECT * FROM $tbcont WHERE namef = 'A*' ";
$result = mysql_db_query( "$dbname", $query, $sqlcon);

if ($result) {
    while ($r = mysql_fetch_array($result)) {
        blah........
    }
} 

-- 
PHP 4.0 Beta Mailing List <http://www.php.net/version4/>
To unsubscribe, e-mail: php4beta-unsubscribe <email protected>
For additional commands, e-mail: php4beta-help <email protected>
To contact the list administrators, e-mail: php4beta-admin <email protected>