|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Codewalkers Forums Sponsor:
|
|
|
|
#1
November 29th, 2003, 04:14 AM
|
|||
|
|||
|
query help please
Here is my query
$sql = "SELECT * FROM ap_data WHERE ap_unique_id = '$ap_unique_id' "; echo $sql; $result = mysql_query ( $sql, $connection ) or die ( "Could Not Do Query" .mysql_error()); I echoed $sql to see what is was and it looks ok This is the error I get SELECT * FROM po_data WHERE ap_unique_id = '605daf694d96adf86b059b44e8cd1516' Could Not Do Query Unknown column 'ap_unique_id' in 'where clause' The column ap_unique_id is really there and it is spelled correctly
|
|
#2
November 29th, 2003, 10:24 AM
|
|||
|
|||
|
RE: query help please
I noticed that you have two different tables (ap_data and po_data) in your query and in the echoed $sql.
It seems that one of them doesn't have the column. Otherwise it looks ok to me.
|
|
#3
November 29th, 2003, 02:00 PM
|
|||
|
|||
|
RE: query help please
no, I tried changing names of everything in case that would help. I just copy and pasted the wrong version of the error, but the error are the same. I can't understand it. A simple query and it don't work
|
|
#4
November 29th, 2003, 03:21 PM
|
|||
|
|||
|
RE: query help please
Can you post your data models, please?
In MySQL, type: Code:
describe ap_data; describe po_data;
|
|
| Viewing: Codewalkers Forums > Other Technologies > Database Help > query help please |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
