Creating a statement via dropdowns

	Home Register Search Help Login

Sponsors
Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax
Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.
Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Recent Posts
Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Creating a statement via dropdowns

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP, PHP, and Database >> Creating a statement via dropdowns

Page: [1]


siask Posts: 12 Joined: 4/21/2009 Status: offline	Creating a statement via dropdowns - 4/21/2009 10:13:29 right...here we go... new boy here... spent the last 2 months trawling this wonderful site for anwsers and today is the first time i've been stumped!... I want to create a statement from dropdown menu's... ie: Constructors_number IS equal to a value entered... Constructors_number will be a dropdown (Field1) Equal to will be a dropdown (also showing Greater than and Less then - should this be LIKE, MORE & LESS? (Option1) ) and a text box for the value (value1) My simple idea of coding would be something like this? SELECT * FROM robdata WHERE '::field1:: ::option1:: ::value1::' ORDER BY Constructors_Number Be gentle.... i've only been learning this FrontPage DRW & Access Database lark since Christmas! Also...is it possible to have a second set with And/Or between these?... clear as mud? Many thanks in advance Si