SitePoint Sponsor |
|
User Tag List
Results 1 to 11 of 11
-
Nov 13, 2001, 00:12 #1
while loop returning error in MYSQL
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>cheers,
Darren Cassidy
-
Nov 13, 2001, 00:17 #2
- Join Date
- Jun 2001
- Location
- In your basement
- Posts
- 1,268
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Are you connected to the database?
Eric Coleman
We're consentratin' on fallin' apart
We were contenders, now throwin' the fight
I just wanna believe, I just wanna believe in us
-
Nov 14, 2001, 18:27 #3
bingo
I thought I was, but once I stuck another connect command right in front of my query, bingo!
cheers,
Darren Cassidy
-
Nov 14, 2001, 18:58 #4
- Join Date
- Jun 2001
- Location
- In your basement
- Posts
- 1,268
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Re: bingo
Originally posted by daliren
I thought I was, but once I stuck another connect command right in front of my query, bingo!heh...
Eric Coleman
We're consentratin' on fallin' apart
We were contenders, now throwin' the fight
I just wanna believe, I just wanna believe in us
-
Nov 14, 2001, 21:51 #5
- Join Date
- Apr 2001
- Location
- My Computer
- Posts
- 2,808
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Yea, sitepoint is a popular site.
i just fish through the stuff i (think) i know and answer
-
Nov 14, 2001, 22:50 #6
- Join Date
- Jun 2001
- Location
- In your basement
- Posts
- 1,268
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Originally posted by Defender1
Yea, sitepoint is a popular site.
i just fish through the stuff i (think) i know and answer
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 guysEric Coleman
We're consentratin' on fallin' apart
We were contenders, now throwin' the fight
I just wanna believe, I just wanna believe in us
-
Nov 14, 2001, 23:12 #7
- Join Date
- Apr 2001
- Location
- My Computer
- Posts
- 2,808
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
I've only seen kevin around the forums 3 times
-
Nov 15, 2001, 01:16 #8
- Join Date
- Jun 2001
- Location
- In your basement
- Posts
- 1,268
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Originally posted by Defender1
I've only seen kevin around the forums 3 timesEric Coleman
We're consentratin' on fallin' apart
We were contenders, now throwin' the fight
I just wanna believe, I just wanna believe in us
-
Nov 15, 2001, 01:20 #9
- Join Date
- May 2001
- Location
- San Diego, CA
- Posts
- 1,701
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Originally posted by Defender1
I've only seen kevin around the forums 3 timesRyan Kuhle - A Proud Advisor - Got Questions? Just Ask!
Get your website started for less than $20! Click Here
-
Nov 15, 2001, 01:21 #10
- Join Date
- Apr 2001
- Location
- My Computer
- Posts
- 2,808
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
or an article for the site
-
Nov 15, 2001, 01:22 #11
- Join Date
- Jun 2001
- Location
- In your basement
- Posts
- 1,268
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
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 repeatedlyEric Coleman
We're consentratin' on fallin' apart
We were contenders, now throwin' the fight
I just wanna believe, I just wanna believe in us
Bookmarks