[Which PHP-Editor do you think is the best?]

LiteEdit - enhanced notepad

[[SOLVED] Need help on how to retrieve the respective value of array from another table???]

My email is public.

So yes.

[Option tag?]

See http://www.w3.org/TR/html4/interact/forms.html#edef-OPTION.

Besides this parameter doesn't work in IE browser.

[[SOLVED] Need help on how to retrieve the respective value of array from another table???]

Yes.

  if (!empty($catids)) {
    $query = "select catid, name from categories where catid in (".$catids.")";
    // select catid, name from categories where catid in (1,2,3)
    $res = mysql_query($query);
    while($row = mysql_fetch_assoc($res)) 
      $ar_cate[] = $row['catid'].' '.$row['name'];
  }

[[SOLVED] Need help on how to retrieve the respective value of array from another table???]

As long as you don't want to add another table (it would be more efficient)

you can use

  $catids = getImplodeCategoriesByEmail($email);
  if (!empty($catids)) {
    $query = "select catid, name from categories where catid in (".$catids.")";
    // select catid, name from categories where catid in (1,2,3)
  }

[Option tag?]

I'm using this and later when proceeding form check wheter is foo not empty.

It's because IE users are still able to select disabled option.

<select name="foo" onchange="if(this.value=='')this.value=1;">
<option value="1">Option 1
<option disabled value="" style="color: gray">Option 2
<option value="2">Option 3
</select>

[download limiter]

You can let user download your file through the php script.

<?php
  // download.php

  //...
  // first check wheter user can download this file once more time
  // you can save download times into your db.

  if ($user_can_download) {
    // if it is a zip file
    // you can store your file somewhere where users can reach it 
    $file = './myfilestorage/file_01.zip';

    Header('Content-type: application/x-zip-compressed');
    Header('Content-Disposition: attachment; filename="file_01.zip"');
    Header('Content-length: '.filesize($file));

    readfile($file);
    Exit;
  } else {
    //... normal output telling user you can't download this file anymore
  }

[dynamic text boxes: changing the rank]

If you don't need id values.

Or you can use style.zIndex as a temporary storage.

<script type="text/javascript">
function SwapValues(frst, sec) {
  var val = frst.value;
  frst.value = sec.id;
  sec.value = val;
  delete frst; delete sec; delete val;
}
function updateForm (which) {
  if (document.rankem.a != which && document.rankem.a.value == which.value) SwapValues(document.rankem.a, which);
  else
  if (document.rankem.b != which && document.rankem.b.value == which.value) SwapValues(document.rankem.b, which);
  else
  if (document.rankem.c != which && document.rankem.c.value == which.value) SwapValues(document.rankem.c, which);
  else
  if (document.rankem.d != which && document.rankem.d.value == which.value) SwapValues(document.rankem.d, which);

  delete which;
}
</script>
<form id="rankem" name="rankem" method="post" action="">
  <p>
    <input name="a" type="text" id="0" size="3" value="1" onfocus="this.id=this.value" onchange="updateForm(this);" />
  </p>
  <p>
    <input name="b" type="text" id="0" size="3" value="2" onfocus="this.id=this.value" onchange="updateForm(this);" />
  </p>
  <p>
    <input name="c" type="text" id="0" size="3" value="3" onfocus="this.id=this.value" onchange="updateForm(this);" />
  </p>
  <p>
    <input name="d" type="text" id="0" size="3" value="4" onfocus="this.id=this.value" onchange="updateForm(this);" />
  </p>
</form>

[[SOLVED] Why doesn't this pedigree work?]

I think all you need to add is few if statements

//Get Sire
  if (is_numeric($row['SireID'])) {
   $SireQ = $sql . $row['SireID']; 
   ....  
//Get PatGrandSire info
    if (is_numeric($SireRow['SireID'])) {
      $PatGrandSireQ = $sql . $SireRow['SireID'];
      ....
   //Get Pat1GGrandSire info
      if (is_numeric($PatGrandSireRow['SireID'])) {
         $Pat1GGrandSireQ = $sql . $PatGrandSireRow['SireID'];
         ....

      }//PatGrandSireRow[sireID]

    }//SireRow[sireID]

  }//row[sireID]

///////////

// in outputting data you just check wheter is your array set
<small>
Sire
".(isset($SireRow) ? $SireRow['RegName'] : '')."</small>

[[SOLVED] Is this header behavior normal?]

PHP page stops executing only at the end of the script, on the errors occure or you can stop the process by calling die() or exit() command.

 

[Hiding Row (javascript-php-html-css)]

Cause css style doesn't get into the element style definition. So the default value of style.display is empty string.

function Show(e) {
  document.getElementById(e).style.display = document.getElementById(e).style.display != 'block' ? 'block' : 'none';
  delete e;
}

[Is it just me?]

for example

$count = $num1*1 + $num2*1;

[storing javascript in a database]

You wish to store this block of data into the database?

If so

$data = '<a href="..." onclick=" ('som..')">Here</a>';
mysql_query(sprintf("update table set field = '%s' where id = 1",
  htmlspecialchars($data, ENT_QUOTES)
));

[ppopulating select rad and chk input elements with posted data.]

<select name="stats">
<option value="0">0
<option value="1" selected>1
</select>

<input type="checkbox" name="sel" checked>

<input type="radio" name="rad" value="1" checked>
<input type="radio" name="rad" value="2">

[passing form variables]

if the form has method set to post you can use

  reset($_POST);
  while(list($key,$value) = each($_POST)) {
    $ar_form_variables[$key] = $value;
  }

[[SOLVED] Need Help Using AJAX To Send 2 Variables In A Query]

You have syntax error here

http.open('get', 'http://domain.com/sub1/items.php?cat='+cat&updown='+updown);

Should be

http.open('get', 'http://domain.com/sub1/items.php?cat='+cat+'&updown='+updown);

[Displaying Sql Data within a PHP page]

You can add some tests messages just to see what is happining in your script.

<?php

  $action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : '');
  echo 'Action: '.$action.'<br />';
  if (($action == 'edit') && isset($HTTP_GET_VARS['oID'])) {
    $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);
    echo 'oID: '.$oID.'<br />';

    $orders_query = tep_db_query("select orders_id from holding_orders where orders_id = '" . (int)$oID . "'");
    $order_exists = true;
    if (!tep_db_num_rows($orders_query)) {
      echo 'Error, order doesn\' exists.<br />';
      $order_exists = false;
      $messageStack->add(sprintf(ERROR_ORDER_DOES_NOT_EXIST, $oID), 'error');
    } else {
      echo 'Order does exists!<br />';
    }
  }
  echo 'orderheld.php';
  include(DIR_WS_CLASSES . 'orderheld.php');
  Exit;
?>

 

Now if you run mainpage with parametrs mainpage.php?action=edit&oID=1 you should see

Action: edit<br />
oID: 1<br />
Order does exists!<br />
orderheld.php

 

If you don't than you can see there is something wrong with this part.

But if you do - delete Exit; command and put more tests further more and test again.

 

 

My tip is that you are missing some important includes. With tep_ etc. functions and database connections.

[Sorting in php]

Perhaps your are not running PHP 5.X and newer.

See http://www.php.net/exceptions

[Changing from Single to multiple select]

<?php
  //overview
  include('database.php');
  $query = "SELECT * FROM polls1 ORDER BY id DESC LIMIT 1";
  $rez = mysql_query($query);
  $row = mysql_fetch_array($rez);
  $id=$row['id']; 
  print('<center>
    <form action="'.$_SERVER['PHP_SELF'].'" method="POST">
    <br>"'.$row['quest'].'"<br />
    <br>"'.$row['a'].'"<input type="checkbox" name="a"><br />
    <br>"'.$row['b'].'"<input type="checkbox" name="b"><br />
    <br>"'.$row['c'].'"<input type="checkbox" name="c"><br />
    <br>"'.$row['d'].'"<input type="checkbox" name="d"><br />
    <br />
    <input type="submit" name="action" value="Send!">
    </form>
    </center>
  ');
   
  // you can use this code to write one result from radio checks too.
  // because in that case only one value will be filled
  if(isset($_POST['action']))
  {
    $a = empty($_POST['a']) ? 0 : 1;
    $b = empty($_POST['b']) ? 0 : 1;
    $c = empty($_POST['c']) ? 0 : 1;
    $d = empty($_POST['d']) ? 0 : 1;
    
    if ($a + $b + $c + $d > 0) {
      $query = "UPDATE results2 SET a = a + %d, b = b + %d, c = c + %d, d = d + %d WHERE id = %d";
      mysql_query(sprintf($query, 
         $a, $b, $c, $d, $id
      ));
    }
  }
  
  print('<a href=results.php>Results</a>');
?>

[[SOLVED] Why doesn't this pedigree work?]

Shouldn't you be using $SireGGrandSireRow in the last two levels?

And from middle of your code you are writing data into pedigree array under the same key values.

if ($SireGGrandSireR) {
  $SireGGrandSireRow = mysql_fetch_array ($SireGrandSireR, MYSQL_ASSOC);
  $pedigree['DamGrandGrand'] = $SireGGrandSireRow['RegName'];
  $pedigree['DamGrandGrandSireID'] = $SireGGrandSireRow['SireID'];
  $pedigree['DamGrandGrandDamID'] =$SireGGrandSireRow['DamID'];
  $message.= "<td class=shade>GrandGrandDam - ".$SireGGrandSireRow ['RegName']."</td>";   
}

 

I would use other way to get those data.

Split this task into two parts - get the data, output data.

  $pedigree = array();
  
  $sql    = "SELECT RegName, SireID, DamID FROM Pedigrees WHERE ID in (%s)";
  
  $result = mysql_query(sprintf($sql, $values['ID']));

  if ($result) {
    $row = mysql_fetch_assoc($result);
    $pedigree[$row['ID']] = $row;
    
    $newIDs = array();
    if (!empty($row['SireID'])) $newIDs[] = $row['SireID'];
    if (!empty($row['DamID'])) $newIDs[]  = $row['DamID'];
    
    $level = 1;
    $maxlevel = 3;
    while (count($newIDs) > 0 && $level <= $maxlevel) {
      
      // select all current anc.
      $newIDs = array();
      $ancres = mysql_query(sprintf($sql, Implode(", ", $newIDs)));
      if ($ancres) {
        while ($row = mysql_fetch_assoc($ancres)) {
          $pedigree[$row['ID']] = $row;
          if (!empty($row['SireID'])) $newIDs[] = $row['SireID'];
          if (!empty($row['DamID'])) $newIDs[]  = $row['DamID'];
        }
      }
      
      ++$level;
    }

    $row = $pedigree[$values['ID']];
    // prepare empty output assoc array with first Reg value.
    $outped = array('Reg' => $row['RegName'], 
            'Sire' => '', 'Dam' => '', 'SireSire' => '', 'SireDam' => '', 'DamSire' => '', 'DamDam' => ''
            ....
            );
    if (!empty($row['SireID']) && isset($pedigree[$row['SireID']])) {
      $sirerow = $pedigree[$row['SireID']];
      $outped['Sire'] = $sirerow['RegName'];
      
      if (!empty($sirerow['SireID']) && isset($pedigree[$sirerow['SireID'])) {
        $SireSire = $pedigree[$sirerow['SireID']];
        $outped['SireSire'] = $SireSire['RegName'];
        if (!empty(......
          // another anc.
        }          
      }
      if (!empty($sirerow['DamID']) && isset($pedigree[$sirerow['DamID']])) {
        $SireDam = $pedigree[$sirerow['DamID']];
        $outped['SireDam'] = $SireDam['RegName'];
        if (!empty(...
          // another anc.
        }
      }  
      
    } 
    
    if (!empty($row['DamID']) && isset($pedigree[$row['SireID']])) {
      $damrow = $pedigree[$row['SireID']];
      $outped['Dam'] = $damrow['RegName'];
      
      if (!empty($damrow['SireID']) && isset($pedigree[$damrow['SireID']])) {
        $DamSire = $pedigree[$damrow['SireID']];
        $outped['DamSire'] = $DamSire['RegName'];
        if (!empty(....
          // another anc.
        }
      }
      
      ....
    }
  
    // output data
    $message  = "<table cellspacing=1 cellpading=1><tr><td colspan=4 align=center class=blackshade>Pedigree Table</td></tr>";
    $message .= "<tr><td colspan=8 class=shade>RegName - ".$outped['Reg']."</td></tr>";
    $message .= "<tr><td rowspan=4 class=shade>Sire - ".$outped['Sire']."</td><td rowspan=4 class=shade>Dam - ".$outped['Dam']."</td></td>";
    $message .= "<tr><td rowspan=2 class=shade>SireSire - ".$outped['SireSire']."</td>".
                    "<td rowspan=2 class=shade>SireDam - ".$outped['SireDam']."</td>".
                    "<td rowspan=2 class=shade>DamSire - ".$outped['DamDam']."</td>".
                    "<td rowspan=2 class=shade>DamDam - ".$outped['DamDam']."</td>".
                    "</tr>";
    ....

  }

[[SOLVED] PHP + Mysql delete from table row]

Ok 

Can you describe what is wrong with your script?

(I don't know background objects so it is hard to say)

[[SOLVED] PHP + Mysql delete from table row]

Try this

  if (isset($_GET['delete']) && is_numeric($_GET['delete'])) {
    // you should always control what users send you via your variables.
    // someone "clever" could open [url]ordersholding.php?delete=1 or (1 = 1)[/url] and delete your whole database
    $delete = $_GET['delete']*1;
    tep_db_query("delete from " . TABLE_HOLDING_ORDERS . " where orders_id = " . $delete . "");
    tep_db_query("delete from " . TABLE_HOLDING_ORDERS_PRODUCTS . " where orders_id = " . $delete . "");
    tep_db_query("delete from " . TABLE_HOLDING_ORDERS_PRODUCTS_ATTRIBUTES . " where orders_id = " . $delete . "");
    tep_db_query("delete from " . TABLE_HOLDING_ORDERS_TOTAL . " where orders_id = " . $delete . "");
  }

 

[[SOLVED] date of birth to display as age?]

 $dop = '1981-07-13';
  $age = Date("Ymd") - Date("Ymd", strtotime($dop));
  echo 'I\'m '.floor($age / 10000).' years old.';

[[SOLVED] help with if statement in function]

You are filling $tourn varibale but testing $tour variable.

while($row = mysql_fetch_array($result,MYSQL_NUM)) {
  $tourn = $row[2]; //!
}
if (($type == 'course') && ($tourn == 'INTERMEDIATE')) {
    $sendto = "intermediatecourses@cycleyorkshire.co.uk";
} elseif (($type == 'course') && ($tourn == 'BEGGINNER')) {
    $sendto = "begginercourses@cycleyorkshire.co.uk";
} elseif ($type == 'tour') {
    $sendto = "tours@cycleyorkshire.co.uk";
} else {
    // Unknown tour type
    return false;
}
echo $sendto;

 

[plzzzzzz help in formatted output]

  while( ($dest = 4) && !isset($b) && (($b = ($max = $dest * ($i = $j = 1) + 1) < 0) == false) ) 
    while ((!$b && $i < ($max + ($j = 0))) || ($b && ($i-- > 0 + ($j = 0))) )
      while( (($j < $i ? ++$j : $max + (!$b ? ++$i : (5 + $i)) ) <= $max && print($j))  
          || !print("<br />".(($b = $b || ($i == $max)) ? (($i = ($i == $max ? $i - 1 : $i)) ? '' : '') : ''))
      ) ;