--- Ligaya Turmelle <[EMAIL PROTECTED]> wrote:
> Think I found it. I made the changes with
> explanations of what I did.
> If you have any further questions feel free to ask.
> Oh and this should
> be on the list for others to see and maybe learn
> from
Wow, thanks so much for going to all th
Think I found it. I made the changes with explanations of what I did.
If you have any further questions feel free to ask. Oh and this should
be on the list for others to see and maybe learn from
Respectfully,
Ligaya Turmelle
[DATABASE CONNECTION]
Country
> -Original Message-
> From: David Blomstrom [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 10, 2004 4:08 PM
> To: [EMAIL PROTECTED]
> Subject: SQL Syntax Problem
>
> $sql = 'SELECT
> F.IDArea,
> C.IDArea, C.Name, C.Pop, C.Nationality,
> C.NationalityPlural, C.NationalityAdjective
First echo out the SQL and verify it is what you are expecting. If it
isn't try changing it to:
$sql =
'SELECT F.IDArea,
C.IDArea,
C.Name,
C.Pop,
C.Nationality,
C.NationalityPlural,
C.NationalityAdjective
FROM cia_people C, famarea2 F
WHERE (C.Nati
It's not translating your vars to their respective values.
I didn't look to see why...
But MySQL doesn't know what
$_POST['order']
is.
David Blomstrom wrote:
This may be a purely PHP problem, but the error
message says "SQL syntax. Check the manual that
corresponds to your MySQL server version.
