[Resolved] sprintf

Hanlie

Hi,

I'm trying to understand how to send two IDs to a delete statement, but I can't quite get it right.

At the moment the code looks like this:

sprintf("DELETE FROM arms_screen_control WHERE screen_id=%s AND control_id=%s",
    	                   GetSQLValueString($_GET['screenID'], "int")
						   GetSQLValueString($_GET['controlID'], "int"));

GetSQLValueString converts the numbers into strings.

Does sprintf know to put the first argument (screenID) in where %s appears first and to put the second argument (controlID) where %s appears second?

Thanks
Hanlie

njm

Read the manual - it describes in detail how the function works, including argument swapping.

hth, njm

Hanlie

Originally posted by njm
Read the manual - it describes in detail how the function works, including argument swapping.

hth, njm

I have read the manual, but it's not entirely clear to me; I don't think the manual is aimed at newbies, let alone people like me who are not really programmers but who got stuck with a PHP assignment.

LordShryku

Well, using sprintf or this is un-neccesary. Also, converting numbers to strings or vice-versa is not needed. This could just be written like this:

$sql = "DELETE FROM arms_screen_control
              WHERE screen_id = '".$_GET['screenID']."'
                AND control_id = '".$_GET['controlID']."'";

Do what you want with it from there. echo it. execute it. Whatever.

Hanlie

Thank you very much, LordShryku, your help did the trick