Advertisement
Guest User

Untitled

a guest
Jun 30th, 2016
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. SELECT `COLUMN_NAME`
  2. FROM `INFORMATION_SCHEMA`.`COLUMNS`
  3. WHERE `TABLE_NAME` IN ('country', 'person')
  4. AND `COLUMN_NAME` LIKE 'name_%';
  5.  
  6. $result = $db->query('SELECT p.name_person, c.name_country FROM person AS p LEFT JOIN country as c ON (p.id_country=c.id_country)');
  7. $fields = array_keys($result->fetch(PDO::FETCH_ASSOC));
  8.  
  9. $fields = $result->fetch(PDO::FETCH_ASSOC);
  10.  
  11. $result = $db->query('SELECT person.name_person, country.name_country FROM person LEFT JOIN country ON (person.id_country=country.id_country)');
  12.  
  13. print_r(array_keys($result));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement