Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › MySQLi Server Behaviors › MySQLI Server Behaviors General / Announcements › MySQLi query where target from $_GET is a column?

View all replies to this thread

MySQLi query where target from $_GET is a column?

Thread began 3/28/2016 9:20 am by Steve | Last modified 3/28/2016 3:13 pm by Steve | 3116 views | 10 replies

3/28/2016 12:18 pmSteve

Dave, it is a string not an integer. Thank you for your reply.

BTW, to move forward I've excluded the Web Assist variable and went with a simpler, direct query:

<?php if(isset($_GET['id'])) {
$target = $_GET['id'];
 ?>

<?php
$Recordset1 = new WA_MySQLi_RS("Recordset1",$redacted_i,0);
$Recordset1->setQuery("SELECT `id`,`setDate`,`fName`,`lName` FROM applications WHERE $target = 1 AND status != 3 ORDER BY applications.id DESC ");
$Recordset1->execute();
?>

It works but was not my first choice.

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.