note 108825 deleted from function.join by danbrown
| From: | danbrown@php.net | Date: | Mon, 16 Jul 2012 15:44:34 +0000 |
| Subject: | note 108825 deleted from function.join by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-189218@lists.php.net to get a copy of this message | ||
Note Submitter: John
----
An example of table join.
<?php
$conn = mysql_connect("localhost", "username", "password");
mysql_select_db("database name", $conn)
or die ('Database not found ' . mysql_error() );
$sql = "select * from consumer, application where consumer.consumernum =
application.consumernum and applicationnum = $variable";
$rs = mysql_query($sql, $conn)
or die ('Issue arose with query' . mysql_error());
?>