Hi! I have a PHP page with a few text areas where users can enter
different combination of fields to query a mySQL database. An example
of a query would be like this:
$query = "SELECT build_ids.build_id, build_ids.username, build_ids.host,
build_ids.configuration, build_ids.build,
build_ids.target, build_tests.input,
build_tests.output, build_tests.result,
build_tests.test_name,
build_tests.prms_id, build_ids.date FROM build_ids,
build_tests
WHERE build_ids.date like \"$date%\" and
build_ids.host like \"$host\" and
build_ids.build_id like build_tests.build_id";
The query would work if I use mySQL from command line, w/o using the
variable, but use the field names themselves. But wouldn't work when I
try to use variable like above and set the variables from a PHP page.
Anybody knows what's wrong w/ my code or could show me to some helpful
resources? Please reply to this email as I am not a subscriber of this
list. Thank you very much! I really appreciate your help!
--
Dzung V. Nguyen email: dunguyen@iol.unh.edu
Alpha Linux Group http://linux.iol.unh.edu/clp
InterOperability Laboratory
University of New Hampshire phone: (603) - 862 - 0401
Durham, NH 03824 fax : (603) - 862 - 4181
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
