Jump to content

Display A Link Only If The Query Returns Results


azocomposto

Recommended Posts

Hello,

how can I view (or appear to) a link if the query returns me the number of rows greater than 1?

 

I have write this simple php code, but the message (echo ...) do not appear

 

 

<?php
$resultt = mysql_query
(" SELECT *
 FROM tabella");
$rows=mysql_fetch_array($result);

if (mysql_fetch_array($rows) > 0)
{
   echo 'in this area writing a link';

}  
?>

 

thanks

Since running a query actually makes you get all the results (which mysql_query() does automatically for you) stick a LIMIT 1 on the end so that if there are results you'll only have to discard the one row.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.