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

2006-11-28 Thread Dwight Altman
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

[PHP-DB] multiple database join with pdo

2006-11-28 Thread C. Tate Baumrucker
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] multiple database join with pdo

2006-11-28 Thread Bastien Koert
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: php-db@lists.php.net Subject: [PHP-DB] multiple database join with pdo Date: Tue, 28 Nov 2006

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

2006-11-28 Thread Chris
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/ --

[PHP-DB] Wrong SQL Syntax

2006-11-28 Thread Chris Carter
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',

Re: [PHP-DB] Wrong SQL Syntax

2006-11-28 Thread Chris
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',