Re: [PHP-DB] Wrong SQL Syntax

Chris Carter wrote: My MySQL version is 5.0. I am trying to run this small query but getting this SQL error "Error! Could not insert valuesYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''userdata' ('fName', '

[PHP-DB] Wrong SQL Syntax

My MySQL version is 5.0. I am trying to run this small query but getting this SQL error "Error! Could not insert valuesYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''userdata' ('fName', 'lName', 'email', 'con

Re: [PHP-DB] multiple database join with pdo

C. Tate Baumrucker wrote: is it possible to join two tables from two different databases using pdo? thanks, Depends if the underlying database supports it. Postgres doesn't without using an external program, no idea about mysql. -- Postgresql & php tutorials http://www.designmagick.com/ --

RE: [PHP-DB] multiple database join with pdo

have you tried the standard sql method select database_name1.table_name1.field_nameA, database_name2.table_name2.field_nameB from ... Bastien From: "C. Tate Baumrucker" <[EMAIL PROTECTED]> To: [email protected] Subject: [PHP-DB] multiple database join with pdo Date: Tue, 28 Nov 2006 15:

[PHP-DB] multiple database join with pdo

is it possible to join two tables from two different databases using pdo? thanks, tate -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Where am I doing wrong - DB

Assuming $submit even has a value (Are you sure you don't mean $_POST['something'] here?) all your code does is test 2 variables, connect to the server, change to a database and set some more few variables. When do you plan to execute a query "mysql_query($sql)", or output a print or echo of some