[RESOLVED] Limit output to single result

drax007

Hi there im not quite sure where im going wrong here.

I have 2 queries; the first selects all records in a table == recordID. The second selects all records in a table <> Session username.

It works! However it outputs the same $row_Fleet['FleetName'] as many times as it checks each of the FleetE records.

So my question is: How can i limit the number of outputs to a single one???

<?php 
$colname_Fleet = "-1";
if (isset($_GET['recordID'])) {
  $colname_Fleet = (get_magic_quotes_gpc()) ? $_GET['recordID'] : addslashes($_GET['recordID']);
}
mysql_select_db($database_swb, $swb);
$query_Fleet = sprintf("SELECT * FROM fleet WHERE FleetName = %s", GetSQLValueString($colname_Fleet, "text"));
$Fleet = mysql_query($query_Fleet, $swb) or die(mysql_error());
$row_Fleet = mysql_fetch_assoc($Fleet);
$totalRows_Fleet = mysql_num_rows($Fleet);


$colname_PlanetName = $row_Fleet['PlanetName'];

$colname_FleetE = "-1";
if (isset($_SESSION['MM_Username'])) {
  $colname_FleetE = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] : addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_swb, $swb);
$query_FleetE = sprintf("SELECT FleetName, PlanetName FROM fleet WHERE PlayerName <> %s AND PlanetName=%s", GetSQLValueString($colname_FleetE, "text"),GetSQLValueString($colname_PlanetName, "text"));
$FleetE = mysql_query($query_FleetE, $swb) or die(mysql_error());
$totalRows_FleetE = mysql_num_rows($FleetE);

<?php while ($row_FleetE = mysql_fetch_assoc($FleetE)){

if ($row_FleetE['PlanetName'] ==  $colname_PlanetName){
echo $row_Fleet['FleetName'];
echo' ';
}} ?>

Thanks 🙂

NogDog

Maybe do a SELECT DISTINCT for the query?

drax007

Thanks for the reply but distinct doesnt help as it still cycles through all the records and outputs the same FleetName for each occurance.

Any other ideas??

Thanks

bradgrafelman

Can you show us your DB structure and explain a little more about what it is you're trying to do?

Frankly, that code is a jumbled mess of statements that could probably be cleaned up into a single SQL query.

drax007

Fleet table
FleetName
PlanetName
Detected
PlayerName

The first query Fleet searches the table for the FleetName which is url parsed parameter from a previous page.

The second query FleetE searches the same table for the all the Fleets where the playername is NOT equal the session username (playername) AND is equal to PlanetName of the previous query Fleet.

The idea is that all FleetE records are compared with the single Fleet record matching the PlanetName. So if the PlanetName of any FleetE record is the same as the PlanetName in the single Fleet record then i want it to output the FleetName of the Fleet record.

I hope ive explained well enough.

Thanks

sneakyimp

Your second query sounds like it is likely to retrieve multiple records: "select all the records from fleet where the PlanetName matches but the PlayerName does not." If you then loop through all the results, you are going to get a bunch of records spitting out.

If you want a query that only returns one record, you need to think a bit harder about what you are asking your db to do.

drax007

I removed the while loop as it wasnt needed and hey presto it works a charm!
Thank yous 😃

sneakyimp

Well you probably should rethink your query if you only want it to return one record. Minimally, you should put something like 'LIMIT 0,1' in there so you aren't fetching tons of records and then failing to use them.

Still not sure exactly what you are trying to accomplish. It might be helpful if you described at a high-level what you are trying to accomplish. The word 'fleet' appears a lot.