Databases
StackOverflow2013
Postsdbo
POSQL works in phpMyAdmin but returns wrong number of rows in webpage script
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSQL works in phpMyAdmin but returns wrong number of rows in webpage script
    primarykey
    data
    text
    <p>I have a login scrip that previously appeared to work, but now is not working for some users, including some that previously worked.</p> <p>The SQL always works in phpMyAdmin, but on the webpage for some users it always returns zero rows. Here is the code where there is a problem:</p> <pre><code>$query_str = 'SELECT id, username, level_access, active FROM users WHERE username = "'; $query_str .= mysql_real_escape_string($uname).'"'; $query_str .= ' AND password = "'.mysql_real_escape_string($pwd).'"'; echo $query_str. "&lt;br/&gt;"; $result = mysql_query($query_str); $num_result = mysql_num_rows($result); echo $num_result. "&lt;br/&gt;"; </code></pre> <p>I spent considerable time testing any variations, and combinations that I could think of, I added back quotes, changed variable names, inserted other variables, simplified the expressions. Each change I tested the outputted query statement in phpMyAdmin. I added other users, deleted users and re-created them, I changed access levels and usernames.</p> <p>Always I got the same result, for some users the login always works for others it always returns no rows, even though they are returned in phpMyAdmin</p> <p>Finally I removed the where statement so that I created the following SQL statement:</p> <pre><code>$query_str = 'SELECT id, username, level_access, active FROM users'; </code></pre> <p>In my webpage this always returns 8 rows, no matter how many users there are. If there are 8, 9 or 10 users it return 8 rows. I deleted users so that there are less than 8 users, but there are still 8 rows returned to the webpage phpMyAdmin the correct number is returned each time.</p> <p>It seems clearly that the issue is not the code. So this is beyond my expertise. What could be causing this problem and how do I solve it?</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USuser1047397
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSQL works in phpMyAdmin but returns wrong number of rows in webpage script
      1. This table or related slice is empty.
      1. VTUpMod
    1. COAre you sure that your PHP code and phpmyadmin are looking at the same database?
      singulars
      1. POSQL works in phpMyAdmin but returns wrong number of rows in webpage script
      1. USMarc B
    2. COAre you sure your data is correct? Sometimes, something as subtle as one incorrect value can throw your whole result out. Also, try using different DB tools, such as PhpMyAdmin _and_ MySQL Work Bench.
      singulars
      1. POSQL works in phpMyAdmin but returns wrong number of rows in webpage script
      1. USAgi Hammerthief
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

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