Member Avatar for mpc123

So I have this query but the error is wrong syntax around '%'$txt2',%' - what would I have to change this too please... thanks
What I am looking for in the field is anything that has txt2, with things after it or just txt2 on its own without anything after it. How would I do this please alltogether.
Thanks.

$result = mysql_query("SELECT * FROM table WHERE field LIKE '%'$txt2',%' ORDER BY field ASC") or trigger_error(mysql_error().$sql);
Edited by mpc123 because: left out rest of question
  • 1 Contributor
  • 1 Reply
  • 125 Views
  • 7 Minutes Discussion Span
  • Latest Post Latest Post by mpc123
Member Avatar for mpc123

Sorry , looks like i have sold it with

$result = mysql_query("SELECT * FROM table WHERE field LIKE '%$txt2,%' OR field = '$txt2' ORDER BY field ASC") or trigger_error(mysql_error().$sql);
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.