[i43haresh]

PHP Code:

<?
    $dbcnx = @mysql_connect('localhost', 'Haresh', 'REMOVED');
    mysql_select_db('iwddb',$dbcnx);
    $memberidresult = @mysql_query('SELECT * FROM members');
    
while ($memberarray = mysql_fetch_array($memberidresult))
    {
        $memberid = $memberarray['memberid'];
        echo '<br>The member id is'; echo $memberid;
        $namelink = $memberarray['name'];
        echo '<br>The name link via DB is '; echo $namelink;
        // value of $namelink in database =    <a href="http://www.xyz.com/x/?x=c&amp;z=s&amp;v=1801659&amp;k=' . $memberid . '" target="_blank">Name Link</a>
        // ERROR: $memberid value is not getting passed within $namelink
    }
?>

[bizzar528]

Yeah, you can't do that. The string that comes from the db won't convert the variable in the string to an actual variable after you've pulled it out.

You can rebuild $namelink if it's the same for everyone though...

PHP Code:

$memberid = $memberarray['memberid'];

$namelink = '<a href="http://www.xyz.com/x/?x=c&amp;z=s&amp;v=1801659&amp;k='.$memberid.'" target="_blank">Name Link</a>'; 

[i43haresh]

How to i rebuild this?
If i enter in database only till = <a href="http://www.xyz.com/x/?x=c&amp;z=s&amp;v=1801659&amp;k=

no string shows in echo and hence i cant join 2 strings...


Can you pls help rebuilding this with a sample... your support will be highly appreciated. Thanks in advance.

[i43haresh]

Hi,

I managed to rebuild it :

// value of $namelink in database = <a href="http://www.xyz.com/x/?x=c&amp;z=s&amp;v=1801659&amp;k=
//removed - ' . $memberid . '" target="_blank">Name Link</a>


echo $namelink;echo $memberid;echo '" target="_blank">Name Link</a>';
This works fine now. Thanks.


Just incase you have an easier / better way, pls share. Thanks a ton.