Re: LIKE statement works in pmyAdmin, not in the web page

From: Marian Heddesheimer (200604.8.nolink_at_spamgourmet.com)
Date: 06/22/04

  • Next message: michel: "Re: String split problem"
    Date: Tue, 22 Jun 2004 07:47:14 +0200
    
    

    On Mon, 21 Jun 2004 23:46:17 GMT, "Matthew Crouch"
    <matthew.crouch@spamlessverizon.net> wrote:

    >$sql2 = "SELECT * from users WHERE note like '%entry%' ORDER BY registered_date DESC";
    >echo $sql2;
    >$result2 = mysql_query($sql2);

    you should also add the following line:

    echo mysql_error();

    so you will see if mySQL returns any error on your query.

    Regards

    Marian

    -- 
    Tipps und Tricks zu PHP, Coaching und Projektbetreuung
    http://www.heddesheimer.de/coaching/
    

  • Next message: michel: "Re: String split problem"

    Relevant Pages

    • Re: Generating PDF
      ... Regards ... Marian ... Tipps und Tricks zu PHP, Coaching und Projektbetreuung ...
      (comp.lang.php)
    • Re: Form Data Loss
      ... Either turn it on or use the $_POST Array (which is the better ... Regards ... Tipps und Tricks zu PHP, Coaching und Projektbetreuung ...
      (comp.lang.php)
    • Re: getting an autonumber off of mySQL
      ... You can check it in your php script calling mysql_insert_idafter ... Marian ... Tipps und Tricks zu PHP, Coaching und Projektbetreuung ...
      (alt.php)
    • Re: Passing Parameters Script
      ... Marian ... Tipps und Tricks zu PHP, Coaching und Projektbetreuung ...
      (comp.lang.php)
    • Re: getting an autonumber off of mySQL
      ... Marian ... Tipps und Tricks zu PHP, Coaching und Projektbetreuung ...
      (alt.php)