Click to See Complete Forum and Search --> : Reading tables from Database?


Dennis_Ingham
08-10-2006, 07:47 AM
I have created a database with two columns an ID column and a text column.

How do I tell PHP that I want to read the texts from ID = 1 to ID = 5?

Cheers
Dennis

NogDog
08-10-2006, 07:53 AM
$connx = mysql_connect('localhost', 'user', 'pwd') or die("DB connect failed");
mysql_select_db("db_name") or die("Select DB failed. ".mysql_error());
$query = "SELECT `text_column` FROM `table_name` WHERE `ID` >= 1 AND `ID` <= 5";
$result = mysql_query($query) or die("Query failed: $query - ".mysql_error());
while($row = mysql_fetch_assoc($result))
{
echo "<p>".$row['text_column']."</p>\n";
}