mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/virtua15/public_html/main/1515/dafreg.php on line 9 [duplicate]

by

Something is wrong with query check with print mysql_error();

Check query. quote properly values assigned in query.

$query = mysql_query("SELECT jos_comprofiler.firstname, jos_comprofiler.lastname,
         jos_users.username, jos_comprofiler.cb_country, jos_users.email 
         FROM jos_users LEFT JOIN jos_comprofiler ON jos_users.id=jos_comprofiler.id 
         WHERE jos_users.id ='".mysql_real_escape_string($id)."'");

More Related Contents:

  1. How to refresh parent page after closing popup window in jQUERY? [duplicate]
  2. Create the timestamp of an hour ago [duplicate]
  3. How to convert the json image url string into Bitmap image to display images in android application
  4. simple PHP to MYsql filtering
  5. How to check if a row exists in MySQL? (i.e. check if username or email exists in MySQL)
  6. How can I do ‘insert if not exists’ in MySQL?
  7. How to use multiple databases in Laravel
  8. MySQL returns only one row
  9. Why doesn’t MySQL support millisecond / microsecond precision?
  10. Real escape string and PDO [duplicate]
  11. Populate a Drop down box from a mySQL table in PHP
  12. Run a mySQL query as a cron job?
  13. PHP PDO vs normal mysql_connect
  14. Can I create a database using PDO in PHP?
  15. Doing a while / loop to get 10 random results
  16. php file upload, how to restrict file upload type
  17. SQLSTATE[HY000] [2002] A connection attempt failed.. – When attempting to connect from Local to remote server
  18. MySQL Error “Too many connections”
  19. Warning: mysql_num_rows() expects parameter 1 to be resource, object given [duplicate]
  20. MySQL error when inserting data containing apostrophes (single quotes)?
  21. Connect to remote MySQL server with SSL from PHP
  22. Using MySQL’s TIMESTAMP vs storing timestamps directly
  23. How can I do a migration in laravel 5.5?
  24. Best way to store IP in database?
  25. Which is fastest in PHP- MySQL or MySQLi?
  26. SQL Query with binary data (PHP and MySQL)
  27. How to get last inserted id from table MySQL [duplicate]
  28. How can I list data in sections by an ID, with a while loop in PHP? [closed]
  29. Save array in mysql database
  30. find in set in laravel ? example

Leave a Comment