get the first row only

jpn

I apoligise if this is a question with an easy answer but...

My mySQL table only has many fields but only 1 row in it.

How can I retrieve only 1 row of data. All the coding examples I have seen expect multiple rows and therefore provide coding examples using loops but thats not what I want.

Here what Im trying to achieve using code and english:

$query = "SELECT * from sysControl";
$result = @mysql_query($query);

if ($result){

  $page_title = firstcolumn;
  $page_content = secondcolumn

  and so on...

}

Hope this makes sense!!

warpkat

Add:

LIMIT 1

to the end of your query:

SELECT * from MyTable LIMIT 1

Of course you'll want to modify the ordering to your liking...

Piranha

You can use loops with one result as well, the result will be that it will only loop once. But if you know that it won't be more than one result you can use a if-statement instead, something like this:

$sql = "SELECT something FROM table WHERE id = 1";
$result = mysql_query($sql);
if ($row = mysql_fetch_assoc($result)
{
   $column = $row['columnname'];
   // other things to do
}