[RESOLVED] mysql error?

[Beffic]

so I was trying to script in the Phone Number and Email of my client through the database. But every time I do a query I get this error message.

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Default' at line 1"

now line one is just the <?php line so this is my query and I hope you guys can help. Thanks.

<?php
include("connect.php");
$query="SELECT Email FROM Default"; 
$Email=mysql_query($query) or die(mysql_error());
$querty="SELECT PhoneNumber FROM Default"; 
$PhoneNumber=mysql_query($querty) or die(mysql_error());
?>

[laserlight]

Considering that DEFAULT is a keyword, perhaps you should write:

$query="SELECT Email FROM `Default`";

[Desbrina]

try putting back ticks around default so it'd be

<?php
include("connect.php");
$query="SELECT Email FROM `Default`";
$Email=mysql_query($query) or die(mysql_error());
$querty="SELECT PhoneNumber FROM `Default`";
$PhoneNumber=mysql_query($querty) or die(mysql_error());
?> 

[Beffic]

Wow thanks! That helped. Now why is the result information showing as "E-mail: Resource id #3"

[Beffic]

never mind. Fixed my problem with a fetch array. Thanks again guys.

[laserlight]

What did you try? For example:

<?php
include 'connect.php';
$query = "SELECT Email, PhoneNumber FROM `Default`";
$result = mysql_query($query) or die(mysql_error());
if ($row = mysql_fetch_assoc($result))
{
    echo htmlspecialchars($row['Email'])
        . htmlspecialchars($row['PhoneNumber']);
}
else
{
    echo 'No rows retrieved';
}
?>