detecting path from Mysql

[imarkdesigns]

hello again guys... im in trouble here in my coding which i cannot open a link for the end user of the page in the site where there is a portal thru the folder... [sorry for my english ahehe..]

anyway, here is my code...

//-- for the table linkage with icon

<table>
<tr>
<td class="rowsavedisk"> <a href="<? echo $dirPath.$rows['name']; ?>" target="_blank" title="Poster"> <img src="imgs/icons/save.gif" alt="" border="0" /> </a> </td>
</tr>
</table>

however, when the database name and path are empty, i need to disable the current linkage in my table like this:

//-- for the table linkage with icon

<table>
<tr>
<td class="rowsavedisk"> </td>
</tr>
</table>

where there is no open link when the name and path of the database are empty... now i wish that someone can help me to correct my code...

here is my code for the path-link:

//--

<?php
 
$source = $name . $path;
 
$query = "SELECT id, name, path FROM $sched LIMIT 1";
$result = mysql_query($query) or die('Error, query failed');
if($source == 0) {
// empty space or no content instead
echo "";
} else {
// include this path if the result is 1
echo "<a href=\"<? echo '$dirPath.$rows['name']'; ?>\" target=\"_blank\" title=\"Poster\"><img src=\"imgs/icons/save.gif\" alt=\"\" border=\"0\" />";
 
?>

sorry for my coding... ahehehe... im not so great in programming... so please understand in what i mean....

[pbmods]

imarkdesigns, please use CODE tags when posting source code. See the REPLY GUIDELINES on the right side of the page next time you post.

[imarkdesigns]

sorry about that...

anyway... i finally solved the case of this stuff...

here's my result:

[PHP]

<?php

$query = "SELECT * FROM $sched";
//$result = mysql_query($query);
//$rows=mysql_fetch_array($result);

$source = $rows['name'];

$dirPath = "picture/";
$mainPath = $dirPath . $rows['name'];

if(empty($source)) {
// Result 0
echo "The $source not exist";
}else{
// Result 1
echo "The <a href=\"$mainPath\"> $source </a>exist";
}

?>

[/PHP]

[pbmods]

Heya, imarkdesigns.

Glad to hear you got it working! Good luck with your project, and if you ever need anything, post back anytime :)

[imarkdesigns]

Heya, imarkdesigns.

Glad to hear you got it working! Good luck with your project, and if you ever need anything, post back anytime :)

:) greetings...

thanks pbmods... since developing isn't my line.. but i am now taking the path for web development... haha... and im enjoy developing site now!

iMark Designs