I am migrating a web app from an old server running PHP 4.2.3 to
a new server running 4.3.8. The problem I am running into at the moment
is building an array and passing it to another page. This code works
fine on the old server, but the array is not coming across to the new
page on the n
I am attempting to use a simple foreach loop on a query result,
and I am only getting the first element of the array back. Here is the
code...
$exclude_query = "SELECT hostname FROM exclusion";
$exclude_results = mysql_query($exclude_query, $Prod);
$exclude = mysql_fetch_array($exclude_re
ssage-
From: Bastien Koert [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 30, 2005 9:35 AM
To: NIPP, SCOTT V (SBCSI); php-db@lists.php.net
Subject: RE: [PHP-DB] MySQL Subquery problems...
only mysql 4.1+ supports subqueries..if you version is lower it won;t
work
Bastien
>From: "NIPP, S
I am working with one of our Oracle DBAs to have him try and
help me get a couple of queries working. The problem is that in looking
at the documentation for MySQL it seems that what we are attempting
should work. Unfortunately, it doesn't. Here is what we are trying...
mysql> SELECT CP
isplay the
data.
Thanks in advance for any help in this. I have no idea if this
is possible, but I am guessing that it is.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: Bastien Koert [mailto:[EMAIL PROTECTED]
S
Original Message-
From: Bastien Koert [mailto:[EMAIL PROTECTED]
Sent: Monday, March 28, 2005 11:13 AM
To: NIPP, SCOTT V (SBCSI); php-db@lists.php.net
Subject: RE: [PHP-DB] RE: Further MySQL query problems...
why wouldn't you just run a query to return only the elements that you
want?
Ba
Oops... Correction to the last line of the script.
Should be...
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
> -Original Message-
> From: NIPP, SCOTT V (SBCSI)
> Sent: Monday, March 28
I am having trouble in the following code. Basically, I want to
query two separate database tables and then generate an array from these
two queries. The first query will return a list of ALL systems. The
second query will return a list of systems that should be excluded. The
problem is
t and select statements.
If it says "No valis MySQL resource then you are returning 0 records
which may be caused by escaping the quotations.
I follow this pattern
$sql ="INSERT INTO VALUES ('some value','another value','etc')";
NIPP, SCOTT V (SBCSI)
I am getting errors for the following queries. This query seems
to work fine in phpMyAdmin.
$query2 = "SELECT AllMid_Data.CPU_Hostname FROM AllMid_Data, accounts
WHERE AllMid_Data.CPU_IN_SVC = \"Y\"
AND AllMid_Data.CPU_DNS = \"sbcld.sbc.com\"
@lists.php.net
Subject: Re: [PHP-DB] Working with multiple tables...
Seperate on another MySQL server, or seperate within the same MySQL
server?
On Monday 21 March 2005 11:44 am, NIPP, SCOTT V (SBCSI) wrote:
> I am working on revising a web request app that I have already
> developed. T
I am working on revising a web request app that I have already
developed. The app basically provides a list of system names with
checkboxes for a user to select to request accounts on the systems. One
feature I am intending to add is that the app should check a separate
database of user a
: Friday, December 10, 2004 2:34 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] MySQL error...
> -----Original Message-
> From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]
> I have been using a PHP page to update a database table for a
long time now.
> Unfortunately, I
I have been using a PHP page to update a database table for a
long time now. Unfortunately, I have noticed that frequently when I
perform an update I get back an error saying "Table 'tablename' doesn't
exist". This is becoming more and more annoying. The table obviously
exists as the pag
Why would you not simply use a 'datetime' field type? This gets
you exactly what you are looking for unless I am misreading what you are
doing here...
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: Bomgardne
http:\\ldsa.sbcld.sbc.com
-Original Message-
From: Bastien Koert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 05, 2004 12:45 PM
To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Auto-increment questions...
If its an autoincrement, the next highest number will be assigne
I am working on a database application for Unix user accounts.
I want to be able to have a system that will provide me the next
available numeric user ID. I have created a 2 column index table that
simply includes UID and user name. This field is autoincrement and the
primary key for the
OK. I know that a BUNCH of people have had this question, and I
have read numerous Google threads on this, but nothing really seems to
point out the resolution... I have a table with the Primary Key as an
auto_increment field. Once I insert a new row of data into the table I
want to dire
I am trying to populate an array from a MySQL database. I think I
have the code correct to populate the array, but I need to somehow sort the
array eliminating duplicate values. I think I can loop through the array
doing a comparison and building a new array by discarding the value if it
I keep receiving a parse error every time I try and view the page I
am working on. I am developing this very simple application in DreamWeaver
MX 2004. Here are lines 3-16:
I am simply attempting to pull data from two separate tables in two
separate databases. Every time I try
is it this way by design? Thanks.
-Original Message-
From: CPT John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 27, 2003 4:10 PM
To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Logic Help...
From: "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED
gure out why at this point. Thanks again for the
help.
-Original Message-
From: CPT John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 26, 2003 9:15 AM
To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Logic Help...
From: "NIPP, SCOTT V (SBCSI)"
This isn't specifically a DB related question, but... The following
code snippet is not functioning for me. I keep receiving a parse error on
the "if" line. Basically I want to stop execution of this page if either of
the conditions in the "if" statement exist. Thanks in advance.
# w
I have a script that is going into semi-production and during this
process a new problem was uncovered. I have the table a couple of table
fields setup as "Not NULL" with a "Default" value. The problem is that if
the user fails to select anything I get garbage in one of the fields and
no
.
-Original Message-
From: Ow Mun Heng [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 29, 2003 11:13 PM
To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subject: RE: Session help...
As mentioned previously in this list,
$_SESSION and session_register, session_is_register, is not compatible with
Sorry for the slightly off-topic post... I have a couple pages that
use a login page. If the user tries to bring up one of these pages without
being logged in, then the pages redirects him to the login page. After
successful login, the user is directed back to the page they were attempti
I actually think I know part of this answer... I don't think you
need to define a variable to insert into your "date" field. Inserting an
empty value into this filed will populate the field in the database with the
current time, which it appears from your code is what you are trying to do
I have an application that is currently working fine under 4.1.2,
and I am in the process of upgrading to 4.2.3. The problem is that after
upgrading PHP the application login no longer works. Additionally, this
same application works fine on another machine running 4.2.3. The only
differ
I know there is another mailing list for installation questions, but
I am hoping for some help here. I get enough mail from this list alone
without having to join another. Anyway, while attempting to compile version
4.3.2 I am running into the following error during the configure...
che
enerating
this error. I am guessing that you guys will need more info to help out
with this now. Just let me know what you want. Thanks again.
-Original Message-
From: CPT John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 10:07 AM
To: NIPP, SCOTT V (SBCSI)
Subject: R
]
Sent: Thursday, June 05, 2003 9:48 AM
To: NIPP, SCOTT V (SBCSI)
Subject: RE: [PHP-DB] Datetime help in an INSERT...
a button is being pressed?
so it is processing a form?
if its in a form just pass along the value of $td via hidden input data...
jay merritt
[EMAIL PROTECTED]
[EMAIL PROTECTED
lto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 9:01 AM
To: NIPP, SCOTT V (SBCSI)
Subject: RE: [PHP-DB] Datetime help in an INSERT...
You could alway place it as a "GET"
echo "";
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forw
ROTECTED]
Sent: Thursday, June 05, 2003 9:06 AM
To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Datetime help in an INSERT...
> I have actually discovered that the $td value is blank. The reason
> appears to be that the page is reloading when a butt
from
the original query than perform another database query to populate this
value yet again. Thanks yet again for the help.
-Original Message-
From: CPT John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 2:14 PM
To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Cc: [EMAIL
far.
-Original Message-
From: CPT John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 2:14 PM
To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Datetime help in an INSERT...
> > I am stumbling across something that I thought
thing using the query. It will update automatically when
the record is inserted and/or updated.
ie; $denylog = "INSERT INTO deny (account, td ) VALUES ($tmp, $td )";
Randy
-Original Message-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 1:4
The error I am receiving is:
You have an error in your SQL syntax near ' NOW())' at line 1
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 1:45 PM
To: NIPP, SCOTT V (SBCSI)
Subject: Re: [PHP-DB] Datetime help in
I am stumbling across something that I thought I have done before,
and I am not having any luck finding an example of this. Basically, I am
wanting to timestamp the date and time into new entries in a simple database
table. The following section is the actual code for this, and I cannot
f
OK... I moved the form tag up before the table tag and added a tr
tag to the beginning of the first line of display in the loop. No
difference in the output. The first line of the output loop is still a
completely empty line.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[E
Anyone have an links to websites that offer good tutorials on web
design? I am most interested in learning about templates and how to design
these for use with PHP pages. I am using DreamWeaver MX as a development
environment and would really like some help with DreamWeaver templates if
a
I am working on a page that displays a line of information with a
checkbox at the end. I began by getting all of the information I wanted
displayed working properly and now I am adding the checkbox. Everything is
going find with the exception that all of a sudden with the checkbox code
i
In response to your bullet points...
1. Built in mysql_ functions in php (does perl have this?)
Perl does not have "built in" functions for MySQL or any
other database. The Perl functions are all added through modules. This is
somewhat annoying as compared to PHP
I am curious about what you guys may have along the lines of best
practices for forwarding from a URL to a login, and then jumping back to the
original URL automatically. I have several separate applications that all
need to utilize the same login mechanism. I want the user to be able to
nd foreach
-Original Message-----
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 11:10 AM
To: '[EMAIL PROTECTED]'; 'Hutchins, Richard'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Easy array question...
Here is basically wha
ually
getting is:
Array
Thanks again.
-Original Message-
From: Jonathan Villa [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 10:58 AM
To: [EMAIL PROTECTED]; NIPP, SCOTT V (SBCSI); 'Hutchins, Richard';
[EMAIL PROTECTED]
Subject: RE: [PHP-DB] Easy array questio
PROTECTED]
Sent: Wednesday, March 12, 2003 10:40 AM
To: '[EMAIL PROTECTED]'
Subject: RE: [PHP-DB] Easy array question...
Are you using:
$array2 = $_SESSION["array1"];
Not sure that will do the trick, but it was my first inclination.
Rich
> -----Original Message-
>
I create an array on one page and then process it on the next page
as I have registered the array as a session variable. I need to basically
process one of these arrays twice, so I want to make a copy of the array.
The question is how do I do this? I have tried the following:
$array2 = $
tting populated into the array in the first place.
-Original Message-
From: Ben Walling [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 11, 2003 1:48 PM
To: NIPP, SCOTT V (SBCSI)
Cc: [EMAIL PROTECTED]
Subject: RE: Stumped again...
Your code:
while($name = mysql_fetch_row($group
I don't really understand this suggestion. Could someone possibly
expound on this further? Maybe an example? Thanks.
-Original Message-
From: Ben Walling [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 11, 2003 12:19 PM
To: NIPP, SCOTT V (SBCSI)
Subject: Re: Stumped
OK... I have once again thought of something cool to do, and can't
quite figure out how to make it happen. I am developing a user account
request system for work. Things are coming along nicely. The user logs
into the system, kind of, selects the systems that he wants to have accounts
a
: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Query Help...
- Original Message -
From: "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 10, 2003 9:23 AM
Subject: [PHP-DB] Query Help...
> I am having a lot of trouble with a query that
I am having a lot of trouble with a query that works fine from a
basic SQL command line, but fails in my web script. Here is the portion of
code including the query:
mysql_select_db($database, $Prod);
$query_groups = "SELECT name FROM group";
$groups = mysql_query($query_groups, $Prod) or
I would most definitely recommend pulling them from a DB table
rather than hard coding these into a page. Here is a code snippet that I
use to do this on one of my pages:
mysql_select_db($Prod, $Prod);
$query_systems = "SELECT Name FROM systems ORDER BY Name ASC";
$systems = mysql_query($
It turned out to be just a simple file permissions issue.
-Original Message-
From: Mohammad Saad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 06, 2003 12:31 PM
To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: Re: [PHP-DB] Weird PHP behavior
ATUS.
()
(pager
)
The portion of PHP code prior to the HTML is inserted at the top of the
file in the broken page. Here is how the HTML portion of the PHP is
inserted...
CALL 214-741-6961
FOR CURRENT ONCALL ST
I developed some dynamic content for a larger web page, and once I
pasted the code into the appropriate area of the page I am seeing the
strangest error. Here is the error:
Warning: Failed opening '/www/DW/index1.htm' for inclusion
(include_path='.:/usr/local/lib/php') in Unknown on line
A.StopDate
-Original Message-
From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 04, 2003 1:36 PM
To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subject: Re: [PHP-DB] A little JOIN help please...
> SELECT 'A.Title'
> FROM `phpCalendar_Dail
This is more of an SQL question, but I am not sure where else to
turn for help. I am trying a JOIN, for the first time ever, and it is NOT
working for me. The following is what I am attempting;
SELECT 'A.Title'
FROM `phpCalendar_Daily` AS 'B'
JOIN 'phpCalendar_Details' AS 'A' ON 'A.Calen
I have a JOIN that is not working, and figured I would piggie-back on this
thread to see if someone could give me a quick answer... Here is the JOIN
syntax. This is my very first attempt at a JOIN statement, so I may be
doing something blatantly wrong here.
SELECT 'A.Title'
FROM `phpCalendar_Dai
t the difference of 2 or 3 days?
-Original Message-
From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 04, 2003 10:04 AM
To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Date Range Question...
> I am working on an app that needs to post informat
I am working on an app that needs to post information to a website
based on date. The tricky part for me is that the date is a range that
spans either 2 or 3 days. I want the web page to dynamically populate this
information based on a query. The query will look something like this:
poorly
coded piece of software, and if I as a relative PHP newbie know this, it is
really bad.
-Original Message-
From: John W. Holmes [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 15, 2003 10:07 PM
To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Duplicate keys
Under Unix I don't know that this is possible, but hopefully someone
else will know of a way. I would love to be able to e-mail some Excel files
that I generate with a Perl cron job, but there does not appear to be any
practical way to do this in Unix.
-Original Message-
From: Bru
OK, I cannot figure out why I keep getting errors about "Duplicate
entry for key 1". Someone please come to my rescue here as this is truly
kicking my but.
if ($dateDiff == 2) {
mysql("$DBName","INSERT INTO phpCalendar_Details VALUES (
'$said','Comp day for weekend
On-Call
: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 15, 2003 10:32 AM
To: 1LT John W. Holmes; NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Date math functions...
> [snip]
> > if ($dateDiff == 3) {
> > mysql("$DBName","UPDATE B
Thanks. I was noticing that it was not working. Let me give this a
try and see how things go.
-Original Message-
From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 15, 2003 10:32 AM
To: 1LT John W. Holmes; NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED
I have a question about using DATE_ADD in MySQL. I am not sure if
this is the most effective way of dealing with this problem so I am asking
here. The situation is that I am working on modifying a calendar system for
our use. Our On-Call rotation is such that when someone is On-Call over
:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003 10:06 AM
To: NIPP, SCOTT V (SBCSI); 'Hutchins, Richard'; '[EMAIL PROTECTED]'
Subject: RE: [PHP-DB] Stumped...
Out of curiosity, what was the solution? It's always good to learn from
someone else's mistakes ... :)
, SCOTT V (SBCSI); '[EMAIL PROTECTED]'
Subject: RE: [PHP-DB] Stumped...
Post your SQL statement.
> -Original Message-
> From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 09, 2003 1:37 PM
> To: '[EMAIL PROTECTED]'
> Subject:
I am getting an error that is proving very difficult to isolate and
was hoping for help. The error is: Column count doesn't match value count
at row 1. I would include the code, but it is about 350 lines, and I am not
sure where to narrow it down at. Any ideas? Thanks.
Scott Nipp
Phone
t+'\')" id="link'+no+'"
onClick=return(openSmallWindow(\''+href+'\'))>'+txet+'<\/a>');
no+=1;
}
//-->
Thanks again.
-Original Message-
From: John W. Holmes [mailto:[EMAIL PROTECTED]]
Sent: Wednesd
OK, this isn't really a DB question, but it is definitely a PHP
question. I am working on customizing a calendar application for my group's
use and noticed that there is a function that has to do with a mouseover
effect. The problem is that this mouseover does not appear to do anything.
C
My head is sore from banging my head on my desk, so I will now ask
the gurus...
I am trying to get a canned Calendar application working, and I am
running into problems. The application is phpCommunityCalendar by
AppIdeas.com. The calendar is currently semi-functional, but for so
I would say his problem is the IIS 5.0. Switch to some non-MS
operating system running Apache as a web server and that should clear up
your problems. :)
-Original Message-
From: Jason Wong [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 20, 2002 11:24 AM
To: [EMAIL PROTECTED]
S
name in
/www/DW/oratest.php on line 11
Unable to logon to database.
Thanks agian.
> -Original Message-
> From: NIPP, SCOTT V (SBCSI)
> Sent: Wednesday, December 18, 2002 10:30 AM
> To: '[EMAIL PROTECTED]'
> Subject: Oracle connectivity ques
OK. I think I now have Oracle support built into PHP/Apache. The
biggest hiccup for HP-UX seems to be that once you add Oracle support to
PHP, you CANNOT built PHP as a DSO, PHP MUST be compiled into Apache. Once
again, I think this is the case, I am still not completely sure at this
poi
---Original Message-
> From: NIPP, SCOTT V (SBCSI)
> Sent: Tuesday, December 17, 2002 9:56 AM
> To: '[EMAIL PROTECTED]'
> Subject: PHP/Oracle Install questions...
>
> I am attempting to recompile PHP 4.2.3 on HP-UX 11.00 for
> connectivity to b
I am attempting to recompile PHP 4.2.3 on HP-UX 11.00 for
connectivity to both a MySQL and a remote Oracle server. I am not having
much luck with this right now. Currently I am getting a couple of different
errors that are of concern for me. First of all, in the Apache error log I
am see
SID and the HOME so that's fine. Just compile new binary
Regards,
Andrey
- Original Message -
From: "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]>
To: "'Andrey Hristov'" <[EMAIL PROTECTED]>; "xxx " <[EMAIL PROTECTED]>;
<[
Anthony Carlos wrote
> > Yes, you need to recompile PHP:
./configure --with-oci8=[your_oracle_home]
> >
> > -Original Message-
> > From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, December 16, 2002 1:58 PM
> > To: '[EMAIL PROTECTED]
parser directly from sql server dts packages & agent jobs... PHP is much
more powerful then anything m$ offers.
<>< Ryan
-Original Message-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 2:08 PM
To: Ryan Jameson (USA); [E
your webserver is win32 then you need to uncomment the line in php.ini
that says :
;extension=php_oci8.dll
if it is unix based I am not sure what you need to do.
<>< Ryan
-Original Message-----
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2
I am now trying to setup connectivity to a remote Oracle database
for my PHP/Apache web server. I am attempting to verify connectivity to the
database by:
I have installed the Oracle client on the system, and I have also
setup the ORACLE_HOME and ORACLE_SID environment variables
I haven't used
Oracle since 8i came out... but I'm pretty sure this is accurate. Except the
guess about how PHP does it.
<>< Ryan
-Original Message-----
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 9:24 AM
To: '[EMAIL PROTECTED
I have now been granted access to a remote Oracle database that I
need to query. All of the work that I have done with databases and PHP has
been focused on MySQL, does anyone know of a good tutorial for PHP with
Oracle? My immediate question is how do I get logged into the remote
databas
eave the column name
changed and take this as a lesson never to use '-' in a column name again.
Thanks again for the help. Maybe we all learned something from
this.
-Original Message-
From: DL Neil [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 2:00 PM
To: NIPP
From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 1:45 PM
To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Update Query Help...
> $tmp = $_POST['sbcuid']."-".$_POST['system'][$a];
> $update = "UPDATE ac
I am attempting to UPDATE a table and I have having absolutely ZERO
success. Here is the query:
$tmp = $_POST['sbcuid']."-".$_POST['system'][$a];
$update = "UPDATE accounts SET atime='NOW()' WHERE
\"id-sys\"='".$tmp."'";
echo $update;
$result1 = mysql_query
I am working on an application and I am not having a lot of luck
getting a form to behave the way I want. I am trying to keep the form "self
referencing", not sure if that is the correct terminology. The form is an
approval form that queries a database to create a list of checkboxes. The
Yes, and yes.
-Original Message-
From: John [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 06, 2002 2:41 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Data not entering DB
Questions:
Is this the right email addy to post help questions, and may I post the php
code within the emai
n Saturday 07 December 2002 04:12, NIPP, SCOTT V (SBCSI) wrote:
> OK. Stumped once again. This function is now properly generating
> and displaying the form as I intend it to. The only problem is that the
> optional text and button at the end of the function is actually displaying
:58 PM
To: '[EMAIL PROTECTED]'
Subject: Re: [PHP-DB] Function questions...
$sys is an array, so echoing $sys will cause problems.
Are you trying to get a 4xN table of values and checkboxes? There's
got to be an easier way...
--- "NIPP, SCOTT V (SBCSI)" <[EMAIL PROT
, December 06, 2002 1:58 PM
To: '[EMAIL PROTECTED]'
Subject: Re: [PHP-DB] Function questions...
$sys is an array, so echoing $sys will cause problems.
Are you trying to get a 4xN table of values and checkboxes? There's
got to be an easier way...
--- "NIPP, SCOTT V (SBCSI
I am trying to convert something that I have working in a PHP script
to be a function in a library type of file. The code contained in the
function works fine in another script, but I am currently getting no output
from the function. I have a question about the nature of functions that ma
]]
Sent: Thursday, December 05, 2002 10:34 AM
To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Newline help...
HTML doesn't render newlines, only . Look at your HTML source code and
the newlines are there.
or,
if you're on windows, use \r\n for newlines.
---J
I must be stupid, because I cannot for the life of me figure out why
I am not getting newlines from some very simply 'echo' statements. Here is
the portion of the code below, and I am getting everything run together on a
single line:
http://www.php.net/)
To unsubscribe, visit: http://www.
-
From: Peter Lovatt [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 4:45 PM
To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Special URL Verification String... PS
Hi
PS
I would use
$verify_string = md5(uniqid(rand()));
to generate a random identifier of the
I am trying to implement an approval system that sends an e-mail to
a user for approval linking them back to a special URL that matches database
entries for a verification string. The verification string sent via the
e-mail does not match that in the database and I am looking for help in
f
Once again I am posting a bit off topic, so tell me to go away if
this is bugging people...
Thanks for all of the assistance so far in creating what will be a
completely automated user account request system. I am now trying to figure
out the mechanics of the account approval proc
, November 20, 2002 2:47 PM
To: NIPP, SCOTT V (SBCSI); 'Aaron Wolski'; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] INSERT question...
> $query = "INSERT INTO accounts (`id-sys`, rtime) VALUES('".$accnts[0]."',
> 'NOW()')";
Remove the quotes arou
1 - 100 of 135 matches
Mail list logo