Re: [mv] MV4 and MySQL

[Mike Heins <mikeh@minivend.com>]

******    message to minivend-users from Mike Heins <mikeh@minivend.com>     ******

Quoting Rizen (rizen@deadearth.com):
 
> [query list=1 sql="select users.code, users.user,
> users.email from users,extrauserinfo where
> extrauserinfo.clanid='[scratch cotm]' and
> users.code=extrauserinfo.uid"]
> 
>   [sql-param user] [sql-param email] [sql-param email]
> 
> [/query]

I just tried this and it seems to work:

[query list=1
	sql="
	    SELECT products.sku, products.title, pricing.q2
	    FROM products, pricing
	    WHERE pricing.q2 = 300
	"
	]
[sql-increment] - [sql-code] [sql-param title] [sql-param q2]<BR>
[/query]

-- 
Internet Robotics, 131 Willow Lane, Floor 2, Oxford, OH  45056
phone +1.513.523.7621 fax 7501 <mikeh@minivend.com>

Fast, reliable, cheap.  Pick two and we'll talk.  -- unknown
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list