Problem with a SELECT WHERE query

Question

Got a relatively simple MySQL query that I'm pulling using php with the following code:

$employeeNames = mysql_query(
          "SELECT * 
           FROM employees 
           WHERE team=\"1st Level Technical Support_a\" 
           LIMIT 0,5000") or die(mysql_error());
$employeeNumRows = mysql_num_rows($employeeNames);
echo $employeeNumRows;
while ($row = mysql_fetch_array($employeeNames, $employeeNumRows)) {
    echo $row['full_name'];
}

Now, if I run the query on the first line in SQL it gives me 18 results. If I echo $employeeNumRows it prints 18. Nothing else after that though.

If I change "1st Level Technical Support_a" to any other team in the table, it will bring up the proper results using PHP

This is the weirdest problem I've come across using MySQL/PHP - can anyone help? Has anyone seen something like this before?

Daan · Accepted Answer · 2009-05-14 12:34:27Z

3

Try removing the second parameter from your call to mysql_fetch_array, so that it reads mysql_feetch_array($employeeNames). See the documentation of the function to see how to use it properly.

answered May 14, 2009 at 12:34

Daan

7,0044 gold badges33 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

frusDev Over a year ago

Amazing, I have a function using a different query but using mysql_fetch_array the same way that works fine. Thank you!

Collectives™ on Stack Overflow

Problem with a SELECT WHERE query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related