• Registered: 2007-04-14
  • Posts: 14

Topic: Don't know if I'm using the query right

I have this following code for a query on a page I am making:

$from = $db->query('SELECT username FROM '.$db->prefix.'users WHERE id='.$senderid) or error('Cannot find user', __FILE__, __LINE__, $db->error());

Let me explain it a little bit:
- I have a user's ID sent to a database. The ID saves correctly, and I've checked that. But, when I use this query to select a username from the database by the ID all I get is the result "Resource id #17". Is there something that I am doing wrong that I should edit the code by?

Thanks!

Without programming, I would have nothing to do...nahhhh
  • From: U.S.A.
  • Registered: 2005-08-26
  • Posts: 1,607

Re: Don't know if I'm using the query right

A recent post from Smartys might help you out.

Looking for a certain modification for your forum? Please take a look here before posting.