Selecting ID

[Exchange_Safe]

Hi there,

I am having a bit of trouble here.

Here is the code that is troubling me:

$id = mysql_query("SELECT id FROM cases WHERE reportername = '$reportname'")
or die(mysql_error());

You see, that is selecting the ID (primary key, auto_increment) from the database and sticking it to the var.

This is where I am outputting it:

While you wait, you may view the status of your case at anytime by using
our tracking form on the front page of this site. Your case number is: <b><? echo $id; ?></b>.

Now, this is how it outputs, regardless of the ID that is actually in the database:

While you wait, you may view the status of your case at anytime by using
our tracking form on the front page of this site. Your case number is: Resource id # 3.

Also, when I go into phpMyAdmin and execute the query there, it shows the actually ID. I have no clue how to fix this. Any ideas?

Thanks,

• Michael

[drew010]

you must call [man]mysql_fetch_array[/man] or one of the similar functions to be able to fetch the data from the query. they provide examples on that page of how it works.

[toplay]

Yes, and here's another example if you need it:
http://www.phpbuilder.com/board/showpost.php?p=10648003&postcount=4

🙂