Can anyone see a probelm with this query ?

[ma201dq]

I have the below query that will query one table but retirve data from two tables, yet not producing an output.

$tablestatuse ="select ptable.tableid, ptable.statuse, ptable.timestamp1, ptable.memid member2.name, member2.lname, member2.memid from ptable, member2 where ".$searchtype." like '%".$searchterm."%' and member2.memid=ptable.memid"; 

it works fine when i take the ".$searchtype." like '%".$searchterm."%' out.

Any ideas

Cheers

Dug

[Mittineague]

Does $searchtype have the format table.field ??

[r937]

take your query, substitute the variable value, and run it outside of php

then report if it works or what the error message was

[ma201dq]

QUOTE:

Does $searchtype have the format table.field ??

No perhaps thats whats causing it not to work.


QUOTE:

take your query, substitute the variable value, and run it outside of php

then report if it works or what the error message was


It works fine outside php.


Thanks


Dug

[r937]

if it works fine outside of php then it's not a database problem, is it

moving to php forum