[RESOLVED] Use of echo in PHP

phprooky

Hi everyone,
I have a php page with the following select to my daabase:

$host=""; // Host name 
$username=""; // Mysql username 
$password=""; // Mysql password 
$db_name=""; // Database name 
$tbl_name=""; // Table name 
 //Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

$sql= "select concat(post,'', post1) as posted from tbl_name order by id desc limit 1";
$result=mysql_query($sql);
while($row = mysql_fetch_array($result))
  {
$updates=$row;
   }
mysql_close($con);

Then, in another page which is my main page I added the following at the begging of my page:

<?php include 'my_otherpage.php';?>

Then in the same main page I added another php code to bring the data using the following:

<?Php echo $updates; ?>

And this is the message I receive: Array
Not the information on my database.
Can anyone please help me?

bradgrafelman

It returns the word "Array" because $updates is an array, not a string. Either treat it as an array, or use [man]mysql_result/man to return a string (since you're only selecting one column from one row).

phprooky

Hi bradgrafelmann,
Is this what you mean:
$host=""; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name=""; // Table name
//Connect to server and select databse.
$link=mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$result= mysql_query('select post from tbl_name order by id desc limit 1');
echo mysql_result($result);
mysql_close($link);

bradgrafelman

You're missing the second parameter that [man]mysql_result/man expects. Other than that, you should see the data from the 'post' column using that code.

phprooky

I have it now. This is what I did:

$host=""; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name=""; // Table name
//Connect to server and select databse.
$con=mysql_connect("$host", "$username", "$password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
$db_selected = mysql_select_db("$db_name", $con);
mysql_select_db("$db_name")or die("cannot select DB");

$sql= "select post from tbl_name order by id desc limit 1";
$result=mysql_query($sql,$con);
echo mysql_result($result,0);
mysql_close($con);

Thanks for your help!!