All pastes #146629 Raw Edit

Unnamed

public php v1 · immutable
#146629 ·published 2006-08-23 19:10 UTC
rendered paste body
if(isset($_POST['article_sort']) AND isset($_POST['article_order'])){							$sort = $_POST['article_sort']; $order = $_POST['article_order'];				$sql_article_sort = send_sql("UPDATE post_sort SET str='$sort' WHERE name='article_sort'") OR die(mysql_error());				$sql_article_order = send_sql("UPDATE post_sort SET str='$order' WHERE name='article_order'") OR die(mysql_error());			} else {				$sql_sort = mysql_query("SELECT str FROM post_sort WHERE name='article_sort'") OR die(mysql_error());				$sql_article_sort = mysql_fetch_assoc($sql_sort);								$sql_order = mysql_query("SELECT str FROM post_sort WHERE name='article_order'") OR die(mysql_error());				$sql_article_order = mysql_fetch_assoc($sql_order);			}// later I call$tmp=send_sql("SELECT * FROM articles ORDER BY '{$sql_article_sort[str]}' '{$sql_article_order[str]}'");