CODEWITHSUNDEEP
phphtmlmysqlsql
amirhosein
amirhosein

Reputation: 15

How Make Links For Array Data In MySQL And PHP

i want make a different link for array data in mysql database.

for example i store data like below in my database:

data1,data2,data3 in one column

and i want fetch them like below by one query:

echo'
<a href="mydomain.php?'.$row[data1].'">data1</a>
<a href="mydomain.php?'.$row[data2].'">data2</a>
<a href="mydomain.php?'.$row[data3].'">data3</a>';

Upvotes: 0

Views: 556

Answers (2)

Galcha
Galcha

Reputation: 64

If your data is stored as "data1,data2,data3" in a column named "column" of your table:

$data = explode(",", $row["column"]);

echo '<a href="mydomain.php?'.$data[0].'">data1</a>';

But as said above, you should avoid storing multiple data in one column.

Upvotes: 1

a4w
a4w

Reputation: 577

Something like this in your database retrieving loop : 

$data = explode(',',$row['COLOUMN_NAME']);
echo'
<a href="mydomain.php?'.$data[0].'">data1</a>
<a href="mydomain.php?'.$data[1].'">data2</a>
<a href="mydomain.php?'.$data[2].'">data3</a>';

Upvotes: 0

Related Questions