while loop returning error in MYSQL

[daliren]

I am stumped as to why this isn't working. The table cell displays this error message:

Supplied argument is not a valid MySQl result resourse in ~/mydoc line ***

Here's the code: it works in other places, why not here?

<td rowspan="4" valign="top" align="left" width="350"><fieldset><legend>
Licenses/legend>
<!-- get list of licenses from database -->
<?php
$license = mysql_query("Select ID, Name from License");
while ($lic = mysql_fetch_array($license)) {
$id = $lic["ID"];
$type = htmlspecialchars($lic["Name"]);
echo("<input type='checkbox' name='ltypes[]' value='$id'>$type");
} ?></fieldset>
</td>

[Eric.Coleman]

Are you connected to the database?

[daliren]

I thought I was, but once I stuck another connect command right in front of my query, bingo!

[Eric.Coleman]

Originally posted by daliren
I thought I was, but once I stuck another connect command right in front of my query, bingo!

Glad I could help... the amount of posts here are intimidating.. I have had an account here for some time.. just to afraid to post heh...

[Defender1]

Yea, sitepoint is a popular site.
i just fish through the stuff i (think) i know and answer

[Eric.Coleman]

Originally posted by Defender1
Yea, sitepoint is a popular site.
i just fish through the stuff i (think) i know and answer

Im normally reading there articles

Or emailing Kevin Yank, to ask him question, which let me tell you, Him and Matt were both great people to talk to, as well as a HUGE HELP!

Thanks you guys

[Defender1]

I've only seen kevin around the forums 3 times

[Eric.Coleman]

Originally posted by Defender1
I've only seen kevin around the forums 3 times

That's why i used email

[RKuhle]

Originally posted by Defender1
I've only seen kevin around the forums 3 times

He used to pop in every other night or so and would answer quite a few questions. Must be busy working on another book!

[Defender1]

or an article for the site

[Eric.Coleman]

Originally posted by RKuhle

He used to pop in every other night or so and would answer quite a few questions. Must be busy working on another book!

Let's hope so.. ohh wait.. NOOO! I haven't orderd my copy of the first one yet...

/me wacks head against wall repeatedly