I am running a search bar to search through user created levels in a Unity game, however the code is returning really weird results. Sometimes it is returning the right levels back, sometimes only some that match the search string but not all or sometimes it doesn't return anything. I am pretty sure the bug is somewhere within the PHP code because I am logging the search string as it is sent to the PHP script and then logging the string results immediately. Please help, I am pretty inexperienced with PHP and SQL. I hope it's not just a stupid syntax error, if it is sorry for wasting your time.  A screenshot of the entire table -   If I search nothing in the searchbar they are all returned. -   If I search 'tester' which is found in the names of two levels I only get one result -   Or if I search '1' which is found in several level names I only get two results, not including 'tester1' which was the last result -   And if I search 'alex' like is found in the name of the creator 'alexander' it returns nothing -   However in the debug log it shows that if I search using something like 'alex' it is returning a string '' but if I search with a search term not found in the table like 'Orange' it returns 'No user maps found' as it should -   $search = $_POST["Search"];  //PDO $stmt = $conn-&gt;prepare("SELECT * FROM metadata WHERE levelname  LIKE concat('%',:search,'%') OR username LIKE concat ('%',:search,'%')");   $stmt-&gt;bindValue(':search', $search); $stmt-&gt;execute();    $row = $stmt-&gt;fetch();    if($row != null)     {     //Show data for each row     $data = $stmt-&gt;fetchAll();     foreach($data as $row)     {             echo $row["username"]."@".$row["rating"]."@".$row["levelname"]."@".$row["id"]."@".$row["numRatings"].",";     } } else {     echo "No user maps found"; }
Here's my attempt at it:  $query = $database-&gt;prepare('SELECT * FROM table WHERE column LIKE "?%"');  $query-&gt;execute(array('value'));  while ($results = $query-&gt;fetch())  {     echo $results['column']; }
What are the ways to position things absolutely on the page? I know that there is tikz, but also eso-pic and textpos.  I'd like to see a list of possible ways (not necessarily packages) for absolute positioning of things (which I believe amounts to "boxes") on the page, together with their advantages and disadvantages (for instance: tikz's current page node is very easy to use, but usually requires two LaTeX runs, and overhead from loading tikz if you don't need it for any other things is considerable).  Both LaTeX and ConTeXt solutions are welcome Persistent Network Configuration using KVM and libvirt Seeing that Defense Against the Dark Arts is a crucial subject, both in Harry's life as well as a part of the school-going wizard's curriculum, it must be in the hands of a good professor.   Is it known who Minerva McGonagall appointed as DADA prof. once she was made Headmistress. Was it someone we know or was it just a random powerful wizard. Is there any information about this available? Subsections as an enumerate I want to have subsections named all the same with a number behind it. The straight forward approach I came up with is this:   \section{User Stories} \subsection*{Userstory 1} This is story 1 \subsection*{Userstory 2} This is story 2   But I though isn't this possible as a list? So I have tried a few things but none worked. I have just learned the basics of LaTeX, and I want to try some more advanced tricks in LateX, but it won't work. I have tried this and some things very similar to this:   \section{User Stories} \begin{enumerate} [label=\subsection*{Userstory \arabic*}]     \item This is story 1     \item This is story 2 \end{enumerate}   Is this behaviour even possible to automatically? What is the best approach, for not typing the number and the title every time. Thanks in advance! Modular arithmetic: division, fractions, solving linear congruences So this has been an on-going saga the last few days, and I've already posted several related questions here, and I am feeling quite defeated.  I have/had a beautiful 16" cast iron dutch oven from Cabelas. I took it out for a test spin the other night (I had completed all seasoning steps that the Google Gods recommended). Then:   I tried (and failed spectacularly) to cook a pork roast in it, but cooked it at way too hot a temperature and burned/charred/fused the animal fats/juices into the oven, whereby it basically baked into the cast iron (related question ) I tried cleaning/scrubbing it with coarse-grained salt -> did nothing Then I tried cleaning it with dishwashing liquid + salt -> did nothing Then I let the whole thing soak in a vat of a 50/50 mixture of water + white vinegar -> took all the tarry slude off, stripped some seasoning off (revealing bare iron), but in 80% of the burned/charred areas, still did nothing Then I went to town on it with a steel wool and salt and dishwashing liquid and was left with some smooth, properly seasoned surfaces, and some more areas stripped down to bare metal I decided to just re-season it. So I scrubbed it one last time (about 1 hour ago) with a steel wool and some water, got all the rust and remaining crud off (finally), and built a fire. I placed it on the hot coals of the fire and let it sit there for 15 mins. My intention (whether misled or not) was to burn off all the remaining water from when I had previously washed/scrubbed it, then let it cool off, then season it with oil, and then bake it for a few hours.   So I just took the oven off the fire and opened the lid...and the entire inside is covered in rust. An hour ago there was none. When I put the oven into the fire 15 mins prior, there had been none (yes, I checked) This just came out of nowhere.  I'm ready to give up, unless anyone can offer some concrete set of steps for me that will salvage this $100 rust bucket. How can I get rid of the rust and then re-season this before more rust sets in? Meh... I'm currently using  but it sometimes falls over when the RSS or Atom feed isn't well formed. Are there any other options for parsing RSS and Atom feeds with PHP? Is verifying ISOs downloaded from the official website worthwhile? I downloaded the ISO from , selecting the default "Ubuntu Desktop" option.  The website links the page  which gives instructions how to verify ubuntu.  This seems pretty tedious, and I am wondering how realistic it is that there is a problem with ISO downloaded from the official website. I note that the process of verification itself requires me to download software that is new to me, thus introducing another attack vector on me even as I am closing another one.  For what it's worth, I am planning to use Live USB only and not to fully install Ubuntu. Does that make a difference? LWJGL—How to Animate and Render Characters Using a Sprite Sheet I'm making an RPG similar to Super Nintendo RPGs in the early '90s. I'm handling movement much like Squaresoft's Final Fantasy IV.   Notice that the player never actually changes his x and y positions on screen. What I'm asking, to be precise, is how could I, in LWJGL through user input (say, the arrow keys), take the sprite sheet I have of my character's movement animations and render them in a [partially] fluid animation like above?  I've been perusing the internet for hours, and I've not found a surefire way to do this. I don't have any code as of yet; I'm more or less looking for a guideline or some pointers in the right direction concerning how I might tackle this.  And, to note, this'll be a rather large game, so I want to focus partially on speed and efficiency—that meaning that I don't want to dive into Slick2D and libGDX unless absolutely necessary. LaTeX for Microsoft Surface I have my new Microsoft Surface and I was wondering whether it's possible to install pieces of software like MikTeX and TexMaker on this tablet. Does anyone know? Formula to add minutes to date+time in Excel If I have a cell formatted as date+time in Excel, how can I add to this in terms of minutes? It would need to work whether I was adding 20 minutes, or 2,500 minutes.   So, for example if I had this spreadsheet, what formula could I put in B5 to get a result of 2013-09-22 09:10?    I tried using =B4+TIME(0,B3,0), but it gives 2013-09-21 09:10 which is a day off. It works fine though if B3 is less than a day's worth. List of Ubuntu Versions with Corresponding Linux Kernel Version Is there a list of Ubuntu versions with default corresponding Linux kernel versions somewhere?  I would specifically like to know the most recent version of Ubuntu that still used Linux Kernel 2.x. I have a list of dictionaries and want each item to be sorted by a specific value. Take into consideration the list: [{'name':'Homer', 'age':39}, {'name':'Bart', 'age':10}]  When sorted by name, it should become: [{'name':'Bart', 'age':10}, {'name':'Homer', 'age':39}] Jquery load() and PHP variables Do we use abstract algebra in real life? Do we use abstract algebra in real life?   Is there any application of abstract algebra in real life? Related to : The question specifies morphs, but I wondered if this was true for Manifest as well? As Manifest is not an ability on the card, does  prevent it from being turned face up for its mana cost? I have a SQL Server 2005 database using the full recovery model. If I execute the following commands:  ALTER DATABASE test SET RECOVERY SIMPLE; ALTER DATABASE test SET RECOVERY FULL;   or   BACKUP LOG test WITH  truncate_only;   Then try to run a log backup:  BACKUP LOG test TO  DISK = 'backupfile.bak'   I receive the error message:     BACKUP LOG cannot be performed because there is no current database backup.   Question:     How do I check that I will not be able to take a log backup, without running a backup log command? Extension of degree 2 with characteristic not 2 I am told that $K \leq L$ is a field extension of degree 2 and that $K$ has characteristic not 2. I am then asked to show that $\exists \: \alpha \in L$ such that $L = K(\alpha), \; \alpha^2\in K $  So far I have that:  $\exists \; \alpha_1, \alpha_2 \in L$ such that $L = K( \alpha_1, \alpha_2)$  $\Rightarrow |L:K| = |L:K(\alpha_1)| |K(\alpha):K| $ so $|K(\alpha):K| = 1$ or $2$  $|K(\alpha_1):K| = 2 \Rightarrow L = K(\alpha_1)$ and $deg(f_{\alpha_1}(t)) = 2  $ where $f_{\alpha_1}(t)$ is the minimal polynomial of $\alpha_1$ over $K$   So $f_{\alpha_1}(t) = t^2 + at + b$ for some $a,b \in K$  Also, $|K(\alpha_1):K|=1 \Rightarrow K(\alpha_1) = K$ and $L = K(\alpha_2)$ which means $degf_{\alpha_2}(t) = 2$ where $f_{\alpha_2}(t)$ is the minimal polynomial of $\alpha_2$ over $K$.   So $f_{\alpha_2}(t) = t^2 + at + b$ for some $a,b \in K$  Given that we consider the same polynomial each time, relabel to consider:   $f_{\alpha}(t) = t^2 + at+ b $ for some $a,b \in K$  We have already demonstrated that $L=K(\alpha)$ for some $\alpha \in L$ so now we much show that $\alpha^2 \in K$  $\alpha^2 \in K \Leftrightarrow a = 0_K$  I now have no idea how to show that this coefficient of $f_{\alpha}(t)$ is necessarily $0$.   I know that $f_{\alpha}(t)$ has two roots in $L$ and that because $K$ and thus $L$ has characteristic not 2, they cannot be the same root, but I don't know how to then conclude that they must sum to $0$  Any help would be greatly appreciated. Let $f_n(x) : \mathbb{R} \rightarrow \mathbb{R}$ be defined as $\dfrac{x}{n}$. Is $f_n$ uniformly convergent?   With "$(a_n)$ is limited and $(b_n)$ converges to 0 $\Rightarrow (a_nb_n)$ converges also to 0" i would guess that $x\cdot \dfrac{1}{n}$ converges uniformly but $x$ is not limited in this case. So does ist converge uniformly or not? Spaces in files names in \input or \includegraphics I'm going crazy...  I have a file I want to include which path is C:\Users\Matthieu\Documents\Folder withOneSpace\myFile.tex. (As you can see with the \, I'm on windows actually)  I tried the following but none works:  \input{C:/Users/Matthieu/Documents/Folder withOneSpace/myFile} \input{C:/Users/Matthieu/Documents/Folder\ withOneSpace/myFile} \input{C:/Users/Matthieu/Documents/Folder withOneSpace/myFile.tex} \input{C:/Users/Matthieu/Documents/Folder\ withOneSpace/myFile.tex}   I also tried to put the file out of the folder with a space and it works (no surprise):  \input{C:/Users/Matthieu/Documents/myFile} --&gt; Works   All I found is to put a \ before the space but it doesn't work at all. --> Please help ! :)