RE: [PHP-DB] Simple database error (SPACE)

OK, try this $db = mysql_connect("localhost", "xxxx","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:nagasea@kaskus.com] Sent: 31 August 2001 01:01 To: Brunner, Daniel; 'nagasea@kaskus.com' 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", "xxxx","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" <daniel.brunner@duni.com> > wrote: >Hello!!! > > >Use mysql_fetch_object... > > >$myrow->WHATEVER > > >Whatever = whatever the field name is.... > > > >Dan > > > > > > > > > >> ---------- >> From: Nagasea >> Reply To: nagasea@kaskus.com >> Sent: Thursday, August 30, 2001 5:01 PM >> To: php-db@lists.php.net >> 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: php-db-unsubscribe@lists.php.net >> For additional commands, e-mail: php-db-help@lists.php.net >> To contact the list administrators, e-mail: >> php-list-admin@lists.php.net >> >> _____________________________________________________________ www.kaskus.com - FREE EMAIL SERVICE -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net