Wildcards

[dcjones]

Hi all

Wildcards:

If I have a URL http://www.mysite/test.htm?idname=a

is it possible to use the appended "a" in a query using the wildcard syntax i.e

$query = "select id, flag, from flags where flag LIKE '$idname%'";

I have played with this most of the day with no luck.

Does this make sense

Does anyone have any ideas, please.

Many thanks

Dereck

$query = "select id, flag, from flags where flag LIKE '$idname%'";

[barand]

Do you have more luck if you rename the file "test.php"?

[dcjones]

Hi

File with a .HTM or .PHP is the same result

If I use URL http://www.mysite/test.php?idname=a

the called file test.php shows the following error

You have an error in your SQL syntax near 'from flags where flag LIKE ""' at line 1

any thoughts

Dereck

[barand]

Remove the last comma before the "from...

[dcjones]

Hi

If I run with:

$query = "select id, flag from flags where flag like  'a%'"; 

I get results but If I use the $idname=a on the end of the URL I get no records shown.

What I am trying to do is, I have a page with letters from A thru to Z. When a user clicks on one of the letters i.e B, I want to display all countries begining with the letter B.

From the calling page if I pass the cursor over a letter I can see the URL on the task bar and it is as I want it to be, the complete URL with ?idname=B appened to the end.

Does this make sense.

Many thanks for looking at this

Regards
Dereck

[barand]

How are picking up the idname ?

$idname = $_GET["idname"];
$query = "select id, flag from flags where flag like '$idname%'";

[dcjones]

Hi

I am using

<div align="center"><a href="/Embassies/embassies1.php?$idname=A" onClick="MM_nbGroup('down','group1','a','/Gif/MENUBARS/A-Z/Adw.gif',1)" onMouseOver="MM_nbGroup('over','a','/Gif/MENUBARS/A-Z/AOV.gif','',1)" onMouseOut="MM_nbGroup('out')"><img name="a" src="/Gif/MENUBARS/A-Z/AUP.gif" border="0" onLoad="" width="20" height="12"></a></div>

from the calling page and

$query = "select id, flag from flags where flag like 'idname%'";

in the called page

Dereck

[dcjones]

Hi All

Can anyone help with this thread, please.

Many thanks

Dereck

[Rodders]

$idname_wild = $idname . "%";

$query = "select id, flag from flags where flag like '$idname_wild'";

Alternatively,

$query = "select id, flag from flags where flag like '${idname}%'";

I think the problem is that your code is looking for a variable called $idname%.

A good tip:
If you are not getting the results you want from your SQL, echo the SQL statement and then run it against your DB with phpmyadmin or something.

If you echo out your, I guess it looks like this:

select id, flag from flags where flag like '';

assuming you don't have a variable called $idname%.

Does that make sense? Does my suggestion work?

[dcjones]

Hi,

Thanks for your reply.

No it does not work.

If I use from the calling page:http://www.mysite/embassies.embcall.php?$idname=A

The Called Page

$idname_wild = $idname . "%";
$query = "select id, flag from flags where flag like '$idname_wild'";

the result is that it shows all records and not those just with the letter A at the begining of the word.

If I use your other suggestion I get the same result.

Any ideas.

Regards

Dereck

[Rodders]

OK

It looks like your $idname is blank. I suggest your URL shouldn't contain the $.

Also, you should refer to variables in your URL using $_GET.

Try this,

URL: http://www.mysite/embassies.embcall.php?idname=A

$idname = $_GET['idname'];

$idname_wild = $idname . '%';

$query = "select id, flag from flags where flag like '$idname_wild'";

[dcjones]

Hi,

Well Done my friend, it works. I have played with this for hours.

I thank you.

Dereck

[Rodders]

Good stuff. Glad you got it going. Just wish I could have seen your posts earlier to save you some time.