hyperlinking DB Items

trininox

So far i've been able to script a page to put information into a DB, which consists of id,description,binary_data,filetype,filename but really i need to focus on the id and description part.

I need to be able to generate a page that will list the Description and make the description a hyperlink to a page using its respective id in the url.

for example.
id description
1 john
2 sarah

i need to be able to display "john" on a page and have it be a hyperlink to "getdata.php?id=1" and display "sarah" as a hyperlink to "getdata.php?id=2".

I've worked submitting the information and getting it now i just need a way to know which info is what by means of the description rather than building a list by hand based on the id #

Any thoughts, i can think of how to do it, just not exactly how to execute it... hope i've explained it so someone can understand and help me out

laserlight

That should be quite simple.

Basically, just retrieve the data from the database table.
As you loop through each row of the result set, output the info.
Since the current row being looped through has both the id and description, you can do it all at once.

trininox

Would i need to setup a loop with mysql_fetch_row.

This is something i found but i havent been able to get it to work for me, i left out the mysql_connect and db select line.

<?
function dispTbl(){
        $query = "select id,description from fwm order by id";
        $results = @mysql_query($query) or die("DB query failed!");

?>
<table border="1" cellpadding="5" cellspacing="2">
<tr>
<?
        // Loop to create the Table heading from the DB column name (from select query)
        $k = mysql_num_fields($results);
        for($i=0;$i<$k;$i++){
                echo "<th>".mysql_field_name($results,$i)."</th>";
        }

?>
</tr>
<?
        // Loop to display the DB table content
        while($result = mysql_fetch_array($results)){
                echo "<tr>";
                for($i=0;$i<$k;$i++){
                        echo "<td>".$result[$i]."</td>";
						echo "</a>";
                }

            echo "</tr>\n";
    }
    mysql_free_result($results);
?>
</table>
<?
} // Close function dispTbl()
dispTbl();

trininox

Your a genius.

I started with a blank php file and ended up doing exactly what you said and it worked, very simple.

<?php

@MYSQL_CONNECT("localhost","username","password") or die("DB query failed!");
@mysql_select_db("db") or die("DB query failed!");

    $query = "select id,description from table order by id";
    $result = @mysql_query($query) or die("DB query failed!");
	$num_results = mysql_num_rows($result);

echo "<h1>Number of Bands: ".$num_results."</h1>";

for ($i=0; $i <$num_results; $i++)
	{
		$row = mysql_fetch_array($result);
		echo "<a href='page.php?id=";
		echo $i+1;
		echo "'>";
		echo "Number ".($i+1).". Data: ";
		echo " ";
		echo $row["description"];
		echo "<br>";
		echo "</a>";
	}

?>

you can see it at work http://gto.dynu.com/fwm/list.php

trininox

Now i need to know how to go about creating a table using that and alternate the rows bg color, like white then grey, then white, until the table is done.