creating column names from variables

[hundredacres]

i am trying to enter a record into a mysql db. i am trying to pass variables for column names and keep getting error messages -

Can't execute resident query: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

anyone have any suggestions or thoughts?

thanks,

matt

<?php

// open connection
include('../connects/connect.php');

if(isset($_POST['submit']))
{
$party_string = "VALUES('','$dj',".$party_string.")";
$sql = "INSERT INTO table VALUES ('','$dj','$style','$affiliations','$urls')" or die("Insert table Error: ".mysql_error());
$result = mysql_query($sql) or die ("Can't execute query: ".mysql_error());
$resident = "INSERT INTO table1 ".$party_string."" or die("Insert residency table Error: ".mysql_error());
$residentresult = mysql_query($resident) or die ("Can't execute resident query: ".mysql_error());
}
else
{

$partyresult = mysql_query("SELECT * FROM table");
$partynameresult = mysql_query("SELECT `party_name` FROM table");
$party_num_rows = mysql_num_rows($partynameresult);
?>
<form action="<?php echo $PHP_SELF ?>" method="post" name="EventAdd" id="EventAdd">        

  <table width="500" border="0">
    <tr> 
      <td><div align="right">Name :</div></td>
      <td><input name="dj" type="text" id="dj" size="20"> </td>
    </tr>
    <tr> 
      <td><div align="right">Style :</div></td>
      <td><input name="style" type="text" id="style" size="20"> </td>
    </tr>
    <tr> 
      <td><div align="right">Affiliations :</div></td>
      <td><input name="affiliations" type="text" id="affiliations" size="50"> 
      </td>
    </tr>
    <tr> 
      <td><div align="right">URL's :</div></td>
      <td><input name="urls" type="text" id="urls" size="50"> </td>
    </tr>
    <tr> 
      <td><div align="right">Parties :</div></td>
      <td class="graytext14px">
	<? 

	$count=1;
	$party_string = "";
	while(($partynamerow = mysql_fetch_array($partynameresult)) && ($count < $party_num_rows)) {
	$party_string = $party_string."'$".$partynamerow["party_name"]."',";
	$count++;
	}
	$party_string = $party_string."'$".$partynamerow["party_name"]."'";

	echo $party_string;
	while($partyrow = mysql_fetch_array($partyresult)) {
 ?>
  <input name="<? echo $partyrow["party_name"];?>" type="radio" value="1"><? echo $partyrow['party_name']; ?><br>
  <?
  }
  ?>
 </td>
</tr>

<tr> 
  <td align="right"><input name="submit" type="submit" id="submit" value="submit"></td>
  <td align="left"><input name="reset" type="reset" id="reset" value="reset"></td>
</tr>
  </table>
      </form>
</td>
  </tr>
</table>
</html>

[Weedpacket]

Try echoing the SQL statement that's causing the problem.

[hundredacres]

i have and it is formatted correctly.

echo $party_string; = '$Illumination','$Mirage','$Neulight','$Secret Pyschedelica','$Sunkissed','$Sunmade'

it should work.

[Weedpacket]

Originally posted by hundredacres
i have and it is formatted correctly.

echo $party_string; = '$Illumination','$Mirage','$Neulight','$Secret Pyschedelica','$Sunkissed','$Sunmade'

it should work.

Er, no, I said the SQL query. The whole thing. The string that actually gets sent to MySQL.

[hundredacres]

this is what it prints:

INSERT INTO illum_artist_residency VALUES('','bld','')

it seems the variable $party_string isn't being passed to the mysql statement.