php if statement

[stu]

Hi all

i have an if statement depending on results from the database. The if statments fine but its not reading the the imput right. The results is always out of stock although there is stock.

heres my code

<?php
$con = mysql_connect("localhost","user","pass123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("cart", $con);

$result = mysql_query("SELECT * FROM tbl_product
WHERE pd_id='22'");

if ($pd_qty > 0) {

// if we still have this product in stock
// show the 'Add to cart' button

?>
<form method="post" action="http://www.mydomain" target="_blank">
<select name="size ">
<option>Please select</option>
<option>small</option>
<option>large</option>
</select>

<input type="hidden" name="Title" value="Some cloathing item">
<input type="hidden" name="SerialNum" value="GAR006">
<input type="hidden" name="Price" value="27.99">

  <input name="cmd" type="hidden" id="cmd" value="1">
  <input type="submit" name="Submit" value="Add To Cart">
</form>
<?php
} else {
   echo 'Out Of Stock';
}
?>


if i delete everything above the if statement and add this $pd_qty = '22'; everything works fine

any body help with this please

thanks

stuart

[Andy]

Hi

You need another line of code before the if statement to extract a value for $pd_qty

Check out http://uk.php.net/manual/en/function.msql-result.php See the recommended functions to use.

[stu]

hi

I have a mysql result line in my code tho

$result = mysql_query("SELECT * FROM tbl_product
WHERE pd_id='22'");

so i dont really understand if i add another line in i get an error message. Sorry i'm new to php

thanks

stuart

[stu]

Hi

I've really tried and feel like i'm running round in circuls now with things i've already tried.

I've tried adding a second result into the code like so

<?php
$con = mysql_connect("localhost","lush_lush","pass123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("lush_plaincart", $con);

$result = mysql_query("SELECT pd_qty * FROM tbl_product
WHERE pd_id='22'");

string mysql_result ( resource $result , int $row [ $pd_qty ] );


if ($result > 0) {


// if we still have this product in stock
// show the 'Add to cart' button

?>
<form method="post" action="http://www.lush-lingerie.com/run/FPHPSC/ShoppingCart.php" target="_blank">
<select name="size ">
<option>Please select</option>
<option>small</option>
<option>large</option>
</select>

<input type="hidden" name="Title" value="Some cloathing item">
<input type="hidden" name="SerialNum" value="GAR006">
<input type="hidden" name="Price" value="27.99">

  <input name="cmd" type="hidden" id="cmd" value="1">
  <input type="submit" name="Submit" value="Add To Cart">
</form>
<?php
} else {
   echo 'Out Of Stock';
}
?>

<?php


I really dont get this at all

please help

thanks

stuart

[Andy]

OK, here is the way I normally extract the row data:

Code:

<?php
if ($row = msql_fetch_object($result)) {
  $pd_qty = $row->pd_qty;


}
?>

or another way:

Code:

<?php
if ($row = msql_fetch_row($result)) {
  $pd_qty = $row['pd_qty'];


}
?>

This assumes that you have a table called 'pd_qty'

 

[stu]

Hi

Thanks for your help. I dont know if I'm being thick but I really just can not do this. I can select itmes from the database arrange them how i want but i just can not get this what so ever.

What i need to do is

<?php
   
$con = mysql_connect("localhost","my user name","sum pass");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("my database", $con);

// this is the select command
// select product quanty (pd_qty) from the table (tbl_product)
//where product quanty has a product id (pd_id) of 22

$result = mysql_query("SELECT pd_qty * FROM tbl_product
WHERE pd_id='22'");

//Now this is were i get lost

// if the pd_qty is grater than zero

if ($pd_qty > 0) {

// if we still have this product in stock
// show the 'Add to cart' button

?>

<form action ........>
</form>

<?php
} else {
   echo 'Out Of Stock';
}
?>


I really can not do this. i have tried so hard but no matter what i do it doesnt work. I'm new to php and I am struggling. I understand that the if statement is one of the basics. I can do the if statement on its own but not when its being incorparated like this.

Please help

thanks

stuart