Quick Boolean Question

Codewalkers Forums Sponsor:

Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here

September 9th, 2003, 09:53 AM

Anonymous

Registered User

Codewalkers God 35th Plane (22000 - 22499 posts)

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 24

Quick Boolean Question

if your seraching a DB using a HTML form is it possible to seach the DB with some fields left empty?

ie.

name = david
dob =
city = glasgow

php Code:

Original - php Code
$thisquery = SELECT * from data WHERE name = '$name' AND dob = '$dob' AND city = '$city;

 $thisquery = SELECT * from data WHERE name = '$name' AND dob = '$dob' AND city = '$city;

so that would search the table named data for a result where name = 'david', dob='' and city = 'glasgow'.

would this work properly?

reason i ask is because i ran this query in myphpadmin and although the query was performed succesfuly it didnt produce any results....

cheers!

david*

September 9th, 2003, 11:17 AM

Matt

Moderator

Codewalkers Specialist (4000 - 4499 posts)

Join Date: Apr 2007

Location: Florida

Posts: 4,158

Time spent in forums: 4 h 10 m 20 sec
Reputation Power: 6

RE: Quick Boolean Question

No...you'll need to build your query dynamically based on what form fields are set....

Here is a mini example:

php Code:

Original - php Code
$where = array(); if(isset($_POST['field1']) { $where[] = "db1 = '$_POST[field1]'"; } if(isset($_POST['field2']) { $where[] = "db2 = '$_POST[field2]'"; } if(isset($_POST['field3']) { $where[] = "db3 = '$_POST[field3]'"; } $where = implode(" AND ", $where); $sql = "SELECT * FROM table WHERE $where";

$where = array();
if(isset($_POST['field1']) {
    $where[] = "db1 = '$_POST[field1]'";
}
if(isset($_POST['field2']) {
    $where[] = "db2 = '$_POST[field2]'";
}
if(isset($_POST['field3']) {
    $where[] = "db3 = '$_POST[field3]'";
}
$where = implode(" AND ", $where);
$sql = "SELECT * FROM table WHERE $where";

Hope that helps...

September 9th, 2003, 01:16 PM

Anonymous

Registered User

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 24

RE: Quick Boolean Question

very cool matey, cheers.

heard but never used the implode function. going to check it out right now.

this is resolved,

david*

Viewing: Codewalkers Forums > Other Technologies > Database Help > Quick Boolean Question

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

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

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump