Re: [PHP] Linux Question

2002-11-25 Thread Brian V Bonini
On Mon, 2002-11-25 at 10:35, 
> > conbud wrote:
> >
> > >Hey. This really isnt a PHP question. but what fonts do you reccomend
> using
> > >so they look decent on linux. Mainly looking for a good font that will
> look
> > >nice in MoZilla and Galeon. Almost all the fonts Ive used so far appear
> > >really tiny or really bold and not very good to read.

If you use a range of fonts with a generic family you should be ok, for
example:

verdana, helvetica, arial, sans-serif

Also, try to use relative sizes, if you use fixed sized like 10pt. you
will have size discrepancies on different platforms. If you use a
relative scheme like 12px it will render more consistently

BTW: I bet you'd find the same issues if you looked at your pages on a
MAC as well...

-Brian


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




Re: [PHP] Linux Question

2002-11-25 Thread Brian V Bonini
On Mon, 2002-11-25 at 18:26, Justin French wrote:
> on 26/11/02 2:41 AM, Brian V Bonini ([EMAIL PROTECTED]) wrote:
> 
> > Also, try to use relative sizes, if you use fixed sized like 10pt. you
> > will have size discrepancies on different platforms. If you use a
> > relative scheme like 12px it will render more consistently
> 
> 12px is NOT a relative size, and will mean that users with vision
> impairment, etc etc will have trouble resizing the text to suit their
> preferences... The relative sizes are things like "small".
> 
> http://www.w3.org/TR/CSS2/fonts.html#propdef-font-size

px is obviously a relative unit (relative to the users screen) unless
your going to try to say everyone views stuff at the same dpi. It's late
so perhaps I'm missing it but I do not see anywhere in the spec that you
cited where it says px is absolute. However I will quote loosely from
the spec: "values with relative units (em, ex, px) must be made absolute
by multiplying with the appropriate font or pixel size," 

So, go ahead and try what I suggested THEN tell me it's not right. Using
px WILL make it more consistent across win, linux, mac, etc.. and will
not inhibit the browsers ability to enlarge the text size at all...


> 
> > BTW: I bet you'd find the same issues if you looked at your pages on a
> > MAC as well...
> 
> You'd have the same problems on any computer where the user has fiddled with
> the default font settings.

No, the problem he stated was the inconsistency of sizes on different
platforms. A totally addressable issues regardless of what the user has
done with the default font settings.





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




Re: [PHP] Linux Question

2002-11-26 Thread Brian V Bonini
On Mon, 2002-11-25 at 20:22, Justin French wrote:

> 
> I don't think I was being clear enough at all :)  12px is 12pixels... there
> is no way for it to *reliably* be reset to 14px, or 10px by the user on all
> browser.

That's like saying 10% is 10%. 10% of what? The physical size of a pixel
varies depending on the device therefore it is not static.

You said px is absolute and even tried to quote from the spec albeit
there was no such quote at the location you cited.

So again, I WILL quote directly from the spec:

-- SNIP --

There are two types of length units: relative and absolute. Relative
length units specify a length relative to another length property. Style
sheets that use relative units will more easily scale from one medium to
another (e.g., from a computer display to a laser printer).

Relative units are:

* em: the 'font-size' of the relevant font
* ex: the 'x-height' of the relevant font
* px: pixels, relative to the viewing device 

-- END SNIP --

I'm pretty sure that says px is a relative unit

http://www.w3.org/TR/REC-CSS2/syndata.html#length-units

section 4.3.2


> 
> In the current versions of IE for Win, using the text size larger smaller or
> % options in the menus has no effect whatsoever if values like 12px or 12pt
> are given.

Sounds like just one more reason in the long list of reasons not to use
MS software.

But, you are correct and if this is an issue then it needs to be
addresses accordingly.

However, if memory serves, the original question was how to get fonts to
appear more consistent in size across varying platforms and browsers.
Not accessibility issues. I believe I did provide the solution for that.
Like I said, try it, then we can debate... ;-)


> 
> So, I stand partially corrected, the user CAN override ALL font size by
> digging into the accessibility menus, but I seriously doubt many do.

Well, really all you have to do is check the "ignore font sizes" in the
accessibility menu. But again, the fact that IE does not allow resizing
sounds more like an IE specific issue (bug if you will) especially since
every other browser I know of does allow it.

> 
> If the latest versions of IE *DO* allow text zooming via the menus, again I
> stand corrected, but there are millions of web users out there on IE5 and
> IE6 without text zoom.  IMO, specifying a px or pt font size is taking away
> the users right to choose what font size they prefer to read with, IF they
> are using IE4/5/6.

Well, I guess, but I think MS took that decision away, not the site
author. Your always free to use NN, or Mozilla, or Opera.

Anyway, besides you mis-quoting the spec I am just arguing for the sake
of argument. Accessibility is an issue that should be addressed even if
Microsuck can't do it themselves and does not have the insight to make a
more user friendly method of controlling font sizes for the end user.
But, non of this really has anything to do with the original question.
And, it is certainly WAY off topic for the PHP list.

Peace,
-Brian
***




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




Re: [PHP] forum?

2002-12-24 Thread Brian V Bonini
On Tue, 2002-12-24 at 09:51, Fatih Üstündağ wrote:
> do you know freeware forum in php I can easly use?

Phorum

http://phorum.org



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




Re: [PHP] ftp and www

2003-01-07 Thread Brian V Bonini
On Tue, 2003-01-07 at 15:16, Mukta Telang wrote:

> May be it means that it should be possible to browse ftp directory
> from a browser? 

Which is entirely possible without PHP


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




[PHP] Loading CSV data into MySQL

2003-02-01 Thread Brian V Bonini
Sorry for the OT question: 

I'm loading a .csv file into MySQL, done it a million times but for some
reason it is scrambling the row order. All the fields are making it in
correctly but the order of the rows seems to end up totally random. I've
done this a million times and never saw this..

Any thoughts...





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




Re: [PHP] Re: Loading CSV data into MySQL

2003-02-01 Thread Brian V Bonini
On Sat, 2003-02-01 at 16:47, Thomas Seifert wrote:
> > 
> > I'm loading a .csv file into MySQL, done it a million times but for some
> > reason it is scrambling the row order. All the fields are making it in
> > correctly but the order of the rows seems to end up totally random. I've
> > done this a million times and never saw this..
> > 
> > Any thoughts...
> 
> where do you take a row-order from? and HOW are you uploading it into mysql?
> if you don't use a "order by"-clause in a select you won't have a really 
> ordered result (only by accident).

LOAD DATA INFILE 'file.cvs' INTO TABLE table1 FIELDS TERMINATED BY ';';

the contnts of file .csv look like:

1;2002-02-01;New Dominion Pictures;Prosecutors - The Gosch Murder
Case;Beau Parcells;Dave Stevenson (victim's husband), Lead;yes;yes;yes
2;2002-02-01;Coastal;Prospecting;Zoe Whitaker;Corporate
Representative;yes;yes; 3;2002-02-01;Metro Video;Right Spirit Campaign
(Binge Drinking PSA), - Richmond, VA;Tom Downs;Jim
(Sailor)/Principal;yes;yes;
4;2002-02-01;Metro Video;Right Spirit Campaign (Binge Drinking PSA), -
Richmond, VA;Amie Hill;Spokesperson;;;
5;2002-02-01;Metro Video;Unit of Action (U.S. Army);Tim Smith;Col. Mike
Daniels (Principal);;yes;
6;2002-02-01;Metro Video;Colonial Williamsburg;Molly
Larkin;Mother/Wife;;yes;
7;2002-02-01;Commercial;Barton Ford;Dave Hobbs;Car Salesman;yes;yes;
8;2002-02-01;Commercial;Barton Ford;Jackie Jackson;Customer's Wife;;;
9;2002-02-01;Regent Films;First Lunch;Molly Larkin;Principal;yes;yes;
10;2002-02-01;Skillet Productions (televisio;Welcome Home;Molly
Larkin;Principal;yes;yes;


etc

You'd think they would load into the db just like that right? But they
do not. They just end up in some random order.


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




RE: [PHP] Loading CSV data into MySQL

2003-02-01 Thread Brian V Bonini
On Sat, 2003-02-01 at 17:25, John W. Holmes wrote:
> > I'm loading a .csv file into MySQL, done it a million times but for
> some
> > reason it is scrambling the row order. All the fields are making it in
> > correctly but the order of the rows seems to end up totally random.
> I've
> > done this a million times and never saw this..
> 
> So?
> 
> Why does it matter to you what order the rows are in the database, as
> long as the right data is there? The order is irrelevant.
> 

Because in this instance I need it to come out in the order it is
actually in.


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




RE: [PHP] Loading CSV data into MySQL

2003-02-02 Thread Brian V Bonini
On Sat, 2003-02-01 at 20:07, John W. Holmes wrote:
> 
> Then use an ORDER BY in your query. If you're relying on the database to
> spit out rows in the order they went in, then you're wrong.

Hey man thanks for pointing that out...  I know it's wrong, I didn't
design it but it's what I have to work with and I'm not being paid to
fix it. And quite frankly clients being as ignorant as they tend to be
at times just know that its worked fine for years and don't want to hear
that they have to spend money fixing something that as far as they can
tell has always worked fine. That being said, in this instance, due to
poor design, I need this stuff to be in there in a particular order. If
that's not possible then I'll just have to suck it up and rebuild this
thing for free but if I can find a way around that for the time being
then


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




[PHP] Text size in image

2003-02-02 Thread Brian V Bonini
When creating an image using the image functions how do you control the
type face size?





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




Re: [PHP] Text size in image

2003-02-03 Thread Brian V Bonini
On Sun, 2003-02-02 at 20:50, Tom Rogers wrote:
> Hi,
> 
> Monday, February 3, 2003, 8:24:00 AM, you wrote:
> BVB> When creating an image using the image functions how do you control the
> BVB> type face size?
> 
> If you are using imagestring() the size is determined by the font number (1 - 5)
> for internal fonts. If you use true type fonts then the size is set in each call to
> imagettftext() as one of the parameters.
> 
> -- 

I noticed afterwords that imagettftext seemed to be the only reasonable
way to control the face and size however I do not seem to be able to get
it to work. Does this require extra libraries or ??



ImageString works fine but Imagettftext, no go... No errors or anything
it just does not output the image.

PHP Version 4.0.6
 './configure' '--with-apxs=/usr/local/www/bin/apxs'
'--with-config-file-path=/usr/local/www/etc' '--enable-versioning'
'--with-system-regex' '--disable-debug' '--enable-track-vars'
'--with-gd=/usr/local' '--with-freetype-dir=/usr/local'
'--with-jpeg-dir=/usr/local' '--with-png-dir=/usr/local' '--with-zlib'
'--with-imap=/usr/local' '--with-mysql=/usr/local'
'--with-imap=/usr/local' '--prefix=/usr/local/www' 'i386--freebsd4.4'

GD Support enabled
GD Version 1.6.2 or higher
FreeType Support enabled
FreeType Linkage with freetype
JPG Support enabled
PNG Support enabled
WBMP Support enabled



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




[PHP] image size from text/font size

2003-02-03 Thread Brian V Bonini
Trying to set the image size based on the amount if text/fontsize,
etc...  Looked through a bunch of the functions but nothing is jumping
out at me. Does anyone have an example and or can point me to the
correct function(s) for this.




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




[PHP] text color in image

2003-02-03 Thread Brian V Bonini
Any idea why this would NOT create white text?

$png = ImageCreatefrompng("images/menu0.png");
$tx_color = ImageColorAllocate($png,255,255,255);
imagettftext($png,12,0,25,16,$tx_color,$font,$text);


There IS white (255,255,255) in the source png's palette, I don't know
weather that makes a difference or not.


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




[PHP] 'superglobal'

2003-02-05 Thread Brian V Bonini
What is it that has to be set in php.ini for a superglobal to work?
-- 
- -- 
Brian V Bonini
-=gfx-Design=-
[EMAIL PROTECTED]
__
gfx-Design  --Web Design and Hosting Services-- 
http://www.gfx-design.com
http://www.gfxdesign.net
[EMAIL PROTECTED]
Phone:(757)623-1655  Fax:(425)675-3094  
__



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




Re: [PHP] 'superglobal'

2003-02-05 Thread Brian V Bonini
On Wed, 2003-02-05 at 19:04, Kevin Waterson wrote:
> This one time, at band camp,
> Brian V Bonini <[EMAIL PROTECTED]> wrote:
> 
> > What is it that has to be set in php.ini for a superglobal to work?
> 
> You dont need to set anything, they work out-of-the-box
> 
> just try something like this...
> 
> 
> 

They're not working, that's why I ask... Is my PHP version too old?

PHP Version 4.0.6

 './configure' '--with-apxs=/usr/local/www/bin/apxs'
'--with-config-file-path=/usr/local/www/etc' '--enable-versioning'
'--with-system-regex' '--disable-debug' '--enable-track-vars'
'--with-gd=/usr/local' '--with-freetype-dir=/usr/local'
'--with-jpeg-dir=/usr/local' '--with-png-dir=/usr/local' '--with-zlib'
'--with-imap=/usr/local' '--with-mysql=/usr/local'
'--with-imap=/usr/local' '--prefix=/usr/local/www' 'i386--freebsd4.4'


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




[PHP] Config problems

2003-02-06 Thread Brian V Bonini
Been using PHP for some time but never have actually compiled my own,
the version my provider compiled always sufficed, anyway, I
I'm having some issues.

config fails here:

checking for GD support... yes
checking for the location of libjpeg... yes
checking for the location of libpng... yes
checking for the location of libXpm... yes
checking for FreeType 1.x support... yes
checking for FreeType 2... yes
checking for T1lib support... yes
checking whether to enable truetype string function in GD... yes
checking for jpeg_read_header in -ljpeg... yes
checking for png_write_image in -lpng... yes
If configure fails try --with-xpm-dir=
configure: error: freetype2 not found!


%locate freetype
/usr/local/include/freetype
/usr/local/include/freetype/freetype.h
/usr/local/include/freetype/fterrid.h
/usr/local/include/freetype/ftnameid.h
/usr/local/include/freetype/ftxcmap.h
/usr/local/include/freetype/ftxerr18.h
/usr/local/include/freetype/ftxgasp.h
/usr/local/include/freetype/ftxgdef.h
/usr/local/include/freetype/ftxgpos.h
/usr/local/include/freetype/ftxgsub.h
/usr/local/include/freetype/ftxkern.h
/usr/local/include/freetype/ftxopen.h
/usr/local/include/freetype/ftxpost.h
/usr/local/include/freetype/ftxsbit.h
/usr/local/include/freetype/ftxwidth.h
/usr/local/include/freetype.h
/var/db/pkg/freetype-1.3.1
/var/db/pkg/freetype-1.3.1/+COMMENT
/var/db/pkg/freetype-1.3.1/+CONTENTS
/var/db/pkg/freetype-1.3.1/+DESC
/var/db/pkg/freetype-1.3.1/+REQUIRED_BY

%locate xpm
/usr/X11R6/bin/cxpm
/usr/X11R6/bin/sxpm
/usr/X11R6/include/X11/xpm.h
/usr/X11R6/man/man1/cxpm.1.gz
/usr/X11R6/man/man1/sxpm.1.gz
/usr/share/man/man3/expm1.3.gz
/usr/share/man/man3/expm1f.3.gz
/var/db/pkg/xpm-3.4k
/var/db/pkg/xpm-3.4k/+COMMENT
/var/db/pkg/xpm-3.4k/+CONTENTS
/var/db/pkg/xpm-3.4k/+DESC

Currently installed module (4.0.6) was configures with:

 './configure' '--with-apxs=/usr/local/www/bin/apxs'
'--with-config-file-path=/usr/local/www/etc' '--enable-versioning'
'--with-system-regex' '--disable-debug' '--enable-track-vars'
'--with-gd=/usr/local' '--with-freetype-dir=/usr/local'
'--with-jpeg-dir=/usr/local' '--with-png-dir=/usr/local' '--with-zlib'
'--with-imap=/usr/local' '--with-mysql=/usr/local'
'--with-imap=/usr/local' '--prefix=/usr/local/www' 'i386--freebsd4.4'

which is exactly what I'm trying to duplicate with the new install
(4.3.0)


Not sure what to do here...





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




[PHP] upgrade issues

2003-02-06 Thread Brian V Bonini
What's wrong with this snippet of code that would make it stop working
after upgrading from 4.0.6 to 4.3.0



Stuff






 './configure' '--with-apxs=/usr/local/www/bin/apxs'
'--with-config-file-path=/usr/local/www/etc' '--enable-versioning'
'--with-system-regex' '--disable-debug' '--enable-track-vars'
'--with-gd=/usr/local' '--with-freetype-dir=/usr/local'
'--with-jpeg-dir=/usr/local' '--with-png-dir=/usr/local' '--with-zlib'
'--with-imap=/usr/local' '--with-mysql=/usr/local'
'--with-imap=/usr/local' '--prefix=/usr/local/www' 'i386--freebsd4.4'



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




Re: [PHP] Re: Config problems

2003-02-06 Thread Brian V Bonini
On Thu, 2003-02-06 at 10:03, Goetz Lohmann wrote:
> Brian V Bonini schrieb:
> > Been using PHP for some time but never have actually compiled my own,
> > the version my provider compiled always sufficed, anyway, I
> > I'm having some issues.
> 
> NOTE: once compiled, this PHP package runs without the include files,
> cause they are "included" to the package. So you provider had freetype
> version 2 and xpm installed, you might not have this.
> 

I got it, thanks... I was just being lazy and did not want to have to
install a newer freetype which also meant having to install GNU make
because BSD make will not work to install freetype. Unfortunately after
upgrading all my PHP sites stopped working, I suspect due to a change in
syntax or perhaps just poor coding practices in the past


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




[PHP] 4.0.6 to 4.3.0

2003-02-07 Thread Brian V Bonini
Any thoughts as to why this snippet:

25: if ($attach != "none")
26:  {
27:$file = fopen($attach, "r");
28:$contents = fread($file, $attach_size);
29:$encoded_attach = chunk_split(base64_encode($contents));
30:fclose($file);

would produce these errors:

Warning: fread(): supplied argument is not a valid stream resource in
/usr/virtual/share/pkgs/installed/aeromail/1.40/aeromail/send_message.php on line 28

Warning: fclose(): supplied argument is not a valid stream resource in
/usr/virtual/share/pkgs/installed/aeromail/1.40/aeromail/send_message.php on line 30

After upgrading from 4.0.6 to 4.3.0


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




RE: [PHP] 4.0.6 to 4.3.0

2003-02-07 Thread Brian V Bonini
On Fri, 2003-02-07 at 09:44, Rich Gray wrote:
> >
> > Any thoughts as to why this snippet:
> >
> > 25: if ($attach != "none")
> > 26:  {
> > 27:$file = fopen($attach, "r");
> > 28:$contents = fread($file, $attach_size);
> > 29:$encoded_attach = chunk_split(base64_encode($contents));
> > 30:fclose($file);
> >
> > would produce these errors:
> >
> > Warning: fread(): supplied argument is not a valid stream resource in
> > /usr/virtual/share/pkgs/installed/aeromail/1.40/aeromail/send_mess
> > age.php on line 28
> >
> > Warning: fclose(): supplied argument is not a valid stream resource in
> > /usr/virtual/share/pkgs/installed/aeromail/1.40/aeromail/send_mess
> > age.php on line 30
> >
> > After upgrading from 4.0.6 to 4.3.0
> >
> 
> Most probably because with 4.3.0 register_globals is set to OFF by default -
> where does $attach get set?
> 


Nope, I do have register_globals on in php.ini

Its being set in another file like this:




It behaves like, if ($_GET['attach'] != "none") or ($attach != "none")
is always true.

If I attach something it goes through no prob, if I do not attach something
it still goes through but with all the error messages and an empty attachment
at the recieving end. Only thng that has changes was upgrading PHP from 4.0.6
to 4.3.0

-B


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




RE: [PHP] 4.0.6 to 4.3.0

2003-02-07 Thread Brian V Bonini
On Fri, 2003-02-07 at 10:13, Rich Gray wrote:

> Hi Brian
> 
> Why are you using $_GET[] when your form is submitting via the 'post'
> method?

My bust, just a typo. It's actually: if ($attach != "none") that is
beign used anyway.

> Secondly for file uploads why are you not using the $_FILES[]
> superglobal array?

I did not write the app, just trying to figure out why it stopped
working after upgrading PHP. You think that's the problem?


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




Re: [PHP] Alternating Row Colors in PHP........

2003-02-08 Thread Brian V Bonini
On Sat, 2003-02-08 at 18:25, CF High wrote:
> Hey all.
> 
> I'm coming from Cold Fusion to PHP; in CF I could alternate rows with the
> following:
> 
> 
> 
> Any ideas how to do this in PHP?
> 

One possibility:

while (whatever) {

$bgcolor = ($i++ & 1) ? '#c0c0c0' : '#ff';
  echo "bla-bla";

}


-Brian


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




[PHP] Counter has gremlins

2003-02-17 Thread Brian V Bonini
I have this basic counter: 

 $counterFile"); 
} 
print "Visitor #$num"; 
} 
if (!file_exists($counterFile)) { 
exec("echo 1 > $counterFile"); 
} 
displayCounter($counterFile); 

?> 

Works like a charm but every so often for no apparent reason it resets
to 0.

Anyone see anything wrong here to cause that?


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




[PHP] World Pac

2003-07-09 Thread Brian V Bonini
http://catalog.worldpac.com/webparts-overview.html

Before I go figuring this out from scratch... Has anyone here worked
with their Java API and interfaced with it via PHP?


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



[PHP] skipping occurance in regex

2003-05-29 Thread Brian V Bonini
how can you skip the first occurance and stop at the second in a regex?






content1





content2



If I wanted to grab all that from within a document I know I can start
at table id= because it's unique but how do I skip the first 
and stop at the second?




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



Re: [PHP] What's wrong with this code??

2003-05-31 Thread Brian V Bonini
On Fri, 2003-05-30 at 20:02, Beauford wrote:
> Your right though, the code is awkward - but I couldn't think of any other
> way of doing it.
> 
> Any suggestions?
> 
 
switch

http://us4.php.net/manual/en/control-structures.switch.php


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



Re: [PHP] Any POSTNUKER, reading from two DB

2003-06-01 Thread Brian V Bonini
On Sat, 2003-05-31 at 07:41, nabil wrote:
> Greeting,
> 
> I have a postnuke site and I want to connect it to two databases in order to
> verify users from these databases.


and..??


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



Re: [PHP] Re: cheap PHP+SQL WebHosting

2003-06-02 Thread Brian V Bonini
On Sun, 2003-06-01 at 13:05, Ryan A wrote:
> Hey there,
> I think i can offer you one of the best packages you will ever find
> 8.50$ a month or 8$ if you pay per year

I think you should take this private...

> 
> FEATURES
> --
> 
> One click to install
> 
> Portals/CMS
> PHP-Nuke
> Post-Nuke
> phpWebSite
> Xoops
> 
> Discussion Boards
> 
> phpBB2
> Invision Board
> 
> 
> 
> Other scripts
> 
> OS Commerce (e-Commerce)
> 4images Gallery
> PHPauction
> PHProjekt
> phpLinks (Web catalog)
> b2
> 
> 
> Mail
> 
> Manage Email Accounts (Add, Remove, ChangePassword)
> WebMail for all Accounts
> Auto Responders
> Custom Mail Filtering
> Forwaders
> Mailing Lists (mailman)
> Ability to Modify an MX Entry
> Spam Filtering
> 
> 
> Stats
> 
> Webalizer Web Stats
> Webalizer Ftp Stats
> Analog Stats
> View Latest Visitors
> View Bandwidth Usage
> View Error Log
> Download a raw logfile
> 
> 
> 
> Ftp
> 
> Manage Ftp Accounts (Add, Remove, Change Password)
> Anonymous Ftp Control
> Ability to change ftp login message
> Ability to kill ftp sessions
> 
> 
> 
> Site Tools
> 
> Web Protect (htaccess editor)
> Ability to Change Site and Frontpage password
> Custom Error Pages
> Redirects
> Ability to Edit Mime Types
> Ability to Edit Apache Handlers
> Install Frontpage Extensions
> Uninstall Frontpage Extensions
> Search Engine Submit Tool
> File Manager
> 
> 
> 
> Subdomains
> 
> Ability to Add/Remove Subdomains
> Subdomain Redirects
> 
> 
> Advanced Tools
> 
> SSH access $4. extra mo. (Cant help this, have to charge, sorry.)
> Manage GPG Keys
> Cron Jobs
> 
> 
> 
> Pre-Installed Cgi Scripts
> 
> Interchange Cart
> Agora Cart
> php BB Forum Board
> Java Chat
> Html Chat
> phpMyChat
> Cgi Wrapper (for non-suexec installs)
> Random HTML Generator
> Advanced Guestbook
> Counter Generator
> Java Clock Generator
> Java Countdown Generator
> Secure FormMail clone
> cgiemail
> Entropy Search
> Entropy Banner
> 
> Network Tools
> Dns Lookup Traceroute
> 
> 
> 
> Database Managment
> (2 DB's) Manage Mysql Databases (Add, Remove, Change Password, Add Access
> Hosts) phpMyAdmin Access
> 
> Servlets/JSP,PHP,CGI etc
> 
> End of features list, if you dont see something you want/need or if you
> think i forgot something tell me.
> NOTE: Two major rules,no spam and no porn (including adult cartoons)
> 
> lf needed I can give you some sites that are being hosted by me and you can
> ask them how is the hosting.
> 
> Cheers,
> -Ryan
> 
> 
> 
> 
> 
> - Original Message -
> From: "Saint Urho" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, June 01, 2003 4:40 PM
> Subject: Re: [PHP] Re: cheap PHP+SQL WebHosting
> 
> 
> > I have been using phpwebhosting with no problems for the last year.
> > They are also real good about responding to questions via email.  Red
> > Hat Linux, php, phpMyAdmin, PEAR, MySQL, secure shell access(ssh), and
> > ftp access.  Un-metered traffic, un-throttled, and true burstable
> > bandwidth.  Un-metered POP3 mailboxes, unlimited email addresses,
> > unlimited auto-responders, and unlimited mailing lists.  $9.95/month or
> > $9.18/month if you pay by the year.  I do not work for them - just a
> > customer.
> >
> > http://www.phpwebhosting.com/
> >
> > Arcadius A. wrote:
> > > Let me add that I don't want a totally free webhosting...
> > >
> > > Thanks.
> > >
> > > ARcadius.
> >
> >
> >
> > --
> > 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] string question

2003-06-11 Thread Brian V Bonini
On Wed, 2003-06-11 at 10:42, Mukta Telang wrote:
> Hi,
> if a string is:
>   $x="A.B. XYZ";
> and if I post it as a hidden form control and echo $_POST['x'] then I
> get:
>   A.B.
> and not "A.B. XYZ" !
> What should I do?
> Mukta

$x = 'A.B. XYZ';


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



Re: [PHP] Problem in windows

2003-06-14 Thread Brian V Bonini
I love that subject line... All I could think was, "of course"... Sorry,
couldn't resist that.. ;-)


On Sat, 2003-06-14 at 08:02, James Stanley wrote:
> Hello,
> 
> I just installed php/mysql on my windows machine, now when I try to run 
> a script I get this:
> 
> Use of undefined constant s_UID - assumed 's_UID' in
> c:\inetpub\wwwroot\php_test\inc\session.php
> 
> And then some Undefined variable: s_UserInfo.
> 
> Any thought why could this be? Thanks.
> 
> James.


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



Re: [PHP] php editor?

2003-06-15 Thread Brian V Bonini
For Linux: Bluefish...

On Sat, 2003-06-14 at 07:15, Ryan A wrote:
> I have tested quite a few editors since i came to php as notepad started to
> p1ss me off after some time...
> I have never really touched vi so cant say much about that but I think Zend
> is pretty good (ill even dare say better) compared to the others(homesite,
> phpedit,editplus etc)
> you DO get only a 21 day trial...but you can make it a free version if you
> want ;-p
> Its a very good product and if you can afford it i think you should buy it
> as a lot of work has gone into it and the developers deserve the $$.
> 
> Please note: I have NOTHING at all to do with ZEND (the company,site and its
> software) dont bug me with arguements, this is just my opinion...my 2 cents.
> 
> HTH
> 
> Cheers,
> -Ryan
> 
> 
> 
> - Original Message -
> From: "Gerard Samuel" <[EMAIL PROTECTED]>
> To: "electroteque" <[EMAIL PROTECTED]>
> Cc: "Jeff Harris" <[EMAIL PROTECTED]>; "M-Ali Mahmoodi"
> <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Saturday, June 14, 2003 9:54 PM
> Subject: Re: [PHP] php editor?
> 
> 
> > Because some of us, work directly on the server, instead of modifying
> > files, then uploading to the server to test :)
> >
> > electroteque wrote:
> >
> > >boy how painfully dweebish is vi why make it harder for yourself :O
> > >
> >
> >
> > --
> > 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] CSS help

2003-06-18 Thread Brian V Bonini
On Wed, 2003-06-18 at 07:14, Angelo Zanetti wrote:
> Hi guys sorry for the off topic post.
> 
> i am not getting any success with Css @ the moment.
> 
> What I need is basically a class in my CSS file that defines everything about A 
> links.
> 
> I have this class but it aint working (i know its wrong):
> 
> .sideMenu {
> 
> hover{color:white};
> visited  {color: black};
> visited:hover {color:white};
> a:text-decoration : none;
> 
> }
>  
> should this be:
> 
> .sideMenu{
>  
> a-hover color:white;
>  

I'm not exactly sure what your tying to do, your example it too poor to
accurately interpret but

To define styles for the 'a' element with a class identifier of
'sideMenu':

a.sideMenu:link,a.sideMenu:active,a.sideMenu:visited {
color: #00;
text-decoration: none;
}

a.sideMenu:hover { color: #ff; }


http://www.w3.org/TR/REC-CSS2/selector.html#link-pseudo-classes


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



Re: [PHP] .htaccess files

2003-06-18 Thread Brian V Bonini
On Wed, 2003-06-18 at 18:34, Steve Marquez wrote:
> Hello everyone,
> 
> Could someone point me in the direction of some info on .htaccess files?
> Could someone send me one, tell me where to put it in my
> server? I hope this is not a stupid question. I am running Apache on a Mac
> with Jaguar OSX.
> 


In the directory you want to effect with its directives.


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



Re: [PHP] Standalone PHP Client?

2003-06-20 Thread Brian V Bonini
On Fri, 2003-06-20 at 13:57, Galen P. Zink wrote:
> I work for a small networking company. We're working on a piece of 
> software that will be run server-side with PHP and MySQL. It allows the 
> user to develop an online store and handles all the complex shopping 
> cart stuff with ease. It is a port of an originally client-side 
> application. We would like to be able to hand out demo discs that do 
> not require the internet to try it out - having a standalone try-out 
> version is a big source of customers.
> 
> Is there any kind of standalone PHP/MySQL engine that could be 
> reasonably installed from a CD and run on most Windows machines? If 
> there was some method to compile the PHP into a binary or otherwise 
> protect it, it would be really good because our company would not be 
> too excited about handing out the near-complete source to our product 
> on all the demo discs. It would be nice if there was support for 
> non-Windows OSes, but Windows is by far the majority in market share 
> and the other OSes could easily just pop into an HTML document that 
> directs them to our online version.
> 


How about demoing the client app and saying there is also an on-line
version...??


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



[PHP] Content-Type:

2003-06-27 Thread Brian V Bonini
This could be an Apache issues, not really sure.

I'm trying to output a php doc as text/css using

But no matter what I do, changing it in the document, adding/altering
apache mime types, all I get is text/html.

The reason is I'm trying to use @import url('xx.css.php') and Mozilla
seems to be very unhappy with this, it will not recognize that as a css
file, IE and Opera are fine with it. The developers say its because Moz
does not make assumptions about mime types, whatever, and I need to set
the mime type explicitly for php files from within the script however
 seems to have no effect.


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



[PHP] mime type

2003-06-27 Thread Brian V Bonini
I want to get php to output text/css for one .php file. I tried using
header() and ini_set () but seems no matter what I do the Content-type
remains text/html


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



Re: [PHP] Re: mime type

2003-06-27 Thread Brian V Bonini
On Fri, 2003-06-27 at 13:26, Pete Morganic wrote:
> chech here
> http://www.phpfreaks.com/mimetypes.php
> 
> and in php add the folowing header
> 
>   header ("Content-type: model/vrml");

As I had already stated I tried using header() and ini_set(), e.g.,
header("Content-type: text/css") or
ini_set('default_mimetype','text/css')

But, it's not working, I'm still getting text/html as the default for
*.php files as it should be according to php.ini but I need to override
that for this one file and output text/css. Am I wrong in assuming
either of these functions should override the global configs?

> 
> 
> Brian V Bonini wrote:
> > I want to get php to output text/css for one .php file. I tried using
> > header() and ini_set () but seems no matter what I do the Content-type
> > remains text/html
> > 


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



RE: [PHP] Re: mime type

2003-06-27 Thread Brian V Bonini
On Fri, 2003-06-27 at 13:47, Carl Furst wrote:
> I doubt this is the problem, but perhaps your webserver is messing with your
> mime-types by printing a default header for some reason.
> 

If that were the case it would return text/plain but this is more like
not being able to override PHP's default mime-type of text/html in
php.ini I even tried setting it explicitly in Apache's mime config. but
still PHP insists on outputting text/html

Good thought though.. :)


> 
> -Original Message-----
> From: Brian V Bonini [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 27, 2003 1:36 PM
> To: Pete Morganic
> Cc: PHP Lists
> Subject: Re: [PHP] Re: mime type
> 
> On Fri, 2003-06-27 at 13:26, Pete Morganic wrote:
> > chech here
> > http://www.phpfreaks.com/mimetypes.php
> >
> > and in php add the folowing header
> >
> >   header ("Content-type: model/vrml");
> 
> As I had already stated I tried using header() and ini_set(), e.g.,
> header("Content-type: text/css") or
> ini_set('default_mimetype','text/css')
> 
> But, it's not working, I'm still getting text/html as the default for
> *.php files as it should be according to php.ini but I need to override
> that for this one file and output text/css. Am I wrong in assuming
> either of these functions should override the global configs?
> 
> >
> >
> > Brian V Bonini wrote:
> > > I want to get php to output text/css for one .php file. I tried using
> > > header() and ini_set () but seems no matter what I do the Content-type
> > > remains text/html
> > >
> 
> 
> --
> 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] @import

2003-06-27 Thread Brian V Bonini
Can anyone make this work with Mozilla?


@import url("site.css.php");


No matter what I try , header("Content-type: text/css")
or ini_set to will not output anything other then text/html


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



Re: [PHP] @import

2003-06-27 Thread Brian V Bonini
On Fri, 2003-06-27 at 20:21, Leif K-Brooks wrote:
> Brian V Bonini wrote:
> 
> >Can anyone make this work with Mozilla?
> >
> >
> >@import url("site.css.php");
> >
> >
> >No matter what I try , header("Content-type: text/css")
> >or ini_set to will not output anything other then text/html
> >
> >
> >  
> >
> This has nothing to do with PHP.

Actually, it does. The only reason it does not work is that I can not
get php to output anything other then text/html for .php files so it
fails because of this Mozilla needs to see a text/css mimetype
for this instance of site.css.php in order to render it correctly.


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



Re: [PHP] @import

2003-06-27 Thread Brian V Bonini
On Fri, 2003-06-27 at 21:02, Brian V Bonini wrote:
> On Fri, 2003-06-27 at 20:21, Leif K-Brooks wrote:
> > Brian V Bonini wrote:
> > 
> > >Can anyone make this work with Mozilla?
> > >
> > >
> > >@import url("site.css.php");
> > >
> > >
> > >No matter what I try , header("Content-type: text/css")
> > >or ini_set to will not output anything other then text/html
> > >
> > >
> > >  
> > >
> > This has nothing to do with PHP.
> 
> Actually, it does. The only reason it does not work is that I can not
> get php to output anything other then text/html for .php files so it
> fails because of this Mozilla needs to see a text/css mimetype
> for this instance of site.css.php in order to render it correctly.


The problem turned out to be that having default_mimetype text/css set
in php.ini seemed to be overriding any attempt I made to set the mime
type via the header function. I thought you are supposed to be able to
over ride the global configs via ini_set or that defining the mime type
via header() would over ride it on a per file basis but apparently not. 

In either case I don't think you can get any more PHP related then that.


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



RE: [PHP] @import

2003-06-28 Thread Brian V Bonini
On Sat, 2003-06-28 at 00:59, electroteque wrote:
> why php ? why not just use a .css file like everyone else ?

Because I wanted to be able to generate dynamically generated styles.
And, while I realize I can just "include" the document in theory @import
should work exactly as expected.

The problem turned out to be that having default_mimetype text/html set
in php.ini seemed to be overriding any attempt I made to set the mime
type to text/css via the header function. I thought you are supposed to
be able to over ride the global configs via ini_set or that defining the
mime type via header() would over ride it on a per file basis but
apparently not or at least not for me... Still trying to figure out why,
but, it is working now..

> 
> -Original Message-----
> From: Brian V Bonini [mailto:[EMAIL PROTECTED]
> Sent: Saturday, June 28, 2003 11:02 AM
> To: Leif K-Brooks
> Cc: PHP Lists
> Subject: Re: [PHP] @import
> 
> 
> On Fri, 2003-06-27 at 20:21, Leif K-Brooks wrote:
> > Brian V Bonini wrote:
> > 
> > >Can anyone make this work with Mozilla?
> > >
> > >
> > >@import url("site.css.php");
> > >
> > >
> > >No matter what I try , header("Content-type: text/css")
> > >or ini_set to will not output anything other then text/html
> > >
> > >
> > >  
> > >
> > This has nothing to do with PHP.
> 
> Actually, it does. The only reason it does not work is that I can not
> get php to output anything other then text/html for .php files so it
> fails because of this Mozilla needs to see a text/css mimetype
> for this instance of site.css.php in order to render it correctly.


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



Re: [PHP] Else If/Elseif

2003-06-30 Thread Brian V Bonini
On Mon, 2003-06-30 at 09:30, Stevie Peele wrote:
> What is the difference between "else if" and "elseif"?
> 
> 

chr(32).. bwahahahah!!! Sorry. couldn't resist


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



RE: [PHP] PHPMyAdmin interface

2002-07-24 Thread Brian V Bonini

Why don't you just install a copy on the server? If the only access you have
is through the mysql monitor program then you must have shell access so
installing your own copy of phpMyAdmin should not be an issue.

But, if your going to access it remotely from a win machine I would use
MySQL-Front instead.

-B
--
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 24, 2002 12:47 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP] PHPMyAdmin interface
>
>
> I have just recently just signed up for virtual hosting with a MySQL
> database.  They do not have a PHPMyAdmin interface too access the
> database.  All they have given me is my username and password and the
> server too login too.  They suggested that I install PHPMyAdmin on my
> workstation and access my database that way.
> Is there major security risks too my database doing this?  Is this normal,
> where service providers request that I install PHPMyAdmin on my
> workstation or should I be looking for a new internet service provider who
> supplies the interface on the server?
>
>
>
>
> --
> 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] Image upload into database

2002-07-24 Thread Brian V Bonini

Just curious why you don't upload the image to a dir and just store the link
in the db?

> -Original Message-
> From: Jesse Lawrence [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 24, 2002 7:44 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP] Image upload into database
>
>
> I've setup an image upload feature on a site, which
> uploads images into a mysql database.
>
> The uploads are working absolutely as expected on my
> local computer (the server), but when someone else
> tried to upload, only 1/3 of the image was uploaded.
> Could it be a matter of size?  I was originally using
> just a Blob, and have since switched to a Long Blob.
> Any thoughts or comments on this would be greatly
> appreciated.
>
> Thanks a bunch,
>
> Jesse
>
> __
> Post your ad for free now! http://personals.yahoo.ca
>
> --
> 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] Brain Fart- table formatting help

2002-07-29 Thread Brian V Bonini

I'm having a total brain fart and can not seem to get the right logic for
this...

I'm trying to format the output of a db query with alternating row colors,
the thing is the usual
if ($i%2) {} will not work here because the alternating colors do not
necessarily fall on odd or even rows.

The one constant is that if ($row->show_title) is true the table row will
have a background color then I need to make the rows after that alternate
until if ($row->show_title) is true again.

Roughly I have the whole thing laid out like this right now:

echo "\n";
while($row = mysql_fetch_object($result)) {
if($row->show_company && $row->show_title && $row->show_month) {
display month;
} else if ($row->show_title) {
display title;
display first row with background color;
} else {
display rows with no background color; //right here needs to alternate
 background color
}
}
echo "";

I think I've been looking at his too long and I just have jello brain right
now but I just can't seem to straighten this out in my head...

Thanks for the help...

-B


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




RE: [PHP] Brain Fart- table formatting help

2002-07-29 Thread Brian V Bonini

Isn't that the same thing essentially? See, from the time ($row->show_title)
is true until it is true again is not a fixed number so the only constant is
that if ($row->show_title) is true then the  background color will be
on. Then I need to alternate the background color between on and off until
($row->show_title) is true again. Then start the process over. So I'm sure
my ignorance has prevented me from fully understanding what you tried to
show me below but isn't that the same as saying:
if ($i&1) {
 do this;
} else {
 do this;
}
which is the same as if ($i%2) { etc. }

???

-B

> -Original Message-
> From: Jay Blanchard [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 29, 2002 9:19 AM
> To: 'Brian V Bonini'; [EMAIL PROTECTED]
> Subject: RE: [PHP] Brain Fart- table formatting help
>
>
> [snip]
> I'm trying to format the output of a db query with alternating row colors,
> the thing is the usual
> if ($i%2) {} will not work here because the alternating colors do not
> necessarily fall on odd or even rows.
> [/snip]
>
>  $i = 0;
> while($exrows = mysql_fetch_object($dbcdrex)){
>   $bgcolor = ($i++ & 1) ? '#FF' : '#CC';
> //other table stuff
> ?>
>
> HTH!
>
> Jay
>
> Minds are like parachutes…they only function when OPEN
>
> *
> * Want to meet other PHP developers *
> * in your area? Check out:  *
> * http://php.meetup.com/*
> * No developer is an island ... *
> *
>
> ***
> * *
> * Texas PHP Developers Meeting*
> * Spring 2003 *
> * T Bar M Resort & Conference Center  *
> * New Braunfels, Texas*
> * Interested? Contact;*
> * [EMAIL PROTECTED] *
> * *
> ***
>
>


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




RE: [PHP] Brain Fart- table formatting help

2002-07-29 Thread Brian V Bonini

> Ah, well... that was not clearly explained in your first post. You wanted
> alternating rows colors, and that is what I gave you. Let's see if I
> understand the question;
>
> For each show_title there are multiple rows of data, but they do not match
> row counts from show to show?
> You want the alternating colors to begin with each show_title, in other
> words the row with the show_title in it shall always be gray, while others
> rows alternate between white and gray?
>

Sorry, I thougth I had explained it better.. But, yes, you have explained it
well now...


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




[PHP] Sorting Output

2002-07-30 Thread Brian V Bonini

I have a db with the following fields:

id | month | company | title | name | role | show_company | show_title |
show_month

sql query is: "select * FROM db ORDER BY month DESC";

Output gets formatted like:

month
 - company
 - title
name   role
name   role
 - title
name   role
 - company
 - title
name   role
name   role
name   role


The occurrence of the number of fields within each heading is not static.

The oldest data sits at the "beginning" of the db so the order by month desc
sorts the output from newest to oldest. Fine so far.

Now, as new data gets added to the db sometimes some of it refers to past
months. So although the order by month clause will move the new data to the
correct month it will not move it into the correct heading (company) and
sub_heading (title). I've tried using group by and using multiple fields in
the order by but can not get the results I'm looking for, any suggestions?

-Brian


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




RE: [PHP] Re: PHP4 and MS Excel?

2002-07-30 Thread Brian V Bonini

file | save as then chose the format you want in the drop down box

> -Original Message-
> From: Jason Caldwell [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 30, 2002 2:46 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP] Re: PHP4 and MS Excel?
>
>
> So -- it looks like I can connect to Excel via COM -- buuutt...
> anyone have
> any examples or can anyone point me to any -- that show how to save-out an
> excel file as a TEXT (.csv) TAB Delimited file?
>
> I guess if there is a way to see each ROW in the Excel
> Spreadsheet -- then I
> can grab that data and easily save it out as a \t delimited file
> (I know how
> to do that) -- ***so, then***  I guess my real question is; how
> can I *see*
> the data using COM ???  I'm not too familiar with COM.
>
> Say I have an excel spreadsheet called "Test.xls" and it has
> three columns:
>
> Name:Salary:Expense:
> Jon Doe$63,000   $2,345
> Jane Doe  $65,234$3,256
>
> and so on...
>
> Thanks
> Jason
>
>
> "Jome" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > > I would like to give my users the ability to send (to my website) a
> > > Microsoft Excel file, and then have my server (PHP code) extract that
> data
> > > and turn it into a TAB Delimited Text file -- is this
> possible with PHP?
> >
> >
> http://groups.google.com/groups?hl=sv&lr=&ie=ISO-8859-1&q=data+fro
m+excel+ph
> p
>
> Google is your friend.
>
>   -Jome
>
>



--
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] sort results into two columns

2002-08-01 Thread Brian V Bonini




link1linka


linklinke




I suppose an example of the sql query you attempting to use and perhaps an
idea of how your db is structured would help a little.. ;-)

> -Original Message-
> From: kompresor [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 01, 2002 10:23 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP] sort results into two columns
>
>
> hi,
>
> how can i sort data from mysql into two columns. Thanks.
>
> eg:
>
> link1linka
> link linke
>
>
>
> --
> 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] Function search utility

2002-08-02 Thread Brian V Bonini

There used to be a utility that let you search php functions from the
address bar in your browser by simply appening PHP to the function name eg,
php mail I thikn it might of been an IE only thing...

I can't remember were I originally got it form and can not find it again,
does anyone know?

-Brian


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




RE: [PHP] Re: Function search utility

2002-08-02 Thread Brian V Bonini

Nope, it was this http://www.php.net/tips.php that I was thiking of
But thanks, I didn't know you could do that ;-)

-Brian

> -Original Message-
> From: Lars Olsson [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 02, 2002 2:41 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP] Re: Function search utility
> 
> 
> It still works...try http://www.php.net/mysql or 
> http://www.php.net/fopen for example...
> 
> /lasso ([EMAIL PROTECTED])
> 
> 
> 
> Brian V Bonini wrote:
> > There used to be a utility that let you search php functions from the
> > address bar in your browser by simply appening PHP to the 
> function name eg,
> > php mail I thikn it might of been an IE only thing...
> > 
> > I can't remember were I originally got it form and can not find 
> it again,
> > does anyone know?
> > 
> > -Brian
> > 
> 
> 
> -- 
> 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] Next and Previous links

2002-08-09 Thread Brian V Bonini

Could you send me the URL's for the MySQL examples? Thanks!!

> -Original Message-
> From: webmaster [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 09, 2002 10:36 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP] Next and Previous links
> 
> 
> Hello,
> 
> I've been trying write a .php page that displays 10 results per page
> with links to the next 10 avail.  I've found a couple examples on how to
> do this with MySQL, and I tried to convert it to work with Postgres with
> no luck.  Has anyone ever done this using PHP4.0.6 and Postgres 7.1?
> 
> Also, I keep getting an error that pg_fetch_row() and pg_fetch_array()
> requires at least 2 parameters where all the examples I find only use
> 1.  Is this a DB configuration problem?
> 
> Thanks in advance,
> -Elkan
> 
> 
> -- 
> 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: including a php file in an html doc

2002-08-12 Thread Brian V Bonini

Because your trying to put PHP directives in an html file. Your web server
does not know to parse html files as php files unless you tell it to do so.



> -Original Message-
> From: Alexander Ross [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 12, 2002 9:50 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP] Re: including a php file in an html doc
>
>
> I still seem to be missing something.  I guess the easiest thing for me to
> do is just show you my code.  All I want is to be able to reference the
> $hotspots array from any .html page oon my site.  I thought I
> could include
> hotspot.php and then reference the array using  syntax.
> What should I
> do?  The one requirement is that I cannot make all my pages PHP. They must
> be html.
>
> HTML PAGE (test.html):
> 
> 
> Untitled Document
> 
> 
> 
>
> 
> 
> 
> 
>
> PHP PAGE (hotspot.php):
>  include_once("../board/db_fns.php");
>
> echo "hotspot = ".$hotspots;
>
> if (!isset $hotspots){
>   $connect = connect_to_db();
>   $query = "SELECT * FROM hotspots";
>   $result = mysql_query($query);
>   $count = mysql_numrows($result);
>
>   $hotspots = array();
>   for($i=0;$i<$count;$i++)
>   {
> $hotspot = mysql_fetch_assoc($result);
>  $hotspots[$hotspot['hotspot']]=$hotspot['val'];
>   }
>   print_r($hotspots);
> }
> ?>
>
>
> "Bogdan Stancescu" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > Hi Alexander!
> >
> > You're missing the distinction between a server-side script (PHP) and a
> > client-side script (JavaScript, VB etc). When you use the syntax you
> > used, the browser attempts to download the src and execute it - and it
> > can't do that, because in the best case the php code runs on the server
> > and returns "test" (your echo()) and then it "tries" to run that as php
> > code, which again it doesn't know how. It does work for JavaScript
> > however, because it downloads the JavaScript file (which is plain text)
> > and then executes the code (because it knows how to execute JavaScript).
> >
> > What you should do would be write
> > 
> > instead of " >
> > Bogdan
> >
> > Alexander Ross wrote:
> > > I have a .php file whose purpose, ultimately, is to set one variable;
> > > $hotspot.  Now I want to include that var in a bunch of places in my
> html
> > > page (it must remain html).  So this was my thought.  In the 
> include
> > > the following:
> > >
> > >