Cannot setup connection to remote Sybase db.
Using Apache 1.3.x + PHP 4.x on Windows 2000 server.
Remote Sybase db on Windows 2000 server.
PHP manual says Servername in sybase_connect() defines in 'interfaces' file.
What are they? Where are they?
rgds
--
PHP Database Mailing List (http://www
Hello,
I have a display problem with one of my sites.
Because there is an big amount of information in the pages, which is
extracted from database, using IE browser I see only the background of
the site, and then, after a time, the whole page.
My client has recently requested to make something to
Hi,
We are accepting Detailed description of the item in
.
Is there any function which can return full words without breaking the
lines. The data is stored in a PostgreSQL database in varchar field.
item_detail_description varchar(200)
I am assuming that the user need not press the 'enter' key
Well for starters, you shouldn't be running a repetitive process from
the web each time, thats why they have cron jobs. In order to have cron
jobs execute php code as an executable, you must make sure you have php
compiled as a cgi. It seems on your error message also that you don't
have php compil
Im having a problem getting listbox data to go into a mySql database.
This may be a simple problem but Ive been searching with out any result, and
thought I would ask on here.
Here goes...
No
Yes
the name of the field in the database is server, all of the other inputs
that I have within
Got this problem here.
I have a script i wish to run from a crontab every 2 minutes (Compiles live
stats for a hockey site). This script doesn't run at all in shell mode as an
application but works perfectly fine when called from the web.
Problem is i can't integrate it in the web site like when
Ok, I thought the index bit might be the problem since when I went to
look I realized I hadn't created one for this database. I also noticed a
problem with my raid array so I updated the driver and that went away.
Still, no matter what, I get this same problem. So here you go. Below
is that en
I'm trying to extract one record that has largest sequence ID number for an
employee, so I've tried below but doesn't work. Help.
$mQuery = "EmployeeID = '$user'";
$mCur = odbc_exec( $mCnx, "select ID=max(ID),Date,TimeIn,TimeOut,StationIP
from Clocks where $mQuery" );
Could it be that a certain web server sees you connect, you request a file,
and that file happens to take forever to load, leaving your script hanging
until memory runs out or something else? Do you have timeouts set properly
to stop the HTTP GET/POST if nothing is happening on that connection?
P
substr();
On Wed, 2003-03-12 at 13:21, Dallas Freeman wrote:
> I dunno what it is called so that is why I am asking, so that I can
> search the web about it.
> What do you call the method of cropping text back, so that there are a
> limited number of characters shown, the rest is cut off.
>
> Th
i believe u mean the dictionary term. not PHP function.
"Truncating"
Joel
"Dallas Freeman" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I dunno what it is called so that is why I am asking, so that I can
> search the web about it.
> What do you call the method of cropping text
if you're using mysql you can use LEFT(column_name, 10) this will return
the first 10 chars of whatever is in column_name. you could also use
SUBSTRING(col, position, length)... i'm sure most DB's support variations
of the above.
hth
jeff
Truncate?
> -Original Message-
> From: Dallas Freeman [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 12, 2003 4:22 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Cropped Text
>
>
> I dunno what it is called so that is why I am asking, so that I can
> search the web about it.
> What d
Strlen
:
-Original Message-
From: Dallas Freeman [mailto:[EMAIL PROTECTED]
Sent: March 12, 2003 4:22 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Cropped Text
I dunno what it is called so that is why I am asking, so that I can
search the web about it.
What do you call the method of croppi
I dunno what it is called so that is why I am asking, so that I can
search the web about it.
What do you call the method of cropping text back, so that there are a
limited number of characters shown, the rest is cut off.
Thanking You,
Dallas Freeman
--
PHP Database Mailing List (http://www.
Jim,
I don't think that matters. One can escape into PHP in several ways
(depending on the php.ini config of course)
1. Jonathan
-Original Message-
From: Jim Hunter [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 2:59 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-D
What does the code look like for the page you are trying to load? There is
an error in the code that is causing the problem, or the page does not
return anything viewable. If you call a PHP page that returns nothing
because of problems with your code, this is the error you will get. Start by
adding
Let me amend that, you need to delete the FILES from the temporary internet
files directory, not the directory itself. Sorry.
> -Original Message-
> From: Hutchins, Richard [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 12, 2003 3:25 PM
> To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
> Su
Yes! I ran into this once and it stumped me for a while. You need to delete
the temporary internet files directory on the machine where you're viewing
the source. Took me three days of looking on microsoft.com to figure that
one out.
I'm not proud.
> -Original Message-
> From: Jonathan V
For starters, and in general, does anyone know why a view source would
not work in IE 6? This hasn't worked for weeks, so I usually have to
use Mozilla to view the source.
Anyway, Jim, this is my basic page setup.
This is where my HTML codes goes.
So for example, a link to another page woul
Please bear with me, I am a complete newbie.
I am trying to use an in house server for test purposes and am having some
problems. I get an Internal Server error and when I look at the error log
the error is as follows:
"Premature end of script headers: /apache/php/php.exe."
I have tried the Apach
Are you doing some kind of recursion and getting stuck or overflowing the
stack?
If you create something like:
function Factorial($x)
{
if ($x == 1)
{
return $x;
}
else
{
return $x * Factorial($x-1);
}
}
You can get into a problem with overflowing the call stack with a
sufficiently hi
Jim,
Thanks for reply.
I haven't moved this into production yet, the d:/is/ was just for
testing as well as because when I use /client_name, the links do not
work.
I will to use the variable names instead of the define and see where
this gets me.
Just to note, I tried
define(IMG_HOME_ROOT
The reason it doesn't work may go beyond PHP. You are trying to make an HREF
point to an exact location on your hard drive. When the user of your web
page clicks the link, they do not have that location on their system so it
will fail. Always use relative locations for links. Then once you get that
I am developing an app which needs 3 constants. The value of these
constants comes from a database result.
This works fine. My problem is that they do not work very well. I am
developing on both windows/Linux (depending what I boot into).
This is the effect I want
$doc_dir = the string of d:
I've been doing that with a much smaller list, and we periodically run into
problems with subscribers SPAM filter, double-propagation of some
addresses, etc. I think the days of bcc: are numbered.
The approach we're working on now is to send an URL to subscribers. They
click on that and view t
I think at this point, as I've been working on it the past few hours, I
can safely say that it is NOT going into an endless loop. It's just
dying at a certain point. Interestingly, it always seems to dies at the
same point. When indexing a particular site, I noticed that it was dying
on a certa
Just a guess, but do you have an index on the table that you are using to
store the URLs that still need to be parsed? This table is going to get
huge! And if you do not delete the URL that you just parsed from the list it
will grow even faster. And if you do not have an index on that table and you
You could form them into an array and then use implode with whatever
delimiter sendmail uses (unless you changed it I believe it is just a
comma). To test it, try limiting your select statement to the first 50 or
so, then echo everything into a test output page. Then try with a defined
limit of 1
On Thursday 13 March 2003 02:14, Chris Payne wrote:
> That makes sense :-) One question, my brain is kind of dead today (Some
> would say always :-) But how would I get $emailadd to display all the
> addresses in the bcc bit? I know you have to add the addresses, seperate
> them with a , etc ..
Hi there.
That makes sense :-) One question, my brain is kind of dead today (Some
would say always :-) But how would I get $emailadd to display all the
addresses in the bcc bit? I know you have to add the addresses, seperate
them with a , etc . but for the life of me I can't think straight
Rich Gray wrote:
I'm having a heck of a time trying to write a little web crawler for my
intranet. I've got everything functionally working it seems like, but
there is a very strange problem I can't nail down. If I put in an entry
and start the crawler it goes great through the first loop. It ge
There was a post yesterday on PHP Classes that is this very thing. Go to www
PHPclasses.org and search for UsersOnline2.
This should help you out a bunch
Jim hunter
---Original Message---
From: Smita Manohar
Date: Wednesday, March 12, 2003 09:59:42 AM
To: [EMAIL PROTECTED]
Subject: [P
You could change the TO: to something generic like "Email List Subscriber"
then add everyone to the BCC field and then generate 1 email with 9000
people in the BCC field. Let sendmail do the rest. It should take less
time to send the emails and only a few seconds to generate your page.
Cheers
Ja
hello all,
im writting code for discussion forum. can any one give any idea about how
to show online status of members on and off ?
- smita.
_
Get ball by ball action on your desktop.
http://server1.msn.co.in/msnspecials/cricketdo
hello all,
im writting code for discussion forum. can any one give any idea about how
to show online status of members on and off ?
- smita.
_
Get ball by ball action on your desktop.
http://server1.msn.co.in/msnspecials/cricketdo
Hi there Everyone,
Below is some code I use to send a newsletter to clients subscribed on
my mailing list. The problem is I have over
9000+ email addresses in the DB and it takes around 30-45 minutes to
send them with the below code.
Can anyone see someway I can optimize it so it sends out the
GREAT. This does the trick for me. Thanks a lot. I am now getting
the output I want, so I can now feel confident about inputting this into the
actual database.
-Original Message-
From: Katie Evans-Young [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 11:21 AM
To: NIPP,
Even if the system is working correctly the first couple times, it may go
into an endless loop if you do not specify the right conditions, for any
programming application ...
I am very curious about this project ... is it open source? If so, I'd be
interested in taking a look at how you implement
Try it with the original array first, just for testing
---> Jonathan
-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
Here is basically what I have and what I am getting...
The section of code to copy and then process the copied array:
$other2 = array();
array_push($other2, $other);
foreach ($other2 as $test) {
if ($test == "") {
echo "NOTHING"."";
} else {
Sorry, I just reread your post
$array_copy = array();
array_push($array_copy, $original_array);
echo $array_copy[0];//or whatever to test
---> Jonathan
-Original Message-
From: Jonathan Villa [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 10:56 AM
To: 'NIPP, SCOTT V
$array_copy = array();
array_push($array_copy, $_SESSION['original_array']);
echo $array_copy[0];//or whatever to test
---> Jonathan
-Original Message-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 10:43 AM
To: 'Hutchins, Richard'; '[EMAIL
I don't think that is the case because I am able to access the
original array in this same page without having to use the session variable
reference. Won't hurt to give it a try though. Thanks for the feedback.
-Original Message-
From: Hutchins, Richard [mailto:[EMAIL PROTECTED]
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:[EMAIL PROTECTED]
> Sent: Wednesday, March 12, 2003 11:37 AM
> To: '[EMAIL PROTECTED]'
> Subject: [PHP-DB] Easy
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 = $
urm, so it does..,
thank you for your polite reply, I had included a month element in my query but left
it out cos i didnt think it made a dufference, of course i was using a where month = 1
clause after the ON bit which was limiting the link to those records, duh!
cheers
Dan
-Original Me
Well, I'm not locking them out exactly, but for good reason. When a url
is first submitted it goes into the database with a checksum value of 0
and a date of -00-00. If the checksum is 0 the spider will process
that url and update the record with the proper info. If the checksum is
not 0,
Lars,
I'm not sure if this is related (possibly), but I has similar problems with
cookies.
I doiscovered that the cookie was only being set if the page that set it
actually produced HTML. By redirecting, you cut out the HTML-writing.
Why not redirect the user if the test fails instead.
HTH
Geo
Hi everyone,
Thanks for looking at my question!
Well, i just made a script that firstly check's up username and password
(log-in script) then next if the user enteret the correct information a
session is set like this:
session_id($sessid);
session_start();
$_SESSION[
I just set up a test db using your info, and the query you have
worked ok. It provided a zero. Here's what I have (slightly modified
from yours, but not appreciably).
select ports.port, sum(stats.amount) as Total from ports left join
stats on ports.port=stats.to_port group by ports.port order by T
Do you "lock out" the URLs that have already been indexed? I'm
wondering if your system is going into an endless loop?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi all,
I have 2 tables that I need to extract data from, say PORTS and STATS.
PORTS contains a list of Sea Ports in PORT i.e. : -
PORTS.PORT
UK
FRANCE
GERMANY
NETHERLANDS
SPAIN
ITALY
STATS contains a few thousand records that with among other things has the elements
TO_
A couple of things. First, I believe it's pg_connect(), not
pgsql_connect(). Also, note that according to the docs, the old
syntax with multiple parameters
$conn = pg_connect("host", "port", "options", "tty", "dbname")
has been deprecated.
But more importantly, can you ping the postgres/mssql se
--- "Snijders, Mark" <[EMAIL PROTECTED]> wrote:
> that's bull
>
> on www.marksnijders.com and www.nederlandmobiel.nl i use those
> scripts (php
> and the GD functions ) for automatically changing the file size...
I think you're missing what he's saying. He's not saying that you
can't resize an
Hi everyone,
Thanks for looking at my question!
Well, i just made a script that firstly check's up username and password
(log-in script) then next if the user enteret the correct information a
session is set like this:
session_id($sessid);
session_start();
$_SESSION[
hi,
The charset used on my sql server is :
Character Set = 1, iso_1
ISO 8859-1 (Latin-1) - Western European 8-bit character set.
Where can I change these settings ?
Ben
[EMAIL PROTECTED] (Edwin Boersma) wrote in
news:[EMAIL PROTECTED]:
> Your code page setting might be wrong.
>
>
> E
> I'm having a heck of a time trying to write a little web crawler for my
> intranet. I've got everything functionally working it seems like, but
> there is a very strange problem I can't nail down. If I put in an entry
> and start the crawler it goes great through the first loop. It gets the
> url
Couldn't be ! I have MS client connecting to the db-server! I tried
odbc_connect for both MSSQL & PostgreSQL and it is ok!
However, odbc connection is no good for db processing!
Further help?
./pl
"Niklas lampén" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Possibly the db-serv
There is no firewall within the LAN environment.
I tried the mssql_connect too using mssql_connect("testdb","sa","") but same
error returned!
Any idea?
./pl
"Jason Wong" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> On Wednesday 12 March 2003 19:28, Patrick LOK wrote:
> > It is p
On Wednesday 12 March 2003 19:28, Patrick LOK wrote:
> It is possible to connect a remote db server using x_connect?
> e.g. a PostgreSQL in server PSQLDB, ip=192.168.0.100 and a MSSQL server
> MSSQLDB, ip=192.168.0.110
>
> I tried pgsql_connect("psqldb","administrator","") &
> pgsql_connect("1
on 12/3/03 12:01 pm, Snijders, Mark at [EMAIL PROTECTED] wrote:
> on www.marksnijders.com and www.nederlandmobiel.nl i use those scripts (php
> and the GD functions ) for automatically changing the file size...
Yeah but GD's server side...
Unless they have something installed on their client mac
that's bull
on www.marksnijders.com and www.nederlandmobiel.nl i use those scripts (php
and the GD functions ) for automatically changing the file size...
-Original Message-
From: Dallas Freeman [mailto:[EMAIL PROTECTED]
Sent: woensdag 12 maart 2003 12:58
To: 'mike karthauser'
Cc: [EMA
By the looks of it, I will have to create something in Delphi or
some-type of web application.
Thanks,
Dallas Freeman
-Original Message-
From: mike karthauser [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 12 March 2003 9:50 PM
To: Dallas Freeman
Subject: Re: [PHP-DB] Don't Underst
Dear Mark,
Thanks, very useful! Can you direct me where for help on getting an
image to resize before it is even uploaded (inother words, it will
resize itself on the end-user's machine and then upload to the
database).
Thanking You,
Dallas Freeman
-Original Message-
From:
It is possible to connect a remote db server using x_connect?
e.g. a PostgreSQL in server PSQLDB, ip=192.168.0.100 and a MSSQL server MSSQLDB,
ip=192.168.0.110
I tried pgsql_connect("psqldb","administrator","") &
pgsql_connect("192.168.0.100","administrator","") but failed!
Error is "Unab
no there is no other way, and it is pritty easy if you get it..
i've made a special function for it, but got the code @ home
but read this:
http://www.php.net/manual/nl/function.imagecopyresized.php
and especially the user comments.. they are always very usefull
goodluck
-Original Messa
Help!
I don't understand how to use the gdImageCopyResized
gdImageCopyResized(gdImagePtr dst, gdImagePtr src, int dstX, int dstY,
int srcX, int srcY, int destW, int destH, int srcW, int srcH)
Thanking You
Dallas Freeman
* is there a simpler way to change the size of an image?
i think i gotcha... u really have a whole site design u need here huh.
do u know PHP / MYSQL ?
TABLE :
games
FIELDS:
game_id as PRIMARY INDEX
game_title VC(100)
team_1 int (tie to key from teams table)
team_2 int (tie to key from teams table)
team_
69 matches
Mail list logo
