Echo an image from Database

[Psycho]

Could this code kill off the other queries?

 

"Kill off other queries"? Not sure what you mean by that. You can erroneously create code that prevents other code from running properly, but that is not a limitation of the code. That is simply a bug that needs to be fixed.

[AyKay47]

you're concatenating incorrectly, and it's not even needed. this will do fine:

 

$query = "SELECT Car_Make, Car_Model, Image_Van,  FROM products WHERE Car_Make= '$strMake' AND Car_Model = '$strModel'";

 

Remove the comma before the "FROM". I also prefer to format my queries in multiple lines to make them easier to read/analyze.

 

$query = "SELECT Car_Make, Car_Model, Image_Van
          FROM products
          WHERE Car_Make= '$strMake'
            AND Car_Model = '$strModel'";

 

missed that, thanks

[roldahayes]

What I mean is that all the other data is now not appearing but there are prices and buy buttons appearing although all the prices are showing as 0.00

 

It appears that the new piece of code stops everything else after it from working...

 

Ok, I need to go though this all again!!

 

(long night ahead....)

[AyKay47]

the success of the query should not affect any code below it, unless it is written incorrectly. Perhaps make a new thread with this new issue, or post it on here if you want us to take a look.

[roldahayes]

What is strange is that if I move the new code to the bottom of the page, after all the original code, it all works fine.

 

I'll tidy up the page and post it so you can have a look.

 

Thanks,