problem with SELECT and WHERE

[putrisakura]

I have table investor with field ID, name, payment and so on. the problem now is, I want to display the record based on ID. I used the WHERE clause but it didn't work. Below are some of coding I already tried :

 

"SELECT payment from investor WHERE ID='' ";            OR

"SELECT payment from investor WHERE ID='%s'"          OR

"SELECT payment from investor WHERE ID LIKE '' "        OR

"SELECT payment from investor WHERE ID LIKE '%s' "   

 

Any other ideas? all the above coding I used will not display any output at all. Sorry, I could not refer to books coz the library closed for maintainance.   

Please help me A.S.A.P.

 

Thank u.

 

[NargsBrood]

are you getting an error or just no results?

 

is your ID field a numerical or a string?

 

if it is string then:

try '%S' vs '%s'

 

Use:

SELECT payment FROM invester WHERE ID LIKE '%'

if nothing is returned then your table is empty.

 

 

[putrisakura]

there are records in my table but there is no result displayed.

 

I've tried

SELECT payment FROM invester WHERE ID LIKE '%' but it display all the data in table.

 

when i tried %S, there is no data displayed.

 

why this can be happened? actually the ID type id varchar.

[fenway]

Echo the raw query string... that looks like printf().