easy array issue.. help newbie ;)

jpfour23

Ok... I am pulling "tooltips" from a database, getting the
$name and $tip

then I am writing a function called tooltip to generate a link in pieces, so that when I want to display a tooltip link i just put:

<? tooltip('Name'); ?>

The problem I am having is matching the right 'Name' in the function with what's in my array. It's frustrating the heck out of me. See code:

dbConnect('mindev');
$sql = "SELECT * FROM tooltip WHERE cat='$catID'";
$result = mysql_query($sql);
if (!$result) {
	echo "Unable to get tooltips from database.<br>";
	echo mysql_error();
	exit;
	} 

while ($row = mysql_fetch_array($result)) {
	$name = $row['name'];
	$tip = $row['tip'];
	$ttip["$name"] = "$tip";
}

// Build Link

function tooltip($tipname) {
	global $ttip;
//	global $name;
//	global $tip;


		while (list($name,$tip) = each($ttip)) {
			if ($name == $tipname) {					

			echo "<a href=\"images/clear.gif\" onclick=\"return wrapContent(event, this.href, 0, 0, '"
			. "<b>" . $tipname . "</b><br>" . htmlspecialchars($ttip[$name]) .
			"', 300)\">";
}
			}

}

zonewatcher

You don't appear to be calling the tooltip function at all in the code displayed. When the php file is called, everything down to the function will be executed so your link will not be generated. If you wanted to use the f(x), an option would be passing it $name and $tip and echo the return value. Something like ...


...

while ($row = mysql_fetch_array($result)) { 
    $name = $row['name']; 
    $tip = $row['tip']; 
    echo tooltip($name,$tip); 
}

You would, of course, have to modify the tooltip function.

HTH ... Bill

jpfour23

Actually this code will be an include at the top of the page... then throughout the page, i want to call tooltip('Subject') or tooltip('Whatever') to use the correct information from the database--which is now plugged into an array.

That make sense?

jpfour23

I coulda swore I had this working a second ago, but now it is not. I have no idea on this one....

dbConnect('mindev');
$sql = "SELECT * FROM tooltip WHERE cat='$catID'";
$result = mysql_query($sql);
if (!$result) {
	echo "Unable to get tooltips from database.<br>";
	echo mysql_error();
	exit;
	} 

while ($row = mysql_fetch_array($result)) {
	$name = $row['name'];
	$tip = $row['tip'];
	$ttip["$name"] = "$tip";
}

// Build Link

function tooltip($tipname) {
	global $ttip;

foreach($ttip as $name => $tip) {
		while ($tipname = each($ttip)) {	
			echo "<a href=\"images/clear.gif\" onclick=\"return wrapContent(event, this.href, 0, 0, '"
			. "<b>" . $name . "</b><br>" . htmlspecialchars($tip) .
			"', 300)\">";
		}

	}

}

Again, the code above will be at the top of the page.... and all throughout the page I want to call:

tooltip('Title')

to do exactly what the function says... somehow it just ain't workin.

Anyone?

jpfour23

Anyone have any suggestions?

sidney

//test array
$ttip=array('subject'=>'Tip1','name'=>'Tip2','whatever'=>'Tip3');


function tooltip($tipname) { 
    global $ttip; 

  if(isset($ttip[$tipname]))
            echo "<a href=\"images/clear.gif\" onclick=\"return wrapContent(event, this.href, 0, 0, '" 
            . "<b>" . $tipname . "</b><br>" . htmlspecialchars($ttip[$tipname]) . 
            "', 300)\">".$tipname."</a>"; 
}
tooltip('subject');

jpfour23

why could i not think that easily?????

thank you, it worked!