multiline sql query using sprintf

[classmaze]

Hi am using following format for queries

$sql = sprintf ( "SELECT 
                                       *
                                       FROM
                                       tablename
                                       WHERE
                                       userid = %s",
                                       $userid
);

but found that other developer had used the following format

$sql = sprintf ( "SELECT " . 
                                       "* " . 
                                       "FROM " .
                                       "tablename " .
                                       "WHERE " .
                                       "userid = %s ",
                                       $userid
);

they both working fine.

which format is good practice?

Thanks

[dagon]

the first is easier to read, less likely for you to make a mistake and will parse faster (fractionally)

[classmaze]

thanks. i am already doing that way. confusion cleared