freelanceprogrammers.org Forum Index » PHP
MySQL Connection
Joined: 25 Feb 2005
Posts: 10
MySQL Connection
Try using session and session objects.
Sesh
Coherent Business Solutions LLC
www.cobizsolutions.com
Anuradika Jaganadhan <anuradika80@...> wrote:
hi there,
its working now after i downloaded the binaries,
thanks for helping, thanks again...
i have another question...is there anywhere, i can
have global variable, where i can share it
between/across the pages...please assist...thanking u
in advance..
--- Marek <marekpraga@...> wrote:
> Download binaries: http://pl2.php.net/downloads.php
> Find the php_mysql.dll
> change path in php.ini
>
> check it:
> http://pl2.php.net/manual/en/ref.mysql.php
>
http://pl2.php.net/manual/en/faq.databases.php#faq.databases.mysql.php5
>
>
> But it`s for php5 did you install php5 or 4??
> ----- Original Message -----
> From: Anuradika Jaganadhan
> To: php-objects@yahoogroups.com
> Sent: Thursday, February 24, 2005 2:08 PM
> Subject: Re: [php-objects] MySQL Connection
>
>
> in my php file, its extension_dir = "./"..
> what is the file name and where its located?
> please help
>
> --- Marek <marekpraga@...> wrote:
> > In my opinion you shoud check extension
> directory
> > path, what error apear?
> >
> > ; Directory in which the loadable extensions
> > (modules) reside.
> > extension_dir = "./"
> > ----- Original Message -----
> > From: Anuradika
> > To: php-objects@yahoogroups.com
> > Sent: Thursday, February 24, 2005 1:14 PM
> > Subject: [php-objects] MySQL Connection
> >
> >
> >
> > I have installed php_4.3.10_Win32.zip, remove
> the
> > `;` in the php.ini
> > file for the three lines
> > extension=php_mssql.dll
> > extension=php_msql.dll
> > extension=php_mysql.dll
> >
> > and i copied the three files under c:windows
> too,
> > restated the IIS,
> > but still im not able to get mysql_connect.
> > Please help.
> >
> >
> >
> >
> >
> > PHP Data object relational mapping generator -
> > http://www.meta-language.net/
> >
> >
> > Yahoo! Groups Sponsor
> > ADVERTISEMENT
> >
> >
> >
> >
> >
> >
>
>
------------------------------------------------------------------------------
> > Yahoo! Groups Links
> >
> > a.. To visit your group on the web, go to:
> > http://groups.yahoo.com/group/php-objects/
> >
> > b.. To unsubscribe from this group, send an
> > email to:
> > php-objects-unsubscribe@yahoogroups.com
> >
> > c.. Your use of Yahoo! Groups is subject to
> the
> > Yahoo! Terms of Service.
> >
> >
> >
> > [Non-text portions of this message have been
> > removed]
> >
> >
>
>
>
________________________________________________________________________
> Yahoo! Messenger - Communicate instantly..."Ping"
> your friends today! Download Messenger Now
> http://uk.messenger.yahoo.com/download/index.html
>
>
> PHP Data object relational mapping generator -
> http://www.meta-language.net/
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
>
>
------------------------------------------------------------------------------
> Yahoo! Groups Links
>
> a.. To visit your group on the web, go to:
> http://groups.yahoo.com/group/php-objects/
>
> b.. To unsubscribe from this group, send an
> email to:
> php-objects-unsubscribe@yahoogroups.com
>
> c.. Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service.
>
>
>
> [Non-text portions of this message have been
> removed]
>
>
________________________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html
PHP Data object relational mapping generator - http://www.meta-language.net/
Yahoo! Groups SponsorADVERTISEMENT
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/php-objects/
To unsubscribe from this group, send an email to:
php-objects-unsubscribe@yahoogroups.com
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
[Non-text portions of this message have been removed]
Joined: 24 Feb 2005
Posts: 17
MySQL Connection
besides, session and cookies, there is any other way..
please guide me
thanks
--- Seshasayee Madaboosi <smadaboosi@...>
wrote:
> Try using session and session objects.
>
> Sesh
> Coherent Business Solutions LLC
> www.cobizsolutions.com
>
>
>
> Anuradika Jaganadhan <anuradika80@...> wrote:
> hi there,
> its working now after i downloaded the binaries,
> thanks for helping, thanks again...
>
> i have another question...is there anywhere, i can
> have global variable, where i can share it
> between/across the pages...please assist...thanking
> u
> in advance..
>
> --- Marek <marekpraga@...> wrote:
> > Download binaries:
> http://pl2.php.net/downloads.php
> > Find the php_mysql.dll
> > change path in php.ini
> >
> > check it:
> > http://pl2.php.net/manual/en/ref.mysql.php
> >
>
http://pl2.php.net/manual/en/faq.databases.php#faq.databases.mysql.php5
> >
> >
> > But it`s for php5 did you install php5 or 4??
> > ----- Original Message -----
> > From: Anuradika Jaganadhan
> > To: php-objects@yahoogroups.com
> > Sent: Thursday, February 24, 2005 2:08 PM
> > Subject: Re: [php-objects] MySQL Connection
> >
> >
> > in my php file, its extension_dir = "./"..
> > what is the file name and where its located?
> > please help
> >
> > --- Marek <marekpraga@...> wrote:
> > > In my opinion you shoud check extension
> > directory
> > > path, what error apear?
> > >
> > > ; Directory in which the loadable extensions
> > > (modules) reside.
> > > extension_dir = "./"
> > > ----- Original Message -----
> > > From: Anuradika
> > > To: php-objects@yahoogroups.com
> > > Sent: Thursday, February 24, 2005 1:14 PM
> > > Subject: [php-objects] MySQL Connection
> > >
> > >
> > >
> > > I have installed php_4.3.10_Win32.zip,
> remove
> > the
> > > `;` in the php.ini
> > > file for the three lines
> > > extension=php_mssql.dll
> > > extension=php_msql.dll
> > > extension=php_mysql.dll
> > >
> > > and i copied the three files under
> c:windows
> > too,
> > > restated the IIS,
> > > but still im not able to get mysql_connect.
> > > Please help.
> > >
> > >
> > >
> > >
> > >
> > > PHP Data object relational mapping generator
> -
> > > http://www.meta-language.net/
> > >
> > >
> > > Yahoo! Groups Sponsor
> > > ADVERTISEMENT
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
>
------------------------------------------------------------------------------
> > > Yahoo! Groups Links
> > >
> > > a.. To visit your group on the web, go to:
> > > http://groups.yahoo.com/group/php-objects/
> > >
> > > b.. To unsubscribe from this group, send
> an
> > > email to:
> > > php-objects-unsubscribe@yahoogroups.com
> > >
> > > c.. Your use of Yahoo! Groups is subject
> to
> > the
> > > Yahoo! Terms of Service.
> > >
> > >
> > >
> > > [Non-text portions of this message have been
> > > removed]
> > >
> > >
> >
> >
> >
>
________________________________________________________________________
> > Yahoo! Messenger - Communicate
> instantly..."Ping"
> > your friends today! Download Messenger Now
> >
> http://uk.messenger.yahoo.com/download/index.html
> >
> >
> > PHP Data object relational mapping generator -
> > http://www.meta-language.net/
> >
> >
> > Yahoo! Groups Sponsor
> > ADVERTISEMENT
> >
> >
> >
> >
> >
> >
>
------------------------------------------------------------------------------
> > Yahoo! Groups Links
> >
> > a.. To visit your group on the web, go to:
> > http://groups.yahoo.com/group/php-objects/
> >
> > b.. To unsubscribe from this group, send an
> > email to:
> > php-objects-unsubscribe@yahoogroups.com
> >
> > c.. Your use of Yahoo! Groups is subject to
> the
> > Yahoo! Terms of Service.
> >
> >
> >
> > [Non-text portions of this message have been
> > removed]
> >
> >
>
>
________________________________________________________________________
> Yahoo! Messenger - Communicate instantly..."Ping"
> your friends today! Download Messenger Now
> http://uk.messenger.yahoo.com/download/index.html
>
>
> PHP Data object relational mapping generator -
> http://www.meta-language.net/
>
>
> Yahoo! Groups SponsorADVERTISEMENT
>
>
> ---------------------------------
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/php-objects/
>
> To unsubscribe from this group, send an email to:
> php-objects-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service.
>
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Mail - Helps protect you from nasty viruses.
>
> [Non-text portions of this message have been
> removed]
>
>
________________________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html
Joined: 25 Feb 2005
Posts: 2
MySQL Connection
Turn on the following variable in php.ini
register_globals
On
On
Regards,
hamid
-----Original Message-----
From: Seshasayee Madaboosi [mailto:smadaboosi@...]
Sent: 25 February 2005 03:13
To: php-objects@yahoogroups.com
Subject: Re: [php-objects] MySQL Connection
Try using session and session objects.
Sesh
Coherent Business Solutions LLC
www.cobizsolutions.com
Anuradika Jaganadhan <anuradika80@...> wrote:
hi there,
its working now after i downloaded the binaries,
thanks for helping, thanks again...
i have another question...is there anywhere, i can
have global variable, where i can share it
between/across the pages...please assist...thanking u
in advance..
--- Marek <marekpraga@...> wrote:
> Download binaries: http://pl2.php.net/downloads.php
> Find the php_mysql.dll
> change path in php.ini
>
> check it:
> http://pl2.php.net/manual/en/ref.mysql.php
>
http://pl2.php.net/manual/en/faq.databases.php#faq.databases.mysql.php5
>
>
> But it`s for php5 did you install php5 or 4??
> ----- Original Message -----
> From: Anuradika Jaganadhan
> To: php-objects@yahoogroups.com
> Sent: Thursday, February 24, 2005 2:08 PM
> Subject: Re: [php-objects] MySQL Connection
>
>
> in my php file, its extension_dir = "./"..
> what is the file name and where its located?
> please help
>
> --- Marek <marekpraga@...> wrote:
> > In my opinion you shoud check extension
> directory
> > path, what error apear?
> >
> > ; Directory in which the loadable extensions
> > (modules) reside.
> > extension_dir = "./"
> > ----- Original Message -----
> > From: Anuradika
> > To: php-objects@yahoogroups.com
> > Sent: Thursday, February 24, 2005 1:14 PM
> > Subject: [php-objects] MySQL Connection
> >
> >
> >
> > I have installed php_4.3.10_Win32.zip, remove
> the
> > `;` in the php.ini
> > file for the three lines
> > extension=php_mssql.dll
> > extension=php_msql.dll
> > extension=php_mysql.dll
> >
> > and i copied the three files under c:windows
> too,
> > restated the IIS,
> > but still im not able to get mysql_connect.
> > Please help.
> >
> >
> >
> >
> >
> > PHP Data object relational mapping generator -
> > http://www.meta-language.net/
> >
> >
> > Yahoo! Groups Sponsor
> > ADVERTISEMENT
> >
> >
> >
> >
> >
> >
>
>
----------------------------------------------------------------------------
--
> > Yahoo! Groups Links
> >
> > a.. To visit your group on the web, go to:
> > http://groups.yahoo.com/group/php-objects/
> >
> > b.. To unsubscribe from this group, send an
> > email to:
> > php-objects-unsubscribe@yahoogroups.com
> >
> > c.. Your use of Yahoo! Groups is subject to
> the
> > Yahoo! Terms of Service.
> >
> >
> >
> > [Non-text portions of this message have been
> > removed]
> >
> >
>
>
>
________________________________________________________________________
> Yahoo! Messenger - Communicate instantly..."Ping"
> your friends today! Download Messenger Now
> http://uk.messenger.yahoo.com/download/index.html
>
>
> PHP Data object relational mapping generator -
> http://www.meta-language.net/
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
>
>
----------------------------------------------------------------------------
--
> Yahoo! Groups Links
>
> a.. To visit your group on the web, go to:
> http://groups.yahoo.com/group/php-objects/
>
> b.. To unsubscribe from this group, send an
> email to:
> php-objects-unsubscribe@yahoogroups.com
>
> c.. Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service.
>
>
>
> [Non-text portions of this message have been
> removed]
>
>
________________________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html
PHP Data object relational mapping generator - http://www.meta-language.net/
Yahoo! Groups SponsorADVERTISEMENT
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/php-objects/
To unsubscribe from this group, send an email to:
php-objects-unsubscribe@yahoogroups.com
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
[Non-text portions of this message have been removed]
PHP Data object relational mapping generator - http://www.meta-language.net/
Yahoo! Groups Links
http://groups.yahoo.com/group/php-objects/
php-objects-unsubscribe@yahoogroups.com
http://docs.yahoo.com/info/terms/
--
Internal Virus Database is out-of-date.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.1.0 - Release Date: 18/02/2005
--
Internal Virus Database is out-of-date.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.1.0 - Release Date: 18/02/2005
[Non-text portions of this message have been removed]
Joined: 24 Feb 2005
Posts: 3
MySQL Connection
I think that register globals is not a good idea because it`s not safe solution.
It`s better to send variables in form and than use _POST, or use session like in
previous post
please read this: www.php.net/variables.predefined
----- Original Message -----
From: Hamid M. Maydanchi
To: php-objects@yahoogroups.com
Sent: Friday, February 25, 2005 11:32 AM
Subject: RE: [php-objects] MySQL Connection
Turn on the following variable in php.ini
register_globals
On
On
Regards,
hamid
-----Original Message-----
From: Seshasayee Madaboosi [mailto:smadaboosi@...]
Sent: 25 February 2005 03:13
To: php-objects@yahoogroups.com
Subject: Re: [php-objects] MySQL Connection
Try using session and session objects.
Sesh
Coherent Business Solutions LLC
www.cobizsolutions.com
Anuradika Jaganadhan <anuradika80@...> wrote:
hi there,
its working now after i downloaded the binaries,
thanks for helping, thanks again...
i have another question...is there anywhere, i can
have global variable, where i can share it
between/across the pages...please assist...thanking u
in advance..
--- Marek <marekpraga@...> wrote:
> Download binaries: http://pl2.php.net/downloads.php
> Find the php_mysql.dll
> change path in php.ini
>
> check it:
> http://pl2.php.net/manual/en/ref.mysql.php
>
http://pl2.php.net/manual/en/faq.databases.php#faq.databases.mysql.php5
>
>
> But it`s for php5 did you install php5 or 4??
> ----- Original Message -----
> From: Anuradika Jaganadhan
> To: php-objects@yahoogroups.com
> Sent: Thursday, February 24, 2005 2:08 PM
> Subject: Re: [php-objects] MySQL Connection
>
>
> in my php file, its extension_dir = "./"..
> what is the file name and where its located?
> please help
>
> --- Marek <marekpraga@...> wrote:
> > In my opinion you shoud check extension
> directory
> > path, what error apear?
> >
> > ; Directory in which the loadable extensions
> > (modules) reside.
> > extension_dir = "./"
> > ----- Original Message -----
> > From: Anuradika
> > To: php-objects@yahoogroups.com
> > Sent: Thursday, February 24, 2005 1:14 PM
> > Subject: [php-objects] MySQL Connection
> >
> >
> >
> > I have installed php_4.3.10_Win32.zip, remove
> the
> > `;` in the php.ini
> > file for the three lines
> > extension=php_mssql.dll
> > extension=php_msql.dll
> > extension=php_mysql.dll
> >
> > and i copied the three files under c:windows
> too,
> > restated the IIS,
> > but still im not able to get mysql_connect.
> > Please help.
> >
> >
> >
> >
> >
> > PHP Data object relational mapping generator -
> > http://www.meta-language.net/
> >
> >
> > Yahoo! Groups Sponsor
> > ADVERTISEMENT
> >
> >
> >
> >
> >
> >
>
>
----------------------------------------------------------------------------
--
> > Yahoo! Groups Links
> >
> > a.. To visit your group on the web, go to:
> > http://groups.yahoo.com/group/php-objects/
> >
> > b.. To unsubscribe from this group, send an
> > email to:
> > php-objects-unsubscribe@yahoogroups.com
> >
> > c.. Your use of Yahoo! Groups is subject to
> the
> > Yahoo! Terms of Service.
> >
> >
> >
> > [Non-text portions of this message have been
> > removed]
> >
> >
>
>
>
________________________________________________________________________
> Yahoo! Messenger - Communicate instantly..."Ping"
> your friends today! Download Messenger Now
> http://uk.messenger.yahoo.com/download/index.html
>
>
> PHP Data object relational mapping generator -
> http://www.meta-language.net/
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
>
>
----------------------------------------------------------------------------
--
> Yahoo! Groups Links
>
> a.. To visit your group on the web, go to:
> http://groups.yahoo.com/group/php-objects/
>
> b.. To unsubscribe from this group, send an
> email to:
> php-objects-unsubscribe@yahoogroups.com
>
> c.. Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service.
>
>
>
> [Non-text portions of this message have been
> removed]
>
>
________________________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html
PHP Data object relational mapping generator - http://www.meta-language.net/
Yahoo! Groups SponsorADVERTISEMENT
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/php-objects/
To unsubscribe from this group, send an email to:
php-objects-unsubscribe@yahoogroups.com
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
[Non-text portions of this message have been removed]
PHP Data object relational mapping generator - http://www.meta-language.net/
Yahoo! Groups Links
http://groups.yahoo.com/group/php-objects/
php-objects-unsubscribe@yahoogroups.com
http://docs.yahoo.com/info/terms/
--
Internal Virus Database is out-of-date.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.1.0 - Release Date: 18/02/2005
--
Internal Virus Database is out-of-date.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.1.0 - Release Date: 18/02/2005
[Non-text portions of this message have been removed]
PHP Data object relational mapping generator - http://www.meta-language.net/
Yahoo! Groups Sponsor
ADVERTISEMENT
------------------------------------------------------------------------------
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/php-objects/
b.. To unsubscribe from this group, send an email to:
php-objects-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
Joined: 25 Feb 2005
Posts: 2
MySQL Connection
Ok, fare enough as marek suggest send a variable in a form or like the
following format: index.php?page=123
And the using the following:
$page=$HTTP_GET_VARS[`page`];
$page=$HTTP_POST_VARS[`page`];
-----Original Message-----
From: Marek [mailto:marekpraga@...]
Sent: 25 February 2005 11:25
To: php-objects@yahoogroups.com
Subject: Re: [php-objects] MySQL Connection
I think that register globals is not a good idea because it`s not safe
solution. It`s better to send variables in form and than use _POST, or use
session like in previous post
please read this: www.php.net/variables.predefined
----- Original Message -----
From: Hamid M. Maydanchi
To: php-objects@yahoogroups.com
Sent: Friday, February 25, 2005 11:32 AM
Subject: RE: [php-objects] MySQL Connection
Turn on the following variable in php.ini
register_globals
On
On
Regards,
hamid
-----Original Message-----
From: Seshasayee Madaboosi [mailto:smadaboosi@...]
Sent: 25 February 2005 03:13
To: php-objects@yahoogroups.com
Subject: Re: [php-objects] MySQL Connection
Try using session and session objects.
Sesh
Coherent Business Solutions LLC
www.cobizsolutions.com
Anuradika Jaganadhan <anuradika80@...> wrote:
hi there,
its working now after i downloaded the binaries,
thanks for helping, thanks again...
i have another question...is there anywhere, i can
have global variable, where i can share it
between/across the pages...please assist...thanking u
in advance..
--- Marek <marekpraga@...> wrote:
> Download binaries: http://pl2.php.net/downloads.php
> Find the php_mysql.dll
> change path in php.ini
>
> check it:
> http://pl2.php.net/manual/en/ref.mysql.php
>
http://pl2.php.net/manual/en/faq.databases.php#faq.databases.mysql.php5
>
>
> But it`s for php5 did you install php5 or 4??
> ----- Original Message -----
> From: Anuradika Jaganadhan
> To: php-objects@yahoogroups.com
> Sent: Thursday, February 24, 2005 2:08 PM
> Subject: Re: [php-objects] MySQL Connection
>
>
> in my php file, its extension_dir = "./"..
> what is the file name and where its located?
> please help
>
> --- Marek <marekpraga@...> wrote:
> > In my opinion you shoud check extension
> directory
> > path, what error apear?
> >
> > ; Directory in which the loadable extensions
> > (modules) reside.
> > extension_dir = "./"
> > ----- Original Message -----
> > From: Anuradika
> > To: php-objects@yahoogroups.com
> > Sent: Thursday, February 24, 2005 1:14 PM
> > Subject: [php-objects] MySQL Connection
> >
> >
> >
> > I have installed php_4.3.10_Win32.zip, remove
> the
> > `;` in the php.ini
> > file for the three lines
> > extension=php_mssql.dll
> > extension=php_msql.dll
> > extension=php_mysql.dll
> >
> > and i copied the three files under c:windows
> too,
> > restated the IIS,
> > but still im not able to get mysql_connect.
> > Please help.
> >
> >
> >
> >
> >
> > PHP Data object relational mapping generator -
> > http://www.meta-language.net/
> >
> >
> > Yahoo! Groups Sponsor
> > ADVERTISEMENT
> >
> >
> >
> >
> >
> >
>
>
----------------------------------------------------------------------------
--
> > Yahoo! Groups Links
> >
> > a.. To visit your group on the web, go to:
> > http://groups.yahoo.com/group/php-objects/
> >
> > b.. To unsubscribe from this group, send an
> > email to:
> > php-objects-unsubscribe@yahoogroups.com
> >
> > c.. Your use of Yahoo! Groups is subject to
> the
> > Yahoo! Terms of Service.
> >
> >
> >
> > [Non-text portions of this message have been
> > removed]
> >
> >
>
>
>
________________________________________________________________________
> Yahoo! Messenger - Communicate instantly..."Ping"
> your friends today! Download Messenger Now
> http://uk.messenger.yahoo.com/download/index.html
>
>
> PHP Data object relational mapping generator -
> http://www.meta-language.net/
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
>
>
----------------------------------------------------------------------------
--
> Yahoo! Groups Links
>
> a.. To visit your group on the web, go to:
> http://groups.yahoo.com/group/php-objects/
>
> b.. To unsubscribe from this group, send an
> email to:
> php-objects-unsubscribe@yahoogroups.com
>
> c.. Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service.
>
>
>
> [Non-text portions of this message have been
> removed]
>
>
________________________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html
PHP Data object relational mapping generator -
http://www.meta-language.net/
Yahoo! Groups SponsorADVERTISEMENT
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/php-objects/
To unsubscribe from this group, send an email to:
php-objects-unsubscribe@yahoogroups.com
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
[Non-text portions of this message have been removed]
PHP Data object relational mapping generator -
http://www.meta-language.net/
Yahoo! Groups Links
http://groups.yahoo.com/group/php-objects/
php-objects-unsubscribe@yahoogroups.com
http://docs.yahoo.com/info/terms/
--
Internal Virus Database is out-of-date.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.1.0 - Release Date: 18/02/2005
--
Internal Virus Database is out-of-date.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.1.0 - Release Date: 18/02/2005
[Non-text portions of this message have been removed]
PHP Data object relational mapping generator -
http://www.meta-language.net/
Yahoo! Groups Sponsor
ADVERTISEMENT
----------------------------------------------------------------------------
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/php-objects/
b.. To unsubscribe from this group, send an email to:
php-objects-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
PHP Data object relational mapping generator - http://www.meta-language.net/
Yahoo! Groups Links
--
Internal Virus Database is out-of-date.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.1.0 - Release Date: 18/02/2005
--
Internal Virus Database is out-of-date.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.1.0 - Release Date: 18/02/2005
Joined: 24 Feb 2005
Posts: 17
MySQL Connection
ok guys, i will use that...
thanks a lot of helping, when i need someone, u ppl
are there to help...thanks again..
--- "Hamid M. Maydanchi" <hamid@...> wrote:
>
> Ok, fare enough as marek suggest send a variable in
> a form or like the
> following format: index.php?page=123
>
> And the using the following:
>
> $page=$HTTP_GET_VARS[`page`];
>
> $page=$HTTP_POST_VARS[`page`];
>
> -----Original Message-----
> From: Marek [mailto:marekpraga@...]
> Sent: 25 February 2005 11:25
> To: php-objects@yahoogroups.com
> Subject: Re: [php-objects] MySQL Connection
>
>
> I think that register globals is not a good idea
> because it`s not safe
> solution. It`s better to send variables in form and
> than use _POST, or use
> session like in previous post
>
> please read this: www.php.net/variables.predefined
> ----- Original Message -----
> From: Hamid M. Maydanchi
> To: php-objects@yahoogroups.com
> Sent: Friday, February 25, 2005 11:32 AM
> Subject: RE: [php-objects] MySQL Connection
>
>
> Turn on the following variable in php.ini
>
>
>
>
> register_globals
>
> On
>
> On
>
>
>
> Regards,
>
> hamid
>
>
>
>
>
> -----Original Message-----
> From: Seshasayee Madaboosi
> [mailto:smadaboosi@...]
> Sent: 25 February 2005 03:13
> To: php-objects@yahoogroups.com
> Subject: Re: [php-objects] MySQL Connection
>
>
>
>
>
> Try using session and session objects.
>
>
>
> Sesh
>
> Coherent Business Solutions LLC
>
> www.cobizsolutions.com
>
>
>
>
>
>
>
> Anuradika Jaganadhan <anuradika80@...>
> wrote:
>
> hi there,
>
> its working now after i downloaded the binaries,
>
> thanks for helping, thanks again...
>
>
>
> i have another question...is there anywhere, i can
>
> have global variable, where i can share it
>
> between/across the pages...please
> assist...thanking u
>
> in advance..
>
>
>
> --- Marek <marekpraga@...> wrote:
>
> > Download binaries:
> http://pl2.php.net/downloads.php
>
> > Find the php_mysql.dll
>
> > change path in php.ini
>
> >
>
> > check it:
>
> > http://pl2.php.net/manual/en/ref.mysql.php
>
> >
>
>
>
http://pl2.php.net/manual/en/faq.databases.php#faq.databases.mysql.php5
>
> >
>
> >
>
> > But it`s for php5 did you install php5 or 4??
>
> > ----- Original Message -----
>
> > From: Anuradika Jaganadhan
>
> > To: php-objects@yahoogroups.com
>
> > Sent: Thursday, February 24, 2005 2:08 PM
>
> > Subject: Re: [php-objects] MySQL Connection
>
> >
>
> >
>
> > in my php file, its extension_dir = "./"..
>
> > what is the file name and where its located?
>
> > please help
>
> >
>
> > --- Marek <marekpraga@...> wrote:
>
> > > In my opinion you shoud check extension
>
> > directory
>
> > > path, what error apear?
>
> > >
>
> > > ; Directory in which the loadable extensions
>
> > > (modules) reside.
>
> > > extension_dir = "./"
>
> > > ----- Original Message -----
>
> > > From: Anuradika
>
> > > To: php-objects@yahoogroups.com
>
> > > Sent: Thursday, February 24, 2005 1:14 PM
>
> > > Subject: [php-objects] MySQL Connection
>
> > >
>
> > >
>
> > >
>
> > > I have installed php_4.3.10_Win32.zip,
> remove
>
> > the
>
> > > `;` in the php.ini
>
> > > file for the three lines
>
> > > extension=php_mssql.dll
>
> > > extension=php_msql.dll
>
> > > extension=php_mysql.dll
>
> > >
>
> > > and i copied the three files under
> c:windows
>
=== message truncated ===
________________________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html
Joined: 24 Feb 2005
Posts: 17
MySQL Connection
i have tried to remove the @ which looks like this now
$cx = mysql_connect(`localhost`, `db`, `password`);
mysql_select_db("db") or die( "Unable to select
database");
and also used without MYSQL_ASSOC, but still im
getting the same error message. Can anyone help me
please
--- Ryan Sexton <rsexton@...> wrote:
> Are you sure the Conn_to_Mysql.php contains the
> correct username and
> password and the correct host to where your mysql
> installation is? I`d
> say you`re failing to make a connection to your
> mysql database at the
> office because it`s setup differently. I`d bet you
> have a @ in front of
> your mysql_connect() statement in that include file.
> remove it and run
> your script to see what the error message is.
>
> Good luck,
> Ryan
>
> On Mar 7, 2005, at 6:42 PM, Anuradika wrote:
>
>
>
> Hi there,
> I have coded the project using php 5.0.3, with MySQL
> 4.1. I am using
>
> require("Conn_to_Mysql.php");
> $query = "Select * from tbl_BBY ";
> $result = mysql_query($query);
> while($row = mysql_fetch_array($result,
> MYSQL_ASSOC))
> {
>
> }
>
> Its running in my office pc, and my home pc, but
> when i upload to the
> webserver, its giving error as such, anyone able to
> help me to solve
> this issue.
>
> Warning: mysql_fetch_array(): supplied argument is
> not a valid MySQL
> result resource
>
> Thanks in advance.
>
>
________________________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html
Joined: 24 Feb 2005
Posts: 17
MySQL Connection
This first code is working well, which return the date of the
server, but, getting rows from the table tbl_BBY doesnt work, please
help
$query = "Select NOW() ";
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
echo $row[0];
}
exit;
$query = "Select txt_ID FROM tbl_BBY ";
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
echo $row[`txt_ID`];
}
--- In php-objects@yahoogroups.com, Anuradika Jaganadhan
<anuradika80@y...> wrote:
> i have tried to remove the @ which looks like this now
>
> $cx = mysql_connect(`localhost`, `db`, `password`);
> mysql_select_db("db") or die( "Unable to select
> database");
>
> and also used without MYSQL_ASSOC, but still im
> getting the same error message. Can anyone help me
> please
>
>
> --- Ryan Sexton <rsexton@f...> wrote:
> > Are you sure the Conn_to_Mysql.php contains the
> > correct username and
> > password and the correct host to where your mysql
> > installation is? I`d
> > say you`re failing to make a connection to your
> > mysql database at the
> > office because it`s setup differently. I`d bet you
> > have a @ in front of
> > your mysql_connect() statement in that include file.
> > remove it and run
> > your script to see what the error message is.
> >
> > Good luck,
> > Ryan
> >
> > On Mar 7, 2005, at 6:42 PM, Anuradika wrote:
> >
> >
> >
> > Hi there,
> > I have coded the project using php 5.0.3, with MySQL
> > 4.1. I am using
> >
> > require("Conn_to_Mysql.php");
> > $query = "Select * from tbl_BBY ";
> > $result = mysql_query($query);
> > while($row = mysql_fetch_array($result,
> > MYSQL_ASSOC))
> > {
> >
> > }
> >
> > Its running in my office pc, and my home pc, but
> > when i upload to the
> > webserver, its giving error as such, anyone able to
> > help me to solve
> > this issue.
> >
> > Warning: mysql_fetch_array(): supplied argument is
> > not a valid MySQL
> > result resource
> >
> > Thanks in advance.
> >
> >
>
>
_____________________________________________________________________
___
> Yahoo! Messenger - Communicate instantly..."Ping"
> your friends today! Download Messenger Now
> http://uk.messenger.yahoo.com/download/index.html
Joined: 25 Feb 2005
Posts: 10
MySQL Connection
My feeling is there is something wrong the way PHP is set up, try using
mysql_fetch_assoc() and see of that works. The reason is that mysql_fetch_array
() uses an argument that is a constant value and this for some reason is not
being set/passed right.
Sesh
www.cobizsolutions.com
Anuradika Jaganadhan <anuradika80@...> wrote:
i have tried to remove the @ which looks like this now
$cx = mysql_connect(`localhost`, `db`, `password`);
mysql_select_db("db") or die( "Unable to select
database");
and also used without MYSQL_ASSOC, but still im
getting the same error message. Can anyone help me
please
--- Ryan Sexton <rsexton@...> wrote:
> Are you sure the Conn_to_Mysql.php contains the
> correct username and
> password and the correct host to where your mysql
> installation is? I`d
> say you`re failing to make a connection to your
> mysql database at the
> office because it`s setup differently. I`d bet you
> have a @ in front of
> your mysql_connect() statement in that include file.
> remove it and run
> your script to see what the error message is.
>
> Good luck,
> Ryan
>
> On Mar 7, 2005, at 6:42 PM, Anuradika wrote:
>
>
>
> Hi there,
> I have coded the project using php 5.0.3, with MySQL
> 4.1. I am using
>
> require("Conn_to_Mysql.php");
> $query = "Select * from tbl_BBY ";
> $result = mysql_query($query);
> while($row = mysql_fetch_array($result,
> MYSQL_ASSOC))
> {
>
> }
>
> Its running in my office pc, and my home pc, but
> when i upload to the
> webserver, its giving error as such, anyone able to
> help me to solve
> this issue.
>
> Warning: mysql_fetch_array(): supplied argument is
> not a valid MySQL
> result resource
>
> Thanks in advance.
>
>
________________________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html
PHP Data object relational mapping generator - http://www.meta-language.net/
Yahoo! Groups SponsorADVERTISEMENT
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/php-objects/
To unsubscribe from this group, send an email to:
php-objects-unsubscribe@yahoogroups.com
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Sesh Madaboosi CISA, CSSA
Coherent Business Solutions LLC
---------------------------------
Celebrate Yahoo!`s 10th Birthday!
Yahoo! Netrospective: 100 Moments of the Web
[Non-text portions of this message have been removed]
Joined: 24 Feb 2005
Posts: 17
MySQL Connection
i have tried, and its giving erro as such
Warning: mysql_fetch_assoc(): supplied argument is not
a valid MySQL result resource
--- Seshasayee Madaboosi <smadaboosi@...> wrote:
> My feeling is there is something wrong the way PHP
> is set up, try using mysql_fetch_assoc() and see of
> that works. The reason is that mysql_fetch_array ()
> uses an argument that is a constant value and this
> for some reason is not being set/passed right.
>
> Sesh
> www.cobizsolutions.com
>
>
> Anuradika Jaganadhan <anuradika80@...> wrote:
> i have tried to remove the @ which looks like this
> now
>
> $cx = mysql_connect(`localhost`, `db`, `password`);
> mysql_select_db("db") or die( "Unable to select
> database");
>
> and also used without MYSQL_ASSOC, but still im
> getting the same error message. Can anyone help me
> please
>
>
> --- Ryan Sexton <rsexton@...> wrote:
> > Are you sure the Conn_to_Mysql.php contains the
> > correct username and
> > password and the correct host to where your mysql
> > installation is? I`d
> > say you`re failing to make a connection to your
> > mysql database at the
> > office because it`s setup differently. I`d bet you
> > have a @ in front of
> > your mysql_connect() statement in that include
> file.
> > remove it and run
> > your script to see what the error message is.
> >
> > Good luck,
> > Ryan
> >
> > On Mar 7, 2005, at 6:42 PM, Anuradika wrote:
> >
> >
> >
> > Hi there,
> > I have coded the project using php 5.0.3, with
> MySQL
> > 4.1. I am using
> >
> > require("Conn_to_Mysql.php");
> > $query = "Select * from tbl_BBY ";
> > $result = mysql_query($query);
> > while($row = mysql_fetch_array($result,
> > MYSQL_ASSOC))
> > {
> >
> > }
> >
> > Its running in my office pc, and my home pc, but
> > when i upload to the
> > webserver, its giving error as such, anyone able
> to
> > help me to solve
> > this issue.
> >
> > Warning: mysql_fetch_array(): supplied argument
> is
> > not a valid MySQL
> > result resource
> >
> > Thanks in advance.
> >
> >
>
>
________________________________________________________________________
> Yahoo! Messenger - Communicate instantly..."Ping"
> your friends today! Download Messenger Now
> http://uk.messenger.yahoo.com/download/index.html
>
>
> PHP Data object relational mapping generator -
> http://www.meta-language.net/
>
>
> Yahoo! Groups SponsorADVERTISEMENT
>
>
> ---------------------------------
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/php-objects/
>
> To unsubscribe from this group, send an email to:
> php-objects-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service.
>
>
>
> Sesh Madaboosi CISA, CSSA
> Coherent Business Solutions LLC
>
> ---------------------------------
> Celebrate Yahoo!`s 10th Birthday!
> Yahoo! Netrospective: 100 Moments of the Web
>
> [Non-text portions of this message have been
> removed]
>
>
________________________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html
Joined: 08 Mar 2005
Posts: 8
MySQL Connection
Have you checked to make sure that table exists in your database? And
that it`s not corrupted?
You might want to issue this command instead of the "Select NOW()";
below:
"SHOW TABLES";
Make sure you are seeing the table.
On Mar 8, 2005, at 8:36 AM, Anuradika wrote:
This first code is working well, which return the date of the
server, but, getting rows from the table tbl_BBY doesnt work, please
help
$query = "Select NOW() ";
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
echo $row[0];
}
exit;
$query = "Select txt_ID FROM tbl_BBY ";
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
echo $row[`txt_ID`];
}
--- In php-objects@yahoogroups.com, Anuradika Jaganadhan
<anuradika80@y...> wrote:
> i have tried to remove the @ which looks like this now
>
> $cx = mysql_connect(`localhost`, `db`, `password`);
> mysql_select_db("db") or die( "Unable to select
> database");
>
> and also used without MYSQL_ASSOC, but still im
> getting the same error message. Can anyone help me
> please
>
>
> --- Ryan Sexton <rsexton@f...> wrote:
>> Are you sure the Conn_to_Mysql.php contains the
>> correct username and
>> password and the correct host to where your mysql
>> installation is? I`d
>> say you`re failing to make a connection to your
>> mysql database at the
>> office because it`s setup differently. I`d bet you
>> have a @ in front of
>> your mysql_connect() statement in that include file.
>> remove it and run
>> your script to see what the error message is.
>>
>> Good luck,
>> Ryan
>>
>> On Mar 7, 2005, at 6:42 PM, Anuradika wrote:
>>
>>
>>
>> Hi there,
>> I have coded the project using php 5.0.3, with MySQL
>> 4.1. I am using
>>
>> require("Conn_to_Mysql.php");
>> $query = "Select * from tbl_BBY ";
>> $result = mysql_query($query);
>> while($row = mysql_fetch_array($result,
>> MYSQL_ASSOC))
>> {
>>
>> }
>>
>> Its running in my office pc, and my home pc, but
>> when i upload to the
>> webserver, its giving error as such, anyone able to
>> help me to solve
>> this issue.
>>
>> Warning: mysql_fetch_array(): supplied argument is
>> not a valid MySQL
>> result resource
>>
>> Thanks in advance.
>>
>>
>
>
Joined: 09 Mar 2005
Posts: 1
MySQL Connection
tbl_BBY table in ?? database or your connection in
"mysql_select_database(databasename);"
Anuradika wrote:
>This first code is working well, which return the date of the
>server, but, getting rows from the table tbl_BBY doesnt work, please
>help
>
>$query = "Select NOW() ";
>$result = mysql_query($query);
>while($row = mysql_fetch_array($result))
>{
>echo $row[0];
>}
>exit;
>
>$query = "Select txt_ID FROM tbl_BBY ";
>$result = mysql_query($query);
>while($row = mysql_fetch_array($result))
>{
>echo $row[`txt_ID`];
>}
>
>--- In php-objects@yahoogroups.com, Anuradika Jaganadhan
><anuradika80@y...> wrote:
>
>
>>i have tried to remove the @ which looks like this now
>>
>>$cx = mysql_connect(`localhost`, `db`, `password`);
>>mysql_select_db("db") or die( "Unable to select
>>database");
>>
>>and also used without MYSQL_ASSOC, but still im
>>getting the same error message. Can anyone help me
>>please
>>
>>
>>--- Ryan Sexton <rsexton@f...> wrote:
>>
>>
>>>Are you sure the Conn_to_Mysql.php contains the
>>>correct username and
>>>password and the correct host to where your mysql
>>>installation is? I`d
>>>say you`re failing to make a connection to your
>>>mysql database at the
>>>office because it`s setup differently. I`d bet you
>>>have a @ in front of
>>>your mysql_connect() statement in that include file.
>>>remove it and run
>>>your script to see what the error message is.
>>>
>>>Good luck,
>>>Ryan
>>>
>>>On Mar 7, 2005, at 6:42 PM, Anuradika wrote:
>>>
>>>
>>>
>>>Hi there,
>>>I have coded the project using php 5.0.3, with MySQL
>>>4.1. I am using
>>>
>>>require("Conn_to_Mysql.php");
>>>$query = "Select * from tbl_BBY ";
>>>$result = mysql_query($query);
>>>while($row = mysql_fetch_array($result,
>>>MYSQL_ASSOC))
>>>{
>>>
>>>}
>>>
>>>Its running in my office pc, and my home pc, but
>>>when i upload to the
>>>webserver, its giving error as such, anyone able to
>>>help me to solve
>>>this issue.
>>>
>>>Warning: mysql_fetch_array(): supplied argument is
>>>not a valid MySQL
>>>result resource
>>>
>>>Thanks in advance.
>>>
>>>
>>>
>>>
>>
>>
>_____________________________________________________________________
>___
>
>
>>Yahoo! Messenger - Communicate instantly..."Ping"
>>your friends today! Download Messenger Now
>>http://uk.messenger.yahoo.com/download/index.html
>>
>>
>
>
>
>
>
>PHP Data object relational mapping generator - http://www.meta-language.net/
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>
>
Joined: 24 Feb 2005
Posts: 17
MySQL Connection
it shows all the tables in the db, but i m aunable to
connect using
mysql_fetch_array():
mysql_fetch_assoc():
mysql_num_rows():
please help
--- Ryan Sexton <rsexton@...> wrote:
> Have you checked to make sure that table exists in
> your database? And
> that it`s not corrupted?
>
> You might want to issue this command instead of the
> "Select NOW()";
> below:
> "SHOW TABLES";
>
> Make sure you are seeing the table.
>
> On Mar 8, 2005, at 8:36 AM, Anuradika wrote:
>
>
> This first code is working well, which return the
> date of the
> server, but, getting rows from the table tbl_BBY
> doesnt work, please
> help
>
> $query = "Select NOW() ";
> $result = mysql_query($query);
> while($row = mysql_fetch_array($result))
> {
> echo $row[0];
> }
> exit;
>
> $query = "Select txt_ID FROM tbl_BBY ";
> $result = mysql_query($query);
> while($row = mysql_fetch_array($result))
> {
> echo $row[`txt_ID`];
> }
>
> --- In php-objects@yahoogroups.com, Anuradika
> Jaganadhan
> <anuradika80@y...> wrote:
> > i have tried to remove the @ which looks like this
> now
> >
> > $cx = mysql_connect(`localhost`, `db`,
> `password`);
> > mysql_select_db("db") or die( "Unable to select
> > database");
> >
> > and also used without MYSQL_ASSOC, but still im
> > getting the same error message. Can anyone help me
> > please
> >
> >
> > --- Ryan Sexton <rsexton@f...> wrote:
> >> Are you sure the Conn_to_Mysql.php contains the
> >> correct username and
> >> password and the correct host to where your mysql
> >> installation is? I`d
> >> say you`re failing to make a connection to your
> >> mysql database at the
> >> office because it`s setup differently. I`d bet
> you
> >> have a @ in front of
> >> your mysql_connect() statement in that include
> file.
> >> remove it and run
> >> your script to see what the error message is.
> >>
> >> Good luck,
> >> Ryan
> >>
> >> On Mar 7, 2005, at 6:42 PM, Anuradika wrote:
> >>
> >>
> >>
> >> Hi there,
> >> I have coded the project using php 5.0.3, with
> MySQL
> >> 4.1. I am using
> >>
> >> require("Conn_to_Mysql.php");
> >> $query = "Select * from tbl_BBY ";
> >> $result = mysql_query($query);
> >> while($row = mysql_fetch_array($result,
> >> MYSQL_ASSOC))
> >> {
> >>
> >> }
> >>
> >> Its running in my office pc, and my home pc, but
> >> when i upload to the
> >> webserver, its giving error as such, anyone able
> to
> >> help me to solve
> >> this issue.
> >>
> >> Warning: mysql_fetch_array(): supplied argument
> is
> >> not a valid MySQL
> >> result resource
> >>
> >> Thanks in advance.
> >>
> >>
> >
> >
>
>
>
>
>
>
________________________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html
Joined: 09 Mar 2005
Posts: 2
MySQL Connection
What does this tell you?
$query = "Select txt_ID FROM tbl_BBY ";
$result = mysql_query($query);
if (mysql_errno()) {
echo "<p>MySQL error: ". mysql_error() . "</p>";
echo "<p>SQL: $query</p>";
die;
}
Here`s another way to check for errors.
$query = "Select txt_ID FROM tbl_BBY ";
$result = mysql_query($query);
if (!$result) {
echo "<p>MySQL error: ". mysql_error() . "</p>";
echo "<p>SQL: $query</p>";
die;
}
--
Sheila
http://www.shefen.com/
Anuradika Jaganadhan wrote:
> it shows all the tables in the db, but i m aunable to
> connect using
> mysql_fetch_array():
> mysql_fetch_assoc():
> mysql_num_rows():
> please help
>
>>>>4.1. I am using
>>>>
>>>>require("Conn_to_Mysql.php");
>>>>$query = "Select * from tbl_BBY ";
>>>>$result = mysql_query($query);
>>>>while($row = mysql_fetch_array($result,
>>>>MYSQL_ASSOC))
>>>>{
>>>>
>>>>}
>>>>
>>>>Its running in my office pc, and my home pc, but
>>>>when i upload to the
>>>>webserver, its giving error as such, anyone able
>>
>>to
>>
>>>>help me to solve
>>>>this issue.
>>>>
>>>>Warning: mysql_fetch_array(): supplied argument
>>
>>is
>>
>>>>not a valid MySQL
>>>>result resource
>>>>
>>>>Thanks in advance.
>>>>
>>>>
>>>
Joined: 24 Feb 2005
Posts: 17
MySQL Connection
MySQL error: Table `domain.tbl_BBY` doesn`t exist
but when i try to do SHOW TABLE, it does shows all the
tables including tbl_BBY, please help
--- Sheila Fenelon <sfenelon@...> wrote:
> What does this tell you?
>
>
> $query = "Select txt_ID FROM tbl_BBY ";
> $result = mysql_query($query);
> if (mysql_errno()) {
> echo "<p>MySQL error: ". mysql_error() .
> "</p>";
> echo "<p>SQL: $query</p>";
> die;
> }
>
>
> Here`s another way to check for errors.
>
>
> $query = "Select txt_ID FROM tbl_BBY ";
> $result = mysql_query($query);
> if (!$result) {
> echo "<p>MySQL error: ". mysql_error() .
> "</p>";
> echo "<p>SQL: $query</p>";
> die;
> }
>
>
> --
> Sheila
> http://www.shefen.com/
>
>
>
> Anuradika Jaganadhan wrote:
> > it shows all the tables in the db, but i m aunable
> to
> > connect using
> > mysql_fetch_array():
> > mysql_fetch_assoc():
> > mysql_num_rows():
> > please help
> >
> >>>>4.1. I am using
> >>>>
> >>>>require("Conn_to_Mysql.php");
> >>>>$query = "Select * from tbl_BBY ";
> >>>>$result = mysql_query($query);
> >>>>while($row = mysql_fetch_array($result,
> >>>>MYSQL_ASSOC))
> >>>>{
> >>>>
> >>>>}
> >>>>
> >>>>Its running in my office pc, and my home pc, but
> >>>>when i upload to the
> >>>>webserver, its giving error as such, anyone able
> >>
> >>to
> >>
> >>>>help me to solve
> >>>>this issue.
> >>>>
> >>>>Warning: mysql_fetch_array(): supplied argument
> >>
> >>is
> >>
> >>>>not a valid MySQL
> >>>>result resource
> >>>>
> >>>>Thanks in advance.
> >>>>
> >>>>
> >>>
>
>
________________________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html
All times are GMT
Page 2 of 3
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Freelace Website Designer - Customer web design and software building.
Booking Calendar - reservation calendar script
Land Surveying - total station instruments and equipments
China Wholesale - Electronics Products
Character Studio - Tutorials and Help
Booking Calendar - reservation calendar script
Land Surveying - total station instruments and equipments
China Wholesale - Electronics Products
Character Studio - Tutorials and Help