Display content of the database

By nico38 on 4 Oct 2016 at 10:00 UTC

hello!
I've an external database width a table named "testable".
My table is like this :

id	titre	desc
1	titre1	desc1
2	titre2	desc2

I want to display the content of fields.
To display one field I write :

<?php
	db_set_active('my_other_db');
	$result = db_query("SELECT titre FROM testable WHERE titre='titre 1'");
	
	$record = $result->fetchField();
	print $record; 

	db_set_active();
?>

But how display all content of field "titre" ?
I tried using fetchAll but no success...

$result = db_query("SELECT titre FROM testable");
	
	$record = $result->fetchAll();
	print $record;

Comments

$result = db_query("SELECT

Jaypan commented 4 October 2016 at 13:01

$result = db_query('SELECT titre FROM {testable}');
foreach($result as $record)
{
  $record = $result->fetchField();
  print $record;
}

loop

nico38 commented 5 October 2016 at 07:01

Thanks!
I've written the code :

db_set_active('my_other_db');
	$result = db_query('SELECT titre FROM {testable}');
	foreach($result as $record)
	{
	  $record = $result->fetchField();
	  print $record;
	}
//fin
db_set_active();

But there is no loop. Only the last value is displaying (not all the values in the field "titre")

id	titre	desc
1	titre1 NO DISPLAY	desc1
2	titre2 DISPLAY	desc2

The code you've shown will

Jaypan commented 5 October 2016 at 08:18

The code you've shown will loop. So your problem is somewhere else.

You are right.

nico38 commented 6 October 2016 at 08:49

You are right.
In fact, 1 in 2 lines of database are skipped

id	titre	desc
1	titre1 NO DISPLAY	desc1
2	titre2 DISPLAY	desc2
2	titre3 No DISPLAY	desc2
2	titre4 DISPLAY	desc2
2	titre5 No DISPLAY	desc2
2	titre6 DISPLAY	desc2