# 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
_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]