* Gilles Ganault: > Is this the standard way to check that a row exists in PHP/SQLite, or > is there a better syntax?
> $query = "SELECT count(*) FROM contacts WHERE contacts_phones_tel GLOB '%s*'; This query stops after the first match: SELECT 1 FROM contacts WHERE contacts_phones_tel GLOB ? LIMIT 1 > $query = sprintf($query,$row['calls_phones_tel']); Danger: SQL injections lurks here. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users