trying to get a variable

[timmybuck]

Hi guys,

this code below isnt working and im not getting an error message

any ideas

<?php
$EventID=$_POST['EventID'];

mysql_connect('localhost', 'phpuser', 'phpuser03')or die ("Database connection error");

mysql_select_db('booking');

$sql = "SELECT Price FROM ticket WHERE EventID='EventID'";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result))
{
echo $row['Price'];
}
?>

[adi]

Try using

select * from  ticket 

instead of

select * from  'ticket' 

[timmybuck]

doesnt work

i get an error message
although not through doing what yopu suggested.

here is my code

<?php
$EventID=$_POST['EventID'];

mysql_connect('localhost', 'phpuser', 'phpuser03')or die ("Database connection error");

mysql_select_db('booking');

$sql = "SELECT ticket.Price FROM ticket WHERE EventID=$EventID";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result))
{
echo $row['Price'];
}

?>

my error message is

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Program Files\Apache Group\Apache2\htdocs\m82\availabletickets.php on line 18

[adi]

$sql = "SELECT ticket.Price FROM ticket WHERE EventID=' $EventID' ";

[ucbones]

<?php 
$EventID=$_POST['EventID']; 
mysql_connect('localhost', 'phpuser', 'phpuser03')or die ("Database connection error"); 

mysql_select_db('booking'); 

$sql = "SELECT Price FROM ticket WHERE EventID='".$EventID."'"; 
$result = mysql_query($sql); 
while($row = mysql_fetch_array($result)) { 
 echo $row['Price']; 
} 
?>

Just the same as above, but change $EventID to ".$EventID." to make the query run slightly faster. I also find it easier to read personally, but that's just me!

HTH,

ucbones

[timmybuck]

thanks guys got it working, it was becuase i wasn't passing the variable from the previous page.

thanks for the comments