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:[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", "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" <[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]
