# Connecting to a MySQL database with PHP

**URL:** <https://forum.kirupa.com/t/connecting-to-a-mysql-database-with-php/59012>\
**Category:** programming\
**Created:** [July 27, 2004, 7:20pm UTC](https://forum.kirupa.com/t/connecting-to-a-mysql-database-with-php/59012 "2004-07-27T19:20:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![PeterHogg](https://avatars.discourse-cdn.com/v4/letter/p/4af34b/32.png) [@PeterHogg](https://forum.kirupa.com/u/PeterHogg)\
**Post date:** [July 27, 2004, 7:20pm UTC](https://forum.kirupa.com/t/connecting-to-a-mysql-database-with-php/59012/1 "2004-07-27T19:20:36Z")

</div>

Okay, so I’ve made my database with three rows:

articleID

articleTitle

articleText

I’ve added in some content to the database. So now I’m trying to print that content on my page, heres my code:

```auto

 
 <?php
 
 //mysql connect details
 include ('mysqlconnection.php'); 
 
 //login to mysql
 mysql_connect($DBhost, $DBuser, $DBpass) or die(mysql_error()); 
 mysql_select_db(swift_dbArticles, $mysql_access);
 
 //connect to database
 mysql_select_db(swift_dbArticles) or die(mysql_error()); 
 
 //select table and data from database
 mysql_select_db(tblArticles) or die(mysql_error());
 $result = mysql_query("SELECT articleID, articleTitle, articleText FROM tblArticles);
 $row = mysql_fetch_row($result)
   
   {
 	  print("$row[1]<br>");
   }
 
 //close mysql
 mysql_close();
 
 ?> 
 
 

```

I’ve messed around with the code quite abit, but I keep getting the same sort of error:

```auto

 Parse error: parse error, unexpected T_VARIABLE in /home/swift/public_html/hogg/php.php on line 19
 

```

or

[www.aftermathdesigns.net/hogg/php.php](http://www.aftermathdesigns.net/hogg/php.php)

Whats wrong with my code?

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [July 27, 2004, 7:26pm UTC](https://forum.kirupa.com/t/connecting-to-a-mysql-database-with-php/59012/2 "2004-07-27T19:26:09Z")

</div>

You need a while loop

```php

while($row = mysql_fetch_row($result)) {
print("$row[1]<br>
");
}

```