TalkPHP - View Single Post

Tanax · 11-03-2007, 05:13 PM

Actually I thought of something, the $aArgs is an array?

So if I do like:

PHP Code:


			
getUsernameByWarnings(5, 'warnings');

PHP Code:


			
            $sql = sprintf("    SELECT `%s`
                    FROM `%s`
                    WHERE `%s` = %s
                    LIMIT 1",
                    $aKeywords[1][0],
                    mysql_parse_value($aArgs[1]),
                    $aKeywords[2][0],
                    mysql_parse_value($aArgs[0]));

Wouldn't that work?

EDIT:
And that would get every user, who has 5 warnings, from the warnings table.

11-03-2007, 05:13 PM	#10 (permalink)
Tanax The Prestige Join Date: Sep 2007 Location: Sweden, Stockholm Posts: 1,080 Thanks: 115	Actually I thought of something, the $aArgs is an array? So if I do like: PHP Code: `getUsernameByWarnings(5, 'warnings');` PHP Code: $sql = sprintf(" SELECT `%s` FROM `%s` WHERE `%s` = %s LIMIT 1", $aKeywords[1][0], mysql_parse_value($aArgs[1]), $aKeywords[2][0], mysql_parse_value($aArgs[0])); Wouldn't that work? EDIT: And that would get every user, who has 5 warnings, from the warnings table. Last edited by Tanax : 11-03-2007 at 07:35 PM.