Hello,
Can anyone tell me why this query errors out? It works from the mysql
client command line just fine
$query1 = "select * from zip_base where '$zip1' >= zip && '$zip1' <= CONCAT
(SUBSTRING(zip , '1' , LENGTH (zip) - LENGTH (range) ), range)";
Christopher C. M. Allen
--
PHP Gen
> If you are going to do a comparison from one of the fields in your table,
> doesn't the field name need to be on the left hand side of the comparison?
> So instead of "where '$zip1' >= zip", shouldn't it be "zip < '$zip1'" (et
al
> for the other comparisons in your query) .
>
Didn't matter. Is t
Greetings!
I am looking for an efficeient way to assign a decimal to a number and store
the new number.
I wanto add a decimal point after the first 2 leading digitis..
while ( query runs)
{
$temp=007170;
$changed_to_deicmal_form; // would store .7170
}
Furthermore I was using printf to round
I want to get the result from first row (the one next from ID field) of the
table using
$HotelName = mysql_result($resultHotel,0,1) or die(mysql_error());
A suggestion:
Why don't you use mysql_fetch_row or any other function that reaches
beyond just getting 1 field?
this would be easier per
> still did not work. Keep returning the same error when I do this:
> $HotelName = mysql_fetch_row($resultHotel,1) or die(mysql_error());
what was your connection statement and query to the db? I would look to
these ass the culprit
heres an example :
mysql_connect("localhost", "$username",
Just did this to a 65mb fixed width file.
What I did was get it into a csv file via perl :)
Then I created the db table.
Then I used:
load data infile "/file.csv" into table blah fields terminated by ',' ;
then go ahead and create any indexes etc...
!works slick!
> Is there an easy way to do th
> Unfortunately, it's not that simple.
>
> You haven't factored in Support costs nor administrative overhead nor...
> Well, I don't know what else the Marketing folks do when they figure these
> things out, but that's why I'm not in Marketing, eh?
Right it's not my game either (marketing), but
J-,
I have tested netscape communicator 4.76 with ssl extensively. no problems
what so ever.
Take a look at www.modssl.org for some of the common problems that are
associated with Internet Explorer
and ssl.
>The users all have MS Win 95, 98, or NT. The
> quality (ie. the 'bug-free-ness") of t
- Original Message -
From: Kurth Bemis <[EMAIL PROTECTED]>
To: Jason Jacobs <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 9:43 AM
Subject: Re: [PHP] Best browser
> At 10:39 AM 2/27/2001, Jason Jacobs wrote:
>
> he's probably referring to the SSL code that the
> The chicken did.
>
> as the Chicken is an actual chicken
> and the egg is a potential chicken.
> Actuality precedes potentiality
amen brotha.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
T
This is _and_ was _and_ ever shall be the state of mailing lists that help
people.
In the years that I have been on mailing lists, I have never seen a high
volume list that wasnt
filled with request after request for common knowledge.
The problem is not stopping people from asking the same manual
Greetings:
Anyone have a clue as how to send an icq message to a given ICQ number via a
php-web-page?
TIA.
Christopher C. M. Allen
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the lis
Hello:
Lookin for a little advice here.
I have a series of scripts that dynamically create web pages. The last page
in the series I wish to be able to write out to a file.
Is there a simple/quick way in which I can take the process(ing) script and
write it to a file at the same time that it is d
Greets:
I have a bit of php code that looks for a matching user/pass in a mysql
table. There are three user/pass phrases in the table along with a an email
that corresponds to each user/pass pair. Is there any way to construct a
query that will do both the matching of the user/passes and also th
In one page from a series of pages where I am building arrays for future
use:
$item4_array = urlencode (serialize ($item4_array));
echo "";
---
On my last page I send an email so I need the info that was stored:
$item4_array = unserialize(urldecode($item4_array));
$message .=" DIMS: L $item4_a
look in manual for HEADER and LOCATION
- Original Message -
From: "Vicor Spång Arthursson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 06, 2001 11:43 AM
Subject: [PHP] Redirect
> Hi!
>
> Still new on PHP, converting from vb$cript, I wonder how I do a
> redirect...
>
>
what's the OS?
- Original Message -
From: "ReDucTor" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 06, 2001 11:34 AM
Subject: [PHP] hey, got a question
i can't seem to access certain ports, through a nat program i have setup on
the computer here with the net, but i
well theres your problem...winblows.lol
- Original Message -
From: "ReDucTor" <[EMAIL PROTECTED]>
To: "Christopher Allen" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, July 06, 2001 11:58 AM
Subject: Re: [PHP] hey, got a question...
Seb-,
http://www.devshed.com/Server_Side/PHP/SoothinglySeamless/
I used this tutorial the first time. It was very straight forward.
Remember that you dont need rsaref files anymore in the US.
>>could someone explain me what i need to ad to the apache compiling
>>string ?
>>( i build php in apache
PHP PEOPLE,
Sorry this is way off topic but can anyone point me to a place where I can
find out how to mount/automount a tape drive in Linux? I need to know device
name mount commands and tape drive commands etc...Been searching on the net
for hours and the bits and pieces are not forming a whole
> $testResult = mysql_query("SELECT * FROM login_table where Pass =
$query = "select * from login_table where Pass=password('$password')";
then echo $query to the screen and make sure you see what needs to be there.
Also try mysql_error etc.. from the manual
GL
--ccma
--
PHP General Mail
Also, postfix works fine for me...
> On a side note, qmail has a wrapper that pretends to be sendmail. You can
> overwrite the /bin/mail with it and it will behave and accept mail just
like
> sendmail, but send it through qmail-smtp.
>
> > - changed php.ini path -> qmail path
--
PHP General
I wonder if Emacs runs on win2k it ran on win95 great...
-ca
- Original Message -
From: "Michael Champagne" <[EMAIL PROTECTED]>
To: "doug" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, July 19, 2001 12:16 PM
Subject: Re: [PHP] a good PHP editor
> VIM on Windows. Free and
Greetings:
OT (yes)?
When a user leaves a realm(.htaccess) from which they have logged into is
there any kind of notification back to the server?
I would like keep a log of such activities and do not want to do any session
type of jizz jazz(cookies etc).
I would think that there would need to be
!!Be careful of this, its super powerful!!
try it on 1 test file first and then do the wildcard...
from the unix command line:
bash>perl -p -i -e s/myself.inc/myself.inc.php/ *.php
so its:
perl -p -i -e s/original_text/text_to_replace/ file_name(s)
- Original Message -
From: "Shr
Day late and a dollar short bro! But thanks anyways.
>
> When the browser quits, it loses its memory of your username/password.
>
> That's all there is to it.
>
Also,
I was reading somewhere last week at some hosting companies website that
they stream http??
What is that? Is it a gimmick? Or does
PhP'ers
I would suggest that people not think too hard about this and continue
programming.
Thats right get back to work...:)
Have Fun!
--ccma
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To cont
> > An alternative (non-subscription) plan for the IDE will be announced
> > next week. It'll be designed to make the IDE much more affordable for
> > everyone, including those who develop for commercial purposes.
> >
> > Stay tuned!
An alternative is xemacs with the correct <.el >file.
Hello,
Is there any way around having to go back and backslash every quote in a
html table that contains millions of quotes?
I noticed that
print "
his name's
jack";
works for a single quote, but not double
I would literally have a thousand quotes to back sl
JB,
yes I do know that, but thanks :)
I was looking for:
print <<
of course it was on : http://www.php.net/manual/en/function.print.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact t
> On Thu, Feb 01, 2001 at 04:29:09PM -0800, Michael Conley wrote:
> > I have several PHP files that I only want users to be able to access via
> > HTTPS.
One way is to place these files only where the https server can see them.
heres an example:
.
.
DocumentRoot "/secure/secure_di
text field
> Hello,
>
> What type of field should I use if I don't want it to have a max length of
> characters?
>
> Thank you,
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the li
Hi!
How to get this to work for every month:
$tomorrow = date ("d", mktime(0,0,0,0,date("d") +4 ) );
echo "Today + 4 days is $tomorrow ";
screws up Feb et al
Thanks,
Christopher C. M. Allen
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMA
Hola:
http://www.google.com/intl/en_extra/options/winnetscape.html
Its kinda helpful: I modified the above to utilize the
www.php.net/some_function
Heres the trivial js code:
javascript:q=document.getSelection();for(i=0;ihttp://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For addition
> I have a mail script that works fine except that it does not send to the
CC
> in my header options... nor will it send to multiple addresses can some
one
> please give me some advice on this... I've looked in the php manual as
well
> as other web pages but neither have an answer for me.
>
>
Hello,
I am using the Header call in a script that has multiple submit buttons:
if ($submit =1)
{
Header (location: test1.php);
}
if ($submit ==2)
{
Header(location: test2.php);
}
Should not the form varaibles be passed along to each of these pages
respectively? I have a
36 matches
Mail list logo
