mysql data as links

[aznjay]

Can anyone create me a script that shows the data from MYSQL as links, and then if i click it it'll show specific data from the specified row.

[wildteen88]

There is not that much to to it really. Example

if(isset($_GET['id']) && is_numeric($_GET['id']))
{
    $id = $_GET['id'];

    $sql  = "SELECT * FROM table WHERE id='$id'";
    $result = mysql_query($sql);

    if(mysql_num_rows($result) == 1)
    {
        $row = mysql_fetch_assoc($result);

        echo '<pre>' . print_r($row, true) . '</pre>';
    }
}
else
{
    $sql  = 'SELECT id, title FROM table';
    $result = mysql_query($sql);

   while($row = mysql_fetch_assoc($result))
   {
        echo '<a href="?id='.$row['id'].'">'.$row['title'].'</a><br />';
   }
}

As I don't know what you're table structure is, you will need to modify the queries and the $row variables.

[aznjay]

Thank you I understand...will this script show the data?? if the link is clicked?

[wildteen88]

That is correct. Have you tested it yet.

 

[aznjay]

I have the website alltraxx.uni.cc is under construction

 

On the context box of this page I have the code:

<?php
$file = $_GET['page'].'.php';
if (file_exists($file)) {

include $file;


} elseif ($_GET['page'] == '') {


include ("newsinc.php");


} else {

echo ' ERROR';
}
?>

 

Whenever I click on the  http://alltraxx.uni.cc/index.php?id=5  ......   it redirects me back to the news page...it does not load up the data from mysql.

[aznjay]

Yes..It's very helpful, but i got another problem...=(

[wildteen88]

whats in newsinc.php

[aznjay]

that is where the news feed another page that shows is there is no link click from side bar

[aznjay]

whats in newsinc.php

 

news..that is not significant to the problem

[wildteen88]

What! You're confusing the hell of me!

 

When the user goes to http://alltraxx.uni.cc/index.php?id=X -- X being a number. Whats supposed to happen?

[aznjay]

it's  suppose to show the  data from click the link on my website click on my website and click the link PHP this will show the page phptuts.php and then phptuts.php?id="1" and then it'll  show specific data from that row...but when ever i click that it show the news... coz' i have the if and then script...that's the main problem...

[wildteen88]

You just need to add the relevant code in the included file then. If you post phptuts.php here I'll be able to incorporate the code I posted earlier for you.

[aznjay]

Here you go:

 

phptuts.php file:

 

<div id="tutorial2">
<?
include 'database.php';

if(isset($_GET['id']) && is_numeric($_GET['id']))
{
    $id = $_GET['id'];

    $sql  = "SELECT * FROM phptut WHERE id='$id'";
    $result = mysql_query($sql);

    if(mysql_num_rows($result) == 1)
    {
        $row = mysql_fetch_assoc($result);

        echo '<pre>' . print_r($row, true) . '</pre>';
    }
}
else
{
    $sql  = 'SELECT * FROM phptut';
    $result = mysql_query($sql);

   while($row = mysql_fetch_assoc($result))
   {
        echo '<a href="?id='.$row['id'].'">'.$row['title'].'</a><br />';
   }
}

?>
</div>
</div>

[wildteen88]

OK now I understand your problem.

 

Change

echo '<a href="?id='.$row['id'].'">'.$row['title'].'</a><br />';

to

echo '<a href="'.$_SERVER['REQUEST_URI'].'&id='.$row['id'].'">'.$row['title'].'</a><br />';

[aznjay]

YOU ARE OFFICIALLY THE BEST!!!!!