PHP noob

[.Jamie]

Halp me please - I'm trying to select the title of a blog and post it - but the code keeps erroring me and I don't know why :/ I've taken the code like directly from w3schools and just changed my bits

<?php
$con = mysql_connect("localhost","*****","*****");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("*****", $con);

$result = "SELECT * FROM 'wp_posts' ".
"ORDER BY 'post_date' DESC LIMIT 0,1";

while($row = mysql_fetch_array($result))
  {
  echo $row['wp_title'];
  }

mysql_close($con);
?>

And the error is

Warning:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /file.php on line 22

Line 22 is this one

while($row = mysql_fetch_array($result)) 

Thanks in advance

.Jamie Reviewed by .Jamie on 20th Oct 2009. PHP noob Halp me please - I'm trying to select the title of a blog and post it - but the code keeps erroring me and I don't know why :/ I've taken the code like directly from w3schools and just changed my bits <?php $con = mysql_connect("localhost","*****","*****"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("*****", $con); Rating: 5

[CyberJ37]

Here, try this.

<?php
$con = mysql_connect("localhost","*****","*****");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("*****", $con);

$result = mysql_query("SELECT * FROM 'wp_posts' ".
"ORDER BY 'post_date' DESC LIMIT 0,1");

while($row = mysql_fetch_array($result))
  {
  echo $row['wp_title'];
  }

mysql_close($con);
?>

[.Jamie]

Thanks - Both you and __Doc_ Fixed it,

1000 internets to you both

Someone can close this now