[SOLVED] query help

[tom232]

THE CODE
$result = $conn->query(" select * from user where username='$username' ");
and
$result = $conn->query("insert into user values ('$username', sha1('$password'), '$email')");

ERROR (same error)
Fatal error: Call to a member function query() on a non-object in /home/u7/collegenote/html/logtest/user_auth_fns.php on line 14

what am im missing? this has been driving me crazy

[tom232]

Heres the code

[code]<?php

require_once('db_fns.php');

function register($username, $email, $password)
// register new person with db
// return true or error message
{
  // connect to db
  $conn = mysql_connect(localhost, collegenote, OC1kl07r);
 
  // check if username is unique
  $result = $conn->query(" select * from user where username='$username' ");
  if (!$result)
    throw new Exception('Could not execute query');
  if ($result->num_rows>0)
    throw new Exception('That username is taken - go back and choose another one.');


  // if ok, put in db
  $result = $conn->query("insert into user values
                        ('$username', sha1('$password'), '$email')");
  if (!$result)
    throw new Exception('Could not register you in database - please try again later.');

  return true;
}[/code]

[Jessica]

It says $conn is not an object. mysql_connect returns a resource. It's not an object that you call a method on, it's a resource you use in a function like http://us2.php.net/mysql_query

[tom232]

so what do i need to define it as?

[corbin]

Ummm instead of
$conn->query(
You need to use mysql_query(

[tom232]

ok thanks