Help with Friend/Foe page

[2bit]

I was going to write a basic mod to practice. For my first mod i wanted to choose something simple but i hit a brick wall! All i wanted to do is create a page that lists your friends and foes. When i looked at the zebra table it had user id, zebra id... wich is fine but when i looked at the user data there was no zebra id as a foreign key leading back to the zebra table. I couldnt find where it defines the zebra id! the zebra id is basicly the user id i think but how would i link the zebra id with the user id and get it to display the users avatar as a friend or foe on the template file?!

[blazes816]

[2bit]

wow ,
That cleared up alot! Thanks a bunch.
I am rather confused on the next step in the process.
I mean the zebra id keeps throwing me off. It easier to run a sql query on say the user avatar and have that display onto the template; but this example is toatly diffrent from that direct approach.
i guess the next step would be to come up with a script that converts the data into usable chunks?!

[2bit]

[igorw]

The foreign key is not on the users table, it's on the zebra table, and it's called "user_id".

[2bit]

[Elglobo]

[2bit]

Thanks a bunch Elglobo,

That was cool of you to help out like that i owe you one.
I am going to soak this in a while to make shore i got it drilled in my head!

[2bit]

[igorw]

[blazes816]

Sorry about neglecting this thread. Must have missed reading it before marking forums read. Don't worry, I won't again.

What are you currently having trouble with?

Also, I'm going to change the topic name to something descriptive so that others that could help know what it's about.

[2bit]

Thanks a bunch guys for clearing all of that up!
I was confused on what or whome was wright about the code. I had a feeling that he was wrong and that it was correct. I had to make shore because i am still learning and i dont want to be going over the wrong info trying to learn from that.

p.s. thanks for changing the topic to something better.

[2bit]

[igorw]

[2bit]

It was a syntax error! nevermind