At 03:37 PM 10/26/00 +0800, you wrote:
># how do you do a multiple query in mysql?
>#
># mysql_query ("SELECT * FROM databasename ......
># ..... WHERE AND OR?
>#
># I have this database via web but I don't know how to get more than 2
># entries the example on devshed only has firstname and last name. what if
># i would like to add more like address or sex or email addy.? please help
># thanks.
>
> SELECT <Field> FROM <TableName> WHERE (<Condition>) and (<Condition>)
>
> ex. SELECT fname,lastname,email FROM UserName,UserInfo WHERE
> fname="sysad"
>
> is this what you're asking for?
>
>jackson
or:
select <field1>,<field2>,<field3>,.... from <tablename>;
raymond
_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
