Inserting data into tables and outputting all

[Breekan]

Let's say I have a table like so called "forum"

code:--------------------------------------------------------------------------------
NAME: EMAIL:
Test [e-mail]

Test2 [e-mail]

How would I output from the bottom up? If I wanted the output on the page to be:

Name: Test2 Email: [e-mail]
Name: Test Email: [e-mail]

<?php
REVERSE ORDER OF TABLE SOMEHOW
while (*SOMETHING MEANING "MORE ROWS TO BE READ"*){
echo "Name: $name <br>E-mail Address:  $email <br><hr>";
//I want this to output the data from current row somehow

}


?>

[bastien]

then its easy

select * from table oder by id desc

which tells the dataset to be use id and reverse the order

hth

[daynah]

When you say 'table,' I'm going to assume it's a mysql database. And I'll assume you have the fields id, name, and email in a table called 'mytable'. I will also assume you want to output it in the reverse order starting with the last 'id.'

With these assumptions in mind, I should you a small snippet.

1) First, you'd need to connect to the database, and run the query.

<?

// Please fill in your $host, $username, and $dbpword variables
$db = mysql_connect( $host, $username, $dbpword );
$connection = mysql_select_db( $database, $db );

?>

2) Now you need to run your query

<?

$result = mysql_query("SELECT id, name, email from mytable ORDER BY id DESC");

while($mydata = mysql_fetch_object($result))
{
	echo 'Name: ' . $mydata->name . ' Email: ' . $mydata->email . '<br />';
}

?>

In this step, the query selects all the needed fields, and then reverse the order from the last entry to the first. I'm assuming you want to reverse by id here, but you can pick another field if you like.

The while statement is very simple. I'm using mysql_fetch_object() here, but you are free to use mysql_fetch_array(), or mysql_fetch_row() if you like.

Within each loop, it will print out:
Name: (the name) Email: (email)

You can make this look better by putting it in a table later on.

That's about it. I hope I answered your question. 🙂

[Breekan]

<?php
$result = mysql_query("SELECT name, email, comments from forum");

while($mydata = mysql_fetch_object($result))
{
    echo 'Name: ' . $mydata->name . '<br />' . ' Email: ' . $mydata->email . '<br />' . 'Comments: ' . $mydata->comments;
}
?>

It says the "while($mydata..." line contains an invalid argument

[daynah]

Is there data in the database? Try checking number of rows first and then do the while statement if there's data.

<?

$result = mysql_query("SELECT id, name, email from mytable ORDER BY id DESC");
$num_rows = mysql_num_rows($result);

if(!$num_rows)
	echo "I have no data in my database.";
else
{
	while($mydata = mysql_fetch_object($result))
	{
		echo 'Name: ' . $mydata->name . ' Email: ' . $mydata->email . '<br />';
	}
}
?>

[Breekan]

Strange...

$num_rows = mysql_num_rows($result);

seems to have an invalid argument

and it displays no data even though when I check my table there are values

[Breekan]

When I debug it by removing the ! of !$num_rows I get an error on line 44, which is that same while-loop statement

[daynah]

If the statement: "SELECT name, email, comments from forum" is correct, then maybe you're not connecting to the right database? Can you check again?