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
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 =
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
-
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, SCOTT V (SBCSI
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
-Original Message-
From: NIPP, SCOTT V (SBCSI)
Sent: Monday, March 28, 2005 10:47 AM
To: 'php-db@lists.php.net'
Subject: Further MySQL query problems...
I am having trouble in the following code. Basically, I want to
query two separate database tables
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?
Bastien
From: NIPP, SCOTT V (SBCSI) [EMAIL
) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-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
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 table VALUES ('some value','another value','etc');
NIPP, SCOTT V (SBCSI) wrote:
I am getting errors for the following queries. This query seems
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\
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
@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. The app
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 have noticed that frequently when I perform
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 page
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:
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
-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 assigned by the
db.
There is no need
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
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:
?php
mysql_select_db($database_Prod, $Prod);
$query_Host = SELECT Name FROM systems;
$Host =
, or
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]
Thanks
:[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) [EMAIL PROTECTED]
This isn't specifically a DB related question, but... The following
code snippet is not functioning for me
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.
#
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
.
-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
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
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
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
, 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 button is pushed, and that
is when the $td
: 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 a href=\yourscript.com/yourpage.php?td=$td\;
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
Pay It Forward
mailto
]
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...
input type=hidden name=td value=? echo $td; ?
jay
. 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: Re: [PHP-DB] Datetime
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...
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
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 an INSERT
. 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:47 PM
To: '[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 I have
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
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]
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
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
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 =
]
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-
From: NIPP, SCOTT V (SBCSI) [mailto
.
-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 question...
Sorry, I just reread your post
$array_copy = array
-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 what I have and what I am getting
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
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 again
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($groups_tmp
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
To: [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 works fine from a
basic SQL
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 =
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
requests call the
Help
Desk/span/h4
...snip
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 06, 2003 11:09 AM
To: NIPP, SCOTT V (SBCSI)
Subject: RE: [PHP-DB] Weird PHP behavior...
well show the working code and then show just a portion
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
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 information to a website
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
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
AND 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_Daily` AS 'B'
JOIN
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:
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
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
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
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 Balances SET CompEarned=CompTaken+8 WHERE
said
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
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
, 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: [PHP-DB] Stumped...
I am
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.
.
-Original Message-
From: John W. Holmes [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 08, 2003 11:56 AM
To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Mouseover question...
OK, this isn't really a DB question, but it is definitely a PHP
question. I am
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
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]
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
Message-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 1:58 PM
To: '[EMAIL PROTECTED]'
Subject: [PHP-DB] Oracle/PHP question...
I am now trying to setup connectivity to a remote Oracle database
for my PHP/Apache web server. I am
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
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 both a MySQL and a remote Oracle server. I am
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:
?php
$connection = OCILogon(user, password) or die (Unable to logon to
database.);
?
I have installed the Oracle client on
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, 2002 1:58 PM
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); [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Oracle/PHP question...
Thanks, but my
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
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]'
Subject: [PHP-DB] Remote Oracle
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.
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 =
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, SCOTT V (SBCSI); '1LT John W
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
, 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) [EMAIL PROTECTED] wrote
, 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) [EMAIL PROTECTED] wrote
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
above the choices provided
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
-
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
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:
?php do {
echo $list['id-sys'] . \n;
$sys =
]]
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 BR. Look at your HTML source code and
the newlines are there.
or,
if you're on windows, use \r\n for newlines.
---John Holmes
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
I have an INSERT statement that I cannot quiet get working. The
table that this data is being put into has 7 columns, but I only care about
putting in the data from the first two columns at this time. The first
column is an array element, and the second column needs to be a timestamp.
. Holmes'; NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subject: RE: [PHP-DB] INSERT question...
Hmm
You learn something new everyday :)
Aaron
-Original Message-
From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]]
Sent: November 20, 2002 2:27 PM
To: Aaron Wolski; 'NIPP, SCOTT V (SBCSI
PROTECTED]]
Sent: Wednesday, November 20, 2002 2:21 PM
To: NIPP, SCOTT V (SBCSI); 'Aaron Wolski'; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] INSERT question...
OK. This sounds great, but now I am getting a completely different
error message.
You have an error in your SQL syntax near '-sys) VALUES
, 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 around NOW(). It's a function, not a string.
---John Holmes
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
I know that this is not the forum for this question, I am only
looking for a pointer in the right direction here. I need to gain a better
understanding of HTML forms, specifically checkboxes. What I am looking for
is once I present a list of checkboxes and the user makes his selections,
is dependant on which method your form uses.
:-) If it is not checked then there is no entry. in PHP with
register_globals on the variable $checkbox1 will equal scoobydoo and not
be set if the box is not checked.
hope this helps...
Ryan
-Original Message-
From: NIPP, SCOTT V (SBCSI) [mailto
1 - 100 of 129 matches
Mail list logo