hi!! tnx for the help with that huge problem... got it running and this is how...
the query ...username='...' and pwd=md5(...) was in "" and i guess when you have something like that putting '' in an index name is illegal?? can somebody explain why? and on the line: if(.....) {... num_of_rows() doesnt work because when $result == false it doesnt know how to deall with NULL for the num of rows returned... the final line then is: if($result==false) {//test the query itself..if false then print whatever } else {//if it did work then do this...} but of course it could always be turned around to: if($result==true) {...} but dont know what way is better or if it is a personal choice...