Creating a List of Brothers

corruption

I'm trying to create a list of fraternity brothers from a database. Right now the brothers will enter their information, last name, first name, address, etc into a form then into a database. I've gotten the process to output to a phonelist type of thing. The question now is from the same table in the database, i want to create a list of brothers where the brother's name is a link that takes you to their profile, which would contain all of the information about them.

I can output the first and last names, but not with spaces in between them (don't know if it's possible) and also they aren't links.

here's what i have so far...

$sql    =    "SELECT * FROM brothers ORDER BY id DESC";
$result    =    mysql_query($sql) or die(mysql_error());
if(mysql_num_rows($result) > 0)
    {
    ?>
    <body bgcolor="#000000" text="#CCCCCC">
    <?php 
    while($row = mysql_fetch_array($result)) 
        { 
            $lname    =    $row['lname']; 
			$fname    =    $row['fname'];
            ?> 

        <table width="75%" align="center" cellpadding="0" cellspacing="0" bordercolor="#660099" border="2" cols = "3">
        <tr>
		<td align="center"><?php echo $fname; echo $lname; ?></td>
		</tr>

        </table>


        <?php 
    } 
?>

mpainter

To get a space you could concatenate the two fields with a space in between:

<?php echo $firstname." ".$lastname ?>

Cheers,
Mark.

corruption

<?php
//phonelist for brothers

include '../connect.php';
//script to display the news in html format or something.
$sql    =    "SELECT * FROM brothers ORDER BY id DESC";
$result    =    mysql_query($sql) or die(mysql_error());
if(mysql_num_rows($result) > 0)
    {
    ?>
    <body bgcolor="#000000" text="#CCCCCC">
    <?php 
    while($row = mysql_fetch_array($result)) 
        { 
            $lname    =    $row['lname']; 
			$fname    =    $row['fname'];
            ?> 

        <table width="75%" align="center" cellpadding="0" cellspacing="0" bordercolor="#660099" border="2" cols = "3">
        <tr>
		<td align="center"><?php echo $fname." ".$lname ?></td>
		</tr>

        </table>


        <?php 
    } 
?> 
    </body>
<?php
}
else
{
echo "No rows returned!";
}

?>

that doesn't seem to give me ny output, but i can't seem to find a syntax error, and it doesn't echo no rows returned, because i know there are rows, any ideas?

corruption

I got that figured out, my next question is how do i turn each of those names into a link to a profile?

mpainter

You need to create the link just as in HTML. It is probably easier to do it all in PHP rather than slipping in and out of it. Note the escape characters () which prevent the echo command closing when it comes across a double quote.

<?php

echo "
<a href=\"profile.html?id=$id\">$fname." ".$lname</a>
";

When you click on the link a variable will be passed in the URL (e.g. profile.html?id=1). You should then be able to use:
id = $_GET['id'];
to retrieve the variable.
Then it's just a case of "SELECT * FROM brothers WHERE id=$id"

Hopefully that should sort it.

Mark.

corruption

something's not quite right with this one....

<?php 
    while($row = mysql_fetch_array($result)) 
    {
        echo "<td>";
        echo "<a href=\"profile.php?id=$id\">"$row['fname']." ".$row['lname']"</a>";
        echo "</td>";
    }
	?>
    </tr>
    </table>
<?php 
} 
    else
    {
    echo "No rows returned!";
    }

?>

mpainter

When you say "Something's not quite right", what do you mean?

It may be something to do with you echo commands. It isn't necessary to keep going in and out of quotes and concatenating to form one string. E.g. :

echo "<a href=\"profile.php?id=$id\">"$row['fname']." ".$row['lname']"</a>";

is the same as

echo "<a href=\"profile.php?id=$id\">$row['fname'] $row['lname']</a>";

If PHP comes across a variable ($var_name) in an echo command it simply replaces the variable with its value.

Mark.