Select problems!

[Maleko]

Ok, ive been rattling my brains...i cant seem to be bale to get the rows from my table, and put them on a web page!!

So, I can connect to my database easy:

<?php
//Database connection
	$user="user
	$host="host";
	$password="pass";
	$database = "database";
//If fail to connect, error
	$connection = mysql_connect($host,$user,$password)
			or die ("Couldn't connect to server");
	$db = mysql_select_db($database,$connection);

ok.where do I go from there??

All i want is to slect the table where my info is, then select all rows in it, and put each info in a table on a website...

Just want to fetch, for example, a name, and email address, and put it in a table...

Cany anyone help me out here??

Also...is is possible to select about 10 rows in a table, then stop, and contine the next 10 on a seperate web page? or is that complex? cheers!

[nicdp]

After $connection... just put something like:

$select = mysql_query("SELECT var1,var2,var3 FROM table WHERE [put here condition]", $connection);
while($query = mysql_fetch_array($select)){
$var1 = $query["var1"];
$var2 = $query["var2"];
$var3 = $query["var3"];
echo $var1;
echo $var2;
echo $var3; }

Just put echos in the cells you want...

To split results on more pages read: http://www.phpbuilder.com/columns/rod20001214.php3

[nicdp]

Also give a look at this to see how to split results on more pages.

And read this to learn about mysql_query funtion.

And this to know more about select query.

[Maleko]

excellent, cheers!!