- Code: Select all
(Connect to your db) and then:
SELECT * FROM table1, table2, table3, etc (add your tables here) WHERE name='Felix'
So in
PHP:
- PHP: Select all
$sql = "SELECT * FROM table1, table2, etc WHERE name='Felix'";
if ($sql) {
echo 'all done';
} else {
echo 'error';
}
Try that?
Remembering first you need to connect to the database:
- PHP: Select all
# DataBase Settings
$hostname_config = "localhost"; # 99% Leave Localhost
$database_config = ""; # Database Name
$username_config = ""; # Database Username
$password_config = ""; # Password
$conn = mysql_connect($hostname_config, $username_config, $password_config) or trigger_error(mysql_error(),E_USER_ERROR); mysql_select_db($database_config)or die(mysql_error());