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 ""; echo $myrow[3]; echo ""; 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(" >. $myrow[3] .""); > >} > [--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]
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 "$myrow[3]"; } 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(" . $myrow[3] .""); } 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(" >> $myrow[3] .""); >> } >> == >> >> 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)
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(" . $myrow[3] .""); } 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(" >> $myrow[3] .""); >> } >> == >> >> 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(" . $myrow[3] .""); } 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(" >> $myrow[3] .""); >> } >> == >> >> 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(" . $myrow[3] .""); } 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(" >> $myrow[3] .""); >> } >> == >> >> 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)
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(" > $myrow[3] .""); > } > == > > 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)
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(" $myrow[3] .""); } == 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]
[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(" $myrow[3] .""); } == 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]