Mulitple lines of script in PHP

bustersnm · November 2, 2007, 1:22am

Hi guys, this is what i need help with, I would like it to pull diffrent rows of dat from the ID. WHERE id=’.intval(2)); But i want it with multiples of id numbers like 1,2,3,4,5,6,7, etc.

Here is my page i want it to look like: http://www.nuffracingleague.com/NuffStandings.html

<?php $username="MYUSERNAME"; $password="MYPASSWORD"; $database="MYDATABASE"; mysql_connect(localhost,$username,$password); mysql_select_db($database) or die( "Unable to select database"); $result=mysql_query('SELECT * FROM `standings` WHERE `id`='.intval(1)); if($row=mysql_fetch_assoc($result)) echo ' $result=mysql_query('SELECT * FROM `standings` WHERE `id`='.intval(2)); if($row=mysql_fetch_assoc($result))

Rank	Points Behind	Driver/Car	Points	Wins	Starts	Poles	Top 5s	Top 10s
'.htmlentities($row['rank']).'	'.htmlentities($row['pointsbehind']).'	'.htmlentities($row['drivers']).'	'.htmlentities($row['points']).'	'.htmlentities($row['wins']).'	'.htmlentities($row['starts']).'	'.htmlentities($row['poles']).'	'.htmlentities($row['top5s']).'	'.htmlentities($row['top10s']).'
Rank	Points Behind	Driver/Car	Points	Wins	Starts	Poles	Top 5s	Top 10s
'.htmlentities($row['rank']).'	'.htmlentities($row['pointsbehind']).'	'.htmlentities($row['drivers']).'	'.htmlentities($row['points']).'	'.htmlentities($row['wins']).'	'.htmlentities($row['starts']).'	'.htmlentities($row['poles']).'	'.htmlentities($row['top5s']).'	'.htmlentities($row['top10s']).'

'; else echo 'entry number '.intval($_GET['id']).' is not existing'; ?>

Q1712 · November 2, 2007, 3:06am

WHERE id>=1 AND id<=10 ORDER BY id

bustersnm · November 2, 2007, 6:08am

<?php $username="MYUSERNAME"; $password="MYPASSWORD"; $database="MYDATABASE"; mysql_connect(localhost,$username,$password); mysql_select_db($database) or die( "Unable to select database"); $result=mysql_query('SELECT * FROM `standings` WHERE `id`>=1 AND `id`<=47 ORDER BY `id`'); { echo '.....'; } while($row=mysql_fetch_assoc($result)) echo ' echo (''); echo (''); echo (''); echo (''); echo (''); echo (''); echo (''); echo (''); echo (''); echo (''); echo (''); echo (''); echo (''); echo (''); echo (''); echo (''); echo (''); echo (''); echo (''); echo (''); }

Rank	Points Behind	Driver/Car	Points	Wins	Starts	Poles	Top 5s	Top 10s
'.htmlentities($row['rank']).'	'.htmlentities($row['pointsbehind']).'	'.htmlentities($row['drivers']).'	'.htmlentities($row['points']).'	'.htmlentities($row['wins']).'	'.htmlentities($row['starts']).'	'.htmlentities($row['poles']).'	'.htmlentities($row['top5s']).'	'.htmlentities($row['top10s']).'

'; ?>

bustersnm · November 3, 2007, 12:25am

Why is my data not showing?
http://www.nuffracingleague.com/NuffStandings2.html the info on the right would be from the data base the info on the left is still HTML.

thanks

<?php $username="MYUSERNAME"; $password="MYPASSWORD"; $database="MYDATABASE mysql_connect(localhost,$username,$password); mysql_select_db($database) or die( "Unable to select database"); if($row=mysql_fetch_assoc($result)) $result=mysql_query('SELECT * FROM `standings` WHERE `id`>=1 AND `id`<=47 ORDER BY `id`');

echo ’

Rank	Points Behind	Driver/Car	Points	Wins	Starts	Poles	Top 5s	Top 10s
'.htmlentities($row['rank']).'	'.htmlentities($row['pointsbehind']).'	'.htmlentities($row['drivers']).'	'.htmlentities($row['points']).'	'.htmlentities($row['wins']).'	'.htmlentities($row['starts']).'	'.htmlentities($row['poles']).'	'.htmlentities($row['top5s']).'	'.htmlentities($row['top10s']).'

'; ?>[