Syntax error?
Posted: Mon Oct 05, 2009 2:18 pm
I want to match this number (APXI12345611) against an ID on the MySQL db. But it won't work!!
Code: Select all
<?php
$link = mysql_connect("localhost","inmy","inmypasw01");
mysql_select_db("inmy_dyomails");
$query = 'SELECT * FROM dyomails';
$results = mysql_query($query);
echo "<?xml version=\"1.0\"?>\n";
echo "<dyomails>\n";
$SomeVar = "APXI12345611";
$query = "SELECT * FROM dyomails WHERE ID = '$SomeVar'";
$results = mysql_query($query);
if($line = mysql_fetch_assoc($results))
{
echo = "<item>" . $line["Email"] . "</item>\n";
}
echo "</dyomails>\n";
mysql_close($link);
?>