Bad syntax
Hi, I've cloned a database to a new server that uses V.4.0.25 and it's choking up when given the query to join two tables and output a combined data printout.
Here's the query:
<?php
mysql_select_db($database_connection1, $connection1);
$recordID = $_GET['recordID'];
$query_Recordset1 = "SELECT * FROM leadgen.contact LEFT JOIN leadgen.detail ON contact.id=detail.did WHERE contact.id = $recordID";
$Recordset1 = mysql_query($query_Recordset1, $connection1) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
Tech support tells me it's syntax but offers no clue as to the proper syntax. I also have no idea what version of mysql the orginal is written for. Any help would
be greatly appreciated.
Subject
Views
Written By
Posted
Bad syntax
5361
July 30, 2007 09:19AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.