I am experimenting with xampp.
I used the following code
Code: Select all
<?php
// set your information.
$host = 'localhost';
$user = 'root';
$pass = '';
$database = 'dbdoc';
// connect to the mysql database server.
$connect = @mysql_connect ( $host, $user ); //, $pass ) ;
// query string
$sql = "SELECT * FROM `tblstd` WHERE `idstd` = 1 " . mysql_real_escape_string ( $_GET['ID'] );
mysql_select_db ( $database, $connect );
if ( @mysql_query ( $sql ) )
{
echo "<p>Hit</p>";
$query = mysql_query ( $sql );
$row = mysql_fetch_assoc ( $query );
echo $row['ID'] . '<br />' . $row['std_filename'] . '<br />' . $row['std_prefix'];
}
else {
die ( mysql_error () );
}
?>
Is it obvious to anybody where I am going wrong please.Hit
"; $query = mysql_query ( $sql ); $row = mysql_fetch_assoc ( $query ); echo $row['ID'] . '
' . $row['std_filename'] . '
' . $row['std_prefix']; } else { die ( mysql_error () ); } ?>
Many thanks
scriptham