SELECT not working for me

[qhiiyr]

Hello, I'm trying to use SELECT to get a certain entry from my database. I've connected to it and everything (INSERT works), but for some reason MySQL says my query isn't right. Here's my code:

 

($name and $desc are set fine)

 

	$query = mysql_query("SELECT id FROM nodes WHERE name = '" . $name . "' AND desc = '" . $desc . "'");
$node = mysql_fetch_assoc($query);

 

I'm pretty sure it's some stupid mistake I'm overlooking somewhere. What I'm trying to do here is actually get the id of the entry I just INSERTed a line earlier (id is auto-incrementing), so if there's a way to do that simpler and more reliably, that would help a lot.

 

Thanks for any help!

[effigy]

Use mysql_insert_id. Always pass variables through mysql_real_escape_string when placing them in SQL.