RE: [PHP-DB] MySQL newbie: inserting new entry to table?

2001-07-29 Thread Howard Picken

Have a look at how I would insert data in your case.

Howard

-Original Message-
From: sg [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 29 July 2001 8:57 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL newbie: inserting new entry to table?


Hi folks!

I'm new to PHP/mysql.

I created a db with one table (using PhpMyAdmin). The table is called
'addressbook' and the base 'mabase'.

I can very well read the table and display it very neatly using the below
code, but I CAN'T write new entries using the code in the second page (end
of mail)

~~  PAGE THAT WORKS


html
head
titleCarnet d'adresses/title
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
style type=text/css
!--
body { font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color:
#00; letter-spacing: 0.1em; background:#efefef}
.NomPrenom { font-family: Arial, Helvetica, sans-serif; font-size: 10pt;
color: #00; font-weight:bold; letter-spacing: 0.1em; }
hr {height:1px; color:#BB}
--
/style
/head

body bgcolor=#FF text=#00

?
$host = localhost;
$user = ;
$password = ;
$database = mabase;

//==
=
//  Display addressbook table content
//==
=

mysql_connect($host,$user,$password) or die(Impossible de se connecter à la
base de données .$database);

$result = mysql_db_query($database,select * from addressbook);

while ($row = mysql_fetch_object($result))
{
 if($row-prenom != )
 {
  echo span class=\NomPrenom\.$row-prenom./span;
 }

 if($row-nom != )
 {
  echo span class=\NomPrenom\nbsp;;
  echo $row-nom./span;
 }

 if($row-teldomicile != )
 {
  echo br\n;
  echo img src=\/interface/icons/domicile_phone.gif\
align=\absbottom\nbsp;\n;
  echo $row-teldomicile;
 }

 if($row-telmobile != )
 {
  echo br\n;
  echo img src=\/interface/icons/mobile.gif\
align=\absbottom\nbsp;\n;
  echo $row-telmobile;
 }

 if($row-telbureau != )
 {
  echo br\n;
  echo img src=\/interface/icons/bureau.gif\
align=\absbottom\nbsp;\n;
  echo $row-telbureau;
 }

 if($row-email != )
 {
  echo br\n;
  echo img src=\/interface/icons/email.gif\
align=\absbottom\nbsp;\n;
  echo a href=\mailto:.$row-email.\.$row-email./a;
 }

 if(($row-rue != ) || ($row-codepostal != ) || ($row-ville != ) ||
($row-pays != ))
 {
  echo br\n;
  echo img src=\/interface/icons/adresse.gif\
align=\absbottom\nbsp;\n;
 }

 if($row-rue != )
 {
  echo $row-rue;
  echo nbsp;-nbsp;;
 }

 if($row-codepostal != )
 {
  echo $row-codepostal;
  echo nbsp;;
 }

 if($row-codepostal != )
 {
  echo $row-ville;
  echo ,nbsp;\n;
 }

 if($row-pays != )
 {
  echo $row-pays;
 }

 echo brbrbrhrbrbrbr\n;
}
mysql_free_result($result);
mysql_close();
// END Display addressbook table content

?

/body
/html
~~  PAGE THAT WORKS  - END -






~~  PAGE THAT DOESN'T WORK

html
head
titleUntitled Document/title
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
/head

body bgcolor=#FF text=#00
?
$host = localhost;
$user = ;
$password = ;
$database = mabase;

mysql_connect($host,$user,$password);

$nom = Dupont;
$prenom = Jean;

$ok = mysql_db_query($database, insert into addressbook (nom,prenom) values
('$nom','$prenom'));



$ok = mysql_query(insert into addressbook (nom,prenom) values
('$nom','$prenom'));


?
/body
/html

~~  PAGE THAT DOESN'T WORK - END -


After that when I look at my page where I display the addressbook table, I
see nothing new, neither does it appear anywhere in PhpMyAdmin.

I don't get it!

But, again, I'm a newbie.

Is there a problem with the fact that I provide an empty user/password? I
don't recall having given any user name and password durng MySQL
installation.

If there is one, where can I find it? Or do I have to re-install???


Hope it's just a newbie syntax mistake though...

Thanks for reading anyway!

Cheers,

Sébastien






--
PHP Database 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 Database 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-DB] MySQL newbie: inserting new entry to table?

2001-07-29 Thread sg

Thank You Howard!

You sure are quick!

I found a way to make it work. I used to have both scripts (the one that
displays and the one that inserts new entries) on the same page...
Once I separated them I had a link on a third page. I first clicked on the
insert entry link then back to the display page... My new entry was there...

Now for the solution you gave me. I haven't tried it yet but I'd like to
know the difference.
I see you don't provide the database name in the mysql_query call. How does
MySQL know what base to work with?
I've seen both 'mysql_query' and 'mysql_db_query' in several tutorials but
haven't yet figured the difference between them (told you a was a newbie...)

Thanks again for your interest, I thought everybody would be on holidays...

Sébastien



-- 
PHP Database 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-DB] replace string - case insensitive

2001-07-29 Thread Dave Watkinson

go to http://www.php.net/eregi_replace



hth


Dave



-Original Message-
From: J- E- N [mailto:[EMAIL PROTECTED]]
Sent: 28 July 2001 15:41
To: [EMAIL PROTECTED]
Subject: [PHP-DB] replace string - case insensitive


hello

str_replace is case sensitive, what function should i use for case
insensitive.

thanks very much.



-- 
PHP Database 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-DB] How to I fetch an image file from /tmp directory?

2001-07-29 Thread Mark Gordon

I am inserting binary image data into a mysql table  (mediumblob).
Actually, what goes into the table is the /tmp...  pathname.

This is the code I used to try to retrieve, but I get Resource ID#2 

$get=mysql_query(SELECT bin_data FROM binary_data WHERE id=$id);
printimg src=$get;


=
Mark
[EMAIL PROTECTED]

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/

-- 
PHP Database 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-DB] excellent reference for form info

2001-07-29 Thread olinux

Here's a VERY helpful link to help deal with a number of form situations. 
http://www.linuxguruz.org/z.php?id=33

Little demo's of each too!

olinux

_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


-- 
PHP Database 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-DB] Still trying to get image from /tmp path

2001-07-29 Thread Mark Gordon

Thanks, David.  That helped a little but now what I get is:
img src=/tmp/phpMVWr5Z in the output.

The tmp folder is up the directory tree outside of my www folder (on my
web host's 'puter)- I don't have direct access to it.

Heres the modified code:

  $sql=mysql_query(SELECT bin_data FROM binary_data WHERE id=4);
  $row = mysql_fetch_array($sql);
  header(Content-type: image/jpeg);
  echo img src=$row[0];

How can I use the path stored in the db to retrieve the image?

=
Mark
[EMAIL PROTECTED]

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/

-- 
PHP Database 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-DB] multiple table query error

2001-07-29 Thread Steve Fitzgerald

I've figured out (with some help) how to query two tables at the same time.
In order to get a corresponding CompanyName with a specified ContactID I
created a SQL query that selects both tables ($table_name1,$table_name2) and
then selects contacts.CompanyID = '$CompanyID'. The result is a match for
data in the contacts table, but the data from the company table is the same
no matter which ContactID I select. I have two CompanyNames (with unique
CompanyID) and two separate contacts each one having a different CompanyID
associated. What am I doing wrong?

Steve

?
error_reporting(5);
$db_name = crm;
$table_name1= contacts;
$table_name2= company;

$connection = @mysql_connect(, , ) or die(Couldn't
connect.);

$db = @mysql_select_db($db_name, $connection) or die(Couldn't select
database.);

$chk_id = SELECT ContactID FROM $table_name1 WHERE ContactID  =
$ContactID;
$chk_id_res = @mysql_query($chk_id,$connection) or die(Couldn't execute
query.);
$chk_id_num = mysql_num_rows($chk_id_res);


 $sql1 = SELECT FirstName, LastName,WorkPhone, HomePhone, EmailName,
Birthday
  FROM $table_name1
  WHERE ContactID = '$ContactID'
  ;

$sql2 = SELECT CompanyName,WebSite
  FROM $table_name1,$table_name2
  WHERE contacts.CompanyID='$CompanyID'
  ;
 $result_1 = @mysql_query($sql1,$connection) or die(Couldn't execute
query.);
 $result_2 = @mysql_query($sql2,$connection) or die(Couldn't execute
query.);



 while ($row = mysql_fetch_array($result_1)) {
  $FirstName = $row['FirstName'];
  $LastName = $row['LastName'];
 $WorkPhone = $row['WorkPhone'];
  $HomePhone = $row['HomePhone'];
  $EmailName = $row['EmailName'];
  $Birthday = $row['Birthday'];

 }


 while ($row = mysql_fetch_array($result_2)) {
  $CompanyName = $row['CompanyName'];
  $WebSite = $row['WebSite'];


 }



?



-- 
PHP Database 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-DB] Finding NoMatches in MySQL

2001-07-29 Thread Dave Watkinson

Hi all

During the process of importing a lot of Oracle data into MySQL, I have two
tables that are giving me a bit of a headache. One is a list of jobs and the
other is a list of employers. There's now a unique id for each table, and
the job table also has a column called id1, which *should* correspond to
employers.uid.

With me so far?

Well, the problem is that there were loads of duplications in the employers
table, and after deleting the duplicates some of the jobs.id1 records now
point to non-existing records.

How do I do a query that does something like this...

select jobs.uid from jobs where jobs.id1 not in employers.uid

???

many thanks in advance!

Dave



-- 
PHP Database 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-DB] Still trying to get image from /tmp path

2001-07-29 Thread David Balatero

No no no, what you want to do is echo $row[0], not img src=$row[0].
$row[0] is the actual jpeg data, and the browser will interpret it like that
since you put the header(Content-type: text/jpeg);

Try echoing $row[0] only and tell me how that goes.

-- David

-Original Message-
From: Mark Gordon [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 29, 2001 1:31 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Still trying to get image from /tmp path


Thanks, David.  That helped a little but now what I get is:
img src=/tmp/phpMVWr5Z in the output.

The tmp folder is up the directory tree outside of my www folder (on my
web host's 'puter)- I don't have direct access to it.

Heres the modified code:

  $sql=mysql_query(SELECT bin_data FROM binary_data WHERE id=4);
  $row = mysql_fetch_array($sql);
  header(Content-type: image/jpeg);
  echo img src=$row[0];

How can I use the path stored in the db to retrieve the image?

=
Mark
[EMAIL PROTECTED]

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/

--
PHP Database 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 Database 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-DB] Query displays one

2001-07-29 Thread Mike Gifford

Hello,

I've got a pretty basic query which I am trying to run within a function.

The query looks like this:

SELECT
a.title,a.alt_title,a.articleID,a.articleSectionID,sect.URLname
FROM
$articlestable a, $categorytable sect
WHERE
a.articleSectionID = sect.articleSectionID
ORDER BY
a.date
DESC
limit 5

The problem is that I am only getting one response from this query rather than 
5.  I can't figure this out.  What did I do to only get one response?

The function is here:

function latest_articles() {
global $id,$main_file,$front_end_url,$alt, $articlestable, $categorytable;
$alt_var=;
$contentquery4 = mysql_query(SELECT 
a.title,a.alt_title,a.articleID,a.articleSectionID,sect.URLname FROM 
$articlestable a, $categorytable sect WHERE a.articleSectionID = 
sect.articleSectionID ORDER BY a.date DESC limit 5) or mysql_die();
if ($result = mysql_num_rows($contentquery4)) {
while ($contentarray4 = mysql_fetch_array($contentquery4)) {
$category = $contentarray4[URLname];
if ($alt) {
if ($contentarray4[alt_title]) {
  $link_name = $contentarray4[alt_title];
$alt_var = ?alt=french;
} else {
  $link_name = $contentarray4[title];
  $alt_var = ?alt=french;
}
} else {
$link_name = $contentarray4[title];
}
$content .= \nlia 
href=\.$front_end_url./.$main_file./.urlencode($category)./.$contentarray4[articleID]./
 
. $alt_var .\  class=\articleslink\.stripslashes($link_name)./a;
}
}
return $content;
}

And Table below:

CREATE TABLE articles (
articleID bigint(21) unsigned NOT NULL auto_increment,
articleSectionID bigint(21),
uid bigint(21),
title varchar(255),
content mediumtext,
image_suffix varchar(4),
date date,
alt_title varchar(255),
alt_content BLOB,
meta_keywords varchar(255),
meta_description varchar(255),
blerb TEXT,
alt_blerb TEXT,
PRIMARY KEY (articleID)
);

The missing results can (not) be seen here (under new postings):

http://airdiv.cupe.ca/union.php/Division/

Mike
-- 
Mike Gifford, OpenConcept Consulting, http://openconcept.ca
Offering everything your organization needs for an effective web site.
Abolish Nuclear Weapons Now!: http://pgs.ca/petition/
It is a miracle that curiosity survives formal education. - A Einstein


-- 
PHP Database 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-DB] Still trying to get image from /tmp path

2001-07-29 Thread Luc Servaas

Maybe this helps:

$file = /tmp/pathtoimage/image.jg
$fp = fopen($file, filesize($file));
$image = fread($fp, filesize($file)); //not sure about fread function¿

print $image //or imagejpeg($image), I'm not sure..

Grtz,

Luc

[EMAIL PROTECTED]
- Original Message -
From: Mark Gordon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, July 29, 2001 10:31 PM
Subject: [PHP-DB] Still trying to get image from /tmp path


 Thanks, David.  That helped a little but now what I get is:
 img src=/tmp/phpMVWr5Z in the output.

 The tmp folder is up the directory tree outside of my www folder (on my
 web host's 'puter)- I don't have direct access to it.

 Heres the modified code:

   $sql=mysql_query(SELECT bin_data FROM binary_data WHERE id=4);
   $row = mysql_fetch_array($sql);
   header(Content-type: image/jpeg);
   echo img src=$row[0];

 How can I use the path stored in the db to retrieve the image?

 =
 Mark
 [EMAIL PROTECTED]

 __
 Do You Yahoo!?
 Make international calls for as low as $.04/minute with Yahoo! Messenger
 http://phonecard.yahoo.com/

 --
 PHP Database 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 Database 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]




Odp: [PHP-DB] InterBase

2001-07-29 Thread Jarek Zgoda

Od: "Sergey Larionov" [EMAIL PROTECTED]
Temat: [PHP-DB] InterBase


 "Warning: InterBase: arithmetic exception, numeric overflow, or string
  truncation  Cannot  transliterate character between character sets in
  /home/larionov/public_html/base.php on line 6"
 How I can turn off tranliteration?

You cann't just "turn it off" - this message means that client charset is
different than db charset. If you have database created with default
character set, say, WIN1252, you will get this message when you try to
retrieve row using, say, WIN1250 and the row contains characters from
outside of WIN1250 character set. This also happens when you do not specify
character set when creating columns in tables then connect specifying
character set - all characters above #127 will be trated as illegal and
raise this error. That's why the best approach is to specify default
character set when creating database - all character and text blob columns
will use this character set and no special processing will be nacessary
during connecting, just set the appropriate lc_ctype variable in database
parameter buffer (i.e. in ibase_connect parameters).

Cheers
Jarek Zgoda



-- 
PHP Database 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-DB] 2 Tables- 1 Insert Problem

2001-07-29 Thread Doug Semig

Beyond that excellent answer, this is exactly the kind of situation where
transactions would be helpful (and in a lot of cases, mission critical).

So an expanded quasi-pseudocode rendition of olinux's answer could be:

$result_bt = mysql_query('[whatever it takes to begin a transaction]');
$result_1 = mysql_query($sql1);
if (!$result_1) {
  $result_rb = mysql_query('[whatever it takes to rollback a transaction']);
  /* whatever else you want to do, such as show an error message */
}
else {
  $result_2 = mysql_query($sql2);
  if (!$result_2) {
$result_rb = mysql_query('[whatever it takes to rollback a transaction']);
/* whatever else you want to do, such as show an error message */
  }
  else {
$result_et = mysql_query('[whatever it takes to commit a transaction']);
} }

If your implementation of MySQL supports transactions (and if it doesn't
then either change databases or web hosts), use them.  It helps ensure the
integrity of the data.  Please feel free to be more elegant in the error
checking...the above is just an example and would undoubtedly not be used,
even fixed up for syntax, on a production site.

Doug

At 10:25 PM 7/28/01 -0500, olinux wrote:
Not possible.

do this $result_1 = mysql_query($sql1) or die('Insert 1 failed');
do this $result_2 = mysql_query($sql2) or die('Insert 2 failed');

olinux

-Original Message-
From: Steve Fitzgerald [mailto:[EMAIL PROTECTED]]

I'm trying to insert data into two separate tables using 1 INSERT.
  ... snip ...


-- 
PHP Database 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-DB] PHP and Informix installation

2001-07-29 Thread Sommai Fongnamthip

Halo,
 How could I set up Informix driver in my Linux Server?
SF

At 13:26 27/7/2001 -0500, Muciño Zúñiga Marco Antonio wrote:
OK, I set my LIBS environment variable to my esql -libs result and the
confire shell is OK now, but now I get the next error when running the make
command:

# make

=== src

make[1]: Entering directory `/tmp/apache_1.3.20'

make[2]: Entering directory `/tmp/apache_1.3.20/src'

=== src/os/unix

gcc -c  -I../../os/unix -I../../include   -DSCO5 -I/tmp/php-4.0.6
-I/tmp/php-4.0
.6/main -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend
-I/tmp
/php-4.0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT
-I../../lib/e
xpat-lite -DNO_DL_NEEDED `../../apaci` os.c

gcc -c  -I../../os/unix -I../../include   -DSCO5 -I/tmp/php-4.0.6
-I/tmp/php-4.0
.6/main -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend
-I/tmp
/php-4.0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT
-I../../lib/e
xpat-lite -DNO_DL_NEEDED `../../apaci` os-inline.c

rm -f libos.a

ar cr libos.a os.o os-inline.o

true libos.a

=== src/os/unix

=== src/ap

gcc -c  -I../os/unix -I../include   -DSCO5 -I/tmp/php-4.0.6
-I/tmp/php-4.0.6/mai
n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend
-I/tmp/php-4
.0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT
-I../lib/expat-lite
  -DNO_DL_NEEDED `../apaci` ap_cpystrn.c

gcc -c  -I../os/unix -I../include   -DSCO5 -I/tmp/php-4.0.6
-I/tmp/php-4.0.6/mai
n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend
-I/tmp/php-4
.0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT
-I../lib/expat-lite
  -DNO_DL_NEEDED `../apaci` ap_execve.c

gcc -c  -I../os/unix -I../include   -DSCO5 -I/tmp/php-4.0.6
-I/tmp/php-4.0.6/mai
n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend
-I/tmp/php-4
.0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT
-I../lib/expat-lite
  -DNO_DL_NEEDED `../apaci` ap_fnmatch.c

gcc -c  -I../os/unix -I../include   -DSCO5 -I/tmp/php-4.0.6
-I/tmp/php-4.0.6/mai
n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend
-I/tmp/php-4
.0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT
-I../lib/expat-lite
  -DNO_DL_NEEDED `../apaci` ap_getpass.c

gcc -c  -I../os/unix -I../include   -DSCO5 -I/tmp/php-4.0.6
-I/tmp/php-4.0.6/mai
n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend
-I/tmp/php-4
.0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT
-I../lib/expat-lite
  -DNO_DL_NEEDED `../apaci` ap_md5c.c

gcc -c  -I../os/unix -I../include   -DSCO5 -I/tmp/php-4.0.6
-I/tmp/php-4.0.6/mai
n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend
-I/tmp/php-4
.0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT
-I../lib/expat-lite
  -DNO_DL_NEEDED `../apaci` ap_signal.c

gcc -c  -I../os/unix -I../include   -DSCO5 -I/tmp/php-4.0.6
-I/tmp/php-4.0.6/mai
n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend
-I/tmp/php-4
.0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT
-I../lib/expat-lite
  -DNO_DL_NEEDED `../apaci` ap_slack.c

gcc -c  -I../os/unix -I../include   -DSCO5 -I/tmp/php-4.0.6
-I/tmp/php-4.0.6/mai
n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend
-I/tmp/php-4
.0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT
-I../lib/expat-lite
  -DNO_DL_NEEDED `../apaci` ap_snprintf.c

gcc -c  -I../os/unix -I../include   -DSCO5 -I/tmp/php-4.0.6
-I/tmp/php-4.0.6/mai
n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend
-I/tmp/php-4
.0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT
-I../lib/expat-lite
  -DNO_DL_NEEDED `../apaci` ap_sha1.c

gcc -c  -I../os/unix -I../include   -DSCO5 -I/tmp/php-4.0.6
-I/tmp/php-4.0.6/mai
n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend
-I/tmp/php-4
.0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT
-I../lib/expat-lite
  -DNO_DL_NEEDED `../apaci` ap_checkpass.c

gcc -c  -I../os/unix -I../include   -DSCO5 -I/tmp/php-4.0.6
-I/tmp/php-4.0.6/mai
n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend
-I/tmp/php-4
.0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT
-I../lib/expat-lite
  -DNO_DL_NEEDED `../apaci` ap_base64.c

gcc -c  -I../os/unix -I../include   -DSCO5 -I/tmp/php-4.0.6
-I/tmp/php-4.0.6/mai
n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend
-I/tmp/php-4
.0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT
-I../lib/expat-lite
  -DNO_DL_NEEDED `../apaci` ap_ebcdic.c

rm -f libap.a

ar cr libap.a ap_cpystrn.o ap_execve.o ap_fnmatch.o ap_getpass.o ap_md5c.o
ap_si
gnal.o ap_slack.o ap_snprintf.o ap_sha1.o ap_checkpass.o ap_base64.o
ap_ebcdic.o
true libap.a

=== src/ap

=== src/main

gcc -c  -I../os/unix -I../include   -DSCO5 -I/tmp/php-4.0.6
-I/tmp/php-4.0.6/mai
n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend
-I/tmp/php-4
.0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT
-I../lib/expat-lite
  -DNO_DL_NEEDED