date:20031110

Re: [PHP-DB] BRU Help

2003-11-10 Thread David T-G

Nitin --

...and then Nitin said...
% 
% I'm sorry, I know this is not the list, to ask this question, but I couldn't find 
the right one.

You're right; it isn't.  Neither is the PHP list.

Although I've heard of it, I've never had any involvement with BRU; I
think it's safe to say I'm pretty new to it.  Less than sixty seconds
with google led me to BMTMicro's Tech Support page where I see

   I am an end user. I am having all sorts of problems. Can you help me?
   Yes we can help you.

which certainly seems like the sort of thing you need.  Go there.


HTH  HAND

:-D
-- 
David T-G  * There is too much animal courage in 
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED]  -- Mary Baker Eddy, Science and Health
http://justpickone.org/davidtg/  Shpx gur Pbzzhavpngvbaf Qrprapl Npg!



pgp0.pgp
Description: PGP signature

[PHP-DB] form not working...

2003-11-10 Thread jas

For some reason my form to edit selected items is not working, I think I
need a new set of eyes.
Any help is appreciated...
Jas

// inc.php
function db_retrieve() {
 require 'dbase.inc.php';
 $tble = $_SESSION['table'];
 $show = @mysql_query(SELECT * FROM $tble LIMIT 0, 15,$db)or
die(mysql_error());
   while ($row = @mysql_fetch_array($show)) {
@list($nItemSKU, $bActive, $nUserID, $nItemConfig, $tItemType,
$tDepartment, $blSerialNumber, $nPropertyNumber, $blHostName, $nIPID,
$tRoomNumber, $tNotes) = $row;
 $_SESSION['table'] .= tr class=fntMAINtd valign=top
align=left$nItemSKU/td
 td valign=top align=left$bActive/td
 td valign=top align=left$nUserID/td
 td valign=top align=left$nItemConfig/td
 td valign=top align=left$tItemType/td
 td valign=top align=left$tDepartment/td
 td valign=top align=left$blSerialNumber/td
 td valign=top align=left$nPropertyNumber/td
 td valign=top align=left$blHostName/td
 td valign=top align=left$nIPID/td
 td valign=top align=left$tRoomNumber/td
 td valign=top align=left$tNotes/td
 td valign=top align=leftinput name=edit type=checkbox
value=$blSerialNumber/td
/tr; }
 $_SESSION['number'] = mysql_num_rows($show); }

?php
session_start();
require 'scripts/inc.php';
if ((!isset($_POST['edit'])) or ($_POST = )) {
 $_SESSION['table'] = t_items;
 call_user_func(db_retrieve);
} elseif ((isset($_POST['edit'])) or (!$_POST = )) {
 require 'scripts/dbase.inc.php';
  $tble = $_SESSION['table'];
  $edt = mysql_query(SELECT * FROM $tble WHERE
blSerialNumber=\$edit\,$db)or die(mysql_error());
   while ($row = mysql_fetch_array($edt)) {
list($nItemSKU, $bActive, $nUserID, $nItemConfig, $tItemType,
$tDepartment, $blSerialNumber, $nPropertyNumber, $blHostName, $nIPID,
$tRoomNumber, $tNotes) = $row;
$_SESSION['table'] .= tr class=fntMAIN
   td valign=top align=leftinput name=nItemSKU type=text size=30
value=$nItemSKU/td
   td valign=top align=leftinput name=bActive type=text size=30
value=$bActive$bActive/td
   td valign=top align=leftinput name=nUserID type=text size=30
value=$nUserID$nUserID/td
   td valign=top align=leftinput name=nItemConfig type=text
size=30 value=$nItemConfig$nItemConfig/td
   td valign=top align=leftinput name=tItemType type=text size=30
value=$tItemType$tItemType/td
   td valign=top align=leftinput name=tDepartment type=text
size=30 value=$tDepartment$tDepartment/td
   td valign=top align=leftinput name=blSerialNumber type=text
size=30 value=$blSerialNumber$blSerialNumber/td
   td valign=top align=leftinput name=nPropertyNumber type=text
size=30 value=$nPropertyNumber$nPropertyNumber/td
   td valign=top align=leftinput name=blHostName type=text
size=30 value=$blHostName$blHostName/td
   td valign=top align=leftinput name=nIPID type=text size=30
value=$nIPID$nIPID/td
   td valign=top align=leftinput name=tRoomNumber type=text
size=30 value=$tRoomNumber$tRoomNumber/td
   td valign=top align=leftinput name=tNotes type=text size=30
value=$tNotes$tNotes/td
   td valign=top align=leftinput name=save type=button value=Save
class=frmBTNS/td
  /tr; }
}
?
form action=?php echo $_SERVER['PHP_SELF']; ? method=post
?php echo $_SESSION['table']; ?
input name=edit type=button value=edit selected items
class=frmBTNS
/form

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] form not working...

2003-11-10 Thread Gary Every

Don't you need to start your form BEFORE your input type's

-Original Message-
From: jas [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 11:38 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] form not working...

For some reason my form to edit selected items is not working, I think I
need a new set of eyes.
Any help is appreciated...
Jas

// inc.php
function db_retrieve() {
 require 'dbase.inc.php';
 $tble = $_SESSION['table'];
 $show = @mysql_query(SELECT * FROM $tble LIMIT 0, 15,$db)or
die(mysql_error());
   while ($row = @mysql_fetch_array($show)) {
@list($nItemSKU, $bActive, $nUserID, $nItemConfig, $tItemType,
$tDepartment, $blSerialNumber, $nPropertyNumber, $blHostName, $nIPID,
$tRoomNumber, $tNotes) = $row;
 $_SESSION['table'] .= tr class=fntMAINtd valign=top
align=left$nItemSKU/td
 td valign=top align=left$bActive/td
 td valign=top align=left$nUserID/td
 td valign=top align=left$nItemConfig/td
 td valign=top align=left$tItemType/td
 td valign=top align=left$tDepartment/td
 td valign=top align=left$blSerialNumber/td
 td valign=top align=left$nPropertyNumber/td
 td valign=top align=left$blHostName/td
 td valign=top align=left$nIPID/td
 td valign=top align=left$tRoomNumber/td
 td valign=top align=left$tNotes/td
 td valign=top align=leftinput name=edit type=checkbox
value=$blSerialNumber/td
/tr; }
 $_SESSION['number'] = mysql_num_rows($show); }

?php
session_start();
require 'scripts/inc.php';
if ((!isset($_POST['edit'])) or ($_POST = )) {
 $_SESSION['table'] = t_items;
 call_user_func(db_retrieve);
} elseif ((isset($_POST['edit'])) or (!$_POST = )) {
 require 'scripts/dbase.inc.php';
  $tble = $_SESSION['table'];
  $edt = mysql_query(SELECT * FROM $tble WHERE
blSerialNumber=\$edit\,$db)or die(mysql_error());
   while ($row = mysql_fetch_array($edt)) {
list($nItemSKU, $bActive, $nUserID, $nItemConfig, $tItemType,
$tDepartment, $blSerialNumber, $nPropertyNumber, $blHostName, $nIPID,
$tRoomNumber, $tNotes) = $row;
$_SESSION['table'] .= tr class=fntMAIN
   td valign=top align=leftinput name=nItemSKU type=text size=30
value=$nItemSKU/td
   td valign=top align=leftinput name=bActive type=text size=30
value=$bActive$bActive/td
   td valign=top align=leftinput name=nUserID type=text size=30
value=$nUserID$nUserID/td
   td valign=top align=leftinput name=nItemConfig type=text
size=30 value=$nItemConfig$nItemConfig/td
   td valign=top align=leftinput name=tItemType type=text size=30
value=$tItemType$tItemType/td
   td valign=top align=leftinput name=tDepartment type=text
size=30 value=$tDepartment$tDepartment/td
   td valign=top align=leftinput name=blSerialNumber type=text
size=30 value=$blSerialNumber$blSerialNumber/td
   td valign=top align=leftinput name=nPropertyNumber type=text
size=30 value=$nPropertyNumber$nPropertyNumber/td
   td valign=top align=leftinput name=blHostName type=text
size=30 value=$blHostName$blHostName/td
   td valign=top align=leftinput name=nIPID type=text size=30
value=$nIPID$nIPID/td
   td valign=top align=leftinput name=tRoomNumber type=text
size=30 value=$tRoomNumber$tRoomNumber/td
   td valign=top align=leftinput name=tNotes type=text size=30
value=$tNotes$tNotes/td
   td valign=top align=leftinput name=save type=button value=Save
class=frmBTNS/td
  /tr; }
}
?
form action=?php echo $_SERVER['PHP_SELF']; ? method=post
?php echo $_SESSION['table']; ?
input name=edit type=button value=edit selected items
class=frmBTNS
/form

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] form not working...

2003-11-10 Thread jeffrey_n_Dyke


i'd be curious what your actual problem is?

here's a question though.,...would these ever work?.
snip
if ((!isset($_POST['edit'])) or ($_POST = )) {
 $_SESSION['table'] = t_items;
 call_user_func(db_retrieve);
} elseif ((isset($_POST['edit'])) or (!$_POST = )) {
/snip

You're basically setting a superglobal array equal to an empty string -
 .  this should at least be $_POST == ...but
instead, i'd use
if ((!isset($_POST['edit'])) or (empty($_POST)) {
--and --
} elseif ((isset($_POST['edit'])) or (!empty($_POST))) {

hth
jeff



   
 
  jas
 
  [EMAIL PROTECTED]To:   [EMAIL PROTECTED]
   
  .comcc: 
 
   Subject:  [PHP-DB] form not working...  
 
  11/10/2003 12:38 
 
  PM   
 
   
 
   
 




For some reason my form to edit selected items is not working, I think I
need a new set of eyes.
Any help is appreciated...
Jas

// inc.php
function db_retrieve() {
 require 'dbase.inc.php';
 $tble = $_SESSION['table'];
 $show = @mysql_query(SELECT * FROM $tble LIMIT 0, 15,$db)or
die(mysql_error());
   while ($row = @mysql_fetch_array($show)) {
@list($nItemSKU, $bActive, $nUserID, $nItemConfig, $tItemType,
$tDepartment, $blSerialNumber, $nPropertyNumber, $blHostName, $nIPID,
$tRoomNumber, $tNotes) = $row;
 $_SESSION['table'] .= tr class=fntMAINtd valign=top
align=left$nItemSKU/td
 td valign=top align=left$bActive/td
 td valign=top align=left$nUserID/td
 td valign=top align=left$nItemConfig/td
 td valign=top align=left$tItemType/td
 td valign=top align=left$tDepartment/td
 td valign=top align=left$blSerialNumber/td
 td valign=top align=left$nPropertyNumber/td
 td valign=top align=left$blHostName/td
 td valign=top align=left$nIPID/td
 td valign=top align=left$tRoomNumber/td
 td valign=top align=left$tNotes/td
 td valign=top align=leftinput name=edit type=checkbox
value=$blSerialNumber/td
/tr; }
 $_SESSION['number'] = mysql_num_rows($show); }

?php
session_start();
require 'scripts/inc.php';
if ((!isset($_POST['edit'])) or ($_POST = )) {
 $_SESSION['table'] = t_items;
 call_user_func(db_retrieve);
} elseif ((isset($_POST['edit'])) or (!$_POST = )) {
 require 'scripts/dbase.inc.php';
  $tble = $_SESSION['table'];
  $edt = mysql_query(SELECT * FROM $tble WHERE
blSerialNumber=\$edit\,$db)or die(mysql_error());
   while ($row = mysql_fetch_array($edt)) {
list($nItemSKU, $bActive, $nUserID, $nItemConfig, $tItemType,
$tDepartment, $blSerialNumber, $nPropertyNumber, $blHostName, $nIPID,
$tRoomNumber, $tNotes) = $row;
$_SESSION['table'] .= tr class=fntMAIN
   td valign=top align=leftinput name=nItemSKU type=text size=30
value=$nItemSKU/td
   td valign=top align=leftinput name=bActive type=text size=30
value=$bActive$bActive/td
   td valign=top align=leftinput name=nUserID type=text size=30
value=$nUserID$nUserID/td
   td valign=top align=leftinput name=nItemConfig type=text
size=30 value=$nItemConfig$nItemConfig/td
   td valign=top align=leftinput name=tItemType type=text
   size=30
value=$tItemType$tItemType/td
   td valign=top align=leftinput name=tDepartment type=text
size=30 value=$tDepartment$tDepartment/td
   td valign=top align=leftinput name=blSerialNumber type=text
size=30 value=$blSerialNumber$blSerialNumber/td
   td valign=top align=leftinput name=nPropertyNumber type=text
size=30 value=$nPropertyNumber$nPropertyNumber/td
   td valign=top align=leftinput name=blHostName type=text
size=30 value=$blHostName$blHostName/td
   td valign=top align=leftinput name=nIPID type=text size=30
value=$nIPID$nIPID/td
   td valign=top align=leftinput name=tRoomNumber type=text
size=30 value=$tRoomNumber$tRoomNumber/td
   td valign=top align=leftinput name=tNotes type=text size=30

Re: [PHP-DB] form not working...

2003-11-10 Thread jas

Yeah, sorry that code wasn't updated... after the $_session['table'] is
called the input button doesn't attempt to post the data form the
$_session['table'] if that makes sense... all the error checking isn't the
problem
jas

Jeffrey N Dyke [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]

 i'd be curious what your actual problem is?

 here's a question though.,...would these ever work?.
 snip
 if ((!isset($_POST['edit'])) or ($_POST = )) {
  $_SESSION['table'] = t_items;
  call_user_func(db_retrieve);
 } elseif ((isset($_POST['edit'])) or (!$_POST = )) {
 /snip

 You're basically setting a superglobal array equal to an empty string -
  .  this should at least be $_POST == ...but
 instead, i'd use
 if ((!isset($_POST['edit'])) or (empty($_POST)) {
 --and --
 } elseif ((isset($_POST['edit'])) or (!empty($_POST))) {

 hth
 jeff




   jas
   [EMAIL PROTECTED]To:
[EMAIL PROTECTED]
   .comcc:
Subject:  [PHP-DB] form not
working...
   11/10/2003 12:38
   PM






 For some reason my form to edit selected items is not working, I think I
 need a new set of eyes.
 Any help is appreciated...
 Jas

 // inc.php
 function db_retrieve() {
  require 'dbase.inc.php';
  $tble = $_SESSION['table'];
  $show = @mysql_query(SELECT * FROM $tble LIMIT 0, 15,$db)or
 die(mysql_error());
while ($row = @mysql_fetch_array($show)) {
 @list($nItemSKU, $bActive, $nUserID, $nItemConfig, $tItemType,
 $tDepartment, $blSerialNumber, $nPropertyNumber, $blHostName, $nIPID,
 $tRoomNumber, $tNotes) = $row;
  $_SESSION['table'] .= tr class=fntMAINtd valign=top
 align=left$nItemSKU/td
  td valign=top align=left$bActive/td
  td valign=top align=left$nUserID/td
  td valign=top align=left$nItemConfig/td
  td valign=top align=left$tItemType/td
  td valign=top align=left$tDepartment/td
  td valign=top align=left$blSerialNumber/td
  td valign=top align=left$nPropertyNumber/td
  td valign=top align=left$blHostName/td
  td valign=top align=left$nIPID/td
  td valign=top align=left$tRoomNumber/td
  td valign=top align=left$tNotes/td
  td valign=top align=leftinput name=edit type=checkbox
 value=$blSerialNumber/td
 /tr; }
  $_SESSION['number'] = mysql_num_rows($show); }

 ?php
 session_start();
 require 'scripts/inc.php';
 if ((!isset($_POST['edit'])) or ($_POST = )) {
  $_SESSION['table'] = t_items;
  call_user_func(db_retrieve);
 } elseif ((isset($_POST['edit'])) or (!$_POST = )) {
  require 'scripts/dbase.inc.php';
   $tble = $_SESSION['table'];
   $edt = mysql_query(SELECT * FROM $tble WHERE
 blSerialNumber=\$edit\,$db)or die(mysql_error());
while ($row = mysql_fetch_array($edt)) {
 list($nItemSKU, $bActive, $nUserID, $nItemConfig, $tItemType,
 $tDepartment, $blSerialNumber, $nPropertyNumber, $blHostName, $nIPID,
 $tRoomNumber, $tNotes) = $row;
 $_SESSION['table'] .= tr class=fntMAIN
td valign=top align=leftinput name=nItemSKU type=text
size=30
 value=$nItemSKU/td
td valign=top align=leftinput name=bActive type=text size=30
 value=$bActive$bActive/td
td valign=top align=leftinput name=nUserID type=text size=30
 value=$nUserID$nUserID/td
td valign=top align=leftinput name=nItemConfig type=text
 size=30 value=$nItemConfig$nItemConfig/td
td valign=top align=leftinput name=tItemType type=text
size=30
 value=$tItemType$tItemType/td
td valign=top align=leftinput name=tDepartment type=text
 size=30 value=$tDepartment$tDepartment/td
td valign=top align=leftinput name=blSerialNumber type=text
 size=30 value=$blSerialNumber$blSerialNumber/td
td valign=top align=leftinput name=nPropertyNumber type=text
 size=30 value=$nPropertyNumber$nPropertyNumber/td
td valign=top align=leftinput name=blHostName type=text
 size=30 value=$blHostName$blHostName/td
td valign=top align=leftinput name=nIPID type=text size=30
 value=$nIPID$nIPID/td
td valign=top align=leftinput name=tRoomNumber type=text
 size=30 value=$tRoomNumber$tRoomNumber/td
td valign=top align=leftinput name=tNotes type=text size=30
 value=$tNotes$tNotes/td
td valign=top align=leftinput name=save type=button
value=Save
 class=frmBTNS/td
   /tr; }
 }
 ?
 form action=?php echo $_SERVER['PHP_SELF']; ? method=post
 ?php echo $_SESSION['table']; ?
 input name=edit type=button value=edit selected items
 class=frmBTNS
 /form

 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] dynamic graph on web site

2003-11-10 Thread Hull, Douglas D

In php/mysql is there a way to create a bar graph and/or a pie chart dynamically and 
then push the chart to the web?  So depending on what information was selected during 
the filtering process would determine what data would be used to create the particular 
graph.

Thanks,
Doug

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] dynamic graph on web site

2003-11-10 Thread Ignatius Reilly

The jpgraph library is what you're looking for.

_
- Original Message -
From: Hull, Douglas D [EMAIL PROTECTED]
To: Note To php mysql List (E-mail) [EMAIL PROTECTED]
Sent: Monday, November 10, 2003 8:36 PM
Subject: [PHP-DB] dynamic graph on web site

In php/mysql is there a way to create a bar graph and/or a pie chart
dynamically and then push the chart to the web?  So depending on what
information was selected during the filtering process would determine what
data would be used to create the particular graph.

Thanks,
Doug

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] dynamic graph on web site

2003-11-10 Thread jeffrey_n_Dyke


jpgraph does a fantastic job of this, and is very easy to use.  I highly
reccomend it!!
http://www.aditus.nu/jpgraph/.



hth
Jeff


   
 
  Hull, Douglas D
 
  [EMAIL PROTECTED]  To:   Note To php mysql List 
(E-mail) [EMAIL PROTECTED]   
   cc: 
 
  11/10/2003 02:36 Subject:  [PHP-DB] dynamic graph on web 
site 
  PM   
 
   
 
   
 




In php/mysql is there a way to create a bar graph and/or a pie chart
dynamically and then push the chart to the web?  So depending on what
information was selected during the filtering process would determine what
data would be used to create the particular graph.

Thanks,
Doug

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] BRU Help

[PHP-DB] form not working...

RE: [PHP-DB] form not working...

Re: [PHP-DB] form not working...

Re: [PHP-DB] form not working...

[PHP-DB] dynamic graph on web site

Re: [PHP-DB] dynamic graph on web site

Re: [PHP-DB] dynamic graph on web site

8 matches

Site Navigation

Mail list logo

Footer information