Looking for an If statement

zonkd

The mysql select query is followed by ....

$a = mysql_fetch_array($a);

(' <div class="something">'
. $a['intro']
. '</div> <h6 class"bold"> <em>'
. $a['sub']
. '</h6></em><p>'
. '<h1 class="red">' etc etc

I'd like to say that if $a['sub'] is empty, then ignore it. Is there a way, please?

laserlight

Yes, check if it is not empty then print it.

error_22

if ($a['sub'] == "")
{
return NULL;
}
else
{
print whatever you wanna print here
}

I think that should do it...not sure though.

zonkd

Thanks, laserlight, and error_22. Will try that error_22.
Exactly, laser_light, how would you code it, please?

laserlight

Pretty much the same way.

HP400

You could also use the

if (!empty($a['sub']))

zonkd

Many thanks, error_22, laserlight and HP400 - very grateful for your help.

zonkd

... but unfortunately neither appears to work. Parse error says the browser to both, and to the variations of them that I have been trying.

Any other thoughts, please, Experts?

HP400

Post your code so around the error and we'll debug it.

zonkd

That's very kind of you, HP400. The code I am using is ....

$a = mysql_query("SELECT
intro,
sub,
head,
story,
byline,
DATE_FORMAT(updated, '%d/%m/%y %H%i')
AS ud
FROM connex
WHERE id=$id");
$a = mysql_fetch_array($a);
$b =
(' <div class="intro">'
. $a['intro']
. '</div> <h6 class"bold"> <em>'
. $a['sub']
. '</em></h6><p>'
. '<h1 class="red">'
. $a['head']
. '</h1> <p></p>'
. $a['story']
. '<div class="names2">- '
. $a['byline']
. '</div> <p><div id="date2"> <em> Updated:  '
. $a["ud"]
. '</em></p></div>'
);

What I want to happen is that if the field "sub" (for subheading) is empty, to just ignore it and move on.

When I use a different way with php to populate a webpage, I use an empty function rather like the one you proposed. However, with this method - which is necessary because of other constraints - I am having an enormous problem trying to find a way.

Hope you might be able to help.

error_22

what about the error?

zonkd

Which error, error_22? The error message? There isn't one - because it would be no help to the website visitor.

zonkd

Or do you mean the trouble I'm having? I want to say with

. $a['sub']

that if it's empty, just ignore it.

HP400

$a = mysql_query("SELECT intro, sub, head, story, byline, DATE_FORMAT(updated, '%d/%m/%y %H%i') AS ud FROM connex WHERE id=$id");
$a = mysql_fetch_array($a);
$b = ' <div class="intro">' . $a['intro'] . '</div>';
if (!empty($a['sub'])) {
$b.= '<h6 class"bold"> <em>' . $a['sub'] . '</em></h6>';
}
$b.= '<p><h1 class="red">' . $a['head'] . '</h1><p></p>' . $a['story']
. '<div class="names2">- ' . $a['byline'] . '</div> <p>
<div id="date2"> <em> Updated:  ' . $a["ud"] . '</em></p></div>'
);

Something like that?

zonkd

Just being thrown out, HP400. Will print it off and play with it overnight and report back in the morning. Many thanks for this.

zonkd

No, still doesn't, sorry to say, particularly after you went to that trouble, HP400. It ought to be so simple. At least I'm encouraged that it isn't straight forward for a fellow of your experience too.

HP400

If you want go ahead and send the whole file to me or post it up here.

zonkd

HP400
This is really very kind of you. The code works well as it is. I wanted a field called "intro" that would - surprise surprise - offer a preamble to some of the articles. But I've had to do without that because I simply can't find a way to say if it's empty, ignore it.

Similarly with the subheads, for the same reason as 'intro', all the articles have subheads whether they need it or not - not knowing how to offer the choice.

$a = mysql_query("SELECT
intro,
sub,
head,
story,
byline,
DATE_FORMAT(updated, '%d/%m/%y %H%i')
AS ud
FROM connex
WHERE id=$id");
$a = mysql_fetch_array($a);
$b =
(' <div class="intro">'
. $a['intro']
. '</div> <h6 class"bold"> <em>'
if($a['sub'] != "")
{
print $a['sub']
}

. $a['sub']
. '</em></h6><p>'
. '<h1 class="red">'
. $a['head']
. '</h1> <p></p>'
. $a['story']
. '<div class="names2">- '
. $a['byline']
. '</div> <p><div id="date2"> <em> Updated:  '
. $a["ud"]
. '</em></p></div>'
);
if (!isset($GET['page']))
{
$page = 0;
}
else
{
$page = $GET['page'];
}
// Split the text into an array of pages
$textarray = spliti('[PAGEBREAK]', $b);
// Select the page we want
$b = $textarray[$page];
$PHP_SELF = $_SERVER['PHP_SELF'];
if ($page != 0) {
$prevpage = $page - 1;
echo "<p></p><p></p><b> <a href=\"$PHP_SELF?id=$id&page=$prevpage\">".

' ... P r e v i o u s   p a g e </a></b>';
}
echo "<p><div class=\"boxed\">$b <p></p></div>";
if ($page < count($textarray) - 1)
{
$nextpage = $page + 1;
echo "<b>
<a href=\"$PHP_SELF?id=$id&page=$nextpage\">".
'R e a d   m o r e . . . </a></b><p></p>';
}
}

else

... the 'else' goes on to offer just heads and blurbs of the articles, for the student to choose which (if any) he wants to read.

Very impressed with your website. Looks v good, I must say. Cheers, HP400