Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › SELEACT statement

SELEACT statement

Thread began 10/18/2017 7:34 am by Jamie | Last modified 10/18/2017 1:34 pm by Ray Borduin | 552 views | 2 replies |

10/18/2017 7:34 am | #1 Jamie

SELEACT statement

Hey Ray

Further to the prem ticket yesterday, how do I correctly structure this SELECT statement

$query_ProductOptions = "SELECT * FROM product_options";
if (isset($_POST['Option'])) {
	$query_ProductOptions .= " WHERE OptionID = " . intval($_POST['Option']);
}

to be this (which I must have a syntax error in as it doesnt sort or filter if record is live / not live

$query_ProductOptions = "SELECT * FROM product_options";
if (isset($_POST['Option'])) {
	$query_ProductOptions .= " WHERE OptionID = " . intval($_POST['Option']) . " AND Live = 1 ORDER BY OptionOrder ASC";
}

cheers

10/18/2017 10:42 am | #2 Ray BorduinWebAssist

php:

$query_ProductOptions = "SELECT * FROM product_options WHERE Live = 1 ";

if (isset($_POST['Option'])) {

    $query_ProductOptions .= " AND OptionID = " . intval($_POST['Option']);

}

$query_ProductOptions .= " ORDER BY OptionOrder ASC";

Did this help? Tips are appreciated...

10/18/2017 12:56 pm | #3 Jamie

thanks mate

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.