Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- // host (localhost)
- $db_host = "localhost";
- // database name
- $db_name = "yourdatabasename";
- // login
- $db_user = "youruser";
- // password
- $db_pass = "yourpass";
- $db = mysqli_connect ($db_host, $db_user, $db_pass, $db_name) or die ("Невозможно подключиться к БД");
- $sql="SELECT id, group_concat(name) as name FROM data group by id";
- $result=mysqli_query($db,$sql);
- while($row=mysqli_fetch_array($result)){
- echo "[ ". $row['id'] ."]  <br>";
- echo "[ <a href='#link'>". $row['name'] ."</a>]  <br><br>";
- }
- CREATE TABLE `data` (
- `id` int(11) NOT NULL,
- `name` varchar(50) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1
- [ 1]
- [ kamran,emin]
- [ 2]
- [ ramin,kam,john]
Add Comment
Please, Sign In to add comment