Jump to content

code that only inserts half


kendallkamikaze

Recommended Posts

<?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> ";

}?>

 

<?php

include 'header.php';

$sql="INSERT INTO assorequest (horseid, assoid, ownerid)
VALUES
('$_POST[horseid]','$_POST[assoid]','$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';

?>

Link to comment
https://forums.phpfreaks.com/topic/150600-code-that-only-inserts-half/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.