marcus.whybrow

Hi, I have constructed this class for handeling making connections to a mysql database, but I can understand why this will not work, it allways returns the error: Parse error: syntax error, unexpected T_VARIABLE, expecting T_FUNCTION in C:\Inetpub\wwwroot\scriptsoft.co.uk\cpt\index.php on line 18 and this is the code: <?php class Connection { var $result; function Connection($localhost, $username, $password, $database){ $con = mysql_connect($localhost,$username,$password); mysql_select_db($database, $con); if($con) { $this->result = 'successful connection'; } else { $this->result = 'failed connection'; } } $test = &new Connection('localhost','***username(removed)***','***password(removed)***','cpt'); //line 18 echo $test->result; ?> Any help would be greatly apprieciated. Thanks, Marcus

Ok it was the ORDER BY order thing, when i got rid of it it worked fine, Thanks for all the posts. Marcus.

Ok, im creating a simple bit of PHP that shoul just order whats in the database. The error messag I keep getting is: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /srv/www/scriptsoft.co.uk/php/index.php on line 48 <?php $con = mysql_connect("localhost","----------","----------"); mysql_select_db("scriptsoft", $con); $cat = mysql_query("SELECT * FROM cat ORDER BY order"); while($mainrow = mysql_fetch_array($cat)){ //line 48 print $mainrow['text']; print "<br />"; } ?> I've done this many times before and it has worked perfectly, I just cant see what the problem is, any help will be greatly appreciated. Thanks, Marcus.