# Mysql-4 to mysql-5 code example help

**URL:** <https://forum.kirupa.com/t/mysql-4-to-mysql-5-code-example-help/220237>\
**Category:** Uncategorized\
**Created:** [March 23, 2007, 11:28pm UTC](https://forum.kirupa.com/t/mysql-4-to-mysql-5-code-example-help/220237 "2007-03-23T23:28:11Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![The\_Vulcan](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/the_vulcan/32/145_2.png) [@The\_Vulcan](https://forum.kirupa.com/u/The_Vulcan)\
**Post date:** [March 23, 2007, 11:28pm UTC](https://forum.kirupa.com/t/mysql-4-to-mysql-5-code-example-help/220237/1 "2007-03-23T23:28:11Z")

</div>

I am currently setting up a osCommerce site.  
However I am trying to run it on mysql-5 so a lot of the queries don’t work.

It would be appreciated if someone could modify this bit of code to mysql-5 standard for me so that I can see how it differs from 4x.

```php
select count(p.products_id) as total from products_description pd,
products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id,
products_to_categories p2c left join specials s on p.products_id = s.products_id 
where p.products_status = '1' and 
p.products_id = p2c.products_id and 
pd.products_id = p2c.products_id and
pd.language_id = '1' and 
p2c.categories_id = '37'

[TEP STOP]

```

Any pointers or tips for other problems I may face is appreciated.  
Or links to any examples on converting mysql-4 to mysql-5 queries.

Thankyou.