PHP/Databases not working

bluebellmorning

Can anyone see any errors in this code? The database is there, the table is there, and the fields are there. I've triple checked. Username/password is correct too. Nothing's showing up at all. Cheers.

<html>
<head>
<title>phantom309</title>

<?php
$db = mysql_connect("localhost","oobtube","mypassword");
mysql_select_db("oobtube_uk_db",$db);

$requete = "SELECT * FROM songs WHERE id=phantom309";
$result = mysql_query ($requete,$db);
$songs =mysql_fetch_object($result);
mysql_free_result($result);
?>
</head>
<body>
<?php echo $songs->id ?>
<BR>
<?php echo $songs->title ?>
<BR>
<?php echo $songs->lyrics ?>
</body>
</html>

ultraslacker

SELECT * FROM songs WHERE id=phantom309

That looks suspicious, as phantom309 is a string and should be quoted. Try that query in mysql client and see what happens.

bluebellmorning

I don't know what MySQL client is :rolleyes:

bluebellmorning

Oh sorry, I got it working by using id='phantom309'!

Just trying to get it working by changing the ID now, like this:

$requete = "SELECT * FROM songs WHERE id=".$id";

But I'm now getting a parse error on that line...

bluebellmorning

Got it working using

$requete = "SELECT * FROM songs WHERE id='$id'";

Sorry for bothering you 🙁

oops