1064 error-any help please!

[Aye Poppin]

I loaded the big image coding. Got my admin working correctly. Now I get this on my pop up images.

 

1064 - You have an error in your SQL syntax near 'p left join products_description pd on p.products_id = pd.products_id where p.pr' at line 1

 

select pd.products_name, p.products_image, p.products_bimage products p left join products_description pd on p.products_id = pd.products_id where p.products_status = '1' and p.products_id = '75' and pd.language_id = '1'

 

 

Probably simple but I am no good at this stuff. Please help!

[spooks]

I loaded the big image coding. Got my admin working correctly. Now I get this on my pop up images.

 

1064 - You have an error in your SQL syntax near 'p left join products_description pd on p.products_id = pd.products_id where p.pr' at line 1

 

select pd.products_name, p.products_image, p.products_bimage products p left join products_description pd on p.products_id = pd.products_id where p.products_status = '1' and p.products_id = '75' and pd.language_id = '1'

 

 

Probably simple but I am no good at this stuff. Please help!

 

 

Try

 

select pd.products_name, p.products_image, p.products_bimage from products p left join products_description pd on p.products_id = pd.products_id where p.products_status = 1 and p.products_id = 75 and pd.language_id = 1

 

B)

[Aye Poppin]

ok I changed that but it didn't change it on the site?

[Aye Poppin]

ok now I get this!

 

1146 - Table 'osdb.p' doesn't exist

 

and when I out the original popup_image code for the catalog it works-very weird!