What is the matter ???

Okay, guys, I am having an impossible time with this program. Either it is a lack of clear tutorial directions or something is just not working as it should

I am trying to create 2 things: a secure zone for dealers to login and register, and a data search for their orders.

When I use the wizards for example, the pages are producing blank white pages whether or not I have security attached to them.
When creating search for orders, It is creating only the search criteria form, but NO results pages. I realize I am using a template page with a DB connection as a base, but nothing seems to produce the results pages. Using a single Search page is not working either.

I am completely frustrated by this set of programs and not sure why things are not working as they did years ago where automation is / was pretty simple. I NOTE that I am trying to use existing tables in the DB to search not using the Orders table created by WA, but that shouldn't be a problem. My orders are not in the orders table!

DealerOrders.php

<?php
$Paramkey_WADArequests = "-1";
if (isset($_GET['key'])) {
$Paramkey_WADArequests = $_GET['key'];
Doing a search set of pages from scratch with blank pages, I am getting this error:

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 'key, Jewelry_Type, Setting_Style, Head_Type FROM requests WHERE Dealer_ID LIKE '' at line 1


This is the request//

mysql_select_db($database_Ben, $Ben);
$query_WADArequests = sprintf("SELECT key, Jewelry_Type, Setting_Style, Head_Type, Prong_Style, Gallery, Shank_Metal, Shank_KaratsW, Shank_KaratsY, Shank_Style, Inside_Shank, Shank_Height, Shank_Width, Edge_Finish, Finger_Size_Main, Finger_Size_half, Gender, Main_Diamond_Shape, MD_Carat, MD_MM_Size, Crown_HeightMM, MD_Color, MD_Clarity, Shoulder_DIamonds1_Shape, SD1_Quantity, SD1_Carat, SD1_MM_Size, SD1_Color, SD1_Clarity, Shoulder_Diamonds2_Shape, SD2_Quantity, SD2_Carat, SD2_MM_Size, SD2_Color, SD2_Clarity, Other_Diamonds_Shape, OD_Quantity, OD_Carat, OD_MM_Size, OD_Color, OD_Clarity, First_Name, Last_Name, Email, Comment, Phone, Call_Time, Address, City, State, Country, Zip FROM requests WHERE key = %s", GetSQLValueString($Paramkey_WADArequests, "int"));
$WADArequests = mysql_query($query_WADArequests, $Bendannie) or die(mysql_error());
$row_WADArequests = mysql_fetch_assoc($WADArequests);
$totalRows_WADArequests = mysql_num_rows($WADArequests);
?>

It looks like you are using a reserved word as a field name.

I'm pretty sure that 'Key' is a reserved mySQL word that can't be used as a field name.

Cheers
Ian

yes that was the problem... the "key" field was created automatically by my database. Very dumb.


Still can't get security features to work properly... and I'm not sure the update feature is working properly because the order number does not show when the form loads. And when you press update, it produces a blank page: requests_update.php...

White pages can mean there is a PHP error occurring on the page or you have whitespace in-between PHP tags.

If you add

<?php
ini_set('error_reporting', E_ALL);
?>

to the top of one of your pages it should tell you where the problem lies. If you still don't get an error then remove any spaces after closing PHP tags, or carriage returns between PHP tags if they exist.

Cheers
Ian

Originally Said By: Ian S

  

<?php
ini_set('error_reporting', E_ALL);
?>

  

Hi, I had checked for whitespace errors but did not find any. Checked in BBEdit, no CRs either. I tried the error code and still got a white page and not results.

I'd probably need to see a copy of your code to troubleshoot further, if its not displaying an errors.

Can you zip it up and attach it to your next post?

Cheers
Ian

Okay, here it is. Thanks.

Thanks.

I am a bit confused by the code to be honest.

There are two record sets on the page with identical names, so there is a conflict straight away.

The first one seems to be working with a Tom Muck extension to create a dynamic search.

In the second copy of the recordset you are referencing a Web Assist DA Search instance, but you don't have the Web Assist DA Search code on the page? Nor do you have the necessary includes for the Web Assist DA Search.

Cheers
Ian

Oh, The search code for WA was not working so I pulled it. Here is a revised page. No search on it, except an inactive form. I have security on it now. The linked files are uploaded, but it it is only producing a white page instead of redirecting to the login page.

What got me started is the security issue, but I'm also finding problems with the search pages not redirecting or finding detail pages... I keep starting over from scratch to get a clean set of pages, but nothing is working right.