MySQL returns only one row

by 
$query = mysql_query("SELECT `title`,
                             `url_title`
                        FROM `fastsearch`
                       WHERE `tags`
                            LIKE '%$q%'
                       LIMIT 5");

while ($row = mysql_fetch_assoc($query)) {
    print_r($row);
}
  • You misspelled $query in your example
  • mysql_fetch_assoc() will return a row each time it is called, and FALSE when out of rows. Use that to your advantage, by assigning a variable to it in the condition. Within the while() loop, $row will be the current row.

More Related Contents:

  1. Query database then email posts from where user is subbed to
  2. Laravel – only a zero is saved to the database
  3. storing user_id in session variable
  4. I am seeing this error on submitting form Error: query was empty [closed]
  5. Reference: What is a perfect code sample using the MySQL extension? [closed]
  6. Convert from MySQL datetime to another format with PHP
  7. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  8. Passing an array to a query using a WHERE clause
  9. Whether to use “SET NAMES”
  10. Escaping single quote in PHP when inserting into MySQL [duplicate]
  11. PHP/MySQL Insert null values
  12. How to store file name in database, with other info while uploading image to server using PHP?
  13. How to best store user information and user login and password
  14. Laravel: connect to databases dynamically
  15. Concatenating a string and primary key Id while inserting
  16. Php : Convert a blob into an image file
  17. Detect mysql update/insertion failure due to violated unique constraint
  18. PHP + MySql + Stored Procedures, how do I get access an “out” value?
  19. How do I construct a cross database query in PHP?
  20. How to bind SQL variables in PHP?
  21. Having issue with matching rows in the database
  22. PHP – Secure member-only pages with a login system
  23. MySQL ORDER BY IN()
  24. mysql – INSERT date range into date columns IF dates don’t overlap with existing ones
  25. PHP mySQL – Insert new record into table with auto-increment on primary key
  26. how to execute mysql command DELIMITER
  27. Cannot figure out how to run a mysqli_multi_query and use the results from the last query
  28. PDO and MySQL ‘between’
  29. PHP add up two time variables
  30. SQLSTATE[HY000] [1698] Access denied for user ‘root’@’localhost’

Leave a Comment