Addposts.php:
Code:<?php $query="SELECT * FROM Skills"; $result=mysql_query($query) or die( "Unable to do query"); $num=mysql_num_rows($result); if ($num==0) { echo "The database contains no skills"; } else { $i=0; while ($i < $num) { $skillid=mysql_result($result,$i,"Skillid"); $skillname=mysql_result($result,$i,"Skillname"); echo "<input name='skills[]' type='checkbox' onclick='this.form.txt$skillname.disabled = !this.checked' value='$skillid' checked>$skillname: <textarea rows='3' cols='20' name='txt[$skillname]'></textarea><br />"; $i++; } mysql_close(); } ?>
and then I call it like this:
Postme.php
(top)
And further down;Code:$skills=$_POST['skills']; $txt = $_POST[ "txt" ];
Code:$query="SELECT Postid FROM Posts WHERE Userid='$user' && Title='$title'"; $result=mysql_query($query) or die( "No Postid"); $postid=mysql_result($result,$i,"Postid"); if( isset($skills)) // if none are checked, will be false { foreach($skills as $skillid) // loop each checked box { //$comment = $txt[$skillid]; $query = "INSERT INTO Skillsrequired VALUES ('', '$postid','$skillid','$txt[$skillid]')"; mysql_query($query); } }




Reply With Quote