i am trying to fetch only image from database. In database the table (post_content) have image along with description i only want image. Is it possible? Keep in mind that $row['post_content']
has image and decription.
<?php
$sql = "select * from wp_tableposts;";
$res = mysql_query($sql);
while ($row = mysql_fetch_array($res))
{
echo'Post Contant:'. $row['post_content']. '';
}
?>
Solution 1(Recommended): Seperate the description and image into 2 columns in the database
Solution 2: Differentiate between image and description in the same column using a delimeter (#, or /\ or seperator)