I have made this little script that selects everything from a table and then outs 2 fields. Eeverything at th emoment is in the same line.
At the moment it comes out like:
Data: scottscott@test scott1scott1@test scott2scott2@test scott3scott3@test
As you can see, everything is in one long line - as there are 4 entried into the database.
I would like to get it like this:
name: scott
email: scott@test
name: scott1
email: scott1@test
name: scott2
email: scott2@test
name: scott3
email: scott3@test
Heres the script - any ideas?
Is this easy to do?
<?php
define('DB_HOST','itdepartment01');
define('DB_USER','sa');
define('DB_PASS', 'xxxxx');
define('DB_NAME','itrequest');
if(! $conn = mssql_connect(DB_HOST,DB_USER,DB_PASS)){
exit ("Wheres the DB_HOST gone?");
}
if(! mssql_select_db(DB_NAME, $conn)){
exit ("Wheres the database gone?");
}
$query = "SELECT * FROM requests";
$result = MSSQL_QUERY($query);
$number = MSSQL_NUM_ROWS($result);
$i=0;
if ($number == 0) :
print "No data?";
elseif ($number > 0) :
print "Data:
";
while ($i < $number) :
$requester = mssql_result($result,$i,"requester");
$email = mssql_result($result,$i,"email");
print $requester;
print $email;
print "
";
$i++;
endwhile;
endif;
?>
Scott
