PHP - Textbox Retrieval From Db

I can't get it to use the item that is selected in the drop down box as the variable $va in the bit where it then queries the data base to retrieve only the line in the able that match the program_name with variable $va. variable $va would be the result of the drop down box.

Below is the code i have so far, any help would be appreciated.

Cheers.

Code: [Select]
<?php
include ('dbConn.php');

mysql_select_db($dbselect, $con);

$QuerySelects = "SELECT program_name FROM program_names";
$Query = mysql_query($QuerySelects) or die (mysql_errno() . ": " . mysql_error(). "\n");

echo '<label>Select Sto </label>';
echo '<select id="program_name"  name="program_name">';
echo '<option value="va">Select Store</option>';
 
while ($row = mysql_fetch_assoc($Query))
{
$va = $row['program_name'];
echo "<option value=''>$va</option>";
}
echo '</select>';



$QuerySelects1 = "SELECT * FROM offers1 WHERE end_date>CURDATE() AND program_name = '$va'";
$Query1 = mysql_query($QuerySelects1) or die (mysql_errno() . ": " . mysql_error(). "\n");



while($result=mysql_fetch_assoc($Query1)) {
include ('variables.php');
echo"
<div class='spacerbox'>
<div class='outerbox eviecodes'>
<div><div class='topbox'>
<div class='leftbox'>
<div class='offerimage'>
<div class='progdiv'><a class='progname' href=".$url." target='_blank'>".$program_name."</a></div>
</div>
</div>
<div class='rightbox'><div class='descbox boxwidth'><h1>
<a href=".$url." target='_blank'>".$description." at ".$program_name."</a></h1></div>
<div class='voubox boxwidth'><h2 class='vvv'>Voucher Code:<span class='vcode'>".$code."</span ></h2></div>

</div>
</div>
<div class='linkbox boxwidthl'>
<a href=".$url." target='_blank'>To Take Advantage of this offer at <span class='prodname'>".$program_name."</span>, click here!</a>
</div>
<div class='expires'>
<span class='end'>Expires:</span> <span>".$dateformat."</span >
 </div>
<div class='socialbox'>
{module Tell A Friend Module}
</div></div>
<div class='spacer'>
</div>
</div>
</div>
";
}
?>

I'm going bananas with one of those issues where it looks like everything is right but the code won't work.  I've included a script below that fetches data from a database and creates a drop down menu.  I'm trying to use a field called "gone" and enter 'gone' in that field when I want to delete the row but be able to retrieve it by making the field empty.  There is something in the WHERE clause of my sql that is screwing things up.  I get nothing retrieved with any of the WHERE clauses below.  Interestingly, when I take the where clause out completely, I get the rows that have no 'gone' in them.

The code is below.  None of the following in the included code get me a result.  All of them return nothing.  I also don't get any errors. Just nothing.

WHERE gone != 'gone'

WHERE gone <> 'gone'

WHERE gone = ''

WHERE gone = 'gone'

Without the WHERE clause it runs fine.

As a work around I tried using

if($row['gone'] == 'gone')  { continue;}

In the while.. function at the end of the file to bypass rows with 'gone' in the field.  It also stopped the script.

Here's my code:

<?php // person_selectall.php

/** Create new pdo object */

require 'Db.php';

//$sql = "SELECT person_id, fname, lname FROM Persons";
$sql = "SELECT * FROM Persons WHERE gone = ''";

$stmt = $pdo->prepare($sql);
$stmt->execute();

echo "<p><select class=\"select-field\" name=\"person_id\" >\n";

while ($row = $stmt->fetch()) {  
    
    $name = $row['fname'] . ' ' . $row['lname'];
    echo "<option value=\"" . $row['person_id'] . "\">" . $name . "</option>\n";
    
    }
    
echo "</select>";

?>

 

I am just starting php and attempting a simple program that will retrieve some data from an array

I have 2 files one with the function containing the array, another with the code that should select a value from the array. I have done what I thought would work however it does nothing. Any help would be greatly appreciated

function.php
<?PHP
function getMonthName(){
    $a=array("one","two","three","four","five");
    print_r($a);
}
?>

retrieve.php
<?PHP
require_once('functions.php');
$number=3;

if ($number == $a) {
    echo "$a";
}
?>

Hello, 

Hi I am currently making a site where users can upload second hand books for sale, I have everything working as i wish apart from i am having trouble creating a account page where users can review the books they have posted.

so far i use the following code to bring view a the data associated with an uploaded book based on its id

Code: [Select]
  public static function getById( $id ) {
    $conn = new PDO( DB_DSN, DB_USERNAME, DB_PASSWORD );
    $sql = "SELECT * FROM books WHERE id = :id";
    $st = $conn->prepare( $sql );
    $st->bindValue( ":id", $id, PDO::PARAM_INT );
    $st->execute();
    $row = $st->fetch();
    $conn = null;
    if ( $row ) return new Book( $row );
  }

I think i can use a similar function for my user account however, each book entered by a user has their member id attached to it, which is gained from there id in the members table which in turn is stored in $_SESSION['id']. My question is, is there a way to rework the code above to have something like select * where member_id = $_SESSION['id']. I have tried a few things and get stuck manly due to the fact i dont know what to replace the current :id with.

Thanks in advance, i hope i explained it well enough for you lot to understand.

Ian