Board index   FAQ   Search  
Register  Login
Board index php forum :: Database mySQL & php coding

Help on my simple sql script

Codes here !

Moderators: macek, egami, gesf

Help on my simple sql script

Postby christoperl » Wed Nov 13, 2002 10:29 am

Thank you in advance!
the script is here:

(SELECT categoryId, NULL AS subCategoryId, categoryName, NULL AS subCategoryName, status AS cStatus, NULL AS sStatus FROM categories )
UNION

(SELECT c.categoryId as categoryId, s.subCategoryId as subCategoryId, c.categoryName as categoryName, s.subCategoryName as subCategoryName, c.status AS cStatus, s.status AS sStatus FROM categories AS c RIGHT JOIN subcategories AS s ON c.categoryId =s.categoryId)
ORDER BY categoryName, subCategoryName ASC
christoperl
New php-forum User
New php-forum User
 
Posts: 2
Joined: Wed Nov 13, 2002 10:24 am

I am using lower version of mysql

Postby christoperl » Wed Nov 13, 2002 10:49 am

I need to upgrade to 4.0, but 4.0 is stable or not?
christoperl
New php-forum User
New php-forum User
 
Posts: 2
Joined: Wed Nov 13, 2002 10:24 am

Postby DutchBen » Fri Nov 15, 2002 11:10 am

Yes ... 4.0 is stable ... but what exactly is your question .... huh?
DutchBen
New php-forum User
New php-forum User
 
Posts: 36
Joined: Thu Oct 24, 2002 10:28 am
Location: Amsterdam


Return to mySQL & php coding

Who is online

Users browsing this forum: No registered users and 1 guest

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.

cron