Row and column data

[apr1515]

How can i get the last row data from a certain column?

[Pikachu2000]

Can you clarify what you're trying to do, please? Would this be immediately after an insert, or what?

[apr1515]

i want to post(in text) the data from hmmm... let's say the data from 3x7 on my site.

[Pikachu2000]

While I'm sure what you said makes perfect sense to you, unfortunately it makes absolutely none to me.

[moreira]

ok, let see if is that that you want:

<?php  
$connection = mysql_connect("host", "username", "password") or die(mysql_error());
//Connection to the database. Error out if the connection fails for 

@mysql_select_db('yourdatabasename');
//Select the database

$query = mysql_query("SELECT * FROM tablename WHERE id = 7");
$row = mysql_fetch_array($query);
echo 	"<h1>" . $row['description'] . "</h1>";     
?>

In this example, let supose that your column3 name is "description" and the 3rd row of your table have the id 7

 

hope i'v been useful.

 

Best regards,

Moreira