troubleshooting Question

PHP Code ignitor

Avatar of Robert Granlund
Robert GranlundFlag for United States of America asked on
PHPAJAXMySQL ServerWeb Frameworks
4 Comments1 Solution154 ViewsLast Modified:
I'm trying to write a query in CodeIgnitor and am a little stuck.

What I want to do is set up a variable.  The variable is either equal to $_GET['var']  or it is equal to anything

So when the query runs it will either thry to match the var in that field or it will return anything from that field if it has an entry or if it is empty.

	if (!empty($_GET['interface'])) {
		$interface = $_GET['interface'];
	} else {
		$interface = ' NULL OR NOT NULL';
	}

$query ->
-> from('exp_channel_data t1') 
	-> where('t1.entry_id', $related_id)
	-> where('t1.field_id_4911', $interface) 
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros