Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STR

[ask9]

hi guys

 

I know this is very basic.

 

But this codes below has something wrong,

$sql="select count('.$postConfig['id'].') as numRows from '$crudTableName' WHERE username='$username'";

 

Thanks in advanced.

 

 

[Pikachu2000]

$sql="SELECT COUNT( {$postConfig['id']} ) AS numRows FROM '$crudTableName' WHERE username = '$username'";

[ask9]

@Pikachu2000

 

thanks, I copied your codes,

 

and this is the new error below,

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''orgs' WHERE username='solid9'' at line 1

 

 

 

 

[ask9]

I fixed the problem with this codes below,

 

$sql="select count({$postConfig['id']}) as numRows FROM $crudTableName WHERE username='$username'";

[Pikachu2000]

I corrected the PHP parse error. The second one was a SQL syntax error, but I see you've figured that out . . .