function addStyle() { $stylesheet = $_REQUEST['styleURL']; $user = $_SESSION['valid_user']; $name = $_REQUEST['styleName']; $query = "INSERT INTO stylesheets(name,creator,url) VALUES ('" . $name . "','" . $user . "','" . $stylesheet . "');"; //$query = "UPDATE user SET stylesheet='". $stylesheet . "' WHERE username='******'"; echo $query; return insertRow($query); }
function daoUpdateArticle($articleArray) { $articleArray['body'] = makeSafeForDAO($articleArray['body']); $articleArray['title'] = makeSafeForDAO($articleArray['title']); if ($articleArray['is_draft'] != "NULL") { $isdraft = 1; } else { $isdraft = "NULL"; } $query = "UPDATE articles SET " . "title='" . $articleArray['title'] . "'," . "body='" . $articleArray['body'] . "'," . "category=" . $articleArray['category'] . "," . "date_posted='" . $articleArray['date_posted'] . "'," . "time_posted='" . $articleArray['time_posted'] . "'," . "language=" . $articleArray['language'] . "," . "is_draft=" . $articleArray['is_draft'] . " WHERE articleid = " . $articleArray['articleid'] . ";"; debug($query); $result = insertRow($query); if ($result) { return 1; } else { return false; } }
function updateTable($inTableNode) { $myAttrList = $inTableNode->attributes(); $myTableName = $myAttrList["name"]; $myCmd = $myAttrList["command"]; echo "\n {$myCmd} table {$myTableName}"; $myRows = $inTableNode->xpath('Rows/Row'); $myRowCount = count($myRows); if ($myRowCount > 0) { foreach ($myRows as $myRow) { if ($myCmd == "Delete") { deleteRow($myTableName, $inTableNode, $myRow); } else { if (isRowFound($myTableName, $inTableNode, $myRow)) { updateRow($myTableName, $inTableNode, $myRow); } else { insertRow($myTableName, $inTableNode, $myRow); } } } } echo "\n------------------------------\n"; }
function migrateThreads($phorumTable, $forum_id) { global $phorum_db, $e107_threadTable, $e107_db, $memberIdTable; // select parentless messages (= start of a thread) $sql2 = "SELECT * "; $sql2 .= "FROM `" . $phorumTable . "`"; $sql2 .= "WHERE `parent` = 0"; mysql_select_db($phorum_db); $thread_list = mysql_query($sql2); // convert each message from Phorum to e107 while ($thread = mysql_fetch_array($thread_list)) { // get the body of the message (stored in a different table in phorum) $sql3 = "SELECT * "; $sql3 .= "FROM `" . $phorumTable . "_bodies` "; $sql3 .= "WHERE `id` = " . $thread['id']; mysql_select_db($phorum_db); $bodies = mysql_query($sql3); $msg_body = mysql_fetch_array($bodies); // set the thread ownership // TODO: create a function for messages migration ? // TODO: recursive call ? //if($thread['parent'] = 0) { // $msg_parent = 0; //} else { // $msg_parent = $thread['thread']; //} // set the thread moderation status if ($thread['approved'] != 'Y') { $msg_active = 0; } else { $msg_active = 1; } // set the ownership string if ($thread['userid'] == 0) { // get the ip of the anonymous poster not the host name if (isIp($thread['host'])) { $ip = $thread['host']; } else { // try to convert the hostname to ip $ip = gethostbyname($thread['host']); if (!isIp($ip)) { unset($ip); } } if (isset($ip)) { $ip = chr(1) . $ip; } $msg_owner = "0." . addslashes($thread['author']) . $ip; } else { $msg_owner = $memberIdTable[$thread['userid']]; } // array to describe how to migrate every data of the thread $msg_tab = array('thread_name' => addslashes($thread['subject']), 'thread_thread' => str_replace("[%sig%]", "", addslashes($msg_body['body'])), 'thread_forum_id' => $forum_id, 'thread_parent' => 0, 'thread_datestamp' => unix_date($thread['datestamp']), 'thread_active' => $msg_active, 'thread_user' => $msg_owner); // add the message in the e107 forum $e107Thread_id = insertRow($msg_tab, $e107_threadTable, $e107_db); $log .= " New thread \"" . stripslashes($thread['subject']) . "\" added with its first message n°" . $thread['id'] . "<br>"; // TODO: this part of function is the same as above, so we can factorise this part // get all messages sons of the current thread $log .= " Get all messages of the thread...<br>"; $sql3 = "SELECT * "; $sql3 .= "FROM `" . $phorumTable . "`"; $sql3 .= "WHERE `thread` = " . $thread['id'] . " AND `parent` <> 0"; mysql_select_db($phorum_db); $son_list = mysql_query($sql3); // convert each message from Phorum to e107 while ($son = mysql_fetch_array($son_list)) { // get the body of the message (stored in a different table in phorum) $sql4 = "SELECT * "; $sql4 .= "FROM `" . $phorumTable . "_bodies` "; $sql4 .= "WHERE `id` = " . $son['id']; mysql_select_db($phorum_db); $bodies = mysql_query($sql4); $son_body = mysql_fetch_array($bodies); // set the thread moderation status if ($son['approved'] != 'Y') { $son_active = 0; } else { $son_active = 1; } // set the ownership string if ($son['userid'] == 0) { // get the ip of the anonymous poster not the host name if (isIp($son['host'])) { $ip = $son['host']; } else { // try to convert the hostname to ip $ip = gethostbyname($son['host']); if (!isIp($ip)) { unset($ip); } } if (isset($ip)) { $ip = chr(1) . $ip; } $msg_owner = "0." . addslashes($son['author']) . $ip; } else { $msg_owner = $memberIdTable[$son['userid']]; } // array to describe how to migrate every data $son_tab = array('thread_name' => addslashes($son['subject']), 'thread_thread' => str_replace("[%sig%]", "", addslashes($son_body['body'])), 'thread_forum_id' => $forum_id, 'thread_parent' => $e107Thread_id, 'thread_datestamp' => unix_date($son['datestamp']), 'thread_active' => $son_active, 'thread_user' => $msg_owner); // add the message in the thread insertRow($son_tab, $e107_threadTable, $e107_db); $log .= " New son message \"" . stripslashes($son_tab['thread_name']) . "\" added to the thread.<br>"; } } return $log; }
function update($query) { //FIXME: this method does not exist in any of the mysql-files, insertRow? // same goes for delete() above here. Maybe insertRow should be renamed to insert rather? return insertRow($query); }
$page_name = isset($_POST['page_name']) ? mysqli_real_escape_string($con, $_POST['page_name']) : ''; $page_content = isset($_POST['page_content']) ? mysqli_real_escape_string($con, $_POST['page_content']) : ''; $page_slug = isset($_POST['page_slug']) ? mysqli_real_escape_string($con, $_POST['page_slug']) : ''; $page_site = isset($_POST['page_site']) ? mysqli_real_escape_string($con, $_POST['page_site']) : 0; $page_modified = date('Y-m-d H:i:s'); $page_author = CUSER; $page_slug = prettyslug($page_slug); if ($page_name == '' or $page_slug == '') { err("Užpildykite visus reikalaujamus laukelius", 'red'); } elseif (isset($_POST['newpage']) and countData('pages', "page_slug = '{$page_slug}' AND page_site = {$page_site}") > 0) { err("Tokia svetainės ir santrumpos kombinacija jau yra", 'red'); } elseif (isset($_POST['savepage']) and countData('pages', "page_slug = '{$page_slug}' AND page_site = {$page_site} AND page_id != " . $_GET['page']) > 0) { err("Tokią svetainės ir santrumpos kombinaciją jau turi kitas puslapis", 'red'); } else { if (isset($_POST['newpage'])) { $id = insertRow('pages', 'page_type, page_name, page_content, page_modified, page_author, page_slug, page_site', "0, '{$page_name}', '{$page_content}', '{$page_modified}', {$page_author}, '{$page_slug}', {$page_site}", false); if ($id) { redirect(0, '?p=' . page() . '&page=' . $id); } else { err('Puslapis nesukurtas', 'red'); } } elseif (isset($_POST['savepage']) and isset($_GET['page'])) { updateFieldWhere('pages', 'page_name', $page_name, 'page_id = ' . $_GET['page']); updateFieldWhere('pages', 'page_content', $page_content, 'page_id = ' . $_GET['page']); updateFieldWhere('pages', 'page_modified', $page_modified, 'page_id = ' . $_GET['page']); updateFieldWhere('pages', 'page_author', $page_author, 'page_id = ' . $_GET['page']); updateFieldWhere('pages', 'page_slug', $page_slug, 'page_id = ' . $_GET['page']); updateFieldWhere('pages', 'page_site', $page_site, 'page_id = ' . $_GET['page']); } else { } }
if ($user_person == '' or $user_cat == '' or $user_address == '' or $user_region == '' or $user_city == '' or $user_desc == '' or $user_phone == '' or $user_email == '' and $user_person == 1 or $user_fname == '' and $user_person == 0 or $user_lname == '' and $user_person == 0 or $user_orgname == '' and $user_person == 1 or $user_code1 == '' and $user_person == 1) { err("Užpildykite visus reikalaujamus laukelius", 'red'); } elseif (strlen($user_phone) != 11) { err("Netinkamas telefono numerio formatas", 'red'); } elseif (strlen($user_desc) < 5) { err("Aprašymas per trumpas", 'red'); } elseif ($user_email != '' and countData('users', "user_email = '{$user_email}'") > 0) { err("El. paštas {$user_email} jau yra įvestas į registruotų vartotojų duomenų bazę", 'red'); } elseif ($user_email != '' and countData('users', "user_phone = '{$user_phone}'") > 0) { err("Telefonas {$user_phone} jau yra įvestas į registruotų vartotojų duomenų bazę", 'red'); } elseif ($user_email != '' and countData('needy', "user_email = '{$user_email}'") > 0) { err("El. paštas {$user_email} jau yra įvestas į neregistruotų vartotojų duomenų bazę", 'red'); } elseif ($user_email != '' and countData('needy', "user_phone = '{$user_phone}'") > 0) { err("Telefonas {$user_phone} jau yra įvestas į neregistruotų vartotojų duomenų bazę", 'red'); } else { $id = insertRow('needy', 'user_person, user_fname, user_lname, user_orgname, user_code1, user_code2, user_reg, user_cat, user_address, user_region, user_city, user_phone, user_email, user_desc, user_registration_datetime', "'{$user_person}', '{$user_fname}', '{$user_lname}', '{$user_orgname}', '{$user_code1}', '{$user_code2}', '{$user_reg}', '{$user_cat}', '{$user_address}', '{$user_region}', '{$user_city}', '{$user_phone}', '{$user_email}', '{$user_desc}', '" . date('Y-m-d H:i:s') . "'"); if ($id and isManager()) { updateFieldWhere('needy', 'user_parent', CUSER, 'user_id=' . $id); updateFieldWhere('needy', 'user_parent_ta', getManagerParent(CUSER), 'user_id=' . $id); } elseif ($id and (isAdmin() or isGridManager())) { $user_parent = isset($_POST['user_parent']) ? mysqli_real_escape_string($con, $_POST['user_parent']) : 0; updateFieldWhere('needy', 'user_parent', $user_parent, 'user_id=' . $id); updateFieldWhere('needy', 'user_parent_ta', getManagerParent($user_parent), 'user_id=' . $id); } if ($id) { if ($_FILES and isset($_FILES['user_thumb']) and $_FILES['user_thumb']["tmp_name"] != '') { $upfilename = date('YmdHis') . str_replace('.', '_', uniqid('_', true)) . '.' . pathinfo($_FILES["user_thumb"]["name"], PATHINFO_EXTENSION); $upDirNative = ROOT_PATH . 'uploads' . DIRECTORY_SEPARATOR . 'needy' . DIRECTORY_SEPARATOR . $id . DIRECTORY_SEPARATO . 'native' . DIRECTORY_SEPARATORR; $upDirThumb = ROOT_PATH . 'uploads' . DIRECTORY_SEPARATOR . 'needy' . DIRECTORY_SEPARATOR . $id . DIRECTORY_SEPARATOR . 'thumb' . DIRECTORY_SEPARATORR; $upDirNativeUrl = ROOT_URL . 'uploads/needy/' . $id . '/native/'; $upDirThumbUrl = ROOT_URL . 'uploads/needy/' . $id . '/thumb/';
echo '<option value=' . $op[0] . '>' . $op[1] . '</option>'; } } ?> </select> <input type="submit" value="Priskirti" /> </form><br><br><?php } } else { updateFieldWhere('cats', 'deleted', $act, 'cat_id = ' . getParam()); redirect(0, $url = '?p=' . page() . (subpage() ? '&subp=' . subpage() : '') . (psl() ? '&page=' . psl() : '')); } } if (isset($_POST['addoption'])) { if (strlen($_POST['option1']) > 2) { insertRow('cats', 'cat_name, cat_type', "'" . $_POST['option1'] . "', " . $catType); redirect(0, $url = '?p=' . page() . (subpage() ? '&subp=' . subpage() : '') . (psl() ? '&page=' . psl() : '')); } else { err('Įveskite kategorijos vardą', 'red'); } } ?> <form action="" method="post"> Įtraukti naują kategoriją: kategorijos vardas <input type="text" name="option1" value="" /> <input type="submit" name="addoption" value="Įtraukti" /> </form> <?php $tablefields = array('cat_id', array('editable' => array('cat_name', 'cat_id', 'fc-verylong', '')), array('action' => array('cat_id', 'salinti', '<i title="Šalinti" class="fa fa-times"></i>', false)), 'null'); $tablehead = array('titles' => array('ID', 'Kategorijos vardas', '', ''), 'columns' => array('right fc-75', 'left', 'left fc-16', '')); $sortby = false; $where = 'SELECT * FROM cats WHERE cat_type = ' . $catType . ' ORDER BY cat_id DESC';
// var_dump("vorher: ".$row['id']." ".utf8_encode($row['name'])." ".utf8_encode($row['address'])); foreach ($address as $key => $value) { if ($key == $anzelem) { break; } $name .= $name == '' ? $value : "," . $value; } $ort = array_pop($address); // letztes Element $ort = utf8_encode(addslashes($ort)); $nam = utf8_encode(addslashes($name)); // var_dump("nachher: ".$row['id']." ".$nam." ".$adr." ".$ort); } else { $nam = utf8_encode(addslashes($row['name'])); $adr = utf8_encode(addslashes($address[0])); $ort = utf8_encode(addslashes($address[1])); } $mid = $anzahl; $lat = $row['lat']; $lng = $row['lng']; $typ = $row['type']; // Row in die DB einfuegen insertRow(); // Protokollausgabe echo '<td>' . $mid . '</td><td>' . $nam . '</td><td>' . $adr . '</td><td>' . $ort . '</td>'; echo '<td>' . $lat . '</td><td>' . $lng . '</td><td>' . $typ . '</td>'; echo '</tr>'; } echo '</table>'; echo "Anzahl Rows: " . $anzahl; mysql_close($connection);
} elseif (strlen($user_phone) != 11) { err("Netinkamas telefono numerio formatas", 'red'); } elseif ($user_name != '' and countData('users', "user_name = '{$user_name}'") > 0) { err("Vartotojas {$user_name} jau yra įvestas į registruotų vartotojų duomenų bazę", 'red'); } elseif ($user_email != '' and countData('users', "user_email = '{$user_email}'") > 0) { err("El. paštas {$user_email} jau yra įvestas į registruotų vartotojų duomenų bazę", 'red'); } elseif ($user_email != '' and countData('users', "user_phone = '{$user_phone}'") > 0) { err("Telefonas {$user_phone} jau yra įvestas į registruotų vartotojų duomenų bazę", 'red'); } elseif ($user_email != '' and countData('needy', "user_email = '{$user_email}'") > 0) { err("El. paštas {$user_email} jau yra įvestas į neregistruotų vartotojų duomenų bazę", 'red'); } elseif ($user_email != '' and countData('needy', "user_phone = '{$user_phone}'") > 0) { err("Telefonas {$user_phone} jau yra įvestas į neregistruotų vartotojų duomenų bazę", 'red'); } elseif ($user_acctype == 1 and $user_desc == '') { err("Neįvestas aprašymas", 'red'); } else { $id = insertRow('users', 'user_name, user_acctype, user_active, user_subscribed, user_password_hash, user_legalstatus, user_person, user_fname, user_lname, user_orgname, user_code1, user_code2, user_reg, user_address, user_region, user_city, user_phone, user_email, user_desc, user_registration_datetime', "'{$user_name}', {$user_acctype}, 1, 1, '{$user_password_hash}', {$user_legalstatus}, '{$user_person}', '{$user_fname}', '{$user_lname}', '{$user_orgname}', '{$user_code1}', '{$user_code2}', '{$user_reg}', '{$user_address}', '{$user_region}', '{$user_city}', '{$user_phone}', '{$user_email}', '{$user_desc}', '" . date('Y-m-d H:i:s') . "'"); if ($id and isGridManager()) { updateFieldWhere('users', 'user_parent', CUSER, 'user_id=' . $id); } if ($id) { myMail($user_email, 'Jūsų vartotojo paskyra sukurta', 'Jūsų pagalbadaiktais.lt ir pagalbadarbais.lt vartotojo paskyra sukurta.<br><br>Paskyros vardas: ' . $user_name . '<br>Slaptažodis: ' . $_POST['user_password_hash']); // take care of uploads $Core = new Core(); $result = $Core->uploadFile($id, null, ROOT_URL); if (!is_array($result)) { $errExpl = $Core->get('uploadFileWriteToFilesystemErrors'); $uperr = $errExpl[$result]; $thumb = 0; } else { $thumb = $result['fileThumb']; }
?> </select> <select name="need_subcat"></select> <input type="submit" value="Priskirti" /> </form><br><br><?php } } else { updateFieldWhere('cats', 'deleted', $act, 'cat_id = ' . getParam()); redirect(0, $url = '?p=' . page() . (subpage() ? '&subp=' . subpage() : '') . (psl() ? '&page=' . psl() : '')); } } if (isset($_POST['addoption'])) { if (strlen($_POST['option1']) > 2) { $cat_level = (isset($_POST['option2']) and $_POST['option2'] > 0) ? 1 : 0; $cat_parent = isset($_POST['option2']) ? $_POST['option2'] : 0; insertRow('cats', 'cat_name, cat_type, cat_level, cat_parent', "'" . $_POST['option1'] . "', " . $catType . ", {$cat_level}, {$cat_parent}"); redirect(0, $url = '?p=' . page() . (subpage() ? '&subp=' . subpage() : '') . (psl() ? '&page=' . psl() : '')); } else { err('Įveskite kategorijos vardą', 'red'); } } ?> <form action="" method="post"> Įtraukti naują kategoriją: kategorijos vardas <input type="text" name="option1" value="" /> Tėvinė kategorija <select name="option2"><option value="0">— Neturi —</option><?php foreach (listData('cats', 'cat_type = ' . $catType . ' AND deleted = 0 AND cat_level = 0') as $op) { echo '<option value=' . $op[0] . '>' . $op[1] . '</option>'; } ?> </select> <input type="submit" name="addoption" value="Įtraukti" />
<title><?php echo getenv('app_name'); ?> - DB Maintenance</title> <link rel="icon" type="image/png" href="favicon-32x32.png" sizes="32x32" /> <link rel="icon" type="image/png" href="favicon-16x16.png" sizes="16x16" /> </head> <body bgcolor="666666"> <!-- Handle POST action / Display result or error --> <?php if ($_SERVER['REQUEST_METHOD'] == 'POST') { echo "<table cellpadding=2 width='100%' bgcolor='FFFFFF'><tr><td>\n"; echo "<font face='arial' color='red'>\n"; if ($_POST["insert"] == 'Submit') { echo insertRow(addslashes($_POST["FortuneText"])); } elseif ($_POST["update"] == 'Submit') { echo updateRow($_POST["id"], addslashes($_POST["FortuneText"])); } elseif ($_POST["delete"] == 'Delete') { echo deleteRow($_POST["id"]); } echo "</font>\n</td></tr></table>"; } ?> <font face="arial" color="FFFFFF"> <h1>Devops Fortune Cookie - Database Maintenance </h1> </font> <font face="arial" color="FFFFFF"> <h2>Current Fortune List</h2>
if ($cover && copyArt($cover)) { uploadArt(basename($cover)); } else { echo "No album art found in {$path}.\n"; } } elseif (isset($row['art'])) { $cover = $row['art']; } // Add db columns $parameters['art'] = basename($cover); $parameters['listeners'] = $listenerString; // DB record exists, overwrite if ($row) { updateRow($parameters); } else { insertRow($parameters); } // Save nowplaying info $row = $parameters; } else { if ($firstPass) { echo "Song unchanged from previous run. Updating playback only.\n"; } updatePlayback($parameters['playback_time'], $parameters['paused'], $listenerString); } } else { // Song was playing on last update if (isset($row['title']) && strlen($row['title']) || isset($row[0])) { deleteRow(); } // Reset nowplaying info
<script src="/ckeditor/ckeditor.js"></script> <?php if (isset($_POST['newpage']) or isset($_POST['savepage'])) { $page_name = isset($_POST['page_name']) ? mysqli_real_escape_string($con, $_POST['page_name']) : ''; $page_content = isset($_POST['page_content']) ? mysqli_real_escape_string($con, $_POST['page_content']) : ''; $page_site = isset($_POST['page_site']) ? mysqli_real_escape_string($con, $_POST['page_site']) : 0; $page_modified = date('Y-m-d H:i:s'); $page_published = isset($_POST['page_published']) ? mysqli_real_escape_string($con, $_POST['page_published']) : date('Y-m-d H:i:s'); $page_author = CUSER; if ($page_name == '') { err("Užpildykite visus reikalaujamus laukelius", 'red'); } elseif (strtotime($page_published) === false) { err("Netinkamas publikavimo laikas", 'red'); } else { if (isset($_POST['newpage'])) { $id = insertRow('pages', 'page_type, page_name, page_content, page_modified, page_published, page_author, page_site', "1, '{$page_name}', '{$page_content}', '{$page_modified}', '{$page_published}', {$page_author}, {$page_site}", false); if ($id) { redirect(0, '?p=' . page() . '&page=' . $id); } else { err('Puslapis nesukurtas', 'red'); } } elseif (isset($_POST['savepage']) and isset($_GET['page'])) { updateFieldWhere('pages', 'page_name', $page_name, 'page_id = ' . $_GET['page']); updateFieldWhere('pages', 'page_content', $page_content, 'page_id = ' . $_GET['page']); updateFieldWhere('pages', 'page_modified', $page_modified, 'page_id = ' . $_GET['page']); updateFieldWhere('pages', 'page_author', $page_author, 'page_id = ' . $_GET['page']); updateFieldWhere('pages', 'page_site', $page_site, 'page_id = ' . $_GET['page']); updateFieldWhere('pages', 'page_published', $page_published, 'page_id = ' . $_GET['page']); } else { } }
$need_needy = isset($_POST['need_needy']) ? mysqli_real_escape_string($con, $_POST['need_needy']) : 0; $need_cat = isset($_POST['need_cat']) ? mysqli_real_escape_string($con, $_POST['need_cat']) : 0; $need_subcat = isset($_POST['need_subcat']) ? mysqli_real_escape_string($con, $_POST['need_subcat']) : 0; $need_name = isset($_POST['need_name']) ? mysqli_real_escape_string($con, $_POST['need_name']) : ''; $need_desc = isset($_POST['need_desc']) ? mysqli_real_escape_string($con, $_POST['need_desc']) : ''; $need_expires = isset($_POST['need_expires']) ? mysqli_real_escape_string($con, $_POST['need_expires']) : 0; $need_regdate = date('Y-m-d H:i:s'); $need_author = CUSER; if ($need_needy == '' or $need_needy <= 0 or $need_cat == '' or $need_cat <= 0 or $need_cat_type == 4 and $need_subcat == '' or $need_cat_type == 4 and $need_subcat <= 0 or $need_name == '' or $need_desc == '' or $need_expires == '') { err("Užpildykite visus reikalaujamus laukelius", 'red'); } elseif (strtotime($need_expires) === false) { err("Netinkamas galiojimo laikas", 'red'); } elseif (strtotime($need_expires) < strtotime('+1 minute')) { err("Šis galiojimo laikas jau praėjo", 'red'); } else { $id = insertRow('needs', 'need_needy, need_cat, need_subcat, need_name, need_desc, need_regdate, need_expires, need_type, need_author', "{$need_needy}, {$need_cat}, {$need_subcat}, '{$need_name}', '{$need_desc}', '{$need_regdate}', '{$need_expires}', {$need_type}, {$need_author}", false); if ($id) { redirect(0, '?p=' . page() . '&type=' . $need_type . '&subp=' . subpage() . '&need=' . $id); } else { err('Poreikis nesukurtas', 'red'); } } } ?> <form action="" method="post"> <label>Stokojantis<span class="reqfield">*</span></label> <select name="need_needy"><?php $ops = listData('needy', "deleted = 0 {$parent} ORDER BY user_lname"); foreach ($ops as $op) { echo '<option value=' . $op[0] . '>' . $op['user_lname'] . ' ' . $op['user_fname'] . ' ' . $op['user_orgname'] . '</option>'; }