Cant combined two mysql tables?

[kendallkamikaze]

try[if (!mysql_query($sql))
  {
echo $sql,'<br />';
echo mysql_error(),'<br />';
  die('You have already submitted a request to this association from this horse');}

and post the error

 

i dont think its that...i think it still has to do with the original code; because if you look horseid = $id and $id is also the id of the owner...i think its because theres two $id

[redarrow]

name = the submit button submit

<?php

include 'header.php';

if(isset($_POST['submit'])){

$sql="INSERT INTO assorequest (horseid, assoid, ownerid)
VALUES
('{$_POST['horseid']}','{$_POST['assoid']}','{$_POST['id']}')";

}

if (!mysql_query($sql))
  {
  die('You have already submitted a request to this association from this horse'); include 'footer.php'; exit;}

echo "<BR><BR><font size='5pt' face='comic sans ms'><B>Registration Request Submitted</b></font><BR><BR>";

?>

<?php

include 'footer.php';

?>

[kendallkamikaze]

 

name = the submit button submit

<?php

include 'header.php';

if(isset($_POST['submit'])){

$sql="INSERT INTO assorequest (horseid, assoid, ownerid)
VALUES
('{$_POST['horseid']}','{$_POST['assoid']}','{$_POST['id']'}";

}

if (!mysql_query($sql))
  {
  die('You have already submitted a request to this association from this horse'); include 'footer.php'; exit;}

echo "<BR><BR><font size='5pt' face='comic sans ms'><B>Registration Request Submitted</b></font><BR><BR>";

?>

<?php

include 'footer.php';

?>

 

"Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting '}' in /home/collegh9/public_html/one-stride/association_apply.php on line 15"

 

 

I really believe that it has to do with the other code and not this one.

[redarrow]

<?php

include 'header.php';

if(isset($_POST['submit'])){

$sql="INSERT INTO assorequest (horseid, assoid, ownerid)
VALUES
('{$_POST['horseid']}','{$_POST['assoid']}','{$_POST['id']}')";

}

if (!mysql_query($sql))
  {
  die('You have already submitted a request to this association from this horse'); include 'footer.php'; exit;}

echo "<BR><BR><font size='5pt' face='comic sans ms'><B>Registration Request Submitted</b></font><BR><BR>";

?>

<?php

include 'footer.php';

?>

[kendallkamikaze]

didnt work. it is not inserting the horse ID at all and i dont know why

[kendallkamikaze]

This portion of the code is making it so when you register it doesnt put the horse ID into the mysql table...everything but the horsesid gets inserted

 

<?php

$assoname=$_GET['assoname']; 
$assoid=$_GET['assoid']; 

$sql="SELECT * FROM horsedata  
LEFT JOIN registration ON registration.horseid = horsedata.id
WHERE Owner='$id' AND ISNULL(registration.assoname) 
GROUP BY horsedata.id";


$result=mysql_query($sql)or die(mysql_error());

while($r=mysql_fetch_array($result))
{   	

  
$horseid=$r["id"];
   $name=$r["Name"];
$assoid=$_GET['id'];
   

  
   echo "<center> 
<form action='association_apply.php' method='post'> 
<input type='hidden' value='$horseid' name='horseid'> 
<input type='hidden' value='$assoid' name='assoid'> 
<input type='submit' value='$name'></form> </center> ";

} ?>

[kendallkamikaze]

anyone ?

[kendallkamikaze]

any fresh minds  ???

[kendallkamikaze]

I've worked on this for another 2 hours today