Hello,
On a list page i have a field with custom view to show some text on mouseover.. this is the code and it works fine
$case = $data['case_no'];
global $conn;
$sql = "SELECT `viewing_date`, `start_time`, `end_time` FROM `viewing` WHERE `case_no` = '".$case."'";
$rs = db_query($sql,$conn);
$row = db_fetch_array($rs);
$rawdate = explode('-', $row['viewing_date']);
$fdate = $rawdate[1]."/".$rawdate[2]."/".$rawdate[0];
$msg = 'Date: '.$fdate.' Start Time: '.$row['start_time'].' End Time: '.$row['end_time'].' Place: '.$row['chapel_name'];
if ($value == "Viewing")
{
$fvalue = '<a href="viewing_edit.php?editid1='.$case.'" onmouseover="showhint(\''.$msg.'\', this, event, \'550px\')" target=_blank><font color="red">Viewing </font></a>';
}
else{
$fvalue = "Error";
}
$value = $fvalue;
On the same list page i need to do the same on another field but i just need to change the table where i'm getting the info.. here is the code but it doesn't work, on mouse over doesn't show anything. however the link works :/
$case = $data['case_no'];
global $conn;
$sql = "SELECT `notes` FROM `counselor_notes` WHERE `case_no` = '".$case."'";
$rs = db_query($sql,$conn);
$row1 = db_fetch_array($rs);
$msg = 'Notes: '. $row1['notes'];
$fvalue = '<a href="counselor_notes_edit.php?editid1='.$case.'" onmouseover="showhint(\''.$msg.'\', this, event, \'500px\')" target=_blank><font color="black">'.$value.' </font></a>';
$value = $fvalue;
after looking at the javascript console in chrome i got this error
70>event.layerX and event.layerY are broken and deprecated in WebKit. They will be removed from the engine in the near future. // line - expedientes_list.php:734
>Uncaught SyntaxError: Unexpected token ILLEGAL
40>event.layerX and event.layerY are broken and deprecated in WebKit. They will be removed from the engine in the near future.
this is the error line on the html page
<td class="runner-cc " ><span id="edit6_coordinator" ><a href="counselor_notes_edit.php?editid1=20120127" onmouseover="showhint('Notes: probando
', this, event, '500px')" target=_blank><font color="black">David </font></a></td>
i don't know what this means.. :/ and i don't understand why it only gives me the error on that field and not on the other one, if the only difference is that im getting the data from another table..
any one knows? please help :S
****new update****
I have found the problem the notes are stored in the table on a field i had set to VARCHAR(3000). on the edit page there is a text area so that the user can update the notes.. if the user hits enter on the text area the showhint on my list page won't work, but i can keep typing, it doesn't matter how long without hitting enter on my keyboard and the showhint will work. is it because of the type of field in mysql? or is there a way to not allow the user to hit enter when entering the notes? or is there a way to store the value suppressing any enters the user might have done?
thanks for your help