PDA

Click to See Complete Forum and Search --> : STRANGE PROBLEM

Anon
02-04-2001, 11:02 AM
Strange thing happened the other day. When I was running a query on my Win98 machine. I needed to get two windows open and view them at the same time....SO, I resized the one window running my PHP web page. Well, everytime I resized that window, PHP started to run another query of some sort that returned nothing after a long time.

Has anyone run into this before? How the heck do I fix this?

Thanks,
Mike
Anon
02-06-2001, 10:17 PM
Were you using Netscape?
Anon
02-06-2001, 10:41 PM
No, i'm using Internet Explorer 5.5? I've never seen anything like this?
Anon
02-07-2001, 11:27 AM
Do you have any code (Java) which causes a refresh of the page if it is resized. Dreamweaver has code it can put in pages to redraw the screen if the window dimensions are altered aftert he page is loaded. Coul be that the refresh does not call the query with all the variables it requires.
Anon
02-07-2001, 04:03 PM
can you take a peek at the site and let me know if you get the requery when resized.

http://24.65.238.253/search.php
Anon
02-07-2001, 08:11 PM
The JavaScript causes the refresh of the page as it repositions the layers and stuff. Odd though, as my query finds 141 results, mostly double-ups, and the post-resize query finds just 15 with no double-ups. Might want to check your SQL command in the back of that.
Ditch the layering stuff and you'll be fine (assuming your SQL is OK).
Anon
02-07-2001, 08:38 PM
Thanks for the advice, we've tried several times to modify the SQL that is causing the same person to show up multiple times but haven't had any luck with it.

Can you take a peek at it? Here's the SQL statement:
$query = "SELECT clients.cusername, CFirstName,CLastName,CEmail,CCity
FROM clients,interests
WHERE
((I1 = '$Interests' OR I2 = '$Interests' OR I3 = '$Interests' OR I4 = '$Interests' OR I5 = '$Interests' OR I6 = '$Interests' OR I7 = '$Interests')
OR (CCity LIKE '$C%%%%%%%%%%%%%%%%%%%%%'
OR CPicture LIKE '$C%%%'
OR CEyeColor LIKE '$C%%%%%%%%%%%%%%%%%%%%%'
OR CHairColor LIKE '$C%%%%%%%%%%%%%%%%%%%%%'
OR CKids LIKE '$C%%%%%%%%%%%%%%%%%%%%%'
OR CBody LIKE '$C%%%%%%%%%%%%%%%%%%%%%'
OR CEducation LIKE '$C%%%%%%%%%%%%%%%%%%%%%'
OR CChurch LIKE '$C%%%%%%%%%%%%%%%%%%%%%')
AND clients.CUserName = interests.CUserName)
ORDER BY CCity, CLastName
";

Thanks for your help