if row num 0 DISPLAY TEXT IN BODY

christL

I've been looking for a thread on this but can't seem to find anything.

What's the lowdown on getting a line of text to display (in the body of the page - not the top) if there are no records returned from the search.

I know it's got something to do with this:

if ($num_rows == 0)
{
echo 'Sorry your search did not return any results. Please return to the search page <a href=aus.php>here</a>';
}

thanks,

christL

Mordecai

Well, do this:

if (mysql_num_rows($result) >= 1) {
  // there're some results, maybe only 1
}
else {
  // no results
}

You can also use mysql_rows_affected(), and must, if it's something other than a SELECT. This code using $result as a MySQL result ($result = mysql_query()...).

christL

Thanks for the reply... unfortunately I'm too much of a novice to know exactely what to do with your code.

Please advise😕

Does it go into the php header above all the HTML ???

and if so how do i make the text appear in the body of the page ??

thanks,

christL

Mordecai

I'm not really sure what you're trying to do. If you want the error to display in the middle of the page, put the PHP in the middle of the page:

<html>
<morehtml>
<?php
$sql = mysql_connect($server,$username,$password);
mysql_select_db($db);
$result = mysql_query($query);
if (mysql_num_rows($result) >= 1) {
  // there're some results, maybe only 1
  while ($results = mysql_fetch_array($result, MYSQL_NUM)) {
    print_r($results);
  }
}
else {
  // no results
  echo("Sorry, there were no results.");
}
?>
</morehtml>
</html>

This will print out the array from the DB using print_r and mysql_fetch_array if there were results, or print out the error if there weren't results.
Obviously, you'll have to change it to your likings.

christL

thanks I'll give it a shot.

I've already formatted a dynamic table to show the results <if any> and am just trying to get the text to display if there are no results.

I'll try modifying what you've given me.

Thanks again,

christL

That's done the job. THANKS:p

Is it possible to format that text so it's not just default style ???

If so, HOW ???

thanks again - where are you anyway ???

I'm in Byron Bay - Australia.

Cheers,

christL

Mordecai

You can use either the <font> tag or CSS stylesheets, if you want HTML formatting. If you mean something with PHP, I'm not sure what you mean (printf()?)...

If you look at the little user-info column to the left of my posts, it says that I live in Springfield, Missouri, USA (many, many miles away).

christL

yeah, thanks. I just didn't know where to put the tags for the formatting.... figured it out.

This is a bit unrelated but I'm trying to figure out how to create an IMAGE FIELD in mySQL database.

The point being so that i can attach a picture to each record.

I can't find anything about it in the Manual which leads me to think that maybe you can't.

Any clues ???

thanks,

christL

ps: I didn't know what MO stood for ???😉

Mordecai

MO = Missouri 🙂

There is nothing that's actually for images. In fact, MySQL discourages putting images in the database. However, everyone tends to use BLOB.

christL

Well Dreamweaver has finally come through with the goods on something.... it made it effortless for me (with ZERO knowledge about MySQL) to get an image field to respond along with the rest of the MySQL fields, just via a simple link.

Thanks Mr MO for your time.

Cheers,

christL

🆒