Hi all,
Just trying to generate dynamic URL's form a MySQL DB based on ID. I spent about 2 minutes on this code then realized i had NO CLUE how to do this. Please suggest something new. For a good laugh here is the code:
<? $jobsall = "select id, title from employment ORDER BY id";
$mysql_result = mysql_query($jobsall, $mysql_link);
$id = $idselect;
$idselect = 4;
while($job = mysql_fetch_row($mysql_result))
{
$id = $job[0];
$title = $job[1];
echo "<a href=http://www.phpbuilder.com/board/archive/index.php/\"employment.php?idselect=$idselect\">$title</a> ";
echo "$title";
echo'<br>';
}
?>
this was my first effort and the core logic is well, non-existent but i was hoping to get some ideas before i waste time on developing core logic that doesn't work.
THANK-YOU for any help
Just trying to generate dynamic URL's form a MySQL DB based on ID. I spent about 2 minutes on this code then realized i had NO CLUE how to do this. Please suggest something new. For a good laugh here is the code:
<? $jobsall = "select id, title from employment ORDER BY id";
$mysql_result = mysql_query($jobsall, $mysql_link);
$id = $idselect;
$idselect = 4;
while($job = mysql_fetch_row($mysql_result))
{
$id = $job[0];
$title = $job[1];
echo "<a href=http://www.phpbuilder.com/board/archive/index.php/\"employment.php?idselect=$idselect\">$title</a> ";
echo "$title";
echo'<br>';
}
?>
this was my first effort and the core logic is well, non-existent but i was hoping to get some ideas before i waste time on developing core logic that doesn't work.
THANK-YOU for any help