Hi,
I installed mysql and php. Its OK. After I install php-mysql, the
following messages come out.
PHP Warning: PHP Startup: Unable to load dynamic library
'/usr/lib/php/modules/mysql.so' - libmysqlclient.so.15: cannot open
shared object file: No such file or directory in Unknown on line
// pg_connection_status($link_id) now equals PGSQL_CONNECTION_BAD or null;
Any comments or suggestions would be appreciated. Thanks.
Scott
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi everyone!
I would like to create a drop down list with the info in my database.
I would also like to have more options so it will filter down to many
rows of data displayed then filtered down to a few rows of data that
said user is looking for.
Kind of like select a state then in the next
Hi everyone!
How can I create a table...or even something similar...to line information up?
The information is coming from an mysql database and there are 5
columns of data.
Of course I am using php to call the data out of the database.
A simple example:
while ($data =
On 2/25/07, Scott [EMAIL PROTECTED] wrote:
Hi everyone!
How can I create a table...or even something similar...to line information
up?
The information is coming from an mysql database and there are 5
columns of data.
Of course I am using php to call the data out of the database
? Or
is a
function such as mysql_real_escape_string needed to ensure it is inserted
correctly?
regards
Simon.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
Scott Hurring [scott dot hurring dot lists at gmail dot com]
http://hurring.com/
I'm pretty new to PHP so I need help. I'm getting this error:
Error in updating SQL PHP Warning: odbc_exec() [function.odbc-exec]: SQL
error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters.
Expected 2., SQL state 07001 in SQLExecDirect in
c:\Inetpub\wwwroot\shout.php on line 77
);
?
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I am trying to set up my laptop to run PHP and MySQL together.My system summary
is:Win 2000 (localhost)PHP 4.3.11MySQL Server 4.1.12MySQL Client 5.0.0MySQL
Admin 1.0.9I can connect to my local MySQL host using MySQL client tools.I can
connect to a remote MySQL server (don't know the exact
tell
you where to get the damn library. If anyone has a link to the new mysql
client libraries, I'd appreciate it.
I tend to simply downgrade the password string to the old 16bit style
run this command:
SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
Bastien
From: Scott Powell
to eliminating this confusion.
Thanks
Scott
[EMAIL PROTECTED] wrote:
php-db Digest 7 Jun 2005 17:56:06 - Issue 2973
Topics (messages 39594 through 39599):
Re: Newbie with mail problem
39594 by: Andrés G. Montañez
39599 by: Wings
Cannot connect to local MySQL -- Client does not support
via the following.
while ($test = mysql_fetch_array($results, MYSQL_NUM)) {
echo $test[0]\n;
}
Is my PHP somehow broke, or am I just missing something here?
Thanks.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
--
PHP Database Mailing
This is an error returned from the mysql client. Any help would
be most appreciated.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Yup... Thanks, I just discovered that myself. Thankfully the
docs have instructions on how to write a subquery for earlier versions
that don't support subqueries.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message
about 900 entries and the query returns about
90 hostnames. The exclude table query has only 13 hostnames and
obviously returns all. I am looking for a way to display the
approximately 77 entries that are NOT in the exclude table. Thanks
again.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL
Oops... Correction to the last line of the script.
?php } while ($blah = mysql_fetch_array($exclude_results)); ?
Should be...
?php } while ($blah = array_shift($temp)); ?
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
\
# AND AllMid_Data.CPU_DNS = \sbcld.sbc.com\
# AND AllMid_Data.CPU_Hostname != exclusion.hostname
# ORDER BY CPU_Hostname ASC;
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: Bastien
array element
associated with the hostname. I would then write my display code to
check the value of this element to determine how/where to display 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
of the other queries it gets excluded from
this one. I have not tried anything to make that happen yet. I will
tackle that challenge once I can resolve this part. Thanks again.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From
\%\.AllMid_Data.CPU_Hostname
ORDER BY CPU_Hostname ASC;
$results3 = mysql_query($query3, $Prod) or die(mysql_error());
$system3 = mysql_fetch_assoc($results3);
I am assuming that I have an issue with query3. Thanks in
advance.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web
at the same time to determine if
the user already has an account. Then I would like to display ALL of
the systems, but grey out the ones that the user already has accounts
on. Can someone help me figure out the best way to go about this?
Thanks in advance.
Scott Nipp
Phone: (214) 858-1289
E-mail
Within the same server, even the same database, just a different
table.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: Micah Stevens [mailto:[EMAIL PROTECTED]
Sent: Monday, March 21, 2005 1:47 PM
To: php-db
the name of the table that
the script is working with.
Thanks for the feedback.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: Norland, Martin [mailto:[EMAIL PROTECTED]
Sent: Friday, December 10, 2004 2:34 PM
. This is really beginning to bug the crap out
of me.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi All,
I'm looking at data abstraction libraries, and various object wrappers
for SQL interfaces. Question -- how does the PEAR DB abstraction handle
JOINS, especially on updates. I've seen several abstractions that
basically encapsulate one table, but what about the situation with
multiple
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
a value for the auto_increment column it
comes up with 3029. Is there a way to query and/or insert such that it
comes up with the next unused numeric value?
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
--
PHP Database Mailing List (http://www.php.net
OK. The problem is I don't want the next highest number.
There are gaps in the UID sequence. I need to find the next UNUSED
number in the sequence which is rarely the highest number.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
Robert Twitty wrote:
On Thu, 19 Aug 2004, Gerard Samuel wrote:
Robert Twitty wrote:
Hi
Is anyone using PHP to connect to an IBM DB2 database? The reason why I
am asking is becaouse I want to see if the odbtp extension can be used to
successfully prepare and execute DB2 stored procedures. So
this function to work in a SQL query window.
Please help!!! I would attach code to this, but I am not sure what to
attach.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net
prints one name. Also next() doesn't seem to be advancing
the table so
I am getting duplicates of the one name it does print to the table
Thanks.
--
Scott
--
Scott Phelps
Regional IT Manager
Ridgway's, LTD.
5001 Cleveland Street
Virginia Beach, VA 23462
757-490-2305
---
Linux: $ su - root
prints one name. Also next() doesn't seem to be advancing
the table so
I am getting duplicates of the one name it does print to the table
Thanks.
--
Scott
--
Scott Phelps
Regional IT Manager
Ridgway's, LTD.
5001 Cleveland Street
Virginia Beach, VA 23462
757-490-2305
---
Linux: $ su - root
Sorry for accidentally posting twice:
I wanted to point out a typo.
At the bottom I meant advancing the array not table in regards to next()
On Wed, 25 Feb 2004 11:12:10 -0600
PHELPS, SCOTT [EMAIL PROTECTED] wrote:
Thanks in advance for reading this:
I am trying to take a query based
'
}
else
{
echo trtd class='result
}
}
?
--
Scott Phelps
---
Linux: $ su - root -- Windows: (reboot)
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Sorry, I didn't cut that right:
Here it is:
table class=results_inner
?php
foreach ($returned_rows as $key = $value)
{
if ($key 1)
{
echo trtd class='results_blue'.$value['lastname'].,
.$value[firstname]./td/trbr;
Patrin
Now how elegant is that?
You da man!
--
Scott
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
for any help.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I have been looking for a resource on how to do proper error handling with
(BPostgreSQL connections and queries. In one specific case, I have a
(Breferential integrity constraint on a table. When I try to delete from that
(Btable, it fails, as it should, when there is something referring to the
, $ProdUsers);' regardless
of whether this is the first or second mysql_select_db. I imagine that I am
simply doing something obviously wrong here. Please help. Thanks.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
--
PHP Database Mailing List (http
, 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
;
# echo p align=\center\font color=\#99\ size=\4\Please
follow this a
href=\http://ldsa.sbcld.sbc.com/sa_bulletin/sa_board.htm\;link/a to
return to the beginning of the request process./font/p;
# exit;
# }
# }
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web
\.$grp_list./div/td;
echo td width=\20%\div align=\center\input type=\text\
name=\other[]\ value=\\ size=\15\/div/td/tr;
$tmp = $sbcuid.-.$_POST['system'][$a];
$a++;
array_push( $accnts, $tmp );
}
?
Thanks in advance for any help.
Scott Nipp
Phone: (214) 858
.
-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
) {
$valid_user = $sbcuid;
# session_register(valid_user);
$_SESSION['valid_user'] = $sbcuid;
header(Location: http://.$_SERVER['HTTP_HOST'].$link);
}
}
End of second snippet...
Thanks in advance for any help.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL
here. Try changing the field name and give that a shot. I think I am
actually right here though.
Scott
-Original Message-
From: Hutchins, Richard [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 1:19 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] MySQL Date insert
Don't know about
difference in the machines is that the working one uses PHP as a static
module and the broken one uses PHP as a loadable module. Anyone run into
this problem before? Thanks in advance.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
--
PHP Database
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
...
checking whether byte ordering is bigendian... configure: error: can not run
tes
t program while cross compiling
At this point the configure simply dies. I have no idea on how to
proceed from this.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
figure out how to get the date/time stamp to populate into the database.
Thanks in advance for the help. I suspect this is a very simple fix.
$denylog = INSERT INTO deny (account, td, date) VALUES ($tmp, $td, NOW());
$denylog_result = mysql_query($denylog, $Prod) or die(mysql_error());
Scott Nipp
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
if
anyone knows of any. Any good book recommendations would be most
appreciated too. Thanks, and sorry for the slightly off topic post.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe
:[EMAIL PROTECTED]
Sent: Tuesday, March 25, 2003 6:30 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: Empty display loop...
Scott V Nipp [EMAIL PROTECTED] wrote:
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
, as
well as the actual query code. Thanks again.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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
not real clear on how to manage this. Does anyone
have any suggestion on implementing this, or another alternative that I have
not touched on yet? Thanks in advance.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
--
PHP Database Mailing List (http
= $array1;
This doesn't seem to do the trick for me. Is this correct and I am
just missing something elsewhere, or is there another way to copy an array?
Thanks.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
--
PHP Database Mailing List
]
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
, SCOTT V (SBCSI)
Subject: RE: [PHP-DB] Easy array question...
It's actually putting the whole of the array $other as the first element of
the array $other2. You're going to have to step through the array to copy
it.
foreach($other as $element) {
$other2[] = $element;
} //end foreach
in advance for any help. Please let me know if you need any
other information to help figure out what is wrong with this.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
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
1.3.27 server. Thanks in advance for the
help.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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 =
0
I have tried this on 2 different servers running 2 different
versions of PHP, 4.1.2 and 4.2.3. The code was developed and tested in a
blank page and then inserted into a much larger page developed in FrontPage
2002. Any ideas? Thanks in advance.
Scott Nipp
Phone: (214) 858-1289
E
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
what I am doing
wrong. Thanks.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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
,
INTERVAL 1 DAY','',1,2,'$CalendarDetailsID')) or die(mysql_error());
My big question is about using the DATE_ADD MySQL function inside
the INSERT statement. Is this allowed? If it is allowed, is it a bad idea
for some reason? Is there a better way of doing this? Thanks in advance.
Scott
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
and
removing of data to test during development, but I thought an auto_increment
field would still track and deal with this correctly.
Thank again for the help.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
--
PHP Database Mailing List (http
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
dLink('./event.php?ID=$IDDate=$Date','$LinkTitle','$AbbrTitle');
/script\n\n;
}
This function is called from another page as such:
if ($ver = 4) {
echo br\n;
getEventIE($CDCI, $CDTi, $showName, $queryDate);
Thanks again.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL
.
-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
.
Thanks in advance for the help.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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]
really do anything, but I am
trying this simply to test for a successful connection. Please let me know
if you have any ideas or suggestions. Thanks again.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
--
PHP Database Mailing List (http
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
cannot remember
exactly what it is and for some reason I can't seem to find the
documentation on it this time around. Any help in the right direction here
would be most appreciated.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
--
PHP Database
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
/DW/oratest.php
on line 10
Do I need to recompile PHP to be Oracle aware or something? What is
it I am missing at this point? Thanks in advance.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
--
PHP Database Mailing List (http://www.php.net
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
database to perform my query? I notice that there is a Oracle function in
PHP called ora_logon. This function description mentions something about
logging in using 'user@TNSNAME'. I am pretty confused by what this means.
Thanks in advance for the help.
Scott Nipp
Phone: (214) 858-1289
E-mail
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
1 - 100 of 187 matches
Mail list logo