mysql search not happening

Discussion in 'PHP' started by gilgalbiblewheel, Apr 10, 2008.

  1. #1
    I don't know where I went wrong but the query isn't taking place:
    <?php
    $con = mysql_connect("","root","");
    if (!$con)
      {
      die('Could not connect: ' . mysql_error());
      }
    
    mysql_select_db("boti_book", $con);
    
    $sql = "SELECT content FROM boti_pages WHERE content LIKE 'Fritz'";
    $result = mysql_query($sql);
    echo $sql;
    while($row = mysql_fetch_array($result))
      {
      echo $row['content']."<br />\n";
      }
    mysql_close($con);
    ?>
    PHP:

     
    gilgalbiblewheel, Apr 10, 2008 IP
  2. nuvsharma

    nuvsharma Peon

    Messages:
    45
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    What is it saying is it a blank page or giving resource ids?
     
    nuvsharma, Apr 10, 2008 IP
  3. wsd

    wsd Peon

    Messages:
    5
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    mysql connect information exmpel localhost ...
     
    wsd, Apr 10, 2008 IP
  4. nuvsharma

    nuvsharma Peon

    Messages:
    45
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    yeah he is using phpmyadmin,i am guessing:p
     
    nuvsharma, Apr 10, 2008 IP