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";
}