want to print theis but not to have the '.jpg' in the results.
Any help would be great. Tried a few tutorials but this script is quite complicated for me and im starting to get dizzy:
$picFile is the .jpg file.
code=
<?
$value = $_POST['search'];
$db_name = "crabbe_dantest";
$table_name = "backfacefinal";
$s = @mysql_connect("localhost", "crabbe_crabbe", "unemployment1")
or die("Couldn't connect.");
$sql = "SELECT project, picFile
FROM $table_name
GROUP BY project DESC
";
$d = @mysql_select_db("crabbe_dantest", $s)
or die("Couldn't selectdatabase");
$resultb = @("select ratio, comments, project, initials, picFile from backfacefinal where initials like\"%$value%\" GROUP BY project");
while($row = @mysql_fetch_array($resultb)){
$project = $row['project'];
$updates_block .= "<font color=\"#666666\"><b>$project-</b></font>";
$sql2="select *, picFIle, ratio FROM $table_name WHERE project=\"$project\" ORDER BY project DESC";
$result2 = @($sql2,$s)
or die("couldn't complete query.");
while ($row2 = @mysql_fetch_array($result2)) {
$ratio = $row2['ratio'];
$picFile = $row2['picFile'];
$project = $row2['project'];
$id = $row2['id'];
$updates_block .= "<a href='asfunction:_root.showjpg,$picFile#$ratio'>$picFile</a>, ";
}
}
echo "$updates_block";
?>
