[PHP-DB] Simple database error (SPACE)
//-- Anybody can help me with this problem (I think
//-- it's simple but im to stupid to know the answer)
==
while ($myrow = mysql_fetch_row($result)) {
echo(
a href=m_template.php?nick=$myrow[3]$myrow[3] ./a);
}
==
If I have a database in $myrow[3] and it has space, it didn't work.
Example Database : John Doe
__
it will shown
m_template?nick=John
I NEED PHP to show the space and Doe also
so it's suppose to be :
m_template?nick=John Doe
_
www.kaskus.com - FREE EMAIL SERVICE
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Simple database error (SPACE)
try urlencode in the PHP manual ... I believe that'll do the trick!
Cheers
Dave
-Original Message-
From: Nagasea [mailto:[EMAIL PROTECTED]]
Sent: 30 August 2001 23:02
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Simple database error (SPACE)
//-- Anybody can help me with this problem (I think
//-- it's simple but im to stupid to know the answer)
==
while ($myrow = mysql_fetch_row($result)) {
echo(
a href=m_template.php?nick=$myrow[3]$myrow[3] ./a);
}
==
If I have a database in $myrow[3] and it has space, it didn't work.
Example Database : John Doe
__
it will shown
m_template?nick=John
I NEED PHP to show the space and Doe also
so it's suppose to be :
m_template?nick=John Doe
_
www.kaskus.com - FREE EMAIL SERVICE
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Simple database error (SPACE)
Hello!!!
Use mysql_fetch_object...
$myrow-WHATEVER
Whatever = whatever the field name is
Dan
--
From: Nagasea
Reply To: [EMAIL PROTECTED]
Sent: Thursday, August 30, 2001 5:01 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Simple database error (SPACE)
//-- Anybody can help me with this problem (I think
//-- it's simple but im to stupid to know the answer)
==
while ($myrow = mysql_fetch_row($result)) {
echo(
a href=m_template.php?nick=$myrow[3]$myrow[3] ./a);
}
==
If I have a database in $myrow[3] and it has space, it didn't work.
Example Database : John Doe
__
it will shown
m_template?nick=John
I NEED PHP to show the space and Doe also
so it's suppose to be :
m_template?nick=John Doe
_
www.kaskus.com - FREE EMAIL SERVICE
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail:
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Simple database error (SPACE)
it's still not working :(
maybe u need my script to see
$db = mysql_connect(localhost, ,pass);
mysql_select_db(mydatabase_com,$db);
$result = mysql_query(SELECT * FROM big_member WHERE position='Squads' ORDER by first
LIMIT 0,300,$db);
while ($myrow = mysql_fetch_row($result)) {
echo(
a href=m_template.php?nick=$myrow[3]. $myrow[3] ./a);
}
I need to make $myrow give the result exactly from the database (including the space)
--- Brunner, Daniel [EMAIL PROTECTED]
wrote:
Hello!!!
Use mysql_fetch_object...
$myrow-WHATEVER
Whatever = whatever the field name is
Dan
--
From:Nagasea
Reply To:[EMAIL PROTECTED]
Sent:Thursday, August 30, 2001 5:01 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Simple database error (SPACE)
//-- Anybody can help me with this problem (I think
//-- it's simple but im to stupid to know the answer)
==
while ($myrow = mysql_fetch_row($result)) {
echo(
a href=m_template.php?nick=$myrow[3]$myrow[3] ./a);
}
==
If I have a database in $myrow[3] and it has space, it didn't work.
Example Database : John Doe
__
it will shown
m_template?nick=John
I NEED PHP to show the space and Doe also
so it's suppose to be :
m_template?nick=John Doe
_
www.kaskus.com - FREE EMAIL SERVICE
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail:
[EMAIL PROTECTED]
_
www.kaskus.com - FREE EMAIL SERVICE
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Simple database error (SPACE)
it's still not working :(
maybe u need my script to see
$db = mysql_connect(localhost, ,pass);
mysql_select_db(mydatabase_com,$db);
$result = mysql_query(SELECT * FROM big_member WHERE position='Squads' ORDER by first
LIMIT 0,300,$db);
while ($myrow = mysql_fetch_row($result)) {
echo(
a href=m_template.php?nick=$myrow[3]. $myrow[3] ./a);
}
I need to make $myrow give the result exactly from the database (including the space)
--- Brunner, Daniel [EMAIL PROTECTED]
wrote:
Hello!!!
Use mysql_fetch_object...
$myrow-WHATEVER
Whatever = whatever the field name is
Dan
--
From:Nagasea
Reply To:[EMAIL PROTECTED]
Sent:Thursday, August 30, 2001 5:01 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Simple database error (SPACE)
//-- Anybody can help me with this problem (I think
//-- it's simple but im to stupid to know the answer)
==
while ($myrow = mysql_fetch_row($result)) {
echo(
a href=m_template.php?nick=$myrow[3]$myrow[3] ./a);
}
==
If I have a database in $myrow[3] and it has space, it didn't work.
Example Database : John Doe
__
it will shown
m_template?nick=John
I NEED PHP to show the space and Doe also
so it's suppose to be :
m_template?nick=John Doe
_
www.kaskus.com - FREE EMAIL SERVICE
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail:
[EMAIL PROTECTED]
_
www.kaskus.com - FREE EMAIL SERVICE
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Simple database error (SPACE)
it's still not working :(
maybe u need my script to see
$db = mysql_connect(localhost, ,pass);
mysql_select_db(mydatabase_com,$db);
$result = mysql_query(SELECT * FROM big_member WHERE position='Squads' ORDER by first
LIMIT 0,300,$db);
while ($myrow = mysql_fetch_row($result)) {
echo(
a href=m_template.php?nick=$myrow[3]. $myrow[3] ./a);
}
I need to make $myrow give the result exactly from the database (including the space)
--- Brunner, Daniel [EMAIL PROTECTED]
wrote:
Hello!!!
Use mysql_fetch_object...
$myrow-WHATEVER
Whatever = whatever the field name is
Dan
--
From:Nagasea
Reply To:[EMAIL PROTECTED]
Sent:Thursday, August 30, 2001 5:01 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Simple database error (SPACE)
//-- Anybody can help me with this problem (I think
//-- it's simple but im to stupid to know the answer)
==
while ($myrow = mysql_fetch_row($result)) {
echo(
a href=m_template.php?nick=$myrow[3]$myrow[3] ./a);
}
==
If I have a database in $myrow[3] and it has space, it didn't work.
Example Database : John Doe
__
it will shown
m_template?nick=John
I NEED PHP to show the space and Doe also
so it's suppose to be :
m_template?nick=John Doe
_
www.kaskus.com - FREE EMAIL SERVICE
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail:
[EMAIL PROTECTED]
_
www.kaskus.com - FREE EMAIL SERVICE
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Simple database error (SPACE)
OK, try this
$db = mysql_connect(localhost, ,pass);
mysql_select_db(mydatabase_com,$db);
$result = mysql_query(SELECT * FROM big_member WHERE position='Squads'
ORDER by first LIMIT 0,300,$db);
while ($myrow = mysql_fetch_row($result)) {
$link_string = urlencode($myrow[3]);
echo a
href=\m_template.php?nick=$link_string\$myrow[3]/a;
}
and you shouldn't really be doing a SELECT * - just name the columns you
really need :-)
-Original Message-
From: Nagasea [mailto:[EMAIL PROTECTED]]
Sent: 31 August 2001 01:01
To: Brunner, Daniel; '[EMAIL PROTECTED]'
Cc: PHP List (E-mail)
Subject: RE: [PHP-DB] Simple database error (SPACE)
it's still not working :(
maybe u need my script to see
$db = mysql_connect(localhost, ,pass);
mysql_select_db(mydatabase_com,$db);
$result = mysql_query(SELECT * FROM big_member WHERE position='Squads'
ORDER by first LIMIT 0,300,$db);
while ($myrow = mysql_fetch_row($result)) {
echo(
a href=m_template.php?nick=$myrow[3]. $myrow[3] ./a);
}
I need to make $myrow give the result exactly from the database
(including the space)
--- Brunner, Daniel [EMAIL PROTECTED]
wrote:
Hello!!!
Use mysql_fetch_object...
$myrow-WHATEVER
Whatever = whatever the field name is
Dan
--
From:Nagasea
Reply To:[EMAIL PROTECTED]
Sent:Thursday, August 30, 2001 5:01 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Simple database error (SPACE)
//-- Anybody can help me with this problem (I think
//-- it's simple but im to stupid to know the answer)
==
while ($myrow = mysql_fetch_row($result)) {
echo(
a href=m_template.php?nick=$myrow[3]$myrow[3] ./a);
}
==
If I have a database in $myrow[3] and it has space, it didn't work.
Example Database : John Doe
__
it will shown
m_template?nick=John
I NEED PHP to show the space and Doe also
so it's suppose to be :
m_template?nick=John Doe
_
www.kaskus.com - FREE EMAIL SERVICE
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail:
[EMAIL PROTECTED]
_
www.kaskus.com - FREE EMAIL SERVICE
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Simple database error (SPACE)
DW was correct, Nagasea. The way to do what you want to do is to use the
urlencode (and perhaps the urldecode) PHP command(s). They are in the PHP
manual. I don't understand what it was that DB told you to do, so I cannot
comment on that, but the correct solution to your problem lies with urlencode.
Additionally, you will want to put quotes around the HREF in your anchor
tag. Perhaps if you rewrote your echo to something like this
(WARNING:untested!):
echo a href=\m_template.php?nick=;
echo urlencode($myrow[3]);
echo \;
echo $myrow[3];
echo /a;
Oh, yeah, and I broke it apart for easy reading. You could concatenate it
all in one big echo, but think maintainability.
Hope this helps,
Doug
At 05:01 PM 8/30/01 -0700, Nagasea wrote:
it's still not working :(
maybe u need my script to see
$db = mysql_connect(localhost, ,pass);
mysql_select_db(mydatabase_com,$db);
$result = mysql_query(SELECT * FROM big_member WHERE position='Squads'
ORDER by first LIMIT 0,300,$db);
while ($myrow = mysql_fetch_row($result)) {
echo(
a href=m_template.php?nick=$myrow[3]. $myrow[3] ./a);
}
[--snip--]
--Doug's Signature File
~ ~ ~ I'm proud to work for GLISnet, Michigan's best ISP ~ ~ ~
--1.888.445.4763---8am to 8pm every day---http://www.glis.net--
The views and opinions expressed in this email are my
own and may not be those of my employer.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
