StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POmysql_query returns a row, but mysql_fetch_array does not do anything
text
Body
copied!<p>I have a strange problem this time. I've got a masking database setup that takes in a url and gives it a string mask so that I can redirect users to another site (direct download) by giving them a link to my site's redirection engine.</p> <p>I'm having a problem in the administrator side (where I put in the urls) where my mysql_fetch_array command just doesn't run. I know the query is returning at least one row because when I run the following code:</p> <pre><code>$query = "SELECT * FROM `urls` WHERE `in`='$lks[$i]' ORDER BY `id` DESC LIMIT 1"; $r = mysql_query($query); if(mysql_num_rows($r) < 1) echo "Less than 1"; else echo "At least 1"; </code></pre> <p>it returns "At least 1", but when it gets down to the mysql_fetch_array while statement, nothing happens. It's like it just ignores it completely.</p> <p>CODE:</p> <pre><code>$query = "SELECT * FROM `urls` WHERE `in`='$lks[$i]' ORDER BY `id` DESC LIMIT 1"; $r = mysql_query($query); while($me = mysql_fetch_array($r)) { echo "Blah"; } </code></pre> <p>Nothing is echoed by this code. What's wrong?</p> <p>By the way, I know that I am connected to the database and everything because I run other commands very similar to this before this one and they all execute without any problems. </p> <p>Also this command is in a <strong>for loop</strong> (I don't know why this would be a problem because I have done this many times before and never had any problems).</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload