OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
From: php-general-digest-helplists.php.net
Date: Sun Feb 25 2001 - 10:56:03 CST

  • Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

    php-general Digest 25 Feb 2001 16:56:03 -0000 Issue 533

    Topics (messages 41542 through 41592):

    Re: Detecting JavaScript
            41542 by: Mitchell Hagerty
            41544 by: Mitchell Hagerty
            41588 by: Trevor DeVore

    Re: Temporarily turning off magic quotes?
            41543 by: Zeev Suraski
            41560 by: mwaples.waples.net
            41574 by: PHPBeginner.com

    Unwanted Characters
            41545 by: Clayton Dukes
            41546 by: Joe Stump
            41555 by: CC Zona
            41558 by: mwaples.waples.net
            41575 by: PHPBeginner.com
            41589 by: Clayton Dukes

    php and apache 2.0
            41547 by: jeremy.netwyred.com

    Escaping double quotes?
            41548 by: Ben Cheng
            41549 by: Joe Stump

    MYSQL HELP!!!
            41550 by: Felipe Lopes

    extract() help
            41551 by: Jaxon
            41553 by: CC Zona

    Re: session_register in function
            41552 by: Jeff Lacy
            41569 by: PHPBeginner.com

    really weird html - was "extract() help"
            41554 by: Jaxon
            41556 by: Jaxon

    Re: Cookie References?
            41557 by: mwaples.waples.net
            41571 by: PHPBeginner.com

    Re: isset()
            41559 by: Mark Maggelet
            41561 by: Joe Stump
            41576 by: PHPBeginner.com
            41577 by: Christian Reiniger

    Join causing Error?
            41562 by: Keith Spiller
            41566 by: CC Zona
            41568 by: Chris Adams

    Implode?
            41563 by: Kenneth R Zink II

    How do I submit a POST form?
            41564 by: Alexis Michel Golzman

    php.ini
            41565 by: Brandon Feldhahn

    Re: PHP4 install question
            41567 by: Michael Hall

    Re: DIsplaying page before script finnished
            41570 by: PHPBeginner.com

    Re: php_self
            41572 by: PHPBeginner.com

    Re: comparing numbers
            41573 by: PHPBeginner.com

    incrementing a date!
            41578 by: kaab kaoutar
            41583 by: Web Admin

    session_start
            41579 by: kaab kaoutar

    Plugin Detection with PHP?
            41580 by: Andy Clarke

    No same username
            41581 by: Brandon Feldhahn
            41584 by: Web Admin
            41585 by: Kath
            41587 by: Web Admin

    Re: [PHP-DEV] No same username
            41582 by: André Langhorst

    Re: crontab help
            41586 by: Joe Stump

    so what program?
            41590 by: Knasen

    Re: [PHP-DB] Join causing Error?
            41591 by: Bob Hall

    Re: [PHP-DB] Re: [PHP] No same username
            41592 by: Scott Bernard

    Administrivia:

    To subscribe to the digest, e-mail:
            php-general-digest-subscribelists.php.net

    To unsubscribe from the digest, e-mail:
            php-general-digest-unsubscribelists.php.net

    To post to the list, e-mail:
            php-generallists.php.net

    ----------------------------------------------------------------------

    attached mail follows:


    I think phpclient sniffer can do that...

    found here: http://www.php.net/manual/en/ref.imap.php

    mitch

    ----- Original Message -----
    From: Jochen K?chelin <jkwa-p.de>
    Date: Saturday, February 24, 2001 10:37 pm
    Subject: [PHP] Detecting JavaScript

    > Who can give me a PHP-Script to
    > detect if JavaScript is enabled?
    >
    > It should work with both, IE and NN!
    >
    > thanks
    >
    > --
    > Ihr WEBberater
    > Stuttgarter Str.3, D-73033 Göppingen
    > Tel. +49(0)7161-929594 - Fax. +49(0)7161-929598
    > http://www.wa-p.de ** mailto:jkwa-p.de
    >
    >
    > --
    > PHP General Mailing List (http://www.php.net/)
    > To unsubscribe, e-mail: php-general-unsubscribelists.php.net
    > For additional commands, e-mail: php-general-helplists.php.net
    > To contact the list administrators, e-mail: php-list-
    > adminlists.php.net
    >

    attached mail follows:


    woooops didn't check to see what was in my paste buffer

    sorry: http://www.asphyxia.com/

    mitch

    ----- Original Message -----
    From: Ed Lazor <osmosisatfantasy.com>
    Date: Saturday, February 24, 2001 11:12 pm
    Subject: Re: [PHP] Detecting JavaScript

    > I couldn't find anything about phpclient sniffer on that page. Is
    > that the
    > right page?
    >
    > -Ed
    >
    > At 10:54 PM 2/24/2001 -0600, you wrote:
    > >I think phpclient sniffer can do that...
    > >
    > >found here: http://www.php.net/manual/en/ref.imap.php
    > >
    > >mitch
    > >
    > >----- Original Message -----
    > >From: Jochen K?chelin <jkwa-p.de>
    > >Date: Saturday, February 24, 2001 10:37 pm
    > >Subject: [PHP] Detecting JavaScript
    > >
    > > > Who can give me a PHP-Script to
    > > > detect if JavaScript is enabled?
    > > >
    > > > It should work with both, IE and NN!
    > > >
    > > > thanks
    > > >
    > > > --
    > > > Ihr WEBberater
    > > > Stuttgarter Str.3, D-73033 Göppingen
    > > > Tel. +49(0)7161-929594 - Fax. +49(0)7161-929598
    > > > http://www.wa-p.de ** mailto:jkwa-p.de
    > > >
    > > >
    > > > --
    > > > PHP General Mailing List (http://www.php.net/)
    > > > To unsubscribe, e-mail: php-general-unsubscribelists.php.net
    > > > For additional commands, e-mail: php-general-helplists.php.net
    > > > To contact the list administrators, e-mail: php-list-
    > > > adminlists.php.net
    > > >
    > >
    > >
    > >--
    > >PHP General Mailing List (http://www.php.net/)
    > >To unsubscribe, e-mail: php-general-unsubscribelists.php.net
    > >For additional commands, e-mail: php-general-helplists.php.net
    > >To contact the list administrators, e-mail: php-list-
    > adminlists.php.net
    >

    attached mail follows:


    PHP won't be able to tell you if JavaScript is enabled or not. PHP can
    only determine what version of JavaScript is supported based on the browser
    information provided in HTTP_USER_AGENT.

    Trevor DeVore
    Blue Mango Multimedia

    > > >
    > > > > Who can give me a PHP-Script to
    > > > > detect if JavaScript is enabled?
    > > > >
    > > > > It should work with both, IE and NN!
    > > > >
    > > > > thanks
    > > > >
    > > > > --
    > > > > Ihr WEBberater
    > > > > Stuttgarter Str.3, D-73033 Göppingen
    > > > > Tel. +49(0)7161-929594 - Fax. +49(0)7161-929598
    > > > > http://www.wa-p.de ** mailto:jkwa-p.de

    attached mail follows:


    You can do it using .htaccess (or equivalent) directive:

    php_flag magic_quotes_gpc off

    On Sat, 24 Feb 2001, Ben Cheng wrote:

    > If I have magic quotes turned on for post/get/etc. in my php.ini, is
    > there any way to temporarily turn it off for one page? For example,
    > I have a preview page inbetween my data entry page and the page that
    > actually saves to db. I don't want magic quotes turned on when going
    > from the data entry to the preview page since all quotes keep getting
    > backslashed. Is there a way to do this?
    >
    > -Ben
    >
    >

    -- 
    Zeev Suraski <zeevzend.com>
    http://www.zend.com/
    

    attached mail follows:


    Ben Cheng wrote: > > If I have magic quotes turned on for post/get/etc. in my php.ini, is > there any way to temporarily turn it off for one page? For example, > I have a preview page inbetween my data entry page and the page that > actually saves to db. I don't want magic quotes turned on when going > from the data entry to the preview page since all quotes keep getting > backslashed. Is there a way to do this? > > -Ben > For php4 look for ini_alter under www.php.net/manual/en/ref.info.php

    attached mail follows:


    you can use:

    if($REQUEST_METHOD=='GET' or $REQUEST_METHOD=='POST') ini_set ('magic_quotes_gpc', 'off');

    Sincerely,

    Maxim Maletsky Founder, Chief Developer

    PHPBeginner.com (Where PHP Begins) maximphpbeginner.com www.phpbeginner.com

    -----Original Message----- From: Ben Cheng [mailto:ronindarwinmail.net] Sent: Sunday, February 25, 2001 1:52 PM To: php-generallists.php.net Subject: [PHP] Temporarily turning off magic quotes?

    If I have magic quotes turned on for post/get/etc. in my php.ini, is there any way to temporarily turn it off for one page? For example, I have a preview page inbetween my data entry page and the page that actually saves to db. I don't want magic quotes turned on when going from the data entry to the preview page since all quotes keep getting backslashed. Is there a way to do this?

    -Ben

    -- 
    PHP General Mailing List (http://www.php.net/)
    To unsubscribe, e-mail: php-general-unsubscribelists.php.net
    For additional commands, e-mail: php-general-helplists.php.net
    To contact the list administrators, e-mail: php-list-adminlists.php.net
    

    attached mail follows:


    How do I remove unwanted/unprintable characters from a variable?

    $sometext = "ThÀe cØar röøan over mÖy dog" needs to be filtered and reprinted as: "The car ran over my dog"

    Thanks :-) Clayton Dukes

    attached mail follows:


    Look at the chr() function - figure out what the character is (number wise) and then do an ereg_replace(chr(),'',$string) (from the hip - you can do a replace with chr() on one of the replaces, I've done it before)

    --Joe

    On Sun, Feb 25, 2001 at 12:34:21AM -0500, Clayton Dukes wrote: > > How do I remove unwanted/unprintable characters from a variable? > > $sometext = "ThÀe cØar röøan over mÖy dog" > needs to be filtered and reprinted as: > "The car ran over my dog" > > > > > Thanks :-) > Clayton Dukes >

    -- 
    

    ------------------------------------------------------------------------------- Joe Stump, PHP Hacker, joestump98yahoo.com -o) http://www.miester.org http://www.care2.com /\\ "It's not enough to succeed. Everyone else must fail" -- Larry Ellison _\_V -------------------------------------------------------------------------------

    attached mail follows:


    In article <20010224220539.C23830zebulon.miester.org>, jstumpzebulon.miester.org (Joe Stump) wrote:

    > Look at the chr() function - figure out what the character is (number wise) > and > then do an ereg_replace(chr(),'',$string) (from the hip - you can do a > replace > with chr() on one of the replaces, I've done it before) > > --Joe > > On Sun, Feb 25, 2001 at 12:34:21AM -0500, Clayton Dukes wrote: > > > > How do I remove unwanted/unprintable characters from a variable? > > > > $sometext = "ThÀe cØar röøan over mÖy dog" > > needs to be filtered and reprinted as: > > "The car ran over my dog"

    And you might also want to look at strtr() <http://php.net/manual/en/function.strtr.php>. You could, I suppose, use it to substitute some character that you know would never legitimately appear in $sometext, then do a straight str_replace() on the string for all occurences of that character.

    -- 
    CC
    

    attached mail follows:


    Clayton Dukes wrote: > > How do I remove unwanted/unprintable characters from a variable? > > $sometext = "ThÀe cØar röøan over mÖy dog" > needs to be filtered and reprinted as: > "The car ran over my dog" > > Thanks :-) > Clayton Dukes

    <?php $sometext = "ThÀe cØar röøan over mÖy dog"; $thread = ereg_replace("[^[:alnum:][:space:]]", "", $sometext); echo $thread ?>

    will print what you asked - of course you may not want numbers but you get the idea. I do this check on all my user inputs to php scripts- I choose what is allowed not what to deny which makes it easier.

    attached mail follows:


    use eregi_replace("[asutk]+", '', $string)

    in this way there will be no such letters as a,s,u,t,k in $string

    Sincerely,

    Maxim Maletsky Founder, Chief Developer

    PHPBeginner.com (Where PHP Begins) maximphpbeginner.com www.phpbeginner.com

    -----Original Message----- From: Clayton Dukes [mailto:cdukescdukes.com] Sent: Sunday, February 25, 2001 2:34 PM To: php-generallists.php.net Subject: [PHP] Unwanted Characters

    How do I remove unwanted/unprintable characters from a variable?

    $sometext = "ThÀe cØar röøan over mÖy dog" needs to be filtered and reprinted as: "The car ran over my dog"

    Thanks :-) Clayton Dukes

    attached mail follows:


    This doesn't seem to work, have I done something wrong?

    $sometext = "ThÀe cØar röøan over mÖy dog\n"; $thread = ereg_replace("[^[:alnum:][:space:]]", "", $sometext); echo $thread;

    still prints: ThÀe cØar röøan over mÖy dog

    Thanks, Clayton

    ----- Original Message ----- From: <mwapleswaples.net> To: "Clayton Dukes" <cdukescdukes.com> Sent: Sunday, February 25, 2001 2:28 AM Subject: Re: [PHP] Unwanted Characters

    > Clayton Dukes wrote: > > > > How do I remove unwanted/unprintable characters from a variable? > > > > $sometext = "ThÀe cØar röøan over mÖy dog" > > needs to be filtered and reprinted as: > > "The car ran over my dog" > > > > Thanks :-) > > Clayton Dukes > > <?php > $sometext = "ThÀe cØar röøan over mÖy dog"; > $thread = ereg_replace("[^[:alnum:][:space:]]", "", $sometext); > echo $thread > ?> > > will print what you asked - of course you may not want numbers but you > get the idea. > I do this check on all my user inputs to php scripts- I choose what is > allowed not what to deny which makes it easier. > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net

    attached mail follows:


    will php 4.0.4 build as a module with apache 2.0?

    - jeremy

    attached mail follows:


    How do you escape double quotes? I have the following which is supposed to make any " in a string into \" but it doesn't seem to work. What's wrong with it?

    $tmp_string = str_replace ("\"", "\\\"", $tmp_string);

    -Ben

    attached mail follows:


    addslashes() usually works for me...

    --Joe

    On Sun, Feb 25, 2001 at 01:46:30AM -0500, Ben Cheng wrote: > How do you escape double quotes? I have the following which is > supposed to make any " in a string into \" but it doesn't seem to > work. What's wrong with it? > > $tmp_string = str_replace ("\"", "\\\"", $tmp_string); > > -Ben > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net

    -- 
    

    ------------------------------------------------------------------------------- Joe Stump, PHP Hacker, joestump98yahoo.com -o) http://www.miester.org http://www.care2.com /\\ "It's not enough to succeed. Everyone else must fail" -- Larry Ellison _\_V -------------------------------------------------------------------------------

    attached mail follows:


    Hi! Here I am again...I have a problem to insert user name, password and host into mysql...I'd like to know what commands I need to do that (since the command to start mysql on my computer) so that way I won't be able to do anything wrong! Thank you Felipe Lopes MailBR - O e-mail do Brasil -- http://www.mailbr.com.br Faça já o seu. É gratuito!!!

    attached mail follows:


    Hi PHPers,

    the following function is supposed to build an html table, creating a content row for every row in a database table. It is creating a table with the correct number of rows, but NO content is being echoed...

    I think I must be using the extract() function inside the for loop wrong... any pointers?

    tia! jaxon

    <?php

    function news_box($max) {

    include_once("inc/config.inc"); include_once("inc/db_connect_params.inc");

    $link_id = mysql_connect($host, $usr, $pass); mysql_select_db($database, $link_id); //select database catalog

    echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"2\" width=\"165\">";

    if (!isset($max)) $max=5; //upper limit of news boxes to build

    for ($i = 1; $i <= $max; $i++)

    { $sql="select i.nID, i.date, i.headline, i.subtitle, i.blurb from news_items i, news_box b where i.nID = b.nID and b.dID = $i"; $result = mysql_query($sql, $link_id); $row = mysql_fetch_row($result); extract($row); //the variables below match field names in this row

    echo " <tr><td><h1>$headline</h1></td></tr> <tr><td><h4>$subtitle</h4></td></tr> <tr><td align=\"right\"><h6>$date</h6></td></tr> <tr><td>$blurb</td></tr> <tr><td><a href=\"news.php?#$nID\"><h5>...more</h5></a></td></tr> ";

    echo "</table>"; } } ?>

    attached mail follows:


    In article <B6BE1922.294E%jaxonsalamander.net>, jaxonsalamander.net (Jaxon) wrote:

    > the following function is supposed to build an html table, creating a > content row for every row in a database table. It is creating a table with > the correct number of rows, but NO content is being echoed... <snip> > $sql="select i.nID, i.date, i.headline, i.subtitle, i.blurb from > news_items i, news_box b where i.nID = b.nID and b.dID = $i"; > > $result = mysql_query($sql, $link_id); > $row = mysql_fetch_row($result); > > extract($row); //the variables below match field names in this row > > echo " > <tr><td><h1>$headline</h1></td></tr> > <tr><td><h4>$subtitle</h4></td></tr> > <tr><td align=\"right\"><h6>$date</h6></td></tr> > <tr><td>$blurb</td></tr> > <tr><td><a href=\"news.php?#$nID\"><h5>...more</h5></a></td></tr>

    The elements in $row will have indexes like $row['i.headline'], rather than $row['headline'], just as the columns would have those names if you ran the query at the command line.

    (BTW, I find that doing a var_dump() or print_r() on variables--such as $row, in this case--to be very helpful when data isn't coming out in the way I expected it to...)

    -- 
    CC
    

    attached mail follows:


    I had this same exact problem just today. It all stems from the variable namespace, I think....

    A similar code 'snippet' is shown below. I just made it up, but I think it illustrates my point.

    <?php session_start (); function crud ($user, $password) { session_register ('user'); session_register ('password'); $GLOBALS['user'] = $user; global $password; /* NOTE: $GLOBALS['varname'] = $value is the same as global $varname. Either will work....*/ } echo "User is $user and password is $password"; ?>

    Good luck with whatever you are doing,

    Jeff Lacy

    ""Jon Rosenberg"" <phpcolumbusinteractive.com> wrote in message news:000901c09e7d$16835420$0100a8c0slinkyboi5... > The variable I register before the function becomes available in the session > to other pages...the variable I register inside the function are not > accessible in the session to ohter pages. Is this normal? How can I work > around this? Thanks! PHP4.0.4pl1 on Linux. > > sample code: > > <? > session_Start(); > > $foo = "bar"; > session_register("foo"); > > function bob($user){ > $username = $user . "one"; > $username2 = $user . "two"; > session_register("username"); > session_register("username2"); > return true; > } > ?> > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net >

    attached mail follows:


    you have to have the variable you register (in both ways) global.

    so no matter how you call the function the variable must be defined global.

    <? session_Start();

    $foo = "bar"; session_register("foo");

    function bob($user){

    Global $user, $username, $username2; # In this way they can "escape the prison of function"

    $username = $user . "one"; $username2 = $user . "two"; session_register("username"); session_register("username2"); return true; }

    Sincerely,

    Maxim Maletsky Founder, Chief Developer

    PHPBeginner.com (Where PHP Begins) maximphpbeginner.com www.phpbeginner.com

    -----Original Message----- From: Jon Rosenberg [mailto:phpcolumbusinteractive.com] Sent: Sunday, February 25, 2001 1:16 AM To: PHP List Subject: [PHP] session_register in function

    The variable I register before the function becomes available in the session to other pages...the variable I register inside the function are not accessible in the session to ohter pages. Is this normal? How can I work around this? Thanks! PHP4.0.4pl1 on Linux.

    sample code:

    <? session_Start();

    $foo = "bar"; session_register("foo");

    function bob($user){ $username = $user . "one"; $username2 = $user . "two"; session_register("username"); session_register("username2"); return true; } ?>

    --
    PHP General Mailing List (http://www.php.net/)
    To unsubscribe, e-mail: php-general-unsubscribelists.php.net
    For additional commands, e-mail: php-general-helplists.php.net
    To contact the list administrators, e-mail: php-list-adminlists.php.net
    

    attached mail follows:


    I replaced extract() with $row[] - much better.

    Now I have the strangest thing happening - the <td align="right"> html formatting only applies to the first iteration in the loop, even though it shows up in the html source!!

    regard, jaxon

    html generation: ---------------- for ($i = 1; $i <= 5; $i++) { $sql="select stuff from table"; $result = mysql_query($sql, $link_id); $row = mysql_fetch_row($result); echo " <tr><td><h3>$row[2]</h3></td></tr> <tr><td><h4>$row[3]</h4></td></tr> <tr><td align=\"right\"><h6>$row[1]</h6></td></tr> <tr><td>$row[4]</td></tr> <tr><td align=\"right\"><a href=\"news.php?#$row[0]\"><h5>...more</h5></a></td></tr> <hr /> "; echo "</table>"; }

    resultant source: ----------------- <table border="0" cellpadding="1" cellspacing="0"> <tr><td><h3>First Headline</h3></td></tr> <tr><td><h4>first subtitle</h4></td></tr> <tr><td align="right"><h6>2001-02-24</h6></td></tr> <tr><td>get it right here now... this is the place to be, I tell you</td></tr> <tr><td align="right"><a href="news.php?#1"><h5>...more</h5></a></td></tr> <tr><td><hr /></tr></td> </table> <tr><td><h3>SECOND HEADLINE!</h3></td></tr> <tr><td><h4>second subtitle</h4></td></tr> <tr><td align="right"><h6>0000-00-00</h6></td></tr> <tr><td>even more good stuff coming out of our second news item!!!</td></tr> <tr><td align="right"><a href="news.php?#2"><h5>...more</h5></a></td></tr> <tr><td><hr /></tr></td> </table> <tr><td><h3>HEADLINE 3!!!</h3></td></tr> <tr><td><h4>subtitle 3</h4></td></tr> <tr><td align="right"><h6>2001-02-26</h6></td></tr> <tr><td>getcha third item here!!</td></tr> <tr><td align="right"><a href="news.php?#3"><h5>...more</h5></a></td></tr> <tr><td><hr /></tr></td> </table>

    attached mail follows:


    gak. everyone ignore me. idiocy is setting in this late at night.

    stoopid me put a </table> tag INSIDE the loop.

    and thanks CC Zona for the pointer on the var_dump() - very helpful!

    regards, jaxon

    On 2/25/01 2:38 AM, "Jaxon" <jaxonsalamander.net> wrote:

    > I replaced extract() with $row[] - much better. > > Now I have the strangest thing happening - the <td align="right"> html > formatting only applies to the first iteration in the loop, even though it > shows up in the html source!! > > regard, > jaxon > > > html generation: > ---------------- > for ($i = 1; $i <= 5; $i++) > > { > $sql="select stuff from table"; > $result = mysql_query($sql, $link_id); > $row = mysql_fetch_row($result); > > echo " > <tr><td><h3>$row[2]</h3></td></tr> > <tr><td><h4>$row[3]</h4></td></tr> > <tr><td align=\"right\"><h6>$row[1]</h6></td></tr> > <tr><td>$row[4]</td></tr> > <tr><td align=\"right\"><a > href=\"news.php?#$row[0]\"><h5>...more</h5></a></td></tr> > > <hr /> > "; > > echo "</table>"; > } > > resultant source: > ----------------- > <table border="0" cellpadding="1" cellspacing="0"> > <tr><td><h3>First Headline</h3></td></tr> > <tr><td><h4>first subtitle</h4></td></tr> > <tr><td align="right"><h6>2001-02-24</h6></td></tr> > <tr><td>get it right here now... this is the place to be, I tell > you</td></tr> > <tr><td align="right"><a > href="news.php?#1"><h5>...more</h5></a></td></tr> > <tr><td><hr /></tr></td> > </table> > <tr><td><h3>SECOND HEADLINE!</h3></td></tr> > <tr><td><h4>second subtitle</h4></td></tr> > <tr><td align="right"><h6>0000-00-00</h6></td></tr> > <tr><td>even more good stuff coming out of our second news > item!!!</td></tr> > <tr><td align="right"><a > href="news.php?#2"><h5>...more</h5></a></td></tr> > <tr><td><hr /></tr></td> > </table> > <tr><td><h3>HEADLINE 3!!!</h3></td></tr> > <tr><td><h4>subtitle 3</h4></td></tr> > <tr><td align="right"><h6>2001-02-26</h6></td></tr> > <tr><td>getcha third item here!!</td></tr> > <tr><td align="right"><a > href="news.php?#3"><h5>...more</h5></a></td></tr> > <tr><td><hr /></tr></td> > </table> >

    attached mail follows:


    Jeff Oien wrote: > > Could you give me some URLs for tutorials related > to cookies and good reference material?

    www.cookiecentral.com/faq/ has some good general info

    rfc2109 - more technical but useful http://www.cis.ohio-state.edu/htbin/rfc/rfc2109.html > > One question I have is can a cookie never expire? > Jeff Oien >

    attached mail follows:


    Yes it can :

    here's what I once was doing to assign a user with a cookie containing a Session ID:

    $uniqid = md5 (uniqid (rand()));

    if(!isset($sid)) { $time = time(); setcookie ("sid", $uniqid, $time*3); }

    time()+time() makes it really, really LONG ... (62 years?), of course it has not expired from anyone yet :-))

    Sincerely,

    Maxim Maletsky Founder, Chief Developer

    PHPBeginner.com (Where PHP Begins) maximphpbeginner.com www.phpbeginner.com

    -----Original Message----- From: Jeff Oien [mailto:jeffwebdesigns1.com] Sent: Sunday, February 25, 2001 7:42 AM To: PHP Subject: [PHP] Cookie References?

    Could you give me some URLs for tutorials related to cookies and good reference material?

    One question I have is can a cookie never expire? Jeff Oien

    --
    PHP General Mailing List (http://www.php.net/)
    To unsubscribe, e-mail: php-general-unsubscribelists.php.net
    For additional commands, e-mail: php-general-helplists.php.net
    To contact the list administrators, e-mail: php-list-adminlists.php.net
    

    attached mail follows:


    On Sat, 24 Feb 2001 17:51:07 +0100, Christian Reiniger (creinigmayn.de) wrote: >On Saturday 24 February 2001 17:18, PHPBeginner.com wrote: >> in my preceding email I've written: >> >> if($var!='') >> >> will fix your all your worries without an intervention of a strings >> function. > >Except that it will throw a warning in PHP4 if $var is not set. >=> isset () should be used.

    man, this is like the thread that will not die. isset() will return true for an empty string, which is not what he wants. the right thing to do is use

    if((isset($var))&&($var!=""))

    the isset on the left gets evaluated first so a warning is never thrown. to be even safer, you can go:

    if((isset($var))&&(trim($var)!=""))

    you do not want to use strlen() for the following reasons: 1) makes code unreadable -> very sloppy 2) overhead 3) it will give a warning when $var is not set (error_reporting 15 only).

    attached mail follows:


    > you do not want to use strlen() for the following reasons: > 1) makes code unreadable -> very sloppy

    Yeah and your if(isset($var) && $var != '') is pretty

    > 2) overhead

    You call one function and do two comparisons - vs an age old C function .... I'd like to run some numbers on that.

    > 3) it will give a warning when $var is not set (error_reporting 15 > only).

    I run on the default error_reporting setting and it's never complained so far.

    --Joe

    > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net

    -- 
    

    ------------------------------------------------------------------------------- Joe Stump, PHP Hacker, joestump98yahoo.com -o) http://www.miester.org http://www.care2.com /\\ "It's not enough to succeed. Everyone else must fail" -- Larry Ellison _\_V -------------------------------------------------------------------------------

    attached mail follows:


    100% agreed!

    this makes much more sense then any of us was saying before.

    Sincerely,

    Maxim Maletsky Founder, Chief Developer

    PHPBeginner.com (Where PHP Begins) maximphpbeginner.com www.phpbeginner.com

    -----Original Message----- From: Mark Maggelet [mailto:maggeletmminternet.com] Sent: Sunday, February 25, 2001 5:01 PM To: creinigmayn.de; php-generallists.php.net Subject: Re: [PHP] isset()

    On Sat, 24 Feb 2001 17:51:07 +0100, Christian Reiniger (creinigmayn.de) wrote: >On Saturday 24 February 2001 17:18, PHPBeginner.com wrote: >> in my preceding email I've written: >> >> if($var!='') >> >> will fix your all your worries without an intervention of a strings >> function. > >Except that it will throw a warning in PHP4 if $var is not set. >=> isset () should be used.

    man, this is like the thread that will not die. isset() will return true for an empty string, which is not what he wants. the right thing to do is use

    if((isset($var))&&($var!=""))

    the isset on the left gets evaluated first so a warning is never thrown. to be even safer, you can go:

    if((isset($var))&&(trim($var)!=""))

    you do not want to use strlen() for the following reasons: 1) makes code unreadable -> very sloppy 2) overhead 3) it will give a warning when $var is not set (error_reporting 15 only).

    -- 
    PHP General Mailing List (http://www.php.net/)
    To unsubscribe, e-mail: php-general-unsubscribelists.php.net
    For additional commands, e-mail: php-general-helplists.php.net
    To contact the list administrators, e-mail: php-list-adminlists.php.net
    

    attached mail follows:


    On Sunday 25 February 2001 09:01, Mark Maggelet wrote:

    > >> if($var!='') > >> > >> will fix your all your worries without an intervention of a

    > >Except that it will throw a warning in PHP4 if $var is not set. > >=> isset () should be used. > > man, this is like the thread that will not die. isset() will return > true for an empty string, which is not what he wants. the right thing > to do is use > > if((isset($var))&&($var!=""))

    I never said *only* isset() should be used :)

    -- 
    Christian Reiniger
    LGDC Webmaster (http://sunsite.dk/lgdc/)
    

    "Never doubt that a small group of thoughtful, committed people can change the world... Indeed, it's the only thing that ever has."

    - Margaret Mead

    attached mail follows:


    Can anyone tell me why this: Line 282 mysql_select_db("centraldb",$db); Line 283 $qorder++; Line 284 $result = mysql_query("SELECT q.questid, q.question, q.answer, q.qorder, q.depart, q.catid, q.active, q.global, q.adate, q.author, q.authoremail, q.askemail, c.catid, c.category, c.under, c.corder, c.active FROM central_groupfaqq q, central_groupfaqcat c WHERE q.active = '1' AND q.global = '1' AND c.active = '1' ORDER BY c.under, c.order, q.qorder",$db); Line 285 while ($myrow = mysql_fetch_row($result))

    Would cause this error: Warning: Supplied argument is not a valid MySQL result resource in faqbody.php3 on line 285

    When changing the same SELECT statement to: Line 284 $result = mysql_query("SELECT * FROM central_groupfaqq WHERE active = '1' ORDER BY qorder",$db);

    Works perfectly?

    Keith Spiller a.k.a. Larentium

    attached mail follows:


    In article <030601c09f05$2b9e6e70$53daead8gilanet.com>, larentiumgilanet.com ("Keith Spiller") wrote:

    > Can anyone tell me why this: > Line 282 mysql select db("centraldb",$db); > Line 283 $qorder++; > Line 284 $result = mysql query("SELECT q.questid, q.question, q.answer, > q.qorder, q.depart, q.catid, > q.active, q.global, q.adate, q.author, q.authoremail, > q.askemail, c.catid, c.category, c.under, > c.corder, c.active FROM central groupfaqq q, central > groupfaqcat c WHERE q.active = '1' AND > q.global = '1' AND c.active = '1' ORDER BY c.under, > c.order, q.qorder",$db); > Line 285 while ($myrow = mysql fetch row($result)) > > Would cause this error: > Warning: Supplied argument is not a valid MySQL result resource in > faqbody.php3 on line 285 > > When changing the same SELECT statement to: > Line 284 $result = mysql query("SELECT * FROM central groupfaqq WHERE > active = '1' ORDER BY > qorder",$db); > > Works perfectly?

    Sounds like the 'while' loop is failing because mysql_query isn't returning to $result what you think it is. Add some error-checking, starting with at least an "or die(mysql_error())" on the query. Also, try running the same query at the command line to confirm that it's valid.

    -- 
    CC
    

    attached mail follows:


    On 25 Feb 2001 00:20:37 -0800, Keith Spiller <larentiumgilanet.com> wrote: > Line 284 $result =3D mysql_query("SELECT q.questid, q.question, =

    Try changing this to something like $result = mysql_query("SELECT ...") or die(mysql_error()); and seeing what error is being returned by MySQL.

    attached mail follows:


    What is the best way to pull data from one table and insert into another? How can I delete entries from a table with a php document?

    The gist of what I'm trying to accomplish is this. This is somewhat of a detailed outline, so please bear with me.

    1. I have one table (members) that has all the old data. 2. I'm am going to send an e-mail to every entry in that table that has an e-mail address and have a link for them to follow to a PHP page. Any entry that does not have an e-mail address, will be moved over with a different (but similar) PHP script that will do a mass search and move of that data to the new table (memberdetail) 3. That PHP page will ask for there name and e-mail address then display a list of matching results to edit. 4. The edit page will pull data from (members) and insert then updated info into a new table (memberdetail). Password protected. Unless you know the password for that information, it will error and stop (exit () ). 5. If the insertion is successful, I want it to open a new window (if statement that contains target="_blank") which will display the new data and then the old page will refresh itself to a new page (if statement with a meta tag). If not, I want it to error and stop. (exit() ). I have already implemented anti-duplication into our new insert script (for memberdetail). The new table (memberdetail) gets scanned for duplicate information in 5 fields (but can easily but expanded to cover more then that) before it inserts data. If it finds duplicate information it displays it with an option to accept it. (password protected). If accepted (with proper password) it will delete the old information (from members) and refresh the page while opening the new information in a new window. 6. The refreshed page will be passed an variable (id) from the old table (members) and delete the entry (from members). 7. Lastly, it will refresh and pass the name and e-mail address from step 3 and display any remaining matches if any. 8. If there were any results from the search in step 7, then it will do step 4 again. If no remaining entries it will error and stop. (exit () )

    Doing it this way will help us clean up our old information and get more current information for our new website. Anything that is not moved over will be erased after a couple of months. That should give them plenty of time to update and move the old data to the new site.

    Thanks.

    Kenneth R Zink II Hellcat1S-Series.Org ICQ# 5095094 '87 GMC S-15 Ext. Cab (Hurricane) ...BBC 524 being built !!! http://www.s-series.org/htm/windstorm/project-windstorm.htm '85 Chevy S-10 Blazer (FireStorm) ...Soon to be 3.4L SFI !!! http://www.s-series.org/htm/firestorm/firestorm.htm '84 Oldsmobile Delta 88 Delta 88 Royal Brougham. Racing by the grace of God!!!

    attached mail follows:


    Hi,

    I've submitted many times a GET form like this:

    header("Location: http://examplesite.com/myscript.php3?key=value&key2=value2&keyn=valuen");

    but now I need to submit a POST form.

    How is this done?

    I found this Perl code on the web: -------------------------------------------------------------- use strict; use LWP::UserAgent; # libwww-perl

    my $ua = new LWP::UserAgent or die "new UA: $!"; $ua->agent("testclient/1.0");

    my $url = 'http://localhost/cgi-bin/test.pl'; my $request = new HTTP::Request('POST', $url) or die "new HTTP::Request POST '$url': $!"; $request->content_type('application/x-www-form-urlencoded');

    $request->content('field1=value1&field2=value2&field3=value3');

    #$request->content('field1=value1'); # optional method #$request->add_content('&field2=value2'); #$request->add_content('&field3=value3');

    my $response = $ua->request($request); print $response->content; --------------------------------------------------------------

    But I want to know if there is a way of doing it in PHP...

    Thanks in advance for your help! :-)

    Kind regards, Alexis Golzman mailto:alexistrafficbar.com http://trafficbar.com

    attached mail follows:


    what do i put in the "Sendmail_from" section of php.ini?

    attached mail follows:


    There may be other/easier solutions, but what always works for me is compiling Apache from source after removing the rpm, then compiling PHP from source. The instructions at the end of the README.config file in the Apache source distro work like a charm. This seems long-winded but at least I know it's gonna work at the end.

    Mick

    On Sat, 24 Feb 2001, Ed Lazor wrote:

    > I've had PHP installed through the RedHat RPMS listed below. > > php-imap-4.0.4pl1-3 > php-manual-4.0.4pl1-3 > php-4.0.4pl1-3 > php-ldap-4.0.4pl1-3 > php-mysql-4.0.4pl1-3 > > Unfortunately, I discovered there's a bug in this version, so I need to > remove the rpms and install PHP by compiling the source. I've been playing > with it for a few hours, but haven't had any luck, so I figured I'd ask > here. What's the easiest way to compile PHP and load it into Apache? > > If I understand correctly, because of the rpm, PHP resides as the file > /usr/lib/apache/libphp4.so > > Apache loads PHP with the following command in httpd.conf > LoadModule php4_module modules/libphp4.so > > I'm not sure (can someone confirm please?), but I assume Apache is loading > all of the modules as DSO. Is the goal is to remove the rpms and create a > new /usr/lib/apache/libphp4.so file by compiling the PHP4 source code? > > If so, how do I go about it? The directions for PHP make it sound really > easy. I tried them tho and the php files just show up as plain text. Here > are the instructions I tried (that didn't work). > > -Ed > > > > > $ ./configure --with-mysql --with-apxs > $ make > $ make install > > If you get an error telling you that the apxs script could not be found, > look for it on your system and if you find it, provide the full path to it > as: --with-apxs=/path/to/apxs > > Next you must copy php.ini-dist to the appropriate place (normally > /usr/local/lib/php.ini) and edit it as necessary to set PHP options. > > The only thing left to do is to edit your httpd.conf file and make sure the > PHP 4 mime type is there and uncommented. You need a line that looks like > this: > > AddType application/x-httpd-php .php > > Then restart your server (apachectl restart) and you should be able to > serve up PHP files now. Make a test file called test.php and put some > PHP tags in it. Like <?phpinfo()?>, for example. > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net > >

    attached mail follows:


    use flush()

    it will push the output out of apache. But note, if you have a table, on Netscape not much will be shown (even if it receives the data) until the </table> arrives.

    Sincerely,

    Maxim Maletsky Founder, Chief Developer

    PHPBeginner.com (Where PHP Begins) maximphpbeginner.com www.phpbeginner.com

    -----Original Message----- From: David Tandberg-Johansen [mailto:daviddatajo.no] Sent: Sunday, February 25, 2001 1:34 AM To: php-generallists.php.net Subject: [PHP] DIsplaying page before script finnished

    Hello!

    I wonder if there are any way to display the page before the script is finished?

    I have a loop in my script,and I want to display the resoult for each loop.

    Thanks

    David :-)

    --
    PHP General Mailing List (http://www.php.net/)
    To unsubscribe, e-mail: php-general-unsubscribelists.php.net
    For additional commands, e-mail: php-general-helplists.php.net
    To contact the list administrators, e-mail: php-list-adminlists.php.net
    

    attached mail follows:


    Here's what to do:

    in Apache: Add (this is all one line) LoadModule php4_module C:/Webserver/php/sapi/php4apache.dll

    then (five lines) AddType application/x-httpd-php .php AddType application/x-httpd-php-source .phps AddType application/x-httpd-php .php3 AddType application/x-httpd-php .php4 AddType application/x-httpd-php .phtml to your httpd.conf.

    Remove(comment) Action application ... line

    Copy php.ini to C:\Winnt\System32.

    Copy msvcrt.dll (from C:\Webserver\PHP\dlls\msvcrt.dll) to C:\Winnt\system32 - you're almost guranteed to have it, as I did, but just check.

    Copy phpts.dll to C:\Winnt\system32.

    Startup the Apache service.

    At this point, if it worked, you are runniong as a module.

    Hopefully this will work :-)

    And if it doesn't download a new version of PHP and reinstall it as INSTALL file says.

    Sincerely,

    Maxim Maletsky Founder, Chief Developer

    PHPBeginner.com (Where PHP Begins) maximphpbeginner.com www.phpbeginner.com

    -----Original Message----- From: Brandon Feldhahn [mailto:BrandonFeldhahnearthlink.net] Sent: Sunday, February 25, 2001 9:27 AM To: PHPBeginner.com Subject: Re: [PHP] php_self

    well i have windows so how do i recompile it?

    "PHPBeginner.com" wrote:

    > You have compiled it as CGI, didn't ya? > > recompile it as apache's module if you can so apache can give PHP_SELF the > right value, > > Sincerely, > > Maxim Maletsky > Founder, Chief Developer > > PHPBeginner.com (Where PHP Begins) > maximphpbeginner.com > www.phpbeginner.com > > -----Original Message----- > From: Brandon Feldhahn [mailto:BrandonFeldhahnearthlink.net] > Sent: Friday, February 23, 2001 4:30 PM > To: php-generallists.php.net > Subject: [PHP] php_self > > Why does php self always show php4/php.exe? how do i take it off? > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net

    attached mail follows:


    $id = ($id<=59) ? $id=81 : false;

    or the traditional way:

    if($id<=59) { $id=81; }

    Sincerely,

    Maxim Maletsky Founder, Chief Developer

    PHPBeginner.com (Where PHP Begins) maximphpbeginner.com www.phpbeginner.com

    -----Original Message----- From: Clayton Dukes [mailto:cdukescdukes.com] Sent: Sunday, February 25, 2001 11:54 AM To: php-generallists.php.net Subject: [PHP] comparing numbers

    How can I do something like the following shell script, in PHP? (I know this won't work normally, but you get the idea).

    if [ $id <= 59 ]; then $id=81

    TIA! Clayton Dukes

    attached mail follows:


    Hi all! s there a way with which we can increment a date (by day) without extracting the month the day and the year then increment some of them depending on the day the month and the year ? ex: 2001-03-28 'll become 2001-04-01

    Thanks _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

    attached mail follows:


    hi, try $tomorrow = mktime(0,0,0,date("m") ,date("d")+1,date("Y")); or maybe better than this, if you convert the date to the standard unix timestamp and use DATE function. Best of luck, Ahmad Anvari ----- Original Message ----- From: kaab kaoutar To: php-generallists.php.net Sent: Sunday, February 25, 2001 2:36 PM Subject: [PHP] incrementing a date!

    Hi all! s there a way with which we can increment a date (by day) without extracting the month the day and the year then increment some of them depending on the day the month and the year ? ex: 2001-03-28 'll become 2001-04-01

    Thanks _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

    -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribelists.php.net For additional commands, e-mail: php-general-helplists.php.net To contact the list administrators, e-mail: php-list-adminlists.php.net

    attached mail follows:


    hi! do we have to use in each page using the data of a session the session-start()? cause in the manual it says that session_start -- Initialize session data and session_start() creates a session ?! thanks _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

    attached mail follows:


    Is there a way to use PHP to tell whether a user's browser has a particular plugin?

    I thought that the $HTTP_ACCEPT variable might have this type of information, but in a little test that I have done, it just returns "*/*".

    I know that this can be done using Javascript, but as this can be turned off by the user etc, it seemed as though it would be more reliable to do it server side (if it is possible).

    Thanks

    Andy Clarke

    ------------------------------------------------ Andy Clarke 78 West Kensington Court, Edith Villas, London, England W14 9AB

    phone: 44 (0)20 7602 3382 mobile: 07947 418177

    Freelance Lingo/PHP Programmer

    andykinonet.com ------------------------------------------------

    attached mail follows:


    how do i make somthing with my database that knows it the username entered is already a name in use?

    attached mail follows:


    define a UNIQUE field :)

    ----- Original Message ----- From: Brandon Feldhahn To: php-generallists.php.net ; php-devlists.php.net ; php-dblists.php.net Sent: Sunday, February 25, 2001 4:03 PM Subject: [PHP] No same username

    how do i make somthing with my database that knows it the username entered is already a name in use?

    -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribelists.php.net For additional commands, e-mail: php-general-helplists.php.net To contact the list administrators, e-mail: php-list-adminlists.php.net

    attached mail follows:


    ------------ $sql = "SELECT username FROM main_users WHERE username = '$username'";

    $result = mysql_query($sql);

    $num = mysql_numrows($result);

    if ($num > "0") { die ("That username already exists, please chose another"); } ----------------- That could do it :)

    - Kath

    ----- Original Message ----- From: "Brandon Feldhahn" <BrandonFeldhahnearthlink.net> To: <php-generallists.php.net>; <php-devlists.php.net>; <php-dblists.php.net> Sent: Sunday, February 25, 2001 7:33 AM Subject: [PHP] No same username

    > how do i make somthing with my database that knows it the username > entered is already a name in use? > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net >

    attached mail follows:


    Or better using:

    create table test1 (t1 char(5), t2 char(5), primary key (t1), unique (t2));

    when creating table. No duplicate records with the same t2 because it's unique.

    Ahmad Anvari ----- Original Message ----- From: Kath To: Brandon Feldhahn ; php-generallists.php.net Sent: Sunday, February 25, 2001 6:19 PM Subject: Re: [PHP] No same username

    ------------ $sql = "SELECT username FROM main_users WHERE username = '$username'";

    $result = mysql_query($sql);

    $num = mysql_numrows($result);

    if ($num > "0") { die ("That username already exists, please chose another"); } ----------------- That could do it :)

    - Kath

    ----- Original Message ----- From: "Brandon Feldhahn" <BrandonFeldhahnearthlink.net> To: <php-generallists.php.net>; <php-devlists.php.net>; <php-dblists.php.net> Sent: Sunday, February 25, 2001 7:33 AM Subject: [PHP] No same username

    > how do i make somthing with my database that knows it the username > entered is already a name in use? > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net >

    -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribelists.php.net For additional commands, e-mail: php-general-helplists.php.net To contact the list administrators, e-mail: php-list-adminlists.php.net

    attached mail follows:


    Brandon Feldhahn wrote:

    > how do i make somthing with my database that knows it the username > entered is already a name in use?

    please do not cross-post!!! it is sufficient to post it to _one_ mailing list (php-general)

    thanks

    -- 
    · André Langhorst        t: +49 331 5811560 ·
    · andrephp.net          m: +49 173 9558736 ·
    * PHP Quality Assurance  http://qa.php.net  *
    

    attached mail follows:


    Didn't you just ask this a few days ago?

    In your while loop put a sleep(300) which will sleep for 300 seconds after processing X amount of emails.

    --Joe

    On Fri, Feb 22, 2002 at 02:53:10PM +0800, Arnold Gamboa wrote: > hi there. > > is there a way to tell crontab to do: > > "run script every 5 mins for 1 hour".. > > i have this mass email script that is so huge that i need it to chunk into > records and make sure that it will run every 5 mins for 1 hour. > > Thanks for any help. >

    -- 
    

    ------------------------------------------------------------------------------- Joe Stump, PHP Hacker, joestump98yahoo.com -o) http://www.miester.org http://www.care2.com /\\ "It's not enough to succeed. Everyone else must fail" -- Larry Ellison _\_V -------------------------------------------------------------------------------

    attached mail follows:


    Ok..

    What I found out in my first mail to the list was..quit working with filmaker =). Sure, I can do that. But the question remains..what program WILL a macuser use to forfill the needs in MySQL/PHP?

    _________________________ knasen

    attached mail follows:


    Sir, I don't see anything wrong with the syntax in your query. If I haven't over looked something, and if you haven't misspelled anything, then you have a data problem. Since your first query returns a Cartesian product, you should get something if the WHERE clause returns >= 1 row for each table. So either there are no rows in q that meet the conditions q.active = '1' AND q.global = '1' or there are no rows in c that meet the condition c.active = '1' Run the first query with only the first WHERE condition. If you get rows, add the second condition. If that works, add the third. The point at which the query stops returning rows is the point at which a subset of your WHERE conditions aren't met by the any of the rows in one of the tables.

    BTW, why are you putting quotes around numbers? I'm assuming that's not the problem, since you say you did it in the query that worked, but I don't see the point.

    Bob Hall

    >Can anyone tell me why this: > Line 282 mysql_select_db("centraldb",$db); > Line 283 $qorder++; > Line 284 $result = mysql_query("SELECT q.questid, q.question, >q.answer, q.qorder, q.depart, q.catid, > q.active, q.global, q.adate, q.author, >q.authoremail, q.askemail, c.catid, c.category, c.under, > c.corder, c.active FROM central_groupfaqq q, >central_groupfaqcat c WHERE q.active = '1' AND > q.global = '1' AND c.active = '1' ORDER BY >c.under, c.order, q.qorder",$db); > Line 285 while ($myrow = mysql_fetch_row($result)) > >Would cause this error: > Warning: Supplied argument is not a valid MySQL result resource in >faqbody.php3 on line 285 > >When changing the same SELECT statement to: > Line 284 $result = mysql_query("SELECT * FROM central_groupfaqq >WHERE active = '1' ORDER BY > qorder",$db); > >Works perfectly? > > >Keith Spiller >a.k.a. Larentium

    Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak

    attached mail follows:


    There is something called constraints in the database (generally). You have to set that field in the database, to unique, or make a "unique" index on that field.

    regards.

    idsarts.

    -----Mensaje original----- De: Web Admin [mailto:webadminmorva.net] Enviado el: Domingo, 25 de Febrero de 2001 10:26 a.m. Para: Brandon Feldhahn; php-generallists.php.net; php-devlists.php.net; php-dblists.php.net Asunto: [PHP-DB] Re: [PHP] No same username

    define a UNIQUE field :)

    ----- Original Message ----- From: Brandon Feldhahn To: php-generallists.php.net ; php-devlists.php.net ; php-dblists.php.net Sent: Sunday, February 25, 2001 4:03 PM Subject: [PHP] No same username

    how do i make somthing with my database that knows it the username entered is already a name in use?

    -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribelists.php.net For additional commands, e-mail: php-general-helplists.php.net To contact the list administrators, e-mail: php-list-adminlists.php.net