HighDots Forums  

Results page does not work correct

Macromedia Dreamweaver Macromedia Dreamweaver Discussions (macromedia.dreamweaver)


Discuss Results page does not work correct in the Macromedia Dreamweaver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Deon
 
Posts: n/a

Default Results page does not work correct - 07-02-2006 , 10:11 AM






Hi there,

DW 8.0.2 with PHP & mySQL

Database: 9 Fields with, amongst others, the following:

Field Type Collation Attributes Null Default Extra
pack_id bigint(10) - -- No -- auto_increment
three_phase decimal(5,1) - -- Yes 0.0 ---

I have a form with "get" to search through this table and goes to
results.php
This is the SQL statement for the RecordSet:

SELECT *
FROM tractorpacks
WHERE three_phase LIKE %colname%

Name: colname
Type: Numeric
Default Value: -1
Run-time Value: $_GET['three_phase']

The default value I have changed to % without any success.

Here's my problem:
When clicking the "TEST" button and I leave the little box where I have
to put in some value OPEN, all my records display.

When I do this through my browser, no data is returned. BUT, when I put
in "1", all the records with "1" in the specific field, return.

What I want to have, is that when I fill nothing in as a criteria, all
the records must return. I have it like this at
www.sincro.co.za/alternators/index.php and this is another query from
the same db but I cannot get this one to work.

I will REALLY appreciate your help here.

Regards,
Deon

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.