Not unique table/alias: 'Extension'

[newphpbie]

I'm having this SQL error appear. It didn't before, I've changed something and I don't know what it might have been to make this error.

Could someone give me an idea/example of when or how this error occurs...

TIA

 

[sleipnir214]

Insufficient data for a meaningful answer. What query brought about the error?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[newphpbie]

The query works fine on my first page.

I have a link to carry the query to another page which will be 'Printer Friendly'.

It's when it opens in the new page I get that message..

The query appears to be fine...I don't understand where I should start looking to solve this error...

I knwo that doesn't help a great deal but I'm just after some hints...or hunches....

 

[newphpbie]

OK, I've compared the original uery with the one which is passed.

It appears that when I pass this variable it removes a space from within the SQL string which in turn is causing my problem. This hasn't happened before so I'm really stumped.

Why would it remove a random space from the string?
How might I go about replacing it??

 

[sleipnir214]

Again, insufficient data for a meaningful answer. There are too many variables in your question to even hope to give you any kind of advice.

Again, how does the query read?

How are you passing the query from one script to another?



Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[newphpbie]

ok, problem solved....

I found in my original SQL string that there wasn't an offical space between the two bits I was having trouble with. I don't know why this didn't show up when I printed the query before passing it...it's all a bit of a mystry...but hey, it's working now so no probs.....

Thanks for lookin thou....