[SOLVED] sql problems

[tom232]

Im getting this error: ???
[i]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 ' Resource id #10' at line 1[/i]

what does this mean and how do i fix?

[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, ++++++);
 
  // check if username is unique
$q = "select username from users where username = '$username'";
  $result = mysql_query(" $q, $conn");
IF (!$result)
    THROW NEW EXCEPTION(mysql_error($conn));
if ($result->num_rows>0)
    throw new Exception('That username is taken - go back and choose another one.');

[/code]

[trq]

[code=php:0]
$result = mysql_query($q, $conn);
[/code]

You also need to fix this...

[code=php:0]
$conn = mysql_connect("localhost", "collegenote", "++++++");
[/code]

And dont post your password on the board, can cause all sorts of issues.

[tom232]

you need the quotations around it for the script to reconginze the server

[trq]

Variables do NOT need to be surrounded with quotes.

[tom232]

well it gives me the error: database has not been selected

[trq]

Because you have no call to [url=http://php.net/mysql_select_db]mysql_select_db[/url].

[trq]

Your next error is going to be this....

[code=php:0]
if ($result->num_rows>0)
[/code]

Should be....

[code=php:0]
if (mysql_num_rows($result) > 0)
[/code]

[tom232]

how do i use the mysql_select_db;
[i]$result = mysql_select_db($q, $conn);[/i] ??

thanks

[trq]

Did you look at the manual entry I provided a link to?

[code=php:0]
$conn = mysql_connect("localhost", "collegenote", "++++++");
mysql_select_db("yourdatabasename");
[/code]

[tom232]

oo ok thanks alot!