Hey Guys,
I'm not sure if this is the right place to ask this question, but to be
honest I didn't know where else to turn since my script deals with mysql.
Here's my problem:
I am using stylesheets and javascript to display a small blurb about a
review on my site and it display is in a stylesheet which is only visible
when the mouse is over the link. The page is here for a reference:
http://www.hardware-unlimited.com/hardware.php (The [Description] link is
where im using java script)
Here's my ordeal, this mysql script generates syntax that is hidden from the
viewer until they put their mouse over a review for a description, however
it has to store this lil bit of syntax 90 times (beacuse I have 90 reviews
listed on the page) and it starts to add up, my page is already 132K and I
need to make it smaller. Is it possible to somehow store these descriptions
in a mysql table or on another page and then have them linked to when you
put your mouse over the link?
Syntax for descriptions is here:
<?php
$db = mysql_connect( "db32.pair.com", "******", "*******");
mysql_select_db( "net3dual_reviews",$db);
$search = mysql_query("SELECT * FROM hwureviews");
while($num=mysql_fetch_array($search)) {
printf ("<span id='%s' class='myStyle'><table bgcolor='#025689' width='300'
style='border-style: ridge; border-color: #00314F'><tr><td><font
face='Tahoma, Verdana, Arial, Helvetica' size='2' color='#FFFFFF'><b><p
align='center'>Description for
%s:</b><br><br></p>%s</font></p></tr></td></table></span>",$num["name"],$num
["name"],$num["info"]);
}
?>
Syntax for links, displaying the descriptions is here:
<?php
$db = mysql_connect( "db32.pair.com", "******", "*******");
mysql_select_db( "net3dual_reviews",$db);
$r = mysql_query("SELECT * FROM hwureviews ORDER BY num DESC");
$max = mysql_query("select max(num) from hwureviews",$db);
while ($info = mysql_fetch_row($max)) {
printf ("<b><font color='#ffffff'>Hardware Reviews - %s Articles
Total</b></font><br>", $info["0"]);
}
while($a=mysql_fetch_array($r)) {
printf ("- <a href=\"%s\">%s</a> (Written by: <a
href=\"mailto:%s\";>%s</a>) - [<a href='%s' onMouseOver='if (window.event ||
document.layers) show(\"%s\",event)'
onMouseOut='hide(\"%s\")'>Description</a>]<br>",$a["url"],$a["name"],$a["ema
il"],$a["author"],$a["url"],$a["name"],$a["name"]);
}
?>
I need to somehow have the "='if (window.event || document.layers)
show(\"%s\",event)' onMouseOut='hide(\"%s\")'" syntax pull its data from a
mysql table or another page, how can I do this?
Thanks!
--------------------------------------------
-Alex "Big Al" Behrens
E-mail: [EMAIL PROTECTED]
Urgent E-mail: [EMAIL PROTECTED] (Please be brief!)
Phone: 651-482-8779
Cell: 651-329-4187
Fax: 651-482-1391
ICQ: 3969599
Owner of the 3D-Unlimited Network:
http://www.3d-unlimited.com
Send News:
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
