[SOLVED] Searching a query result.

[adam291086]

I have a simple query that selects everything from a database and limits the results to one row ordered by desc. The code does work. The next step is to search the query result to see is if a certain feild has a result. I'm not sure how to do this. Any pointers are appreciated.

<?php

Include("config.php");
$con;

if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

$result = mysql_query("SELECT * FROM photos ORDER BY photo_id DESC LIMIT 1");
while($row = mysql_fetch_array($result))
{
echo $row['photo_id'];
}

?>

[trq]

The next step is to search the query result to see is if a certain feild has a result.

 

You shouldn't search through the result, but write your query in such a way to only retrieve the data you need. eg;

 

SELECT * FROM foo WHERE bar = 'val';

 

What field do you want to check and what value do you want it checked for?

[richardw]

One item that I use as part of a select that checks a specific field value  is  "metaphone".

[adam291086]

Basically what i am trying to do is search the database table and return the highest photo_id number. This equals the photo just uploaded. Then i want to check the photo_location and ensure the feild isn't empty. If it is empty then an error message is display else display photo uploaded ok.

[richardw]

 

 

SELECT  max(photo_id) as lastid  FROM  photos WHERE photo_filename <>'';

 

Or did you want to grab the filename and check to see if it was uploaded and then either display or show error?