Jump to content


Photo

Selecting Prohibiting Echoeing


  • Please log in to reply
2 replies to this topic

#1 shortkid422

shortkid422
  • Members
  • Pip
  • Newbie
  • 8 posts

Posted 18 December 2003 - 08:18 PM

Why wont the $price get echoed like i want it to when I select it?
<?    include("misc.inc");  $connection = mysql_connect($host,$user,$password)       or die ("couldn\'t connect to server");  $db = mysql_select_db($database,$connection)       or die ("Couldn\'t select database");  $query = "SELECT * FROM flights ORDER BY \'price\'";  $result = mysql_query($query)       or die ("Couldn\'t execute query.");         echo "$price <br>";?>

Need some php work thats cheap and reliable?[br]AIM shortmonkey422[br]MSN shortkid422@hotmail.com[br]Email: shortkid422@hotmail.com

#2 shivabharat

shivabharat
  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 18 December 2003 - 10:23 PM

$query = \"SELECT * FROM flights ORDER BY \'price\'\";


Whats price ? here

you should have used $price in your query if its being collect from another form.

also when collecting values from a form you need to use the $_POST or $_GET. Enusre that you are collecting the value.
Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks

#3 shortkid422

shortkid422
  • Members
  • Pip
  • Newbie
  • 8 posts

Posted 18 December 2003 - 11:25 PM

this is just from the database. Price is an integer value.
Need some php work thats cheap and reliable?[br]AIM shortmonkey422[br]MSN shortkid422@hotmail.com[br]Email: shortkid422@hotmail.com




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users