Select from db

[forumnz]

Heres my code followed by the error. Any idea? Thanks, Sam.

 

<?php
include('connectdb.php');

$id = "100000";

$result = mysql_query("SELECT * FROM fflists WHERE id=`$id` AND active="1" LIMIT 1");

while($row = mysql_fetch_array($result))
  {
  $business_name = $row['business_name'];
  }

mysql_close($con);

?>

 

Error:

 

Parse error: syntax error, unexpected T_LNUMBER in /usr/local/www/vhosts/foodfinder.co.nz/httpdocs/Browse/Listing/listinginfo.php on line 6

 

[teng84]

here is your error

$result = mysql_query("SELECT * FROM fflists WHERE id=`$id` AND active="1" LIMIT 1");

 

should be

$result = mysql_query("SELECT * FROM fflists WHERE id=`$id` AND active='1' LIMIT 1");

[Nhoj]

$result = mysql_query("SELECT * FROM fflists WHERE id=`$id` AND active="1" LIMIT 1");

 

That query is rather messed up in a multitude of ways...

 

Try this:

$result = mysql_query("SELECT * FROM `fflists` WHERE `id`={$id} AND `active`='1' LIMIT 1");