[SOLVED] Problem

[SkyRanger]

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.

[suttercain]

With this section:

if ($rowb['bpid']) {

 

Is that suppose to be $rowb['bid']? Or do you have a column in your MySQL table named bpid?

[warewolfe]

use isset() to check the variable without the script failing.

[jitesh]

is bpid same bid

 

 

Run this script and post o/p

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



echo "<pre>";
print_r($rowb );




if ($rowb['bpid']) {
   echo $rowb['blfpost'];
   echo "<br>";
............
............

[SkyRanger]

No, that part is correct. I have a bid and bpid but as I mentioned I can get the show part if it exists but can't get it to show the not exists part which is the ----- and $origpost; data

[SkyRanger]

2 tables

 

Table 1 just has bid

 

table 2 has bid and bpid

 

T1 bid = T2 bid

 

bid = Board ID

bpid = Board Post ID

 

If bid=$bid in T2 is not there then I want it to echo ---- and $orig...

[SkyRanger]

is bpid same bid

 

 

Run this script and post o/p

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

echo "<pre>";
print_r($rowb );

if ($rowb['bpid']) {
   echo $rowb['blfpost'];
   echo "<br>";
............
............

 

Table is empty so it will display nothing.

[jitesh]

if (isset($rowb['bpid']) and is_numeric($rowb['bpid'])) {

echo $rowb['blfpost'];

  echo "<br>";

........

.......

[jitesh]

If table is empty then it will not go in to while loop.......

[suttercain]

Dumb question but I'll ask anyway... Are there any 'bpid' rows in your database that are empty... NULL?

[suttercain]

if (!isset($rowb['bpid'])) {
   echo "OrigDate: " . $origdate;
   }

[SkyRanger]

My table is empty, so Not sure what the problem is.  In my board table there is a bid in my board_post table there is nothing.  When there is nothing in the board_post table it should read $origpost

[jitesh]

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;

 

}

 

[SkyRanger]

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.

[SkyRanger]

bump

[SkyRanger]

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;

 

[SkyRanger]

~bump~

[MadTechie]

whats the problem/error/question!!

[SkyRanger]

Weird things is I am not getting any errors, The problem is that if bid is not existing in board_post then the  } else { code } is not displaying.

[SkyRanger]

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'];
}
}

[taith]

YAY! I WIN! *pats himself on the head*

 

 

what do i win?