Results 1 to 5 of 5

Thread: table query

  1. #1
    Join Date
    Apr 2004
    Location
    NY
    Posts
    3

    Unanswered: table query

    I can connect to my db but I can't access my tabe "details" Im thinking it has to do something with my query either on the php end or phpmyadmin side... maybe Im wrong?

    phpmyadmin side:
    SELECT * FROM `details` WHERE 1

    php side:
    $query = mysql_query("SELECT * FROM details WHERE $metode LIKE '%$search%' LIMIT 0, 50");
    while ($row = @mysql_fetch_array($query))

    I have been stuck on this for a few days and I have tried searching for the solution to this problem, this is my last resort. So any help would greatly be appreciated.

    -Anthony

  2. #2
    Join Date
    Jan 2004
    Location
    Germany
    Posts
    167
    Code:
    my $statement = "SELECT * FROM details WHERE $metode LIKE '%$search%' LIMIT 0, 50"; 
    $query = mysql_query($statement);
    while ($row = mysql_fetch_array($query)){
      [...]
    }
    board.perl-community.de - The German Perl-Community

  3. #3
    Join Date
    Apr 2004
    Location
    NY
    Posts
    3
    That didn't work at all...

  4. #4
    Join Date
    Feb 2004
    Posts
    5
    try specifing the columns, instead of using *. In fact, start with just one or two columns to confirm where your problem is.

  5. #5
    Join Date
    Apr 2004
    Location
    NY
    Posts
    3
    are there tutorials on how to setup the query?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •