| |
| Calling number of database table values at one line i.e, "list" function in PHP |
|
<![CDATA[
<?php
$rs = mysql_query("SELECT project_name,project_designer,project_id FROM
bookmarklet_details where project_status='APPROVED' ORDER BY id DESC ") ;
while(list($projectname,$desginer,$project_id) = mysql_fetch_row($rs))
{
]]>
// If project name is not available in the database table then project name will not show on the screen.
<![CDATA[
if($projectname!='')
{
?>
<a href="entry.php?project_id=<?php echo $project_id?>">
<?php echo $projectname; ?></a>
<?php
}
]]>
// If Designer name is not available in the database table then the name and html tag values will not show on the screen.
<![CDATA[
if($designer!='')
{
?><strong>Designer: </strong><?php echo $desginer;
}?>
]]>
|
| Output: |
 |
|
Here , If not available designer for correspondent project ,then the above Designer word with html tag will not be displayed on the screen. So we can use the condition for required values.
|
| |
| |