DataAssist help

I was reconstructing the website & i m stuck at a place where i need help..
PLEASE ASAP.

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.

your recordset already has a where clause in it, so i think the default where clause should be:
AND 0 <> 0

if that does not fix the error, change the following line:

$WADAproducts = mysql_query($query_limit_WADAproducts, $Connection1) or die(mysql_error());

to:

$WADAproducts = mysql_query($query_limit_WADAproducts, $Connection1) or die(mysql_error()."<br />".$query_limit_WADAproducts);

this will write the sql causing the error to the page so we can look into it further.

i made both the changes. in productresult.php page it still shows all the products available for that user. & Now i m getting many errors ->

Missing argument 2 for GetSQLValueString(), called in C:\xampp\htdocs\AniSnapFeb\products_Results.php on line 93 and defined in C:\xampp\htdocs\AniSnapFeb\products_Results.php on line 47

Notice: Undefined variable: theType in C:\xampp\htdocs\AniSnapFeb\products_Results.php on line 59

Notice: Undefined variable: theType in C:\xampp\htdocs\AniSnapFeb\products_Results.php on line 60

Notice: Undefined variable: theType in C:\xampp\htdocs\AniSnapFeb\products_Results.php on line 63

Notice: Undefined variable: theType in C:\xampp\htdocs\AniSnapFeb\products_Results.php on line 66

Notice: Undefined variable: theType in C:\xampp\htdocs\AniSnapFeb\products_Results.php on line 69





i have attached file once again. please look into it.

there you the file..

Im a lot of this error all time.. Parse error: syntax error, unexpected ';' in C:\xampp\htdocs\AniSnapFeb\SnapDetail.php on line 101


This is another page.. It says unexpected ";" so if i remove ':' i get error like this -->

Parse error: syntax error, unexpected T_STRING in C:\xampp\htdocs\AniSnapFeb\SnapDetail.php on line 102

btw these above errors used to come even at productresult.php page ( that is uploaded in my previous post.
I have uploaded SnapDetail.php page. please look into it also.. ty

the code for the products is duplicated on your results page. delete the code at lines 88 - 97:

$colname_WADAproducts = "-1";

if (isset($_SESSION['SecurityAssist_UserID'])) {

  $colname_WADAproducts = (get_magic_quotes_gpc()) ? $_SESSION['SecurityAssist_UserID'] : addslashes($_SESSION['SecurityAssist_UserID']);

}

mysql_select_db($database_Connection1, $Connection1);

$query_WADAproducts = sprintf("SELECT * FROM products WHERE productUser = %s ORDER BY ProductName ASC", GetSQLValueString($colname_WADAproducts));

$query_limit_WADAproducts = sprintf("%s LIMIT %d, %d", $query_WADAproducts, $startRow_WADAproducts, $maxRows_WADAproducts);

$WADAproducts = mysql_query($query_limit_WADAproducts, $Connection1) or die(mysql_error()."<br />".$query_limit_WADAproducts);

$row_WADAproducts = mysql_fetch_assoc($WADAproducts);

i think the error you are getting is caused by line 116:

$query_WADAproducts = sprintf("SELECT * FROM products WHERE productUser = %s ORDER BY ProductName ASC", GetSQLValueString($colname_WADAproducts, "-1"));

this should be changed to:

$query_WADAproducts = sprintf("SELECT * FROM products WHERE productUser = %s ORDER BY ProductName ASC", GetSQLValueString($colname_WADAproducts, "int"));

on the detail page line 101:

$query_WADAuploads = sprintf("SELECT UploadID, UploadedFileName, Comments, Status, AniSnapImg, UploadThumb, AniSnapCode FROM uploads WHERE UploadID = %s OR ( -1= %s AND UploadID= %s)", GetSQLValueString($ParamUploadID_WADAuploads,"int"),GetSQLValueString($ParamUploadID2_WADAuploads)

should be:

$query_WADAuploads = sprintf("SELECT UploadID, UploadedFileName, Comments, Status, AniSnapImg, UploadThumb, AniSnapCode FROM uploads WHERE UploadID = %s OR ( -1= %s AND UploadID= %s)", GetSQLValueString($ParamUploadID_WADAuploads, "int"),GetSQLValueString($ParamUploadID2_WADAuploads, "int"),GetSQLValueString($ParamSessionUploadID_WADAuploads, "int"));

I made all the changes .. @ snapdetail.php page i m not getting any errors but all the products are FOR THAT USER IS been shown in productresult page only when blank entry/anything is typed search product text field. (i.e in snapdetail.php page )

& in snapdetail.php page others details can be checked by other users (i.e by using ********/SnapDetail.php?UploadID=8) n etc.

No errors are displaying.. but i dont want to show other upload details to others & dont want to show all product in productresult page even when u type something wrong..

In snapdetail.php page everything is displayed with this error ---->
Undefined variable: Products in C:\xampp\htdocs\AniSnapFeb\SnapDetail.php on line 298
Warning: mysql_free_result() expects parameter 1 to be resource, null given in C:\xampp\htdocs\AniSnapFeb\SnapDetail.php on line 298

other users can view other details in this page still.

on the detail page, you have not added a condition to the recordset where clause for the user ID, you need to configure the recordset to filter using the user ID session variable.


at line 298 you have the following code:
mysql_free_result($Products);

that recordset does not exist on this page, delete it.

for the results page, to help troubleshoot, add the following code after the body tag and post back the SQL that it outputs:

<?php echo("SQL: ".$query_limit_WADAproducts); ?>

At result page i m getting two errors...

Notice: Undefined variable: query_WADAproducts in C:\xampp\htdocs\AniSnapFeb\products_Results.php on line 91
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\AniSnapFeb\products_Results.php on line 92




& @ the end of the productresult page i m getting error like this-->


SQL: SELECT * FROM products WHERE productUser = 1 ORDER BY ProductName ASC LIMIT 0, 5