Need help. Of course why would I be writing this. If using two rows such as print first name and another print statement for last name, how would I create a space between the two. Also how would I create the output to be an html link to something such as another page or picture.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
PHP/MYSQL
- Thread starter 183391
- Start date
davidshields
Programmer
If I get what you mean ... 2 cols in db called say fname and sname, do this in your php page ...
<HTML header stuff ..>
<?php
// assume connection etc set up ok...
$sql="select fname, sname from mytable where key='somekeyval'";
$result=mysql_query($sql,$conn);
@$rows=mysql_num_rows($result);
if($rows>0){
$fn=mysql_result($result,0,"fname"
;
$sn=mysql_result($result,0,"sname"
echo "<b>Name:</b> $fn $sn<BR>";
}
?>
<more static HTML>
</BODY></HTML>
should do the trick ...
for links, change echo to
echo "<b>Name:</b> $fn <a href=\"myurl.php3\">$sn</a>";
so surname is a link...
David.
<HTML header stuff ..>
<?php
// assume connection etc set up ok...
$sql="select fname, sname from mytable where key='somekeyval'";
$result=mysql_query($sql,$conn);
@$rows=mysql_num_rows($result);
if($rows>0){
$fn=mysql_result($result,0,"fname"
;$sn=mysql_result($result,0,"sname"
;echo "<b>Name:</b> $fn $sn<BR>";
}
?>
<more static HTML>
</BODY></HTML>
should do the trick ...
for links, change echo to
echo "<b>Name:</b> $fn <a href=\"myurl.php3\">$sn</a>";
so surname is a link...
David.
- Status