Basic Query

[grantf]

is anything obviously wrong with this? when i run it this is the output...

 

Result = ''

 

 

 

<?php

$link = mysql_connect("localhost","root","password");

if (!$link)

  {

  die('Could not connect: ' . mysql_error());

  }

 

  $db_selected = mysql_select_db('db1', $link);

  if (!$db_selected) {

die ('Can\'t use db1 : ' . mysql_error());

}

 

$name = "John Smith";

$result = mysql_query('SELECT email FROM people where name = $name');

print "Result = '$result'";

?>

[trq]

mysql_query returns a result resource on success or false on failure. There is no point simply echoing it.

 

You will wont something more like....

 

<?php

// connect to db.

$sql = "SELECT email FROM people WHERE name = '$name' LIMIT 1";
if ($result = mysql_query($sql)) {
  if (mysql_num_rows($result)) {
    $row = mysql_fetch_assoc($result);
    echo "Result = '{$row['email']}'";
  }
}

?>

 

ps: This board is for help specifically with mysql issues, next time, this type of question belongs in php help.

[grantf]

Thanks a lot.. sorry will post in the other section.