Help with GET query

jbachris

Hey,

I have this code that I use in one column:

$query = "SELECT * FROM goals WHERE team_id = 1;

It works fine. What I need to do in the column on the right is SELECT * FROM goals WHERE team_id = anything but 1. It could be 2, 4, 12, 36, etc. Can anyone help me?

mobtex

Is it essential to select * from ? By doing this you're calling every value in an array, if you only need two values such as player and team for example you could do select player,team from as this would return less data and make your script more memory efficient.

In answer to your question though:

select * from goals where team_id !='1'

Blulagoon

query = "SELECT * FROM goals WHERE team_id <> 1;

jbachris

mobtex wrote:
Is it essential to select * from ? By doing this you're calling every value in an array, if you only need two values such as player and team for example you could do select player,team from as this would return less data and make your script more memory efficient.

In answer to your question though:
select * from goals where team_id !='1'

Thanks, I'll give it a try. Yes it is essential.