[RESOLVED] Search on multiple fields - sprintf()

slowgin

After a day of Googling, Searching forums, experimenting and reading the PHP Manual it is time to concede that I need help.

I am using Dreamweaver CS4 and it has produced the code below which will search on one field and produce the correct result. I would like to be able to search on all the fields in the table - please could someone guide me. Many thanks.

$query_Address = sprintf("SELECT Fname, Lname, House, Add1, Add2, Town, County, Pcode, Tel1, Tel2, Tel3, Comment FROM address WHERE Fname LIKE %1s ORDER BY Lname ASC", GetSQLValueString($colname_Address . "%", "text"));

jkurrle

Something like this?

$query_Address = sprintf("
    SELECT    Fname, Lname, House, Add1, Add2, Town,
              County, Pcode, Tel1, Tel2, Tel3, Comment 
    FROM      address 
    WHERE     Fname LIKE %1s
    OR        Lname LIKE %1s 
    OR        House LIKE %1s
    ORDER BY  Lname ASC", GetSQLValueString($colname_Address . "%", "text"));

slowgin

Thanks - I had tried that and got:-
Warning: sprintf() [function.sprintf]: Too few arguments in D:\Server\xampplite\htdocs\address.php

Still open for suggestions - Cheers 🙂

igorek

jkurrle;10952777 wrote:

Something like this?

$query_Address = sprintf("
    SELECT    Fname, Lname, House, Add1, Add2, Town,
              County, Pcode, Tel1, Tel2, Tel3, Comment 
    FROM      address 
    WHERE     Fname LIKE %1s
    OR        Lname LIKE %1s 
    OR        House LIKE %1s
    ORDER BY  Lname ASC", GetSQLValueString($colname_Address . "%", "text"),GetSQLValueString($colname_Address . "%", "text"),GetSQLValueString($colname_Address . "%", "text"));

try that should be enough arguments now =D

bradgrafelman

Alternatively, since all of the parameters are the same, you could do this:

$query_Address = sprintf(' 
    SELECT    Fname, Lname, House, Add1, Add2, Town, 
              County, Pcode, Tel1, Tel2, Tel3, Comment 
    FROM      address 
    WHERE     Fname LIKE %1$s 
    OR        Lname LIKE %1$s 
    OR        House LIKE %1$s 
    ORDER BY  Lname ASC', GetSQLValueString($colname_Address . "%", "text"));

(I believe this is what igorek intended to do previously - he just left off the dollar signs.)

slowgin

🙂 Brilliant.
I have been through so many variants. I could have sworn I had tried the %1$s.

If I had, I obviously got it wrong - so Many Many thanks for your help.

Cheers
Rob

igorek

bradgrafelman;10952785 wrote:
(I believe this is what igorek intended to do previously - he just left off the dollar signs.)

sprintf(); is a very powerful function. I only seen the use of it when I was coding in dreamweaver and therefor did not know all its abilities. the above is an example of The format string supports argument numbering/swapping. which is very cool if you do not have your $args in correct order of type specifier and at the same time if you only use the same $arg.

I appologize for the misconception of error message I should of gave it more time and attention, yet because of it I have added a powerful function to my arsenal 🙂

P.S. Interesting question, easy test solution but came to mind, the type specifier possible types in the format -- have to also follow order just like conversion specifications do? most likely not but just interesting. Then you would have to align the $args to match the types and the would become type numbering/swapping.

slowgin

For anyone interested the link below is from the PHP manual and gives an excellent description of the function and full list of it parameters.

http://uk2.php.net/manual/en/function.sprintf.php