PHP - Basic Problem With Isset

I'm having a problem where when I click the "use" link it only displays my check message which is "Hey", but for some reason I have to click it again for my queries to work. Here's a pick: .

Here's the code:
Code: [Select]

<?php

if(isset($_SESSION['user'])){

include_once('connect.php');

$session = $_SESSION['user'];

echo "
<br/>
<div class='profile-general-stats'>
<table>

<th>Item Name</th><th>Description</th><th>Use/Sell</th>
";

$yo = "SELECT * FROM player_items WHERE Username = '$session' ORDER BY id ASC";
$check = mysql_query($yo) or die (mysql_error());
$num_of = mysql_num_rows($check);

if($num_of > 0){

while ($is = mysql_fetch_array($check)){

$item_id = $is['id'];
$item_name = $is['Name'];
$item_type = $is['Type'];
$item_value = $is['Value'];
$item_description = $is['Description'];
$item_sell_value = $is['Sell_Price'];

echo "

<tr>

<td align='left' style='padding: 5px; padding-left: 25px;'><strong>$item_name</strong></td>
<td align='left' style='padding: 5px;'>$item_description</td>
<td align='middle' style='padding: 5px;'><a href='?use&id=$item_id&name=$item_name&type=$item_type&value=$item_value'>Use</a>&nbsp;|&nbsp;<a href='#sell_$item_name' id='$item_id'>Sell</a></td>

</tr>

";

}
 
 }else{
 
 echo "
 <tr>
 
 <td align='left' style='padding: 5px; padding-left: 25px;'>No Items</td>
<td align='left' style='padding: 5px;'>No Items</td>
<td align='middle' style='padding: 5px;'>No Items</td>
 
 </tr>
 ";
 
 }
 
  echo "
 </table>
 </div>
 ";
 
 if(isset($_GET['use'])){
 
 echo "Hey";
 
 $use_id = $_GET['id'];
 $use_name = $_GET['name'];
 $use_type = $_GET['type'];
 $use_value = $_GET['value'];
 
 if($use_type == "Credits"){ $use_type = "Current_Credits"; }
 
 $check_item =  "SELECT id FROM player_items WHERE id = '".mysql_real_escape_string($use_id)."' AND Username = '".$_SESSION['user']."'";
 $run_check = mysql_query($check_item) or die(mysql_error());
 $num_check = mysql_num_rows($run_check);
 $e = mysql_fetch_array($run_check);
 
 $item_stat = "SELECT `".$use_type."` FROM stats WHERE Username = '".$_SESSION['user']."'";
 $run_stat = mysql_fetch_array(mysql_query($item_stat)) or die (mysql_error());
 
 $new_stat = $run_stat[''.$use_type.''];
 
 if($num_check == 1){
 
$new_stat = $new_stat + $use_value;

mysql_query("UPDATE stats SET `".$use_type."` = '".mysql_real_escape_string($new_stat)."' WHERE Username = '".mysql_real_escape_string($_SESSION['user'])."'") or die(mysql_error());
mysql_query("DELETE FROM player_items WHERE id = '$use_id'") or die(mysql_error());
 }else{
 }
 
 }else{
 }
 
}else{

header("Location: index.php");

}

?>

Hey,

I've got a site and I need to query a database to check if there is a result. If there isnt then I need a default result...


//Check the database and get a result
$skinName = strtolower(get_post_meta($post_id, $key, $single));


if (isset($skinName)) 
{ 
//If there is a result, then use it
$skinName = strtolower(get_post_meta($post_id, $key, $single));
} else {
//If NO result then use RED
$skinName = 'red';
}

//Build up the var to show REDsite
$skinName = $skinName . 'site';

For some reason the above doesnt work.
If there is a result then it uses it, however if there is no result then it simply shows "site" - not "redsite" like it should do.

Any ideas what I missed?

Hi guys

I am trying to create a page where if a selection has not been made then a jump menu is displayed listing all of the fixtures for a season, if a selection has been made then at present I want it to show Enter match info, however when a match is selectd it goes to a yahoo search page, as if the page cannot be found, the code I have used is below, any ideas what I have done wrong?

The page can be seen at www.yardleyheroes.co.uk/admin/edit_result.php

Code: [Select]
<h1>Submit Results</h1>
    <?php
if (isset ($_GET['match_id']))
{
echo('Enter match info');
}
else
{
$con = mysql_connect('localhost', 'user', 'password', true);
if(!$con)
{
      die('Could not connect: ' . mysql_error());
}
mysql_select_db('dbname', $con);
echo('<form name="form" id="form">');
    echo('<select name="jumpMenu" id="jumpMenu" onChange="MM_jumpMenu(\'parent\',this,0)">');
$fixtures=mysql_query('SELECT * FROM `fixtures` where current=1 ORDER BY `match_date`');
if(mysql_num_rows($fixtures)==0) 
echo('<option>there is no data in table..</option>');
else
echo('<option selected="selected">Please select the match</option>');
{
while($matchrow=mysql_fetch_assoc($fixtures))
{
echo ('<option value="edit.php?match_id='.$matchrow['match_id'].'">'.date("d-M-Y", strtotime($matchrow['match_date'])).'|'.$matchrow['Opposition']."</option>");
}
}
echo('</select>');
echo('</form>');
}
?>
[/cod]

Hi guys, first time posting here.

Anyway, heres my problem.

I have this section of code at the beggining of my page:

Code: [Select]
if (isset($_POST['userChoice'])) {
  $try = check_word($_POST['userChoice']);
  echo ("We are into the loop");
}
else {
  echo ("<br/>about to call change word");
  changeword();
  echo ("<br/> we called the changeword");
}

And here is my form:
Code: [Select]
<html>
    <head>
    </head>
    <body>
        <form name="wordguess" action="Index.php" method="POST">
        <table>
            <tbody>
                <tr>
                Try to guess what the following word is: <?=$scrambled ?> <br/>
                </tr>
                 <tr>
                Your Guess: <input type="text" id="userChoice" size="20" /> <br/>
                </tr>
                <tr>
                <td>
                    <input type="submit" name="submit" id="submit" value="Submit">
                </td>
                </tr>
                <tr>
                   <?=$correct?>
                </tr>
            </tbody>   
        </table>
        </form>
    </body>
</html>'

Now, how i assumed it worked was that the first time the page is loaded it would display the form and that's it. However, even when they hit the submit button on the form, its not really doing the POST, so when the page reloads, gives me the same stuff so it always goes on the else part of the if.

Any help would be appreciated.

Thanks,
GoodVibe

I am an absolute beginner in php & am trying to validate a form using javascript.
Problem is I am checking if the textbox is left empty before the user clicks on the submit button(using javascript).
On the other hand i'm using isset function of php for the same submit button so that it does not run the code unless and until the button is clicked. Due to this, the default value of text box is being entered into database. How do i prevent this?
Is there an alternate function to isset for such an event?

Here is a sample code
Code: [Select]
<?php
if(isset($_POST[sub]))
$sql="insert into testing values('$_POST[txt1]')";
$exec = mysql_query($sql);
?>

<script type="text/javascript">
function check()
{
var a = document.getElementById('add');
if (a.value = "")
{
return false;
}
}
</script>

<form action="add.php" method="post">
<input type="text" name="txt1" id="add"><br>
<input type="submit" name="sub" value="Click to Add" onclick = "check();">
</form>



I'm using ghost text technique on my page instead of labels so the text boxes have different values at different instances and hence I cant use !empty function either.
How do i unset the submit button so that it does not run the script further?