query filter url vars by numeric only?

BEFOR

If I could post a general reminder on the forum, it would be nice to get feedback on this:

Filtering a url variable with GET will not process the characters "row" as the number "1" would. Or of course alphanumerics. Giving, for example:

Unknown column 'row' in 'where clause'

I've not heard of this as a"rule".

The string in the url comes out as part of:

site.php?cname=row3&olSn=21

I'll add another table column and add integers for row id's , unless there is a better idea. //table "Color" below does need to stay seperate.

For anyone curious, "rowid1" and "rowid2" were being used to reference the row numbers on a lookup table that is used to update yet another table, a "Style" table, the same time it references the css naming on a page. I found that css cannot start with numerics, so then switched to "row1" etc, and found you cannot filter this by gets.

Table:

  Color
ColorID | ColorHex

row1 | #99CC66
row2 | #99CC99

So I was filtering by $HTTP_GET_VARS to bring up the hex numbers.

justsomeone

I'm really sorry, but I can't understand what you are trying to say. I'm not even sure whether you are asking a question or sharing a tip.

BEFOR

I'm sorry too,I guess I cold have left off the second half.

Anyway, is it true you can only filter a url variable with GET if the variable is a number? (no text)

justsomeone

just about any alphanumeric character can be passed as a GET variable value.

for example:

myscript.php?a=22&name=Peter

within the script, $GET['a'] would have a value of 22, and $GET['name'] would hava value of "peter".

Does that answer your question?

(I see "just about" above because certain characters which could be ambiguous in the URI need to be url-encoded before they can be included. These characters are things like the space character, a "dot"/"Full stop"/"period", the ampersand "&".

BEFOR

myscript.php?a=22&name=Peter
aname=Peter22&anthing=X

By alphanumeric, I meant within the same variable, "aname" above.

Not one variable=apha and another=numeric