Re: [PHP] Very, very wiered problem

2004-03-08 Thread Brian Drexler
I've run into a similar problem before and it seems like the problem was
with permissions on the file.  You may want to double check those.

Brian

- Original Message - 
From: Ryan A [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, March 08, 2004 4:43 PM
Subject: Re: [PHP] Very, very wiered problem


 Hey,
 I dont really know the cause of your problem but I would put in a bunch of
 echo statements
 to pin down the area where you are getting the random char, then you
could
 go in and debug a
 bit more easily.

 HTH.

 Cheers,
 -Ryan


 On 3/8/2004 10:15:47 PM, Mário Gamito ([EMAIL PROTECTED]) wrote:
  Hi,
 
  I have this site at http://www.dte.ua.pt/ticct
 
  I
  don't know why, but it has a very strange behaviour.
  If you visit it and make a few reloads or browse through the site you'll
  see
  that *randomly* it shows only a blank page or an error saying it cannot
  find
  file whatever_file.php although it's there.
 
  I'm running SuSE 9, with a
  compiled Apache 1.3.29, PHP 4.3.4, and MySQL
  3.23.28
 
  Can it be SuSE's compiler the source of the problem ?
  It's random
  character makes it so difficult to debug :-(
 
  Any ideas would be apreciated.
 
  Warm Regards,
  Mário Gamito

 -- 
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP] convert access to JAVA PHP mysql Xml Soap

2002-05-01 Thread Brian Drexler

Ouchsucks to be that guy/company

-Original Message-
From: John Holmes [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 11:45 AM
To: [EMAIL PROTECTED]
Cc: 'PHP General'; [EMAIL PROTECTED]
Subject: RE: [PHP] convert access to JAVA PHP mysql Xml Soap


Gee, why didn't you copy all of the lists on your wonderful reply to my
message? I'm not trying to cock up life, whatever that is. I'm just
trying to stop people like you from wasting everyone's time. Don't send
messages to a PHP list about an ASP programmer or learn how to write a
decent job description that accurately describes what you're looking
for. I'm sure other people agree with me. I should Cc: your message and
response to all of the PHP lists you spammed to so everyone can know
what kind of company you are running. 

v/r

John Holmes

 -Original Message-
 From: Jacky Kenna [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, May 01, 2002 5:17 AM
 To: [EMAIL PROTECTED]
 Subject: RE: [PHP] convert access to JAVA PHP mysql Xml Soap
 
 Wonderful that you have the time to reply.  Must be sitting on your
arse
 doing fuck all. At least we are doing something. Why do we all have to
put
 up with slobs like you who only have time to cock up life.  Surely you
 should be out marching it's May day.
 
 -Original Message-
 From: John Holmes [mailto:[EMAIL PROTECTED]]
 Sent: 01 May 2002 16:12
 To: [EMAIL PROTECTED]; 'Jacky Kenna'
 Cc: [EMAIL PROTECTED]
 Subject: RE: [PHP] convert access to JAVA PHP mysql Xml Soap
 
 
 I don't know what kind of company you run, but I consider this SPAM.
You
 sent this crap out to a bunch of PHP lists and you're looking for an
ASP
 programmer. Who cares if there are people on here that know ASP,
that's
 not why they are on this list. If they are looking for ASP jobs,
they'll
 subscribe to an ASP list. I wouldn't have anything to do with a
company
 that does this. Keep you SPAM to yourself next time and stop wasting
my
 time.
 
 v/r
 
 John Holmes
 
  -Original Message-
  From: Jacky Kenna [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, May 01, 2002 4:17 AM
  To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; php-
  [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED];
 php-
  [EMAIL PROTECTED]; [EMAIL PROTECTED]; php-gtk-
  [EMAIL PROTECTED]; [EMAIL PROTECTED];
 [EMAIL PROTECTED];
  [EMAIL PROTECTED]; [EMAIL PROTECTED]; php-
  [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
  Subject: [PHP] convert access to JAVA PHP mysql Xml Soap
 
 
  Hi  We are a publishing company based in London. We have developed a
  multi-user
  MS Access contact management and bookkeeping database system which
we
 want
  to adapt / re-write such that it can be used over the web ( ASP)
using
  Internet
  Explorer (or similar) from any location, as our clients would like
to
 use
  it.
 
  We are therefore looking for someone to develope or who will head a
 team
  of
  developers and
  co-ordinate this project. If you are interested in working with us
on
  this,
  please e-mail [EMAIL PROTECTED] with a brief outline of your
  knowledge
  and experience of programming languages and I will get back to you
as
 soon
  as possible.
 
  Jacky Kenna
  Managing Director, PDA
  0207 384 1985
  [EMAIL PROTECTED]
 
 
 
 
  --
  PHP General Mailing List (http://www.php.net/)
  To unsubscribe, visit: http://www.php.net/unsub.php
 
 



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP] List, Key, Value oh my.

2002-04-23 Thread Brian Drexler

Wow, I didn't know Angles could sing...:-)  Sorry, bad attempt at humor.

-Original Message-
From: John S. Huggins [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 23, 2002 11:53 AM
To: Miguel Cruz
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] List, Key, Value oh my.



The Earth shook, Angles sang, there was much rejoicing.

Behold Miguel is correct. === did the trick.

It sure is nice to know I am not going nuts.

Much thanks.

John


On Tue, 23 Apr 2002, Miguel Cruz wrote:

-Amazing things happen when you compare values of different types. The
-numerical value of Name is zero. Try using === to compare type as well
-as value.
-
-miguel
-
-On Tue, 23 Apr 2002, John S. Huggins wrote:
- I forgot to show you some output from this thing...
-
- ---{0,BLOW, JOE}---Name is BLOW, JOE, Key = 0 |
- ---{Name,BLOW, JOE}---Name is BLOW, JOE, Key = Name |
- ---{1,YES}---1 |
- ---{2,}---
- ---{3,YES}---3 |
-
- The way I see it, that first line should have not printed because $key
is
- equal to 0 not Name.
-
-
- On Tue, 23 Apr 2002, John S. Huggins wrote:
-
- -
- -I have a problem.
- -
- -I am fetching rows from a MySQL table called temp.  Each row has
four
- -fields: Name, 1, 2 and 3
- -
- -Then I do this function which will eventually generate records for a
- -lookup table for any skills in the 1, 2 or 3 fields that equal the
string
- -YES associated with the Name (right now it just prints to the web
- -browser while I debug it).
- -
- -function generateLookupTable() {
- -  //
- -  $query  = SELECT * FROM temp;
- -  if ( !$result = mysql_query($query) ) {
- -  //
- -  print(pmysql_error() .  br$query/p);
- -  } else {
- -  //
- -  // For each name returned, march through
- -  // each skill and insert a row into the
- -  // lookup_skill
- -  // where the skill value == YES
- -  while ( $row = mysql_fetch_array($result) ) {
- -  //
- -  print(p); // For test
- -  while ( list($key,$value) = each($row) ) {
- -  print(---\{$key,$value}---); // For test
- -  //
- -  if ( $key == Name ) { -
- -  print(Name is $value, Key = $key
- -| );
- -  } else {
- -  if ( $value == YES ) {
- -  print($key | );
- -  }
- -  }
- -  print(br);
- -  }
- -  print(/p); // For test
- -  }
- -  }
- -}
- -
- -
- -
- -I have marked an IF statement with the - string.  As the
- -while statement marches through the array $row returned from
- -mysql_fetch_array the value of key is set first to 0 then Name
then
- -1 then 2 then 3.  Fine.  However, the if statement highlighted
above
- -winds up being true when the $key == 0 and when $key == Name and I
- -can't see why this would be so.
- -
- -Any possibilities folks?  I am quickly working around this now so it
is
- -not slowing me down, however, this is just too unusual to not figure
out.
- -
- -John
- -
- -
- -**
- -
- -John Huggins
- -VANet
- -
- [EMAIL PROTECTED]
- -http://www.va.net/
- -
- -**
- -
- -
- -
- ---
- -PHP General Mailing List (http://www.php.net/)
- -To unsubscribe, visit: http://www.php.net/unsub.php
- -
-
- **
-
- John Huggins
- VANet
-
- [EMAIL PROTECTED]
- http://www.va.net/
-
- **
-
-
-
-

**

John Huggins
VANet

[EMAIL PROTECTED]
http://www.va.net/

**


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP] authentication

2002-04-23 Thread Brian Drexler

Use javascript and close the browser, that's all I can think of.

-Original Message-
From: Michael Kimsal [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 23, 2002 3:04 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] authentication 


Morten Ronseth wrote:
 Anybody know how to revoke the HTTP authentication, i.e. log people out,
 using PHP?
 


You can't

---
Michael Kimsal
http://www.phphelpdesk.com
Guaranteed PHP support when you need it
734-480-9961


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP] PHP editor for windows

2002-04-22 Thread Brian Drexler

I really hate to do this, but it's one of my pet peives.

Shooter McGavin:  I eat pieces of shit like you for breakfast.
Happy Gilmore:  You eat pieces of shit for breakfast.

Wonderful movie.sorry about being a prick.

Brian

-Original Message-
From: Erik Price [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 22, 2002 11:19 AM
To: [EMAIL PROTECTED]
Cc: PHP
Subject: Re: [PHP] PHP editor for windows



On Monday, April 22, 2002, at 11:07  AM, .ben wrote:

 Other than notepad, interdev, ultraedit, etc (which i currently use 
 for
 editing), does anyone know of a good editor for PHP for Windows, 
 ideally
 with syntax colouring, etc?

 Cheers,

  .ben

 You use etc for editing?  Sounds pretty cool.

 (stupid Monday morning humor)



 Erik

 Ahh, nothing like a bit of Python-esque humour to start the day (tho, 
 my day
 started 8 hours ago!)

I was thinking of Adam Sandler.  I think it was Happy Gilmore.

Shooter McGrath makes threats, then: I eat shit like you for breakfast!
Happy Gilmore: You eat shit for breakfast?




Erik






Erik Price
Web Developer Temp
Media Lab, H.H. Brown
[EMAIL PROTECTED]


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP] mysql

2002-04-10 Thread Brian Drexler

select * from table_name where criteria=whatever limit 1;

-Original Message-
From: Mason Batley [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 11, 2002 12:02 AM
To: [EMAIL PROTECTED]
Subject: [PHP] mysql


Hi guys,

I've been looking on the net and the php docs for a simple
mysql query solution, can someone please let me know
the best way to get the values of a query that only returns 1 record?

All the select query examples on the net are examples of
multiple records being returned, and therefor, there is repition
methods shown.

For this I don't need any repitition, I just need to know the best
way to get the DB values from the query into variables.

Cheers.

-Mason


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP] Is While needed in MySQL Result with a Limit of 1

2002-04-10 Thread Brian Drexler

Here is my code:

mysql_connect(localhost,username,password);
$result=mysql_db_query(Database,select * from table_name where
criteria=whatever limit 1);
while($r=mysql_fetch_array($result) {
$Value1=$r[TableFieldName1];
$Value2=$r[TableFieldName2];
echo $Value1, $Value2;
}

My question is thisis the while statement needed when I'm only returning
one record?

Brian


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP] Re: php+myslq+IDE

2002-04-09 Thread Brian Drexler

I'm a big Edit Plus fan as well.  Really though, it's just a fancy text
editor with color coding and autocompleting, and IMHO the autocompleting can
get annoying fast.  However I have yet to find anything better.  Anyone know
of anything worth while?

-Original Message-
From: Joel Colombo [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 5:11 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Re: php+myslq+IDE


go download.com

get EditPlus

the trial runs up and still works without limit.
very cool program




Javier [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 Is there any free app. for php coding? I tried komodo but I can't get it
 to work in debug mode. Also tried Zend's Studio but it expires. :(
 Is there any free choice?




--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP] PHP FAQ (again) ... we have a plan!

2002-04-03 Thread Brian Drexler

I like the looks of it, if there's anything I can do just ask

-Original Message-
From: Hugh Bothwell [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 12:09 PM
To: [EMAIL PROTECTED]
Subject: [PHP] PHP FAQ (again) ... we have a plan!


I'm getting a bit interested in this; here's how I
suggest we proceed.

First, we have to agree on the scope of the project.
I suggest a small number of FAQs directed at specific
subjects (rather than one 5000-line monster); my
suggested breakdown follows below.

Second, I suggest storing these permanently in
an easily-referrable format so it's easy to quote the
official faq.  Would php.net be willing to host them?
Hard to find a more suitable spot...

Third, I suggest the introduction to php.net
should be posted to the php.general newsgroup
weekly, and the other faqs could maybe be
posted one per week in rota just to keep
everyone's memory fresh.

Fourth, we should have a set of guidelines for the
content (a faq faq?), ie

- each faq should start with links to the whole
list of permanently-stored faqs

- each faq should be no more than two layers deep
or 500 lines long; more than that, we should
consider splitting off a top-level subject into its
own faq.

- faqs should be text-only, or HTML equivalent
(modest background, URLs turned into links,
no graphical content) with rows no more than
72 characters long (easy to quote in a newsgroup).

- each bottom-level section should consist of a short
explanation, two to ten lines, followed by one
to three URLs for further reference.

- all URLs should be to stable, recognized sites;
OpenSource-affiliated sites should be listed first

Suggested content / breakdown:
==

+ introduction to php.net
  charter - the purpose of this newsgroup
  posting guidelines and etiquette
be specific
be terse
descriptive subject
include exact error messages
include code no more than N lines, else give URL
be polite
be thankful - no-one HAS to help you
don't cross-post
don't multi-post
don't spam
  how to subscribe / unsubscribe to the newsgroup
  how to subscribe / unsubscribe to mailing lists
  reference to archives
  reference to php.net manual

+ quick overview of the language
  what is PHP, short history
  most recent version
  where to download
refer to installation instructions
  terminology/jargon?
  refer to php.net manual
  refer to tutorials
http://www.zend.com/zend/art/intro.php
http://hotwired.lycos.com/webmonkey/programming/php/
  what else I should learn
HTML, JavaScript, CSS, SQL - links

+ installation, recompilation, configuration

+ name this function
  quick searchable function list with keywords, short
descriptions,  maybe very short examples, and links
to appropriate php.net manual page

+ advanced language questions
  what is a good development environment
  page redirection
  browser refresh / timeout
  I keep getting headers already sent
  how to print a number with leading zeros
  how to interact with JavaScript
  the difference between include() and require()
  playing with arrays
  playing with tables

+ forms, sessions, user authentication, cookies
  how to authenticate users
  playing with forms
  how to pass values from one script to another
  how to initiate a session
  how to terminate a session
  counting current users

+ php+database
  refer to mysql.com
  how to query a database
  how to get a limited number of rows

+ email
  how to validate an email address
http://www.zend.com/zend/spotlight/ev12apr.php
  sending email
refer to RFCs
plain text
HTML
multipart MIME
  processing email ie w/ procmail






-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP] April fools day - did anyone notice Thies's fangs on rc1???

2002-04-02 Thread Brian Drexler

Wow, talk about things from your past coming back to haunt you :-)

-Original Message-
From: Rasmus Lerdorf [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 11:52 AM
To: Erik Price
Cc: Frank Joerdens; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [PHP] April fools day - did anyone notice Thies's fangs on
rc1???


They were breadsticks.  Picture was taken in early 1999 in a restaurant in
Tel Aviv, Israel.

-Rasmus

On Tue, 2 Apr 2002, Erik Price wrote:


 On Tuesday, April 2, 2002, at 11:52  AM, Frank Joerdens wrote:

  Did anyone else notice Thies's fangs on the phpinfo() page of 4.2.0rc1
  yesterday? I wonder what they where . . . french fries? Salty sticks
  (German 'Salzstangen')?? At first I though I was hallucinating,
  especially when I found that he was gone again today! Try setting your
  server's system date back to yesterday, as in

 Pencils, I thought?  I didn't know who that was.


 Erik




 

 Erik Price
 Web Developer Temp
 Media Lab, H.H. Brown
 [EMAIL PROTECTED]


 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP] [Session]

2002-03-26 Thread Brian Drexler

Try using the same session variable.  Right now it looks like the first one
is v_s and the second is s_v.  HTH.

Brian

-Original Message-
From: Evan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 2:15 PM
To: [EMAIL PROTECTED]
Subject: [PHP] [Session]


Hi !!
I can't make this work:
PAGE 1:
?
$HTTP_SESSION_VARS[v_s]=500;
?
html
head
titleSESSION 1/title
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
/head

body bgcolor=#FF text=#00

pVariabile settata? --
?
if (isset($HTTP_SESSION_VARS[v_s])){
 echo si;
}else{
 echo no;
}
?/p
pa href=sess_2.phplink to next/a
/p/body
/html

In page 1 I create the session var and I check if it exists. The if stat
returns YES so it seems everything's ok.

PAGE 2:
html
head
titleSESSION 2/title
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
/head

body bgcolor=#FF text=#00
?
echo $HTTP_SESSION_VARS[s_v];
?
/body
/html

In page 2 I simply read the session var but it doesn't return anything.

I must leave register_globals = Off !
What's wrong?

Thanks,
Evan



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP] FAQ

2002-03-22 Thread Brian Drexler

Yes, an FAQ would be nice...so would a Manual...Oh wait, there is one, but
people just happen to overlook it most of the time :-)  I apologize for the
sarcasm, but it is Friday!

Brian

-Original Message-
From: James Taylor [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 22, 2002 2:50 PM
To: [EMAIL PROTECTED]
Cc: PHP List
Subject: Re: [PHP] FAQ


You are correct sir.  The purpose of the FAQ would be so that, like I said,
similar questions that pop up say, once a week, could be answered in the FAQ
instead of on the list - That way I won't get 300 messages a day :)

On Friday 22 March 2002 11:36 am, you wrote:
 Despite what Rasmus just said, I think that you are saying a PHP Mailing
 List faq based on the q's that the mailing list gets, not the general PHP
 faq.

 Scott

 -Original Message-
 From: James Taylor [mailto:[EMAIL PROTECTED]]
 Sent: Friday, March 22, 2002 2:30 PM
 To: [EMAIL PROTECTED]
 Subject: [PHP] FAQ


 Has anyone given any thought to possibly maintaining a FAQ containing the
 answers to the most commonly asked PHP questions on this list? I notice
 duplicates roll through every couple of days, and it would probably be a
 really nice PHP resource.

 Or, does one already exist? Ha.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP] Re: [NEWMAN] make an if or else if statement from mysql.

2002-03-20 Thread Brian Drexler

Try if(mysql_num_rows($sql_result)) instead of db_num_rows.  Hope this
helps.

Brian Drexler

-Original Message-
From: Philip J. Newman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 20, 2002 7:09 AM
To: Philip J. Newman; Julio Nobrega Trabalhando
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] Re: [NEWMAN] make an if or else if statement from
mysql.


$sql = SELECT accessIP FROM `access` ORDER BY `accessID` DESC;
$sql_result = mysql_query($sql, $connection) or die (Could not get Query);

if (db_num_rows()  0) {
// Update view where ip = visitor_ip
 } else {

 // Normal insert
  $sql = INSERT INTO `access` (`accessID`, `accessIP`, `accessDNS`,
`accessTIME`, `accessUPDATE`, `accessVIEW`) VALUES ('', '$proxy_ip',
'$proxy_dns', '$add_date', NOW(NULL), '0');
 $result = mysql_query($sql);
 }

this gives me

Fatal error: Call to undefined function: db_num_rows() in
d:\hosting\crushme\index.php on line 20

anyone helo me fix this


- Original Message -
From: Philip J. Newman [EMAIL PROTECTED]
To: Julio Nobrega Trabalhando [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, March 20, 2002 8:46 AM
Subject: Re: [PHP] Re: [NEWMAN] make an if or else if statement from
mysql.


 if (db_num_rows()  0) {

 mysql_query(UPDATE access SET access VIEW= accessVIEW+1 WHERE
accessIP
 = accessIP);  // Update view where ip = visitor_ip

  } else {

 $sql = INSERT INTO `access` (`accessID`, `accessIP`, `accessDNS`,
 `accessTIME`, `accessUPDATE`, `accessVIEW`) VALUES ('', '$proxy_ip',
 '$proxy_dns', '$add_date', NOW(NULL), '0');
 $result = mysql_query($sql);

  }

  if (db_num_rows()  0) {= WHERE DOSE THIS VERABLE COME FROM?

 - Original Message -
 From: Julio Nobrega Trabalhando [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Wednesday, March 20, 2002 8:45 AM
 Subject: [PHP] Re: [NEWMAN] make an if or else if statement from
mysql.


  Select before to see if exists:
 
  if (db_num_rows()  0) {
 // Update view where ip = visitor_ip
  } else {
  // Normal insert
  }
 
  --
 
  Julio Nobrega.
 
  Um dia eu chego lá:
  http://sourceforge.net/projects/toca
 
  Ajudei? Salvei? Que tal um presentinho?
  http://www.submarino.com.br/wishlistclient.asp?wlid=664176742884
 
 
  Philip J. Newman [EMAIL PROTECTED] wrote in message
  003401c1cf85$1afe54c0$0401a8c0@philip">news:003401c1cf85$1afe54c0$0401a8c0@philip...
  I have a log of IP numbers that come to WEBSITE A
 
  $sql = INSERT INTO `access` (`accessID`, `accessIP`, `accessDNS`,
  `accessTIME`, `accessUPDATE`, `accessVIEW`) VALUES ('', '$proxy_ip',
  '$proxy_dns', '$add_date', NOW(NULL), '0');
 
  This has worked well, how ever when someone comes back with the same
  accessIP then I would like then accessVIEW aadds a +1 to the value.
 
  I would like help to create this ..
 
 
  if (!$remote_addr) - if the ip that they are using is the same as one
in
  the table then update the record and use the accessID for that record.
 
  else if there isn't that $remote_addr in the table then it is added.
 
  I have yet to start on the code, so would some direction.
 
  Philip J. Newman
  PhilipNZ :: Design Solutions
  http://www.philipnz.com/
  [EMAIL PROTECTED]
  ICQ# 20482482
  +64 25 6144012
 
 
 
  --
  PHP General Mailing List (http://www.php.net/)
  To unsubscribe, visit: http://www.php.net/unsub.php
 
 
 





--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP] Problem with gethostbyaddr()

2002-03-20 Thread Brian Drexler

Greetings all,
 I'm having a problem with the gethostbyaddr() function in PHP 4.1.2.
Whenever I use it, regardless of the IP (Intranet or Internet) it just
returns the IP.  It says in the manual if there is an error, it will return
the IP, but I can't figure out what the error is.  Anyone have any input?
Thanks in advance.

Brian Drexler
Operations Technician
Saginaw Control  Engineering
(989)799-6871 Ext. 497
http://www.saginawcontrol.com http://www.saginawcontrol.com/


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP] Problem with gethostbyaddr()

2002-03-20 Thread Brian Drexler

My apologies for wasting everyone's time.  gethostbyaddr() works fine, I had
gethostbyname() in my script.  Is today Monday or something?  Have a nice
day!

Brian

-Original Message-
From: Brian Drexler [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 20, 2002 8:15 AM
To: Php-General@Lists. Php. Net
Subject: [PHP] Problem with gethostbyaddr()


Greetings all,
 I'm having a problem with the gethostbyaddr() function in PHP 4.1.2.
Whenever I use it, regardless of the IP (Intranet or Internet) it just
returns the IP.  It says in the manual if there is an error, it will return
the IP, but I can't figure out what the error is.  Anyone have any input?
Thanks in advance.

Brian Drexler
Operations Technician
Saginaw Control  Engineering
(989)799-6871 Ext. 497
http://www.saginawcontrol.com http://www.saginawcontrol.com/


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP] Problem with HTTP Authorization

2002-03-20 Thread Brian Drexler

I realize this may be a bit out of the scope of this list, but I'm sure
someone out there can help.  Here is my problem.  I'm using
htaccess/htpasswd for authentication on my site.  I want to know if there is
a way that when a user opens a link in a new window, their htaccess
information stays the same.  As it is right now, if USER1 clicks on a link
that opens a new window, the new window has no user.  I'd like the new
window to have USER1 as the user.  Is this possible?



Brian Drexler
Operations Technician
Saginaw Control  Engineering
(989)799-6871 Ext. 497
http://www.saginawcontrol.com http://www.saginawcontrol.com/


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP] Cannot Find php binary

2002-03-19 Thread Brian Drexler

You need to reconfigure PHP without the --with-apxs line in your configure script.  
Hope this helps.

Brian

-Original Message-
From: N. Pari Purna Chand [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 1:57 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Cannot Find php binary


Hi all
I have compiled php on a slack box
./configure --with-apxs=/usr/local/apache/bin/apxs ..
make  make install

everything Fine
and .php pages are being parsed with php when called thru webserver(apache).

But I can not find any binary named php
which I need to run php scripts from shell.

?
/Chandu




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


RE: [PHP] MySQL and indexes

2002-03-18 Thread Brian Drexler

You don't have to have an index in order for an update to work, although indexes do 
help performance a great deal when you are dealing with a lot of records.  Do you have 
Update permissions on the particular table/database you are working with?

Brian Drexler

-Original Message-
From: Jennifer Downey [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 18, 2002 3:41 PM
To: [EMAIL PROTECTED]
Subject: [PHP] MySQL and indexes


Hi all,

Just wondering, does a table have to have an index? If so what should I
consider when making a colum an index?

Here is the table I am using but I can't get php to update it.
Is it because there is no index?


CREATE TABLE wt_pet (
  petid varchar(100) default NULL,
  pet_user int(10) NOT NULL default '0',
  petname varchar(50) NOT NULL default '',
  pet_sex enum('Male','Female') NOT NULL default 'Male',
  pet_equip varchar(50) NOT NULL default '',
  pet_state varchar(20) NOT NULL default '',
  pet_hunger varchar(20) NOT NULL default '',
  pet_date date NOT NULL default '-00-00',
  num_pets int(1) NOT NULL default '0',
  ) TYPE=MyISAM;


Thanks
Jennifer Downey



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


RE: [PHP] Can anybody tell what is wrong with this file?

2002-03-12 Thread Brian Drexler

MessageYou need a form before the select.  Hope this helps.
  -Original Message-
  From: Balaji Ankem [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, March 12, 2002 4:13 AM
  To: 'Php-General'
  Subject: [PHP] Can anybody tell what is wrong with this file?


   H i friend,
  I am using the browser Netscape 4.7.

  It z not displaying the select box..blindly displaying in text format.. (If 
u want to see open example.jpg)
 
  Example.html
  =
  !DOCTYPE html public -//w3c//dtd html 4.0 transitional//en
  html
  body
  table
  tr
  td width=19% bgcolor=#DBF3DE1/td
  td width=15% bgcolor=#DBF3DE1/td
  td width=14% bgcolor=#DBF3DERaghu/td
  td width=19% bgcolor=#DBF3DEModem/td
  td width=18% bgcolor=#DBF3DE8L_LT/td
  td width=14% bgcolor=#DBF3DEW_SW150_1/td
  td width=14% bgcolor=#DBF3DENULL/td
  td width=14% bgcolor=#DBF3DENULL/td
  td width=14% bgcolor=#DBF3DEPending/td
  td
  select name=change1
  option value=SELECT/option
  option value=ApprovedApproved/option
  option value=RejectedRejected/option
  /select
  /td
  td width=14% bgcolor=#DBF3DE
  form name=name_1 method=post action=modify_status.php
  input type=submit name=modify value=SUBMIT
  input type=hidden name=req_id value=1
  input type=hidden name=dev_tag 
value=W_SW150_1
  /formbr
  /td
  /tr

  /table

  /body
  /html
  = 



  Thanks in advance

  Balaji




RE: [PHP] Re: Is there a GoTo Page Function?

2002-03-06 Thread Brian Drexler

Andre,
 In your php database storage code, after ? but before anything else you can do a 
(!isset($name)) die (You need to fill in your name.  Use the browser's back button 
and input this information.);  Hope this helps.

Brian

-Original Message-
From: Andre Dubuc [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 7:04 PM
To: hugh danaher
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] Re: Is there a GoTo Page Function?


Hi Hugh,

Thanks - I can access the next page now. But I've got a new problem: even if 
the fields are all empty, a carriage return sends me off to the next form 
[Bad! Bad, form - that's not what I want you to do!]

Where would you insert:

if (!isset($name)) die (You need to fill in your name.  Use the browser's 
 
back button and input this information.);

I tried in the php database storage code (didn't work). Tried it after the 
appropriate 'Name' code in the form's html document. Didn't work. I know 
that it should work somewhere . . . . 

Somehow, I don't think the Submit function is working as it should 
(especially if a carriage return or Enter can override everything). Is 
there some code that will defeat this undesirable activity?

Oh this is so much fun :) -- I love the long days and even longer nights. I'm 
glad I've got four months to put this new site together. Any insights and 
help will be greatly appreciated!

Tia,
Andre



On Tuesday 05 March 2002 16:50, you wrote:
 Andre,
 Have your form action point to a page that has your database storage code,
 and nothing else (no screen output at all!).  Have this page start with the
 ?php tag with nothing above the tag (no html and no blank lines either!).
 Once your storage is complete, then use the header(location:
 somepageyouname) to go to the page you have next in line.  Oh, and make
 sure to use the ? to end your php code.

 Once you get the above to work, then you can add decision statements which
 will help qualify your data.  (e.g. if (!isset($name)) die (You need to
 fill in your name.  Use the browser's back button and input this
 information.);).

 Hope this helps,
 Hugh
 - Original Message -
 From: Michael Kimsal [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
 Sent: Tuesday, March 05, 2002 1:15 PM
 Subject: [PHP] Re: Is there a GoTo Page Function?

  Andre Dubuc wrote:
   As a complete newbie to PHP, and relative novice to html, this one has

 me

   stumped. Rather than wade through volumes of documentation, I thought

 I'd

   risk asking it here.
  
   After inserting variables from a fill-out html form into my database, I

 would

   like the form to goto the next html page, but I cannot figure out how

 to do

   this basic function. I assume that when one clicks a Submit button,

 the

   info is sent to the server, but how do you call a new page? [In my old
   Paradox PAL days, this was accomplished very easily. I cannot find a
   corresponding function either in PHP or html.]
  
   (I.e: Once a person clicks on Input type=submit value=Accept Is

 there a

   function that can redirect the form to a new form?)
  
   Any help here would be greatly appreciated (or pointers to a good

 working

   tutorial that covers this area!)
 
  Usually people will do one of two things:
 
  Make the action of the form tag point to the new page directly.  That
  page would take care of any form data processing that needed to happen.
 
  OR
 
  Have the form call itself, then when it's done, use a HEADER tag with
  location: to redirect
  header(Location: newpage.php);
 
  Hope that helps.
 
 
  Michael Kimsal
  http://www.phphelpdesk.com
  734-480-9961
 
 
  --
  PHP General Mailing List (http://www.php.net/)
  To unsubscribe, visit: http://www.php.net/unsub.php

-- 
Please pray the Holy Rosary to end the holocaust of abortion.
Remember in your prayers the suffering souls in Purgatory.

May God bless you abundantly in His love!

For a free Cenacle Scriptural Rosary Booklet -- http://www.webhart.net/csrb/


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


RE: [PHP] CGI

2002-02-26 Thread Brian Drexler

Maybe I'm misunderstanding the question, but you should be able to make an alias in 
your httpd.conf file that points /cgi-bin/cgiscripts to /usr/lib/xxx/cgi-bin/ .  Then 
in your scripts variable you would need something like this: 
scripts=/cgi-bin/cgiscripts/xxx.cgi  Someone please correct me if I'm wrong.  Hope 
this helps.

-Original Message-
From: Sven Jacobs [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 26, 2002 9:31 AM
To: '[EMAIL PROTECTED]'
Subject: [PHP] CGI 


Hey

I have some cgi files who are in the /usr/lib/xxx/cgi-bin/ directory
How can i make them a part of my php meaning that in the current situation
the url is something like this
http://x.x.xxx/cgi-bin/cgiscripts/.cgi
and i want it to be something like this
http://../index.php?action=cgiscripts=xxx.cgi

Maybe a stupid question but 


Kind regards
Sven



Re: [PHP] Can I select only the newest record?

2001-02-18 Thread Brian Drexler

This worked:

SELECT * from that_table ORDER BY thetimestamp DESC LIMIT 1

Thanks to all for the help.

Brian Drexler



- Original Message - 
From: Christian Reiniger [EMAIL PROTECTED]
To: Php-General [EMAIL PROTECTED]
Sent: Saturday, February 17, 2001 8:58 AM
Subject: Re: [PHP] Can I select only the newest record?


 On Saturday 17 February 2001 12:12, PHPBeginner.com wrote:
  I wonder, if LAST_INSERT_ID will work in here...
 
  I know it works when on the same file was an insertion.. but will it
  return you the last ever inserted id, say a week ago?
 
 It will you return the id that was used on the last INSERT that *this* 
 process (i.e. this script while being executed right now) did.
 
 = it won't help.
 
   MySQL table.  I have a datetime field and an Auto_incremented field.
 
 If you want the "newest" field, add a timestamp field and do a 
 SELECT * from that_table ORDER BY thetimestamp DESC LIMIT 1
 
 a timestamp field in MySQL is by default automatically set to NOW() at 
 each INSERT and UPDATE if you don't set it yourself in the query.
 
 -- 
 Christian Reiniger
 LGDC Webmaster (http://sunsite.dk/lgdc/)
 
 Drink wet cement. Get stoned.
 
 -- 
 PHP General 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: [EMAIL PROTECTED]


-- 
PHP General 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: [EMAIL PROTECTED]




Re: [PHP] Re: Creative solution with XML,PHP,MYSQL

2001-02-18 Thread Brian Drexler

You could use frames, then you wouldn't have to refresh ALL of the page


- Original Message -
From: Siim Einfeldt aka Itpunk [EMAIL PROTECTED]
To: Brian V Bonini [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Saturday, February 17, 2001 10:07 AM
Subject: RE: [PHP] Re: Creative solution with XML,PHP,MYSQL



  Maybe Flash is an option?

 Well, I know I could probably do it some way in flash (if I had
 experiences with it), but this is just a bit out 'of the box'. But still,
 thanks for offering.

 Siim


 --
 PHP General 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: [EMAIL PROTECTED]


-- 
PHP General 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: [EMAIL PROTECTED]




[PHP] Uploading Files via PHP

2001-02-18 Thread Brian Drexler

I've been using a PHP upload script to upload files to our server, but my
problem is this.  I can't upload anything but JPG, GIF, and HTML files.
Anyone have any idea why?  This is probably something simple that I'm just
overlooking, but please help.

Brian Drexler


-- 
PHP General 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: [EMAIL PROTECTED]




Re: [PHP] Uploading Files via PHP

2001-02-18 Thread Brian Drexler

?
exec( "mv $image '$Destination/$FileName'");
?

- Original Message -
From: Michael Stearne [EMAIL PROTECTED]
To: Brian Drexler [EMAIL PROTECTED]
Cc: Php-General [EMAIL PROTECTED]
Sent: Sunday, February 18, 2001 1:55 PM
Subject: Re: [PHP] Uploading Files via PHP


 The script you are using is probably checking the MIME type of the file
 uploaded and rejecting any of the ones that are not one of the types you
 listed.  Look at or post some of the code you are using to find out if
 this is the case.

 Michael


 Brian Drexler wrote:

  I've been using a PHP upload script to upload files to our server, but
my
  problem is this.  I can't upload anything but JPG, GIF, and HTML files.
  Anyone have any idea why?  This is probably something simple that I'm
just
  overlooking, but please help.
 
  Brian Drexler
 
 



 --
 PHP General 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: [EMAIL PROTECTED]


-- 
PHP General 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: [EMAIL PROTECTED]




Re: [PHP] Converting CFML to PHP

2001-02-18 Thread Brian Drexler

Maybe I'm not all with it, but what is CFML?


- Original Message - 
From: Camden Spiller [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, February 18, 2001 3:52 PM
Subject: RE: [PHP] Converting CFML to PHP


Checkout: http://sourceforge.net/projects/cf2php

Camden



-- 
PHP General 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: [EMAIL PROTECTED]




[PHP] Can I select only the newest record?

2001-02-16 Thread Brian Drexler

Using PHP3/MySQL, is there a way I can select only the newest record from a
MySQL table.  I have a datetime field and an Auto_incremented field.  Anyone
got any ideas???

Brian Drexler


-- 
PHP General 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: [EMAIL PROTECTED]




Re: [PHP] MySQL: Add Autoincrement Field?

2001-02-16 Thread Brian Drexler

alter table $TableName add column $ColumnName NOT NULL AUTO_INCREMENT
PRIMARY KEY;

Have a nice day!

Brian Drexler
Precision Web Design


- Original Message -
From: Jeff Oien [EMAIL PROTECTED]
To: PHP [EMAIL PROTECTED]
Sent: Friday, February 16, 2001 11:30 PM
Subject: RE: [PHP] MySQL: Add Autoincrement Field?


 Could you tell me how to add a field to an existing
 database? I'm having trouble finding out how to do it.
 Thanks.
 Jeff Oien

  just add a field unique_id int auto_increment in the table...u dont have
to
  do anything more...it will start at 1 and every time a new record is
added
  to the table this value will be incremented
 
   I have an existing database from a flat file that I
   imported into a MySQL table. Some of the title
   fields are duplicates - songs with the same name
   from different song books. So if I want to delete
   a record by title, I'll end up deleting all songs with
   that title. Is there a way I can add a unique id field
   and have it automatically generate a unique number to
   each record? Hope that made sense.
   Jeff Oien
  
   --
   PHP General 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:
[EMAIL PROTECTED]
  
  
  
  
 
 
  --
  PHP General 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: [EMAIL PROTECTED]
 

 --
 PHP General 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: [EMAIL PROTECTED]


-- 
PHP General 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: [EMAIL PROTECTED]