Jump to content


Photo

Resource ID's PHP/SQL?


  • Please log in to reply
2 replies to this topic

#1 scottybwoy

scottybwoy
  • Members
  • PipPipPip
  • Advanced Member
  • 532 posts
  • LocationUK

Posted 28 September 2006 - 09:58 AM

Hi All,

What is a Resource ID?  I see them popped up here and there and don't really know what they are?  I searched on the net and found no meaning, once again they popped up with no explanation.  So I thaught some of you clever people would know.  Are they what php uses to locate a result of an SQL query, or are they bad?

Thanks in advance

#2 HuggieBear

HuggieBear
  • Members
  • PipPipPip
  • Advanced Member
  • 1,899 posts
  • LocationEngland, UK

Posted 28 September 2006 - 10:27 AM

Yes that's correct,

When you use mysql_query() a Resource ID is returned from it, ultimately it's a 'results table'.

Try checking this link out?

Regards
Huggie
Advice to MySQL users: Get phpMyAdmin and test your queries work there first, take half the hassle out of diagnosis, also check the reserved words list.

Links: PHP Docs :: RegEx's :: MySQL :: DevGuru :: w3schools

#3 scottybwoy

scottybwoy
  • Members
  • PipPipPip
  • Advanced Member
  • 532 posts
  • LocationUK

Posted 28 September 2006 - 12:24 PM

Thanks again Huggie,

Much clearer now.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users