How do i output my database data echo()??

[brad12345]

hi all i think my database has been updated and i want to check to see if the rows have been updated in my table how would i go about this?

 

 

$addOwner = $_POST['addOwner'];
$phoneNumber = $_POST['phoneNumber'];
$address = $_POST['address'];
$ownerName = $_POST['ownerName'];
$title = $_POST['title'];




echo("<font face='Arial'>");
$self = $_SERVER['PHP_SELF'];

if (isset($_POST['addOwner']))
{

	//Insert new owner data into the database martinb 
	$createQuery1 = "INSERT INTO tblOwnerBK (title, ownerName, address, phoneNumber) VALUES ('$title','$ownerName','$address','$phoneNumber')";

	$selectString = "SELECT * FROM tblOwnerBK";  //Selects all owner details

// dont know what to do after this????

[oron]

Not sure whether this is what your looking for, haven't done php for a while so sorry if it doesnt work

$addOwner = $_POST['addOwner'];
$phoneNumber = $_POST['phoneNumber'];
$address = $_POST['address'];
$ownerName = $_POST['ownerName'];
$title = $_POST['title'];




echo("<font face='Arial'>");
$self = $_SERVER['PHP_SELF'];

if (isset($_POST['addOwner']))
{

	//Insert new owner data into the database martinb 
	$createQuery1 = "INSERT INTO tblOwnerBK (title, ownerName, address, phoneNumber) VALUES ('$title','$ownerName','$address','$phoneNumber')";

	$selectString = "SELECT * FROM tblOwnerBK";  //Selects all owner details

                while($row = mysql_fetch_assoc($selectString)) {
                        echo $row['title];
                        //Then just keep doing the same for the rest of them, and add some formatting
                }

[brad12345]

im getting this error back

 

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource

[BlueSkyIS]

the string $selectString is not a mysql resource. you have to run the query to get the resource:

 

$resource = mysql_query($selectString) or die(mysql_error(). " in $selectString");