Hi jam,
thanks. It was some help.
Using this i can now search with call_no and isbn which are both int type. But i can't do the searching using the same code for string value searching:
Code: Select all
if($_POSTї'R1'] =='V2'){
$sql = "Select * FROM book WHERE author1=('{$_POSTї'author']}')";}
As far as i know Something about SQL i know that to searcha table with string i must quote it first...like
Code: Select all
Select * from book where author='topu';
So, i did add a quote with this part of code
Code: Select all
author1='('{$_POSTї'author']}')"';}
I wonder what i m doing wrong? i added double quoto (" ")first it gave me parser error and second time i used single quoto (' ')..this time it doest not give me any error but it simply can't retrive any data..it just shows the table structure and the column heading..but no value...
Can u tell me what M i doing wrong?