Writing to MySql Databse

I have gone thru tutorials and understand how to query and display results from a database using PHP.

However, I cannot seem to figure out how to write to a database.

I am trying to write firstName, lastName, emailAddress to a database.

Could some please show me the code to access the database and write to it?

I assume the problem is I don't know how to properly OPEN the database. After that can't I just use an INSERT command?

Just want to learn the basics.

Thanks!

Open your connection the same way, build your insert query, run it. The example below uses mySql.

$query = "INSERT into myTable (firstName, lastName, emailAddress) values ('$firstName', '$lastName', '$emailAddress')";
mssql_query($query)

THANKS!!!

What is the easiest way to display the data from the entire table?

For example I want my database to display every person in a format like this:

firstName lastName emailAddress

Thanks in advance!

$query = "select firstName, lastName, emailAddress from myTable";

$result = mssql_query( $query );

while($row = mssql_fetch_row($result)){
echo $row[0] . " " . $row[1] . " " . $row[2] . "<br>";
}

Not tested, but should work...........

Ok here is my present code based on what you gave me:

<?php

$DBhost = "mysqlserver";
$DBuser = "username";
$DBpass = "password";
$DBName = "brownpauls";
$table = "myTable";

/ Connecting, selecting database /
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");

mysql_select_db("$DBName") or die("Unable to select database $DBName");
echo "Connected Successfully";

/ Performing SQL query /
$query = "select firstName, lastName, emailAddress from myTable";

$result = mssql_query($query);

while($row = mssql_fetch_row($result)){
echo $row[0] . " " . $row[1] . " " . $row[2] . "<br>";
}

/ Closing connection /
mysql_close();

I get the following error:

Call to undefined function: mssql_query() in /var/www/brownpauls/myTable2.php on line 18

What am I doing wrong?

Sorry, obscure typos on my part. I did some cut and pasting and grabbed the MS versions instead of the mySql versions

The mssql stuff needs to be mysql

$result = mysql_query($query);

while($row = mysql_fetch_row($result)){
echo $row[0] . " " . $row[1] . " " . $row[2] . "<br>";
}

THANKS!