PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
Copy Clear
Copy Format Clear
<?php $result = $mysqli->query( "SELECT field_image_fid, filename, title FROM field_revision_field_image, file_managed, node WHERE file_managed.fid = field_revision_field_image.field_image_fid AND field_revision_field_image.bundle = 'article' AND node.type = 'article';" ); while ($row = $result->fetch_assoc()) { print "URI : " . $row["filename"] . "; title: . " . $row["title"] . "<br>"; }
Show:  
Copy Clear