04072005 1130 GMT-6
Ok. I spoke way to soon.
$sql = "SELECT userid FROM user WHERE username = '".$username."'";
$result = mysql_query($sql);
while ( $row = mysql_fetch_array($result,MYSQL_ASSOC)) {
$userid = $row['userid'];
}
mysql_close();
= produces:
/mysql_fetch_array(): supplied argument is not a valid MySQL result
resource/
Wade wrote:
> 04072005 1110 GMT-6
>
> I finally figured out that a whole chain of troubles stemed from the db
> name. I was off one letter. Then I had to go figure out if my functions
> that called the db function were calling the right one.
>
> I finally got things working.
>
> I like this cosde here keerthi. Ill try that.
>
> Wade
>
> KEERTHI LAKSHMI wrote:
>
> > hi Wade,
> >
> > i suggest u to try giving the following statement instead..hope it
> > will work fine..and let me know the result .ok?
> >
> > while ( $row = mysql_fetch_array($result,MYSQL_ASSOC)){
> >
> >
> >
> > cheers
> >
> > keerthi
> >
> >
> > Wade <[EMAIL PROTECTED]> wrote:
> > 04062005 1152 GMT-6
> >
> > I started getting the following error today - but I have not changed
> > this page in weeks...?
> >
> > */*/*/*Warning*: mysql_fetch_array(): supplied argument is not a valid
> > MySQL result resource
> >
> > /*/*/*
> > This is the code that I have always used to access the db....
> >
> >
> > $sql = "SELECT username, password FROM user WHERE username = '".$user."'
> > AND password ='".$pass."'";
> >
> > $result = mysql_query($sql, $connection);
> >
> > while ( $row = mysql_fetch_array($result)){
> >
> >
> > Wade
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > Community email addresses:
> > Post message: php-list@yahoogroups.com
> > Subscribe: [EMAIL PROTECTED]
> > Unsubscribe: [EMAIL PROTECTED]
> > List owner: [EMAIL PROTECTED]
> >
> > Shortcut URL to this page:
> > http://groups.yahoo.com/group/php-list
> >
> >
> >
> > ---------------------------------
> > Yahoo! Groups Links
> >
> > To visit your group on the web, go to:
> > http://groups.yahoo.com/group/php-list/
> >
> > To unsubscribe from this group, send an email to:
> > [EMAIL PROTECTED]
> >
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
> >
> >
> > Yahoo! India Matrimony: Find your life partneronline.
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > Community email addresses:
> > Post message: php-list@yahoogroups.com
> > Subscribe: [EMAIL PROTECTED]
> > Unsubscribe: [EMAIL PROTECTED]
> > List owner: [EMAIL PROTECTED]
> >
> > Shortcut URL to this page:
> > http://groups.yahoo.com/group/php-list
> >
> >
> > ------------------------------------------------------------------------
> > *Yahoo! Groups Links*
> >
> > * To visit your group on the web, go to:
> > http://groups.yahoo.com/group/php-list/
> >
> > * To unsubscribe from this group, send an email to:
> > [EMAIL PROTECTED]
> > <mailto:[EMAIL PROTECTED]>
> >
> > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> > Service <http://docs.yahoo.com/info/terms/>.
> >
> >
> >------------------------------------------------------------------------
> >
> >No virus found in this incoming message.
> >Checked by AVG Anti-Virus.
> >Version: 7.0.308 / Virus Database: 266.9.4 - Release Date: 4/6/2005
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Community email addresses:
> Post message: php-list@yahoogroups.com
> Subscribe: [EMAIL PROTECTED]
> Unsubscribe: [EMAIL PROTECTED]
> List owner: [EMAIL PROTECTED]
>
> Shortcut URL to this page:
> http://groups.yahoo.com/group/php-list
>
>
> ------------------------------------------------------------------------
> *Yahoo! Groups Links*
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/php-list/
>
> * To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>
>------------------------------------------------------------------------
>
>No virus found in this incoming message.
>Checked by AVG Anti-Virus.
>Version: 7.0.308 / Virus Database: 266.9.4 - Release Date: 4/6/2005
>
>
[Non-text portions of this message have been removed]
Community email addresses:
Post message: php-list@yahoogroups.com
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-list/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
