Search Error - Page 2

[spluskhan]

error is the same showing all sored records from table

[pritaeas]

Echo and show the exact query that's being executed.

[spluskhan]

This table is showed when i searchd for Jams

Business Name   Business Type               Address
James Tech      Business Service Provider   NY
Roosts Systems  Govt                        Pak
Ntel ISP        Internet Service Provider   International

[pritaeas]

Looks like $query never gets a value, so that the executed query returns everything.

[Webville312]

According to your query, you are searching based on "TYPE", perhaps, you wanna try searching by "name" or something like that ...

[spluskhan]

can you give me an example,
what kind of change you want i do to this code?

[pritaeas]

Add:

$query = isset($_GET['query']) ? $_GET['query'] : '';

or:

$query = isset($_GET['Editbox1']) ? $_GET['Editbox1'] : '';

Your form's input is defined strangely, so I cannot tell for sure.

[spluskhan]

I try it:

$query = isset($_GET['query']) ? $_GET['query'] : '';

Result is:

Query was empty

[spluskhan]

Query was empty

[spluskhan]

now what is wrong now?

[pritaeas]

Check your form's input and use the right name for the GET variable.

[spluskhan]

Look this is all records which is stored in table.
I search for James,
Result is Query was empty

Business Name   Business Type               Address
James Tech      Business Service Provider   NY
Roosts Systems  Govt                        Pak
Ntel ISP        Internet Service Provider   International

[pritaeas]

I give up. The answer is in the previous posts.

[spluskhan]

I type James Tech
the result is the same,

Type:
Roosts Systems
Govt
International

But all they display all records, So what are you suggest ?

[spluskhan]

if it is not working then, i have anoth code, but it have prob how i add url link to Name.
Its working good.

Link:
Click Here