Jump to content

[SOLVED] Problem


SkyRanger

Recommended Posts

Not sure why this isn't working,  It will bring up the info if there is a bid=whatever but when it doesn't have a bid it doesn't show anything.  here is what I have and you will see what I am trying todo:

 


$origdate = $postbdate->format('M d, Y  H:i');

    $bid = $row['bid'];
    $resulta = mysql_query( "SELECT * from board_post where bid='$bid'" ) or die( "Unable to select database");
                $wordnum = mysql_num_rows( $resulta );
while( $rowb = mysql_fetch_array( $resulta ) )
{

if ($rowb['bpid']) {
   echo $rowb['blfpost'];
   echo "<br>";
   echo $rowb['bpdate'];
} else {
#This section is not showing when bpid is empty or does not have a bid=$bid 
  echo "-------";
  echo "<br>";
  echo $origdate;
}
}
$origdate echos with no problem.

Link to comment
https://forums.phpfreaks.com/topic/50439-solved-problem/
Share on other sites

if(mysql_num_rows($resulta)){

while( $rowb = mysql_fetch_array( $resulta ) )

{

 

if ($rowb['bpid']) {

   echo $rowb['blfpost'];

   echo "<br>";

   echo $rowb['bpdate'];

} else {

#This section is not showing when bpid is empty or does not have a bid=$bid

  echo "-------";

  echo "<br>";

  echo $origdate;

}

}

}else{

#This section is not showing when bpid is empty or does not have a bid=$bid

  echo "-------";

  echo "<br>";

  echo $origdate;

 

}

 

Link to comment
https://forums.phpfreaks.com/topic/50439-solved-problem/#findComment-248005
Share on other sites

Grrrr.....

 

if(mysql_num_rows($resulta)){
while( $rowb = mysql_fetch_array( $resulta ) )
{

if ($rowb['bpid']) {
   echo $rowb['blfpost'];
   echo "
";
   echo $rowb['bpdate'];
} else {
#This section is not showing when bpid is empty or does not have a bid=$bid
#  echo "-------";
#  echo " ";
  echo $origdate;
}
}}

 

This isn't working either.

 

I am not sure what the heck is going on.

Link to comment
https://forums.phpfreaks.com/topic/50439-solved-problem/#findComment-248028
Share on other sites

Ok, not sure if I explained it properly to what I am trying to do:

 

Table 1 (board)

bid

btitle

bmsg

bdate

etc....

 

Table 2 (board_post)

bpid

bid

blpost

bpdate

 

 

What I am trying to do is:

 

    $origdate = $postbdate->format('M d, Y  H:i')
    $bid = $row['bid'];

    $resulta = mysql_query( "SELECT * from board_post where bid='$bid'" ) or die( "Unable to select database");

                $wordnum = mysql_num_rows( $resulta );

while( $rowb = mysql_fetch_array( $resulta ) )
{
if ($rowb['bpid']) {
   echo $rowb['blfpost'];
   echo "<br>";
   echo $rowb['bpdate'];
} else {
  echo "-------";
  echo "<br>";
  echo $origdate;
}
}

This will display if the bid = $bid and bpid is there

echo $rowb['blfpost'];
   echo "<br>";
   echo $rowb['bpdate'];

But if there is no $bid it will not display the

echo "-------";
  echo "<br>";
  echo $origdate;

 

Link to comment
https://forums.phpfreaks.com/topic/50439-solved-problem/#findComment-248144
Share on other sites

taith if you see this post, thanks,  I just found my fix in another thread that was replied to by you.  Anybody else that is looking for help, best thing to do is keep searching the forum while you are still waiting for help, because you may end of finding the answer:

 

    $origdate = $postbdate->format('M d, Y  H:i');
    $bid = $row['bid'];

$sql = mysql_query("SELECT * FROM board_post where bid='$bid'");
if(mysql_num_rows($sql)==0){
echo "-----";
echo "<br>";
echo $origdate;
}else{
while($rowb = mysql_fetch_array($sql)) {
echo $rowb['blfpost'];
   echo "<br>";
   echo $rowb['bpdate'];
}
}

Link to comment
https://forums.phpfreaks.com/topic/50439-solved-problem/#findComment-248245
Share on other sites

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.