Create a clickable link in php from sql results

Question

I am trying to make the results from mysql results clickable links in php. I am new to php and please help.

<?php mysql_connect("localhost", "root", "pass") or die(mysql_error());
mysql_select_db("Branches") or die(mysql_error());
$data = mysql_query("SELECT * FROM items order by ID desc Limit 5") or die(mysql_error());
while ($info = mysql_fetch_array($data)) {
    echo $info['title'];
    echo " <br>";
    echo $info['descr'];
    echo "<br>";
    echo "<br>";
} ?>

you can do something like echo '<a href="'.$info['descr'].'">bla link</a>'; whats the problem ? — Mayank K. Swami
– Mayank K. Swami, Commented Dec 21, 2012 at 5:57
Seems like, you wanna show data from database on link click. ?? — Ravi
– Ravi, Commented Dec 21, 2012 at 5:57

asprin · Accepted Answer · 2012-12-22 07:12:37Z

1

while ($info = mysql_fetch_array($data)) {
    echo '<a href="somefile.php?id='.$info['ID'].'">'.$info['title'].'</a>';
    echo " <br>";
    echo $info['descr'];
    echo "<br>";
    echo "<br>";
}

Then in somefile.php, use $_GET to capture the id and show the results

$id = $_GET['id'];
// pull info from db based on $id
$sql = mysql_query('SELECT * FROM items WHERE ID = "'.$id.'"');
.
.
.
.

edited Dec 22, 2012 at 7:12

answered Dec 21, 2012 at 5:59

asprin

9,85512 gold badges72 silver badges126 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Ucz Over a year ago

Thanks Asprin, The clickable link worked briliantly but I am now strugling with pulling a field 'details' from the items table corresponding with the 'id'. I tried the following code but it not working, where am I going wrong? '<?php $id = $_GET['id']; // pull info from db based on $id $sql = "SELECT * FROM items WHERE ID = '".$id."'"; while ($info = mysql_fetch_array($sql)){ echo $info ['Title']; echo $info ['Details']; " <br>"; }?>'

Ucz Over a year ago

The message from the browser is: Warning: mysql_fetch_array() expects parameter 1 to be resource, string given in C:\xampp\htdocs\news\article.php on line 7

Sean Over a year ago

@Ucz that error - Warning: mysql_fetch_array() expects parameter 1 to be resource ... is caused because you are using $sql which is your sql string without mysql_query(). Change it to - $sql = mysql_query("SELECT * FROM items WHERE ID = '".$id."'");

asprin Over a year ago

Yep! @Sean got it spot on. Wonder how I missed that

Ucz Over a year ago

Thanks guys, you r life servers. Works perfectly.

Yogesh Suthar · Accepted Answer · 2012-12-21 05:58:11Z

0

just use anchor tag like this

while ($info = mysql_fetch_array($data)) {
    echo "<a href =\"$info[title]\">".$info['title'];. "</a>";
}

answered Dec 21, 2012 at 5:58

Yogesh Suthar

30.5k18 gold badges75 silver badges100 bronze badges

1 Comment

Mayank K. Swami Over a year ago

let op replay my comment first ..i am telling same ... question is vague

Ganesh RJ · Accepted Answer · 2012-12-21 05:58:41Z

0

echo '<a href="php page which you want to display on click">$info['descr']</a>'

answered Dec 21, 2012 at 5:58

Ganesh RJ

9422 gold badges19 silver badges31 bronze badges

1 Comment

Mayank K. Swami Over a year ago

let op replay my comment first ..i am telling same ... question is vague

Collectives™ on Stack Overflow

Create a clickable link in php from sql results

3 Answers 3

5 Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

5 Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related