[RESOLVED] using onMouseover in php

[Anon]

I have a mySQL database that holds name and address information. My page displays an ordered list of surnames. I would like to generate an alert box that shows the 'first name' onMouseover of a surname in the list.

The following code generates the list of surnames as html anchors. The onMouseover works but I get a javascript error message - e.g. if the name I mousedover was 'Smith' the error message says "'Paul' is undefined" (i.e. as in 'Paul Smith')

here's the code:

'first name' is held in $row[1] and surname in $row[2].

for ($i = 0; $row=mysql_fetch_row($result); $i++)
{

$name = "<a href='#' onMouseover='alert(" . $row[1] . ")'>" . $row[2] . "</a>";

//etc..
}

I note that this works for $row[0] but why do I get an error for elements beyond [0]?

I tried setting a variable to $row[2] and putting that in the alert, but that didn't work.

[Anon]

perhaps you are forgetting that arrays (like $row[]) are zero-based (i.e. the first element is zero, not one). Without seeing you're other code it is difficult to see - maybe 'first name' is held in $row[0] and surname in $row[1]?

[Anon]

Hi Craig - thanks for replying. I have posted the rest of the code below (except the code for connecting and opening the database, I've also taken out the error messages etc. This code generates a list of surnames (found in the 3rd element of the row[] array, i.e. row[2]). $name holds the data formatted as an anchor so that I can test for a mouseover. But when I mouse over the surname, I get an error message - that the VALUE contained in the element is an undefined variable. Any help would be gratefully received. Thanks, Tony.

$mainSQL="SELECT * FROM main
Order by surname";

$result=mysql_query($mainSQL,$link);

echo ("<table width='80%' border='0' cellpadding='3'>");

for ($i = 0; $row=mysql_fetch_row($result); $i++)
{
$name = "<a href='#'
onMouseover='alert( " .

$row[1] .

")" .
"'>" .
$row[2] .
"</a>";

echo ("<tr><td valign='top'>
<span style='font-family: verdana;
color: navy;
font-size: 11px; '>

            $name
       </span>
   </td> </tr>");

}

echo("</table>");

?>

[xpherism]

Hi Tony!

It seems to me that you simply forgot to quote row[1]. eg. it should look something like,

$name = "<a href='#' onMouseover='alert(\"" . $row[1] . "\")'>" . $row[2] . "</a>";

I used double-quotes as you used single-quote in your <A> tag. And escaped them so php wouldn't complain... :-)

goodluck

[Anon]

IT WORKS!!

thank you !

[agnaldovb]

Pls you can send me your scripts php and javascript, for I can understand how you to access mysql onmouseover?

I need make this for country regions...

tks
Agnaldo

[NogDog]

As this thread nearly 7 years old, I suggest you do not hold your breath waiting for a response. :rolleyes: