Select those record only from table 1 where city exist against state id in table 2 in PHP

by

Try like this

SELECT t1.* FROM
table1 t1
JOIN table2 t2 ON(t2.state_id = t1.state AND t2.city!='')

More Related Contents:

  1. How to update multiple MySQL table entries with different id?
  2. Can’t insert data into mysql database using PHP [closed]
  3. which is better every user have a table or just a row [closed]
  4. How chnage image size before uploaded on server [closed]
  5. PHP PDO: charset, set names?
  6. How to retract a salted password from the Database and auth user?
  7. What is the difference between MySQL, MySQLi and PDO? [closed]
  8. Fatal error: [] operator not supported for strings
  9. Fetching data from MySQL database to HTML dropdown list
  10. How to solve General error: 2006 MySQL server has gone away
  11. How to insert an array into a single MySQL Prepared statement w/ PHP and PDO
  12. ini_set, set_time_limit, (max_execution_time) – not working
  13. Find Point in polygon PHP
  14. phpmyadmin automatic logout time
  15. unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING error [duplicate]
  16. Setting a connect timeout with PDO
  17. How to build a JSON array from mysql database
  18. How to display a date as iso 8601 format with PHP
  19. How to generate unique id in MySQL?
  20. Join two tables with comma separated values
  21. Fatal error: Call to undefined method mysqli_stmt::fetch_array() [duplicate]
  22. adding 30 minutes to datetime php/mysql
  23. Remotely connecting to a MySQL database
  24. Create table with PHP and populate from MySQL
  25. mysql_connect VS mysql_pconnect [closed]
  26. Strange problem with the length of the field gotten from database [duplicate]
  27. Can I detect and handle MySQL Warnings with PHP?
  28. mysql_fetch_array skipping first row
  29. 500 Internal Server Error?
  30. mysql count into PHP variable

Leave a Comment