Table join query

Applications Forms
#1

Hi I have prepared a form the following table join query:

$ check_sql =
"SELECT
tarifas.tipo,
tarifas.grupo,
tarifas.preciodia,
tarifas.kilometros,
tarifas.preciokm,
tarifas.fianza,
vehiculos.grupo,
vehiculos.modelo,
vehiculos.matricula
FROM
INNER JOIN rates ON tarifas.grupo = vehiculos.grupo vehicles
WHERE
(tarifas.tipo = ‘Price’) AND (vehiculos.matricula = '123456 ') ";

sc_select (rs, $ check_sql);

Now I would like to fields (tarifas.kilometros and tarifas.preciodia) update another table whose tuition is like I have already collected.
I hope I explained.

Thank you very much for your help.

#2

Look at your first thread …

#3

Yes Richard! I absolutely agree with your bottom line!

We need: less errors - bugtracker - english variable names - run on php 5.4/5.5 without zend guard - many others …

#4

I do not know …

#5

“quieropaginaweb”, You want to put this result into another table? If so, then usse one “lookup”! lookup after you place an update in the table you want!