Posted by Michiel de Roo on 02/21/05 01:58

Marcos Donoso wrote:
> Hello group, i have follow problem:
>
> Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
> result resource in
>
> when I make query use "INNER JOIN":
> this is code:

I corrected your code

$vsql = "select tramos.codtra_tra,
tramos.ciudori_tra,
tramos.ciuddes_tra,
itinerarios.fecha_iti,
itinerarios.hora_iti,
itinerarios.codmaq_iti
from tramos
inner join itinerarios
on (tramos.codtra_tra=itinerarios.codtra_iti)
where tramos.ciudori_tra='$origen_con'
and tramos.ciuddes_tra='$destino_con'
and itinerarios.fecha_iti='$fecha_con'";

$result=mysql_query("$vsql",$link);

[Back to original message]