MySQL Forums
Forum List  »  Full-Text Search

Bad syntax
Posted by: dan thurman
Date: July 30, 2007 09:19AM

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.

Options: Reply• Quote


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.