Displaying multiple URL links from database

Question

Like the titles describes, I'm trying to output multiple URL links from a database. But recieving an error.

PHP

$link_select = mysql_query("SELECT link FROM links WHERE sigaren_id = " .$resultaat_fetch_id_sigaren);                  
while ($link = mysql_fetch_array($link_select)) 
{
    $resultaat_link = $link['link'];
    $link .= "<a href='".$link."'>$link</a>";
}

HTML

<b>Links</b><br><br>
<?php echo $link;  ?>

ERROR

Notice: Array to string conversion

`$link = mysql_fetch_ARRAY($link_select)`. You are trying to append a string with an array, bruv. As a matter of fact, you are also trying to append an array with a string. It doesn't work like that. — , Aug 17 '15 at 19:01
Your code is very messy. You're `echo`ing an array, your `Notice` just said that. — al'ein, Aug 17 '15 at 19:01
possible duplicate of [How to solve error 'Notice: Array to string conversion in.....'](http://stackoverflow.com/questions/20017409/how-to-solve-error-notice-array-to-string-conversion-in) — nomistic, Aug 17 '15 at 19:02

codez · Accepted Answer · 2015-08-17T19:07:37.677

2

Because, you're treating an array as a string.

$link is an array, but you're referring to it as a string.

To fix it, change the code like this:

$link_select = mysql_query("SELECT link FROM links WHERE sigaren_id = " .$resultaat_fetch_id_sigaren);                  
while ($link = mysql_fetch_array($link_select)) 
{
    $resultaat_link = $link['link'];
    $linkData .= "<a href='".$resultaat_link."'>$resultaat_link</a>";
}   

<b>Links</b><br><br>
<?php echo $linkData;  ?>

Side note: Stop using mysql_* functions because they are deprecated. Move on to PDO or MySQLi instead.

edited Aug 17 '15 at 19:07

answered Aug 17 '15 at 19:03

codez

1,440
2
19
34

Well, seems like your code still treats `$link` as string, since you're still concatenating stuff in there with `.=` – al'ein Aug 17 '15 at 19:06
Ooh stupid me... --' I used the $link variable 2 times.. my bad. Thanks for clearing that out! – user3360972 Aug 17 '15 at 19:11
Why do I get http://localhost//www.google.com when I press the link? = my website name. Instead I want it to go to www.google.com directly. – user3360972 Aug 17 '15 at 19:16
It depends on what output you got. Please open up another question for that with your output, etc. – codez Aug 17 '15 at 19:17
When I press a link => http://localhost/el_gusto/www.google.be is filled in the browser. – user3360972 Aug 17 '15 at 19:18
1

Oh, I see. You have to do this: `$linkData .= "$resultaat_link";` – codez Aug 17 '15 at 19:19
Awesome! that did it again! – user3360972 Aug 17 '15 at 19:26

Displaying multiple URL links from database

1 Answers1