Connecting to a MySQL database with PHP

programming
1

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:


 
 <?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:


 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

Whats wrong with my code?

2

You need a while loop


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