Is this statement stupid to search in different tables in one query?
Code: Select all
<?php
$query = "SELECT * FROM $tabla, $tabla2 WHERE ($tabla.Id='$varid' AND $tabla2.Id='$varid')";
?>Moderator: General Moderators
Code: Select all
<?php
$query = "SELECT * FROM $tabla, $tabla2 WHERE ($tabla.Id='$varid' AND $tabla2.Id='$varid')";
?>Code: Select all
<?php
$query = "SELECT * FROM ".$tabla.", ".$tabla2." WHERE (".$tabla."Id.='".$varid."' AND ".$tabla2.".Id='".$varid."')";
?>what's wrong with them?daven wrote:Your logic was fine, but you were using imbedded strings.Code: Select all
<?php $query = "SELECT * FROM ".$tabla.", ".$tabla2." WHERE (".$tabla."Id.='".$varid."' AND ".$tabla2.".Id='".$varid."')"; ?>
DatosInmuebleId.
Code: Select all
DatosInmueble.IdCode: Select all
<?php
$pegar=mysql_query($query, $conexion) or die($query.' :'.mysql_error());
$pegar2=mysql_query($query2, $conexion) or die($query2.' :'.mysql_error());
?>Code: Select all
<?php
while($row = mysql_fetch_array($pegar))
{
}
?>