Unknown column in 'where clause'

[vinny199]

Hi,

here is what I can't figure out.

It seems that I can only "pull" a record out of a table via url parameter if the url parameter is a number.

for instance: www.test.com/page.php?orderid=15

then no problem I can retrive all the data from orderid=15

but if my orderid is a mix of numbers and letters, I get a :

Unknown column '40636dae1fb8a' in 'where clause'

as you can see, my orderid are alphanumeric.

is there a way to retrieve it from an url string?

for instance: www.test.com/page.php?orderid=40636dae1fb8a

and it works?

Thanks,

Vinny

[planetsim]

Can we see your code.

[vinny199]

Thanks for reply,

Sorry just found an old post that answers the question,

basically adding single quotes around the VALUE does the trick

WHERE orders.orderid='VALUE'

another one though?

how do you get a record from a table (MYSql) to purge itself after a set amount of time?

Do you know?

cheers,

Vinny