Hi Simon, Please give us the output of the phpinfo() function. Do a small php file like below and put it together with the rest of the php scripts, then access it via the browser:
<?php phpinfo(); ?> This should help us understand what is present and what is not. Kind regards, Bernard 2009/8/14 Simon Mutama <[email protected]>: > Bernard, > > I do have it installed. Synaptics shows that the package is installed and > when I run > > sudo apt-get install php5-mysql' > > The result is: > > php5-mysql is already the newest version. > > Simon > > > 2009/8/14 Bernard Wanyama <[email protected]> >> >> Simon, >> >> You might want to check that you have the package php5-mysql installed >> (PHP extensions that add MySQL functionality). >> >> If not, do a 'sudo apt-get install php5-mysql' >> >> HTH. >> >> Kind regards, >> Bernard >> >> 2009/8/14 Simon Mutama <[email protected]>: >> > All, >> > >> > I am running a LAMP server on Ubuntu 8.10. Can connect to the database >> > using >> > either phpmyadmin or the CLI and manipulate databases successfully. I >> > can >> > also run .php files in my browser successfully provided the files do not >> > contain any database functions. >> > >> > However, when I try to use PHP with MySQL functions, I get either a >> > blank >> > page or a syntax error. What am I doing wrong? >> > >> > For instance, the following code results in the syntax error: >> > >> > Parse error: syntax error, unexpected T_STRING in >> > /var/www/Test_Database_Access.php on line 6 >> > >> > <html> >> > <head></head> >> > <body> >> > <?php >> > // open connection to MySQL server >> > $connection = mysql_connect('localhost', 'guest', 'pass') ↵ >> > or die ('Unable to connect!'); >> > >> > // select database for use >> > mysql_select_db('northwind') or die ('Unable to select database!'); >> > // create and execute query >> > $query = 'SELECT * FROM items'; >> > $result = mysql_query($query) ↵ >> > or die ('Error in query: $query. ' . mysql_error()); >> > // check if records were returned >> > if (mysql_num_rows($result) > 0) >> > { >> > // print HTML table >> > echo '<table width=100% cellpadding=10 cellspacing=0 border=1>'; >> > echo >> > '<tr><td><b>ID</b></td><td><b>Name</b></td><td><b>Price</b></td></tr>'; >> > // iterate over record set >> > // print each field >> > while($row = mysql_fetch_row($result)) >> > { >> > echo '<tr>'; >> > echo '<td>' . $row[0] . '</td>'; >> > echo '<td>' . $row[1] . '</td>'; >> > echo '<td>' . $row[2] . '</td>'; >> > echo '</tr>'; >> > } >> > echo '</table>'; >> > } >> > else >> > { >> > // print error message >> > echo 'No rows found!'; >> > } >> > // once processing is complete >> > // free result set >> > mysql_free_result($result); >> > // close connection to MySQL server >> > mysql_close($connection); >> > ?> >> > </body> >> > </html> >> > >> > Thanks >> > >> > Simon Mutama >> > >> > >> > _______________________________________________ >> > LUG mailing list >> > [email protected] >> > http://kym.net/mailman/listinfo/lug >> > %LUG is generously hosted by INFOCOM http://www.infocom.co.ug/ >> > >> > The above comments and data are owned by whoever posted them (including >> > attachments if any). The List's Host is not responsible for them in any >> > way. >> > --------------------------------------- >> > >> > >> > >> >> >> >> -- >> Bernard Wanyama >> Technical Manager >> Syntech Associates Ltd >> Suite 422, GPO Building >> Plot 35, Kampala Rd, Kampala, UGANDA >> Web: www.syntechug.com >> Cell: +256 71 2193979 >> Fixed: +256 41 4251591 > > > > -- > Simon Mutama > +256-753-259080 > -- Bernard Wanyama Technical Manager Syntech Associates Ltd Suite 422, GPO Building Plot 35, Kampala Rd, Kampala, UGANDA Web: www.syntechug.com Cell: +256 71 2193979 Fixed: +256 41 4251591 _______________________________________________ LUG mailing list [email protected] http://kym.net/mailman/listinfo/lug %LUG is generously hosted by INFOCOM http://www.infocom.co.ug/ The above comments and data are owned by whoever posted them (including attachments if any). The List's Host is not responsible for them in any way. ---------------------------------------
