Re: [mv] MV4 and MySQL

["Rizen" <rizen@deadearth.com>]

******    message to minivend-users from "Rizen" <rizen@deadearth.com>     ******

On Wed, 10 May 2000 19:17:29 -0700 (PDT)
 Dan Busarow <dan@dpcsys.com> wrote:
> ******    message to minivend-users from Dan Busarow
> <dan@dpcsys.com>     ******
> 
> > 1) I cannot do multiple table selects:
> > 
> > example: 
> > select table1.field1, table2.field1 from table1,table2
> 
> Please send an example of your MV code to the list.
> 

ok. it doesn't matter if i use the old syntax, or the new, i
get the same results:

[sql base="users" type=list query="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]

[/sql]

--- OR

[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 suppose i could do a left join instead of selecting
directly out of two tables, but i don't think that will make
a difference. minivend seems to be having the problem with
the TABLE.COLUMN format of my query.
___________________________________________________
Ready to see the future? - http://www.deadearth.com
-
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