Newbie passing arguments - please help

[unkempt]

ok so im passing arguments to a function i.e.

[pre]function getAllStaff ($live, $tblname) {[/pre]

 

but how do i get $tblname argument to replace "staff" (the table) in the following code:

 

[pre]$sql = sprintf("SELECT * FROM staff WHERE live = '%s';",

                    $live);[/pre]

 

Hope you can help

[wildteen88]

As you're using sprintf, then add tblname as the second parameter, eg:

[tt]$sql = sprintf("SELECT * FROM %s WHERE live = '%s';", $live, $tblname);[tt]

[ansarka]

why you want to use like this

change the below code

$sql = sprintf("SELECT * FROM staff WHERE live = '%s';",
                    $live);

 

TO

 

$sql = "SELECT * FROM ".$tblname."  WHERE live ='".$live."'";

 

OR

$sql = "SELECT * FROM $tblname  WHERE live ='$live'";

 

OR

$sql = 'SELECT * FROM '.$tblname.'  WHERE live ='.$live;

[unkempt]

Thanks but that didn't seem to work - here is my function - does this look correct:

 

[pre]function getAllWorks ($live, $tblname) {

// Create SQL statement

$sql = sprintf("SELECT * FROM %s WHERE live = '%s';", $live, $tblname);

// Trace the query in the NetConnection debugger

//NetDebug::trace($sql);

// Run query on database

$result = mysql_query($sql);

 

$return = Array();

while($row=mysql_fetch_object($result)) {

$row->last_updated = $this->datetime_mysql_to_mysoup($row->last_updated);

array_push($return, $row);

}

return $return;

}

[/pre]

 

 

[unkempt]

Thanks this worked

 

[pre]$sql = "SELECT * FROM $tblname  WHERE live ='$live'";[/pre]

 

I was using someone elses code that helped me previously - what is the reason that they would have used sprint

[ansarka]

that you should ask them

 

all programmers will have there own style of coding

 

 

your sprint also work if you change it to

 

$sql = sprintf("SELECT * FROM %s WHERE live = '%s';", $tblname,$live); 

[unkempt]

Thankyou all - this is my first post here - you have all been very helpfull - great forum