MySQL Forums
Forum List  »  MyISAM

QUERY PROBLEM
Posted by: manu chowdry
Date: September 19, 2005 06:48AM

M Using this query

$db1=mysql_query("SELECT tbl1.field1, tbl1.field2,tbl1.field3, tbl1.field4,tbl1.field5, tbl2.field1 FROM `tbl1`,`tbl2` where tbl1.field1='$cat' OR tbl1.fieldvalue2 BETWEEN '$pricerange1' AND '$pricerange2'");


BUT ITS NOT WORKING PROPERLY IT SHOULD SHOW ONLY SPECIFIC RECORDS FROM TBL1 , BUT IT IS SHOWING MORE THAN ONE TIEM....

CAN ANYBODY HELP

Options: ReplyQuote


Subject
Views
Written By
Posted
QUERY PROBLEM
2387
September 19, 2005 06:48AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.