Code: Select all
<?php
$query = "SELECT * FROM accounts WHERE account_id={$account_ref}";
$results = mysql_query($query);
while($line = mysql_fetch_array($results)) {
echo $line['name'];
echo "<br/>";
}
$query = "SELECT * FROM accounts WHERE account_id={$account_ref}";
$results = mysql_query($query);
while($line = mysql_fetch_array($results)) {
echo $line['max_users'];
echo "<br/>";
}
$query = "SELECT * FROM accounts WHERE account_id={$account_ref}";
$results = mysql_query($query);
while($line = mysql_fetch_array($results)) {
echo $line['account_id'];
echo "<br/>";
}
?>
Should I be retrieving my data in a different way first - i.e. filling a group of array and then using the array data rather than multiple queries, or is this still the best way of going about it?
Many thanks in advance, hope you're all having a cool day!