@mysql_select_db("be"); -- this failed
do echo mysql_error(); to see what went wrong
Nuno Lopes wrote:
I done a echo of Mysql_error and it returned:
'Nenhum banco de dados foi selecionado'
(I have the mysql server in portuguese, but the translation is something
like 'no db was selected')
--
You don't have TCP/IP networking installed on your computer.
guilherme.afm wrote:
>I downloaded mysql, i am not sure about the version,
>number but i think is the last stable version. And i use
>it under Win98.
>
>when i type:
>mysql -u root
>to try to login for the first time, i get the follo
Use:
tabProds LEFT JOIN tabUsers ON tabProds.usr_ID = tabUsers.usr_ID
from the manual:
If there is no matching record for the right table in the |ON| or
|USING| part in a |LEFT JOIN|, a row with all columns set to |NULL| is
used for the right table.
Jorge Garza wrote:
>Hi
>
>I'm designing 2
Hi,
is it possible to simply update a row from one table with a row from
another table using reference key.
Something like this example query (which is doesn't work)
UPDATE orders_products SET orders_products.status=orders.orders_status
WHERE orders.orders_id=orders_products.orders_id