Hello my dear friends!
I learnt so much from this forum and you!
I managed at last to make a search system
that gets info from MySQL database
and then puts out the photo
(i keep just URL of the photos in database
thanks to your advice).
I thought of making a link from the photo - search result -
to a personal profile,
so a visitor when clicking on an image,
could get more detailed information.
but the browser says " parse error in /var/www/html/.../PHP/profile.php on line 24
line 24 is "$photo= "<IMG SRC="$row['photo']">" ;'
here's my script of the profile.php:
<?
require("page.inc");
$content= '';
$content .= '
<table width="100%"
align="center" bgcolor="white"
border="0" cellspacing="0" cellpadding="20">
<tr>
';
$con = mysql_connect("localhost","db","password")or die(mysql_error());
mysql_select_db("bride",$con)or die(mysql_error());
$query="SELECT * FROM
member, photos
WHERE member.memberid= photos.memberid" ;
$result= mysql_query($query)
or die(mysql_error());
$row= mysql_fetch_array($result) ;
if ($row['photo']=="" or $row['photo']=="http://" )
$photo="" ;
else
$photo= "<IMG SRC="$row['photo']">" ;
$content = '
<INPUT TYPE=\"BUTTON\" name=\"back\"
value=\"Back\" onClick=\"history.back()\"></td>
<td class=head> Profile ID '.$personalID.'
</td>
</tr>
<tr><td valign=\"top\" width=\"200\">
<p class=\"head\" >First name:<br>
<class=\"data\">".$row[1]."<br>
</td>
<td valign=\"top\">".$photo."</td></tr>
<tr><td valign=\"top\" width=\"200\">
<p class=\"head\">My info:</td>
<td>".$row['AboutMe']."<p></td></tr>
</table>' ;
$homepage = new Page();
$homepage -> SetContent($content);
$homepage->Display();
?>
what can be wrong?
thank you!