Thanks Mathew
I really don’t want to give up on this but I don’t know what’s the level of patience here, so far it is way more than I expected and thank you and everyone else for that.
So, based on your last reply I created and whole new test environment where some things have changed, new db is called “test”, the only table in it is called ”ttable” and there are only two fields: “name” (text) and “active” (int(1)), that’s all there is to the db.
I have noticed how I’ve been getting different behaviors with the field named “previous_employee” so that’s why I changed that to that field named “active”. Question, are there limitations when naming fields in mysql? Is there a limit on the amount of characters or can you not use _ for some reason?
I inserted your last code suggestion in my applicants.php page, this is what I can see on the browser:
(Whatever person) There are: 2 Rows of resultsArray ( [0] => 0 [active] => 0 ) 0Array ( [0] => 1 [active] => 1 ) 1
This is a test
Now, for the sake of resolving this (and just in case it is important) I’m posting the code of all 4 files relevant to this test environment
Index.php
<html>
<head></head>
<body>
<form action="insert.php" name="form" method="post">
Name: <input type="text" name="name" />
Active: Yes<input type="radio" name="active" value="1" /> No<input type="radio" name="active" value="0" />
<input type="submit" value="Send"></input>
</form>
</body>
</html>
Insert.php
<?php
$con = mysql_connect("localhost","user","pass");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("test", $con);
//$previous_employee = isset($_POST['previous_employee']) ? $_POST['previous_employee'] : '';
$sql="INSERT INTO ttable (name, active)
VALUES
('{$_POST['name']}', '{$_POST['active']}')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "Data sent";
mysql_close($con)
?>
Select.php
<html>
<head>
</head>
<body>
<?php
$con = mysql_connect("localhost","user","pass");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("test", $con);
$result = mysql_query("SELECT * FROM ttable");
?>
<p>Name | Active</p>
<?php
while($row = mysql_fetch_array($result))
{
?>
<div class='input'>
<a href="applicants.php?name=<?php echo rawurlencode($row['name']);?>">
<?php echo $row['name']; ?>
</a>
</div>
<div class='input'>
<?php echo $row['active']; ?>
</div>
<br />
<?php }
?>
<?php
mysql_close($con);
?>
</body>
</html>
Applicants.php
<html>
<head>
</head>
<body>
<?php
$con = mysql_connect("localhost","user","pass");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("test", $con);
$result = mysql_query("SELECT * FROM ttable");
?>
<?php
if(isset($_GET['name']) && !empty($_GET['name'])){
//captured the data now display contents from db
$SqlQuery = "SELECT * FROM `ttable` WHERE `name` = '".strip_tags(mysql_real_escape_string($_GET['name']))."' ";
$SqlSent = mysql_query($SqlQuery) or die(mysql_error());
//loop through returned data
while($result = mysql_fetch_array($SqlSent)){ ?>
<p><a class="name"><?php echo $result['name'];?></a>
<?php
$sql = "SELECT `active` FROM `ttable` ";
$result = mysql_query($sql) or die (mysql_error());
//check the query returns a result
if(mysql_num_rows($result) > 0) {
//see how many rows are returned
echo "There are: <b>".mysql_num_rows($result)."</b> Rows of results";
//It does, loop through the data returned
while($values = mysql_fetch_array($result)){
//debug ensure that the values exist and the names are correct
print_r($values);
//echo the value you are after no matter what its value is
echo $values['active'];
//try the 'catch'
if($values['active'] == 1) {//try with the quotes or without, result may change
echo "<p>This is a test</p>";
}
}//close while
}
else{
//no rows returned
echo "No information was recieved";
exit;
}
?>
<?php }//close while loop
}
else{
//redirect back to form as $_GET doesn't have a value
header("location: select.php");
exit;
}
?>
<?php
mysql_close($con);
?>
</body>
</html>
Hope this helps finding the problem, thanks.
