I was reconstructing the website & i m stuck at a place where i need help..
My website is all about purchasing digital goods online.
First of all i have inserted all data Assist wizard pages.. like productserach,results,details & etc pages etc...
on detail page i have added a add to cart button. everythign functioning properly.
now in product search page when a there is no value entered it takes me to result page & shows all the products available..
So how we show if something wrong is entered on search product text field..
& in Product DB, i have entered a new field called ProductUser. Here i store UserID of a user.
Mainly i have some product for particular users only.. so please help me on this..
i tried changing values some values @ product result page i.e
DataAssist search server behavior, i set the default where clause to:
0 <> 0
& so when i run the page empty ie. if i open only productresult.php page then i get error like --->
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 '0 <> 0 ORDER BY ProductName ASC LIMIT 0, 5' at line 1
I have attached da file please look into it.