Unable to declare a global variable

[rkolbe]

Or whatever the proper terms would be....

All I am trying to do is call some data from MySQL, then have it bring the row ID with it, and limit the characters...then put a link at the end which says [more] and will link to that ID and only show that row ID.

For some reason his variable isnt getting passed. Here is the code.

function GetRecortarTexto ($vTxt, $Car) {
  if (strlen($vTxt) > $Car) {
       return substr($vTxt, 0, $Car) . "... <a href=\"?id=$rows[id]\" class=toplink>[more]</a>";
  } else return $vTxt;
}

and some more stuff here..

while ($rows = mysql_fetch_array($result)) {
		$rows[id];
		$rows[body] = GetRecortarTexto($rows[body], $max_length);
		echo" <table cellpadding=\"4\" cellspacing=\"1\" bgcolor=\"#000000\" style='width:100%;font-family:Verdana;font-size:12px;'>\n
			<tr>\n
			  <td class=\"tablehead\" height=\"20\">\n
				<p><font color=\"#FFFFFF\"><strong>".$rows[title]."</strong></font><br>\n
				<font color=\"#CCCCCC\">Posted By ".$rows[author]." on ". date("l dS of F Y @ h:i A", $rows[date])."</font></p></td>\n
			</tr>\n
			<tr>\n
			  <td bgcolor=\"#FFFFFF\"><font color=\"#000000\">".$rows[body]."</tr>\n
		  </table><p></p>\n";
	}

Thanks all who are willing to help. This is getting frustrating. I have the feeling Im really over looking something. I've tried $_REQUEST, GET and nothing seems to work 🙁

[chads2k2]

MySQL has a function within it that will limit the characters returned by the select statement. Gosh, I don't remember what it is but I am sure on here someone will be able to tell you. Hit up the database board and someone should know. Don't create code when teh database can do the work for you. :-D

Chad

[rkolbe]

Originally posted by chads2k2
MySQL has a function within it that will limit the characters returned by the select statement. Gosh, I don't remember what it is but I am sure on here someone will be able to tell you. Hit up the database board and someone should know. Don't create code when teh database can do the work for you. :-D

Chad

I got it to work...I used $GLOBALS