[Resolved] placing manual variables onto page

[BEFOR]

I would like to manually place a variable amount right onto the page, so the rest of the page picks up the values.

Tried variations of this but what is the right way?

If this is table row 200 (MBatID is col name) and the table name is 'MBat':

<?php $MBatID = "200";?>

Using:

SELECT *
FROM MBat WHERE MBatID= // ?

[TheDefender]

Assuming your MBatID field is set to INT or TINYINT type...

<?php 
$MBatID = 200; //This defines it as an integer instead of a string.

$query = "SELECT * FROM MBat WHERE `MBatID`= '" . $MBatID . "'";
?>

[BEFOR]

thanks theDefender. Works nice.

[TheDefender]

YW.
Be sure to mark this thread resolved using the "Mark Thread Resolved" link below.