This is down to an issue in phpmyadmin (or should that be PhpMyAdmin?). If
you create the tables from the MySQL console (or put the create statements
in a file and then run this form the console) the case sensitivity will be
retained.
Tom
Paul Meagher wrote:
> I am creating tables in Mysql on W
If at first youdon't succeed, then give up and try a bulldozer approach: -
Create a seperate php script for the new window.
>From your existing page, open the new window with javascript, passing in the
required id parameter to identify the cart contents that you want to display. If
you can't ident
Still not a flame, just a gripe against MS to think about!
>
> Actually, one thing that I REALLY like about the newer VB development
> environment is that it will automatically correct/adjust the case of your
> variables/functions to match their definition. This allows me to define
> them accor
Where I have the choice on WinNT I always use Apache module, never had any
problems with a qualified release version.
Tom
Tim Uckun wrote:
> At 12:13 PM 5/9/2001 -0700, Flint Doungchak wrote:
> >Tim,
> >
> >Unfortunately, the ISAPI module just isn't stable on this platform. Sorry.
>
> What is t
Nothing really wrong with the code, just different error reporting set.
But, as a couple of cents worth from someone that's learnt the hard way, it is
usually preferable to do something like
if (!isset($submit)){...} and handle the negative condition first. (Of course
this won't be the case if you
It's something which I've tried on a pile of occasions, and never really had
any success with - the best solution I've found is to put the directories
which are symlinks into the include path (Apache), or else run an external
module with a pile of typedefs in it. Both ways work, but neither is
par
John
If what you are really after is to display any records where a given field is
duplicated, then I would say that a self join is the best bet.
If you just pull 500 consecutive records out into an array, and perform the
comparrisoon in php, then what happens if record 500 has a duplicate to rec
Tim Uckun wrote:
> >
> >Finally, one language issue that is a real pet peeve of mine is case
> >sensitive variable definitions. This is not a problem in either CFM or ASP.
> >While it can be somewhat worked around by setting the PHP error level
> >reporting to flag uninitialized variables, it is
OK
Forget this - I managed to get onto php.net this morning and noticed the
helpful comment from Bernard Blundell - if anyone else has this problem, just
add the constant , ORA_FETCHINTO_NULLS, to the ora_fetch_into() function: -
ora_fetch_into($cursor, &a, ORA_FETCHINTO_NULLS)
Tom Mat
Hi all
I've just had to revert to Ora (as opposed to OCI) functions for a
backward site and I'm having a problem: -
I'm doing the following
1) ora_parse and ora_exec on a SELECT statement
2) ora_fetch_into on the cursor from (1)
What seems to happen is that when it encounters any null values i
In MySQL, you can run something like this: -
while ($row1=mysql_fetch_array($result_set)){
$name=$row1[Column1];
$desc=$row1[Column3];
echo"$name$desc";
Does anyone know a way of doing the same with oracle - by which I mean
refering to the columns in the array by name rather than by index (ie
Johannes is correct, but if you're woried about security remember that MD5 is a
one way algorithm - you don't need a key to unscramble it.
Tom
Johannes Janson wrote:
> Hi,
>
> a simple INSERT would do the job.
> To encrypt password use md5().
>
> Johannes
>
> ""fipo2001"" <[EMAIL PROTECTED]> sc
Check with your ISP what access rights you have to the MySQL db - if you
don't have create table rights, then you won't be able to crete temporary
tables either.
Tom
John Morrison wrote:
> Hi
>
> I have cobbled together my first PHP/MySQL site which
> checks out OK on "localhost" (a WinMe/Xitam
1) Command line console is always installed with MySQL - telnet to the
remote machine and you should be able to run it with no problems.
2) GUI - I reccommend phpmyadmin - get it from the MySQL site. It has a lot
of limitations, but the basic functionality is all fine.
Tom
edwin wrote:
> hi,
>
Depends how neat you want it to be!
If you don't mind asking the user to hit a button for each selection, then treat
each list as a form with its own submit button. Set the submit action to update
the variable that you use for the select to create the next list down.
Note that if you do this you w
True enough, but life's just a bitch sometimes! I don't create the problems,
just work around them.
"Svensson, B.A.T." wrote:
> >Using quotes (and remebering to escape them) may or may not cure the
> problem - it
> >seems to be a bit intermittent. It's more reliable just to hard code the
> tabl
Try using the table name instead of a variable containing the table name.
If you must use $tablename within the SQL statement then you should include it in
quotes.
The error that you are getting is basically saying that MySQL can't find the table
that you are looking for, which is true as you have
If you're not too fussed about security, then the easiest way is to create a
cookie and then check for it at the beginning of each page
(ie if (!ISSET(CookieName) {})
Tom
Synopsis wrote:
> any one here , know how to pass the login data to each page a user gose on,
> and that page checking it to
Thanks all, I was trying the . operator as a concatenator before - must have got my
languages mixed up!
Tom
Tom Mathews wrote:
> Window(IDent)
> {
>
>msgWindow=window.open("ContentsWindow.php3?ID=IDent","displayWindow","menubar=no,width=500,height=
Before you shout at me, I know that this isn't the right place for this
question, but you're all always so helpful that I thought I'd ask anyway
(grovel grovel..)
I'm playing around with php and javascript again, passing variables from
one to the other. I've got stuck on something too basic to me
Few things: -
1) Update Apache - 1.3.6 probably came out before WinME went Gold (it's not that
old really, but there have been a number of pretty serious bug fixes in the last
few releases and its always a good idea to try and stay pretty current)
2) Are you using this on a network with a firewall
Flint
Yeh, that's about the right syntax, but if you are sending duplicate messages
from a web server, I'd strongly recommned bcc: in the header instead of cc:
Tom
Flint Doungchak wrote:
> Randall,
>
> I'm not sure on this so I may need some correction, in theory, you should be
> able to put t
The other alternative (for those who don't have control of their DNS fro
instance so can't set up a pile of virtual hosts) which I often use when I'm
developing is just to set up some alias's to the root of the directory tree
that you want to use
eg http://localhost/bollox/ would take you to c:\bo
Have you set your path to include the php directory - or are you in the php
directory?
Tom
John wrote:
> I just get "Bad command or file name"
>
> Phil Driscoll wrote:
> >
> > >When I type php.exe -i at a ms-dos prompt, I get no response.
> > What do you mean by no response?
> > Cheers
> > --
>
Has anyone out there had any success with connecting to a Microsoft
Access database using the following config?
Server - Apache on Solaris
Access database location - Solaris NFS
I know that its a bit hopeful, but I thought that I'd ask anyway!
Cheers
Tom
--
PHP Windows Mailing List (http:/
Don't know what your problem is?
You can get the current time using the time() function - loads of formatting
options to output it as you require. To get 15 minute intervals, just put
the SELECT for your form element in a while loop.
If your problem is which locale you are in, then that's another
Yep - Apache bug - upgrade it!
Aleksey Filimonov wrote:
> Hi all,
>
> I have some problems installing php-4.0.4pl1 on apache-1.3.14 on win98...
> The apache server is running fine before adding this line in httpd.conf:
> LoadModule php4_module c:/php/sapi/php4apache.dll
> After adding module apa
It sounds an obvious question, but is it a new script you are trying to run, or
is it one that could be sitting in the browser cache and you aren't refreshing
it properly?
Antonio Lopez wrote:
> I installed PHP404pl1 with the automatic installer, and all works right.
>
> Now, i want to install P
Anything in the querystring can be translated as a php variable.
Say you have the string coming in as
...?result=1&age=23...
then in the called page/script, the querystring are already variables.
eg $result will have the value 1, $age will have the value 23...
Hope this is what you're after
Tom
Mark Tipton wrote:
> Any ideas on what could be causing such
> poor performance?
>
Microsoft!
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail
Depends which versionof PHP your ISP is running. Prior to v4.x, MySQL module
was not included in the standard compilations but had to be deliberately put
in. Easiest way to check is to run a script containing phpinfo() on your
hosting site.
Tom
Mark Taylor wrote:
> hi all,
>
> I've been testing
This is a segment taken straight from Julie Meloni's PHP Essentials. I've
used a variation of this on my WinNT dev pc with no problems at all.
Tom
' -o $crypted -a $clear");
unlink("$clear");
?>
Antonio Lopez wrote:
> Can anyone give me a sample code of system funct
try the unlink() command
Glenn wrote:
> hallo!
> how can i removing files from my upload folder on the server whit php
>
> Best regards.
> /Glenn
>
> _
> Free email with personality! Over 200 domains!
> http://www.MyOwnEmail.com
>
> --
> PHP Windows Ma
When I load data in from a file, I always make sure that the data is seperated
using a character which doesn't occur within the data itself - eg if you have
data with spaces in it, then don't use space a seperator.
eg
LOAD DATA LOCAL INFILE "countries.txt" INTO TABLE Countries FIELDS TERMINATED B
;time is to buy a copy of Exchange and do it in there.
>
> I haven't tried pdflib, so it's possible that there is an option for the security
>settings.
>
> > -Original Message-
> > From: Tom Mathews [mailto:[EMAIL PROTECTED]]
> > Sent: March 2
1) Text
It is a feature of Acrobat reader that you can take any pdf file and select text
from it and copy this to a clipboard. The only way to prevent this is to use a
version of Acrobat reader before 4.0! You should not be able to alter the text
using acrobat reader (although using the full versi
I seem to have missed the question on this one, but my guess from the answer
is that you are trying to open a different page based on the screen
resolution, presumably so that you can resize the graphics and text
accordingly.
This method will take a lot of extra development time - you have to wri
don't like being picky, but you may be thinking of MySQL where
% is the multiple character wildcard (eg select 'David!' LIKE '%D%v%';)
_ is the single character wildcard (eg select 'David' LIKE 'Davi_';
Tom
Ben Cairns wrote:
> The wildcard in PHP is a %
>
> E.G.
> select * from YOUR_TABLE where
How is your file delimited? This could impact on whether elemdata is a string
or actually a real array.
That may not be helpful, but here's a handy tip when using file() - remember
that it retains the newline character, so you have to be careful about mixing
and matching dos/windows type files wi
SELECT SUM(Row_x) FROM Table_y;
Tom
Ben Cairns wrote:
> I have a slight problem with this
>
> I am returning numerical values (i.e. 22.64, 2.54 etc. All with two Decimal
> Places) from a database. I then want to add these together.
>
> But, I don't know how many rows there are, so I cant do
I've never tried, but I'm wandering if it is related to the GIF licensing issue
that forced GIF's out of the GD libraries - does anyone know if the same
happenned to the PDF libraries?
Tom
Jason Hoover wrote:
> Rainer,
>
> Here is sample code for placing a .jpg image in pdf. Anyone out there g
Manuela.
I tried this for a while, and found that it was actually a problem at one of my
ISP's end that they were unable to resolve, so I gave up and installed
phpmyadmin on my remote site as well (its not very big if you pare down the
unwanted bits).
You may have the same problem
Tom
Manuela wr
ay of doing things when I get some time, but it
ain't going to be for a couple of weeks I guess.
Tom
[EMAIL PROTECTED] wrote:
> Mathews, could you dig out that script please? I think I might need
> it.
>
> Bikes
>
>
>
> -Original Message-
> From: Tom
Easier to diagnose if you tell us what the error was?
Winston Valenzuela wrote:
> I'm using ODBC to connect to my Interbase 6 database. Using the code:
>
> $post_stmt = "Insert into
> MSGTABLE(firstname,middlename,lastname,msg_subject,msgbody,remote_ip)
> values('$fname','$mname','$lname','$subj
I'm going to sound like a database freak, but my solution to nearly all
'dynamic' pages is to pull everything out of a database -
My implementation would probably be four fields - ID, Name (to display in
the select list), text and image. You query the db to get a list of 'Name's
and then use the I
Is anyone else getting pissed off with the amount of shite coming through this
list?
Does anyone reply to this stuff with remove messages (from the php lists not your
own address!) or is there no designated administrator? If no-one else already does
it, then I'll happily take on the responsibility
Had the same problem with LDAP and GD, but not with any of the others.
I tried copying stuff into different paths, but that didn't seem to help
either.
Eventually I gave up and just used the module instead of the CGI (faster
as well!)
Tom
Erik Ableson wrote:
>
>
> I'm seeing an interesting prob
Yep, but it may not be anything to do with the cookie - do you have any
JavaScript floating around on the same page? Netscape 4.x caches all script
that it finds before displaying the page (some people think its better this
way - once the page is up there are no delays, but in commercial situation
I run php4 on windows, linux and solaris with MySQL, MSSQL and Oracle 8i and the
aggregate
functions seem to be fine. Same goes fro php3 on windows and linux with MySQL (except
that the
aggregate functions are a bit limited here, so its not always worth bothering!).
Do you get an error message,
1) I think that people use Apache as old versions of IIS were crap. In addition, it is
about the widest used server out there in the commercial world (Linux running Apache
with PHP3 is I believe the most common config at the moment) so if you're developing
something to put on such a site, it's
Hmm - this old chestnut again.
Be very careful when passing arrays, sometimes it seems to work swimmingly
well, othertimes not so well!
There was a lot of discussion about this about a month ago, with people
trying the serialise / urlencode techniques and then running into GET
problems over the l
Can't remember the syntax off hand, but if you look under the file handling
stuff in the manual, you will see that there is a function which allows you to
put a tab delimited file into an array. From there you can do what you want
with each of the elements.
Ben Cairns wrote:
> I have a file wher
.. or www.mysql.com/downloads/contributions - there's a whole class in there to
handle HTML with MySQL
phobo wrote:
> see http://www.php.net/manual/en/function.nl2br.php
>
> siggy
>
> - Original Message -
> From: "Bikes" <[EMAIL PROTECTED]>
> To: "'Robert Trembath '" <[EMAIL PROTECTED]>;
If there was an error with the DB connection, then the 'or die' clause should
pick it up?
If nothing has changed between the IIS nad Apache implementation then I don't
know what is happenning
If however you have changed the table structure at the same time... or maybe
don't have any records on you
of FAQ out there in net land?
> Not that I have looked for one.
>
> kill-9
>
> ----- Original Message -
> From: "Tom Mathews" <[EMAIL PROTECTED]>
> Cc: "php" <[EMAIL PROTECTED]>
> Sent: Thursday, February 01, 2001 12:52 PM
> Subject: Re
If there is a FAQ, I've never found it. However, the list is archived daily
(twice daily?) on php.net and you can search the archive if you can be
bothered!
Anyone know who to contact about setting up a FAQ on php.net? Or has anyone
got a reliable site with space (and the time to manage) a FAQ? I
I agree with Simon
It is actually possible to work three tiers with PHP, but not so obviously as
JSP does.
The hit you take is performance, so it depends on what the application is
whether to use JSP or PHP.
Personally, for any e-commerce work I use PHP. It's very easy to get it hosted
and those
Ta
I forgot about the 'expose PHP' directive
Tom
Ryan Grove wrote:
> Comment out line 113 (or thereabouts) of your php.ini file. That
> should do the trick.
>
> --
> Ryan Grove
> [EMAIL PROTECTED]
> http://wonko.com/
> -
> Eve
I've just installed PHP 4-04pl1 on a new NT/Apache box and can't
remember how to turn off the very irritating
"X-Powered-By: PHP/4.0.4pl1 Content-type: text/html "
message that appears at the top of any script generated page.
Can anyone please remind me how to get rid of this.
Cheers
Tom
--
This issue cropped up with us a little while ago, but in a slightly different
context.
We have documents that are created using Word (PC users) and FrameMaker (die
hard Unix users that do not want anyone else to be able to edit their work
without first taking a degree in pontlessness). All of thes
60 matches
Mail list logo
