table query

linus · #1 (**permalink**) 04-05-04, 01:50

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

reneeb · #2 (**permalink**) 04-05-04, 02:51

Code:

my $statement = "SELECT * FROM details WHERE $metode LIKE '%$search%' LIMIT 0, 50"; 
$query = mysql_query($statement);
while ($row = mysql_fetch_array($query)){
  [...]
}