almostbob 866 Retired: passive income ROCKS

the code is unneccessarily complex

<img src='image1.jpg' onmouseover='src="image2.jpg";' onmouseout='src="image1.jpg";'>

the only javascript required is to load the second image in the background after the page is loaded and displayed, so there is no mouseover delay

 ...snip .. 

</body>
<script language="javascript" type="text/javascript">
//<![CDATA[
<!-- 
image2 = new Image();
image2.src = "image2.jpg";
//-->
//]]>
</script>
</html>
almostbob 866 Retired: passive income ROCKS

Damn good, I have only one possible idea
calclualtors usually are right justified, the digits extend from the right
so for the input containing the number <input style='text-align:right;' type="text" size="25" length="25" value="" name="ans" style="background:beige;color:black;">

almostbob 866 Retired: passive income ROCKS

topic body: <br />

almostbob 866 Retired: passive income ROCKS

There is an add in library for this function,
not sure how good it is,
http://phplens.com/phpeverywhere/node/view/16

almostbob 866 Retired: passive income ROCKS

popups are blocked on many systems
better is login opens in a layer above the index page and redirect is automatic
less likely to be affected by security softwares

almostbob 866 Retired: passive income ROCKS

the javascript in php that is giving the ip is externally hosted.
only the external ip will be returned by that script,
that script is php outputting javascript so the logic used to generate the javascript is not viewable
I still think that turnstone is likely to have more than one pc on an intranet, and your script is receiving the local intranet address not the external IP coded for
I can (dis)prove this assumption from within turnstone, <?php echo $_SERVER['REMOTE_ADDR']; ?> but I don't know how to do it remotely

almostbob 866 Retired: passive income ROCKS
<tr onclick='open("http://www.google.com/","_blank");'>
<td>google</td>
<td>bla bla</td>
<td>bla bla</td>
</tr>
almostbob 866 Retired: passive income ROCKS

dunno what I did to post the same answer twice

almostbob 866 Retired: passive income ROCKS

What about the Print Screen

dunno how to disable printscreen
don't want to interfere with someones hardware
bad mojo

the background image is in the tif,
it has to download to display,
can make it harder to copy,
but not impossible
I watermark all images, and dump copyright info throughout the exif tables (Irfanview, batch edit and resize)
cant do much more.
the ones that really **expletive deleted** me,
are those who want to link to my files, on my server, and send me dirty email because they cant pull images from the database

there was a problem with the code.......... I did not see at first problem here

left side is your code........ and my first code is on the right......

You are using width/height to resize an image, bad idea
the image on the server should be optimised, stored on the server at the size it is to display
download a 300k large image, and resize it small
or download a 30k small image
much more efficient
my code was width='width of realpic' height='height of realpic' meant to show resizing wasnt available

almostbob 866 Retired: passive income ROCKS

this is better

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> 
<head>
<title>Add help</title>
<meta http-equiv="cache-control" content="no-cache" />
<meta http-equiv="expires" content="Mon, 22 Jul 2000 11:12:01 GMT" />
<!-- Put IE into quirks mode -->
<title><?php echo HOSTDESCRIPTOR ?>: HelpPage</title>
<link rel="stylesheet" type="text/css" href="CSS/Help.css" />
<link rel="stylesheet" href="/CSS/custom-theme/jquery-ui-1.7.1.custom.css"/>
<link rel="stylesheet" href="/CSS/SiteWide.css"/>
<script type="text/javascript" src="/JavaScripts/DWjQuery.js"></script>
<script type="text/javascript" src="/JavaScripts/CL/ComponentLoader.js"></script>
<script type="text/javascript">
$(document).ready( function()
    {
    //load the standard headers.
    $("#header").LoadComponent("<? echo STANDARD_HEADER;?>");
    });
</script>
</head>
<body bgcolor="#eeeeee">
<div style='text-align:center'>
<h2>Amend/Delete Help Record</h2><br>
<form id="HelpUD" name="HelpUD" action="HelpUpdate.php?UID=<?php echo $ID ?>" method=post enctype="multipart/form-data">
<table style="hidden">
<tr><td>Record Type:</td>
<td><input type='text' readonly id="RecordType" name="RecordType" value="<?php echo $ParentString ?>" >
</td></tr>
<tr><td>Topic Title:</td>
<td><input type="text" id="TopicTitle" name="TopicTitle" value="<?php echo $TopicName ?>" maxlength="25">
</td></tr>
<tr><td>Parent:</td>
<td><input type='text' id="Parent" name="Parent" value="<?php echo $Parent ?>" />
</td></tr>
</table>
Topic Body:
<textarea cols="60" rows="10" id="TopicBody" name="TopicBody" value="<?php echo $Topic ?>"></textarea>
</div>
<p><font color='red'><?php echo $Message ?></font></p>
<input type='button' value="Back" onclick="BackClick()" />
<input type='button' value="Delete" onclick="DeleteHelp()" />
<input type='button' value="Update" onclick="UpdateClick()" />
</form>
</div>
<div id="header">loading...
</div>
</body>
</html>

the best criticism/advice I can offer is to use a code highlighting editor, notepad2 notepad++ or any of the others, that will show you when you have forgotten to close a quote.
the code is not valid xhtml see the new line 2, there are other bugs, validate by pointing the validator at a test run url, so there is a value in the script variables
this tool http://validator.w3.org/ will help you …

stockton commented: Thank you for the suggestions +2
almostbob 866 Retired: passive income ROCKS

I used the wizard on install, audio is 32k 16k selectable by user
video is 256K for a 640*400px image at 15frames/sec

almostbob 866 Retired: passive income ROCKS
@media print { img { background:url('./images/copyright.jpg'); } }
<img style="background:url('./images/realpic.jpg')" src='./images/blank.gif' width='width of realpic' height='height of realpic'>
<img style="background:url('./images/anotherpic.jpg')" src='./images/blank.gif' width='width of anotherpic' height='height of anotherpic'>

blank.gif is a 1px transparent .gif image
all images have the same src, the background is the real image
the print styling is generic, can be refined to take a class or id of image to copyright, and allow non-copyright images to print

almostbob 866 Retired: passive income ROCKS

am using camstreams.com, some of the price in the pricey ones is for setup assistance, we didnt need it it was easy
for audio its a matter of a cable from line out on the mix board to line in on the sound card, and choose a stream format
we stream sound and vision separately,
the streams are click to start, not onload, page load delays p__ people off
- have several live cams running, on various sites
and an aggregated view of them all selectable on my ad page, the user can click between them, with separate sound the sound continues when the views are swapped, makes the changes appear seamless
low speed users can just stream sound or video for lower bandwidth

almostbob 866 Retired: passive income ROCKS

add to the above, miss-spelled includes case-sensitive servers where this.jpg may not be the same as this.JPG

almostbob 866 Retired: passive income ROCKS

there arent 17 lines in this file, so is the cause in the included session handler at around line 16

almostbob 866 Retired: passive income ROCKS

I do not suggest the code was the fault
the code in the op works,
its just longer and uses external files

the Fix, is the ip, $_SERVER["REMOTE_ADDR"] is not returning the expected result
add echo $_SERVER["REMOTE_ADDR"]; to check what the result is
the code produced verifies the external ip. - what you see from your office if you ping the client's dotcom
the external ip may not be the one presented to the script when the script is running on the client's intranet. intranet ips typically are in the range 192.168.0.*
the external ip is not static and varies whenever the ISP alters it

almostbob 866 Retired: passive income ROCKS

If they are at the office presumably turnstone, are they on a company intranet, the ip reported may not be the external ip expected, it may be the intranet 192.168.*.*, or similar

no external file ip redirect

<a href="<?php ( $_SERVER['REMOTE_ADDR']== '69.245.218.248' ) ? ( echo 'http://www.turnstone.org/employee2/index.html'; ) : ( echo 'http://www.turnstone.org/notatoffice.html'; ) ?>">link title</a>

also allowing for users who write down the filename at work and type it in at home add a redirect to the /employee2 file to bounce them to 'notatoffice' if that too is not at the required IP

edit:?dunno Why: click plain text toggle and the code looks right, in php there is an extra echo ?

http://validator.w3.org/check?uri=http%3A%2F%2Ftechexpressinc.com%2F&charset=%28detect+automatically%29&doctype=Inline&group=0

http://jigsaw.w3.org/css-validator/validator?uri=http%3A%2F%2Ftechexpressinc.com%2F&profile=css21&usermedium=all&warning=1&lang=en

almostbob 866 Retired: passive income ROCKS

** the above is not be valid code in all circumstance **
it validates if <label> is inside one <td> but does not if <label> spans more than one <td> or <tr>

apologies

almostbob 866 Retired: passive income ROCKS

html <label> tag
anything within the label is clickable for the checkbox

<label for='check1'>Entire Row<!-- any kind of code --> <input type='checkbox' id='check1' value='yes'> Yes <!-- any kind of code --></label>
almostbob 866 Retired: passive income ROCKS

in a where clause where column [I]operator[/I] number is ok where column [I]operator[/I] 'text' text is quoted

query = "SELECT * ";
$query .= "FROM subjects ";
$query .= "WHERE id='" . $subject_id ."' ";// note extra single quotes around $subject
$query .= "LIMIT 1";

my opinion (humble or otherwise) this is a bad way to set out a query, such a risk of typo, all the joins parse to

$query = "SELECT * FROM subjects  WHERE id='$subject_id' LIMIT 1";

is simpler, variables parse inside dquotes. or at least

$query = "SELECT * FROM subjects  WHERE id='".$subject_id."' LIMIT 1";

without some quote mysql sql will assume the text is a resource :- column, table,dbase -: name

almostbob 866 Retired: passive income ROCKS
$query = "SELECT * FROM subjects  WHERE id='$subject_id' LIMIT 1";
//
$query = "SELECT * ";
$query .= "FROM subjects ";
$query .= "WHERE id=" . $subject_id ." ";
$query .= "LIMIT 1";

text field quotes? there arent any in the concatenated version

almostbob 866 Retired: passive income ROCKS

In an rss feed, the output of the php script generating the feed is xml, rss is an xml format

<?xml version="1.0" encoding="ISO-8859-1"?>
<rss version="2.0">
	<channel>
		<title>CBC | Top Stories News</title>
		<link>http://www.cbc.ca/news/?ref=rss</link>
		<description>FOR PERSONAL USE ONLY</description>
		<language>en-ca</language>
		<lastBuildDate>Mon, 31 Aug 2009 15:25:52 EDT</lastBuildDate>
		<copyright>Copyright: (C) Canadian Broadcasting Corporation, http://www.cbc.ca/aboutcbc/discover/termsofuse.html#Rss</copyright>
		<docs>http://www.cbc.ca/rss/</docs>
<!-- /* snipped */ -->
	</channel>
</rss>

so rss2html any of the php addins like magpierss to parse rss will likely work, even though the filenam is .php

php scripts can output images .pdf html csv .doc .xml and a bunch of other formats on execution

there is a good likelyhood that you could point the feedreader to the php script as source
Google does index pages generated by feed2Html, (am using it to add feeds from local newspapers) they show up in site:mysite.com searches

almostbob 866 Retired: passive income ROCKS

just stating that $connection is global won't help much
$connection (see php.net mysql_connect) is ususally defined earlier than line 33 but after the global, something like

$connection="mysql_connect('localhost', 'admin', '1admin') or die(mysql_error())";// host account password

which may be included in a 'connect.php' script if $connection is also accesssed elsewhere, from the look of the error message, there is no database connection
if there is a $connection defined, are the server account and password correct

almostbob 866 Retired: passive income ROCKS

The added <select> has no part in the calculation, its values are all text, so the code where changing the text <select> chanes recalculates the form is not enough
changing the text select item is supposed to change the price values in the size <select> there needs to be another javascript to do so
something like

<TD style="height: 28px; width: 120px;">
<SELECT onChange="populate("price2");calculate();" name="item2" style="width: 133px">
<OPTION value="widget1">widget 1
<OPTION value="widget2">widget 2
<!--snip-->
</SELECT></TD>

where populate() is a javascript that populates the <select><option>s named
this link goes to one available for download, might give you an insight into the code you require

almostbob 866 Retired: passive income ROCKS

no, its a fiction

almostbob 866 Retired: passive income ROCKS

I have an course_enrollment table, and I have a group_student table. The group_student table has the students that belong to the groups. But there a students that have enrolled for courses and they has not been placed in a group yet. Do you know how can I make an query in access that can give me the students that have not been enrolled in a group yet.

Sorry to bother you, but you seems to me a good help.

making assumptions
course_enrolment:id unique autoincrement, lastname,firstname, //and others
group_students:id unique autoincrement,group,student_id, //and others where student_id is the foreign key relating the two tables
select from course_enrollment * where id .... is not in the groups table, table joins mess me up
TRY

SELECT * FROM course_enrolment WHERE id NOT IN (SELECT student_id FROM group_student)

in access it would be something like

SELECT course_enrollement.[*],group_student.[id]
FROM course_enrollment INNER JOIN group_student ON course_enrolment.id = group_students.student_id HAVING (((group_students.[student_id]) Is Null));

have used access twice in my life, don't trust this code

almostbob 866 Retired: passive income ROCKS
<a href='download.php?$filename=whilemyguitar.mp3'>the beatles-while my guitar gently weeps</a>
<?php /* download.php */
if(!session_id) { $hiddenfile="../absolutepath/polkamusic.mp3"; } // evil laugh
else $hiddenfile="../absolutepath/$filename";
header('Content-type: file/mp3'); // I dunno and I'm too lazy to look up (audio/mpeg)?
header('Content-Disposition: attachment; filename="$filename"');
readfile("$hiddenfile");
?>

!logged_in users get polka music for every mp3 they download

slyme commented: Very helpful, thank you. +1
almostbob 866 Retired: passive income ROCKS

using php the user neve sees the url of the file
and without a logged in session nothing

<?php /* download.php */
if(!session_id) { die ('only registered users'); } // better session validation than that but its a thought example
$hiddenfile="../absolutepath/$filename";
header('Content-type: file/mp3'); // I dunno and I'm too lazy to look up (audio/mpeg)?
header('Content-Disposition: attachment; filename="$filename"');
readfile("$hiddenfile");
?>

very poor code unchecked dont think it works its a concept example

almostbob 866 Retired: passive income ROCKS

you already have a query that prints a list of the students able to take the exams
ingonring the bad code for the moment (really bad code)
and the poor field names
output a table in a form something like

<?php echo '<table>';
for each $output ++{echo "<tr><td>$lastname</td><td>$firstname</td><td>$coursename</td><td><input 'name='mark' value='$mark'></td></tr>"; }
echo "</table><input type='submit'value='update marks'></form>"; }

and have the form submit to a script(or self) to update table marks with the marks data
it is a thought exercise this code does not work

almostbob 866 Retired: passive income ROCKS

if a student can only attend 1 course, add the column to the student table
if the student can attend more than one course create a table
marks (id,student_id,course_id,mark)

almostbob 866 Retired: passive income ROCKS

can anyone give me full coding

not without more assistance from you, nobody reading your posts has access to the existing code
database structure, field names, and what code you already have.
we are all giving guidelines,
Graphix' code work standalone
that may not work with what there is already
self-deprecating laughdont use any of the sql date formats, text dates are tedious to manipulate, they have to be converted to numeric for any operation which takes al lot of time and processing (relatively)
a timestamp takes 10bytes stores date and time in one column and can be mined for any part of the date and time, and need only be converted once on input
a text date time is
january 1 2009 10:45.22am (25 bytes) not a lot on 1 row, but a lot on a million rowsspeed test,
examine 10000 text records of dates
find dates between December 1 2008 at 12:15pm and 1 January 2009
echo $date;
- or -
examine 10000 numbers >1228133700 and <1230768000
echo date(d m y, $timestamp)bit overboard 'bout this ... :icon_wink:

almostbob 866 Retired: passive income ROCKS

Thanks for the tip on the ems! Looks good except now that the hover is bold, it displaces the rest of the links. Any suggestions?

<style type='text/css'>
a.menu { width:19%; bottom:0; font-family:'script'; font-size:1.5em; font-weight:normal; }
a.menu:hover {  width:19%; bottom:0; font-family:'script'; font-size:2em; font-weight:bold;  }
</style>

and push the menu to the bottom of the screen (maybe- its been a while)

almostbob 866 Retired: passive income ROCKS

add the marks column to the database default blank/fail
enable it with a query that enumerates the same output as the prior attendance query and asks you to update the mark fields, for each row in the result array
can be all records or single records

almostbob 866 Retired: passive income ROCKS
almostbob 866 Retired: passive income ROCKS

My only answer, dont use any of the sql date formats, text dates are tedious to manipulate, they have to be converted to numeric for any operation which takes al lot of time and processing
a timestamp takes 10bytes stores date and time in one column and can be mined for any part of the date and time, and need only be converted once on input
a text date time is
january 1 2009 10:45.22am (25 bytes) not a lot on 1 row, but a lot on a million rows
speed test,
examine 10000 text records of dates
to find dates between December 1 2008 at 12:15pm and 1 January 2009
echo $date;
or
examine 10000 TIMESTAMPs >1228133700 and <1230768000
echo date(d m y, $timestamp)

bit over passionate 'bout this ... :)

iamthwee commented: Thanks for the heads up! +23
almostbob 866 Retired: passive income ROCKS

it may take redesigning the link images, so that they scale well
after all, blackberry is 200*200px screen, NO image button looks good on a blackberry
not an answer to the question, but - trying to work out why the heavy overhead of image buttons and javascripts, when css can do the same thing very short code

<style type='text/css'>
a.menu { font-family:'script'; font-size:1.5em; font-weight:normal; }
a.menu:hover { font-family:'script'; font-size:2em; font-weight:bold;  }
</style>

Note: 'script' is not necessarily correct, didnt bother to look up a proper font name
Note 2: "em" font sizes rescale automatically to screen resolution

<a class='menu' href="contact.html">Contact Us</a>

to make sure, http://www.browsershots.org is a useful aid, to make sure your site works in different browsers

almostbob 866 Retired: passive income ROCKS

you require information about the time of the update
you put a column in the database, that autopopulates the lastupdate column with
now(), which is an sql construct that does what it looks like it does,
if the data management system is one developed by someone else as a saleable script, such function is probably built in

you then select from the database those records that match the selected date spans
inserting the returned values into an automailer is another question,
if the data management system is one developed by someone else as a saleable script, such function is probably built in

where the first reply did not make the answer pop out obviously,
I have to assume someone else wrote the dbms, so hopefully you got a manual, and the reporting function is written in the manual
fingers crossed on your behalf, sql is not as hard as it looks
good luck

almostbob 866 Retired: passive income ROCKS

a database column for timestamp of the last update, filled on update with sql now()

select from table * where lastupdate < (now()-(5*365*24*60*60));

5*365*24*60*60 = 157680000 ~ 5 years of seconds

almostbob 866 Retired: passive income ROCKS

The W3c Recommendation for element sizes is %
example : excluding <head>

<div style='text-align:center; width:100%;'>
<a href="Body.html">Welcome to the World of Cat Bent</a>
</div>
<div style='text-align:center; width:100%;'>
<img src="Images/Purple_lips.gif" width="385" height="481" />
</div>
<div style='text-align:center; width:100%; bottom:0;'>
<a href="about.html" onmouseover="MM_swapImage('About','','Images/CatBent_aa_rollover.gif',1)" onmouseout="MM_swapImgRestore()"><img src="Images/CatBent_aa.gif" name="About" width="15%" height="100" border="0" id="About" /></a>
<a href="yourvoice.html" onmouseover="MM_swapImage('Your Voice Vocal Studio','','Images/CatBent_yv_rollover.gif',1)" onmouseout="MM_swapImgRestore()"><img src="Images/CatBent_yv.gif" name="Your Voice Vocal Studio" width="20%" height="100" border="0" id="Your Voice Vocal Studio" /></a>
<a href="mmss.html" onmouseover="MM_swapImage('Musical Mischeif','','Images/CatBent_mmss_rollover.gif',1)" onmouseout="MM_swapImgRestore()"><img src="Images/CatBent_mmss.gif" name="Musical Mischeif" width="20%" height="100" border="0" id="Musical Mischeif" /></a>
<a href="creative.html" onmouseover="MM_swapImage('Creative','','Images/CatBent_cc_rollover.gif',1)" onmouseout="MM_swapImgRestore()"><img src="Images/CatBent_cc.gif" name="Creative" width="20%" height="100" border="0" id="Creative" /></a>
<a href="contact.html" onmouseover="MM_swapImage('Contact','','Images/CatBent_contact_rollover.gif',1)" onmouseout="MM_swapImgRestore()"><img src="Images/CatBent_contact.gif" name="Contact" width="15%" height="100"  border="0" id="Contact" /></a><a href="catbent.com/contact" onmouseover="MM_swapImage('Contact','','Images/CatBent_cc_rollover.gif',1)" onmouseout="MM_swapImgRestore()"></a></div>

framesets are so passe

the styles would normally be in an external css file, but I got lazy

almostbob 866 Retired: passive income ROCKS

if xhtml,

<input type='checkbox' name='yournamehere' value='yourvaluehere' checked='checked' />
almostbob 866 Retired: passive income ROCKS
almostbob 866 Retired: passive income ROCKS
<label for='this'>related this </label><input type='radio' id='this' name='oneonly' value='single'><br>
<label for='that'>related that </label><input type='radio' id='that' name='oneonly' value='double'><br>
<label for='unrelated'>unrelated</label><input id='unrelated'type='checkbox' name='unrelated' value='lots'>

no javascript required

**edit** sorry Manuz, just read posts and saw your prior answer

almostbob 866 Retired: passive income ROCKS

the student table does not need the text course names
the reporting logic can print the text names if necessary from the course table

student (studentNum,firstName,lastName,),
course (courseID, CourseName,courseTotalCapacity),
course_allocation (studentNum,courseID)

one link between each datatable

almostbob 866 Retired: passive income ROCKS

should i post a new Thread on how to set up?

@media all {
@media print {
@media screen {

resurrecting the dead thread but,
@media all gives the same result as css without a media definition, gets applied to everything unless overwritten

I have @media all { /* generic styles */ } set because I tend to come back in months (as in this thread) and have to work out what the **expletive deleted** I have done to make 'this' do 'that' @media screen { /* watermarks for images (transparent png overlays, take that you right click save as), auto resizing em font sizes to be user friendly, web safe colors */ } and @media print { /* logo image top left, menus display:none, pt font sizes, all black text, images without copysafe overlays */ } all css within the displayable ability of the device works, its just a matter of deciding exactly how you want the page to display on certain devices, and putting the css in place

almostbob 866 Retired: passive income ROCKS

four functions in two lines of code, or two functions in one line of code
extrapolated over a very large dataset, one times out, one don't, because whatever you do on input, used the same way on report generation or data manipulation slows down
once the dates are stored in the database as text, every manipulation will have to take every date and convert it to a timestamp to compare it, to select on date ranges
extrapolated over a very large database, timeout

select * where date >  1251245826  and date < 126235900

is quite fast compared to
?? -off the top of my head its been so long since I used anything but a timestamp that the code to
convert each date in the database to a timestamp,
store the id and timestamp in a temp table,
select id on the basis of the timestamp value in the temp table,
select * where id is in the temp output dataset,
drop the temp table
just wont pop into my head
but I guess that it will take much longer than one line of code to execute

database design is probably the most important thing to consider at this point
a few records, anything will work (not work well, just work)
increasing record numbers requires good design, by which time it is too late to implement design changes

almostbob 866 Retired: passive income ROCKS

the php string to time function strtotime() allows this

<?php echo date('l dS \o\f F Y h:i:s A', strtotime('+7 day')); ?>

format the date() how you need,

storing the timestamp in the db is more efficient than storing any text representation of the date and time
comparisons are simpler, date ranges are simpler, each record is only 10bytes
it is easier to process a numeric timestamp and echo the formatted version on output

almostbob 866 Retired: passive income ROCKS

an iframe contains a full html file
at minimum <iframe src='file'>alternate text</iframe> rambling on, as thoughts just wander, try <a href="" onclick="window.top.document.getElementById('element').style.display = 'none'"> as there may be other elements in the document tree(?), not just the immediate parent

almostbob 866 Retired: passive income ROCKS
#Menu li:hover a, #Menu li.over a { background: url(../../images/red/grad2-1.gif) repeat-x top #626A69; }

the css above points to a different folder to all the others, 2parents/images intead of parent/images

http://jigsaw.w3.org/css-validator/ W3C css validator -- the code itself checks out
http://validator.w3.org/ W3C html validator
http://www.browsershots.org to checkout your site in browsers to which you don't have direct access

3 tools incase they are useful

almostbob 866 Retired: passive income ROCKS

cwarn23,

I tried it but still could not solve the problem. please I'm trying with all soughts of different function but could not fix it. Please help me.

Thank you for the Reply

Regards
chavan

perhaps post a little more of the code, the balls up could be the combination of another bottleneck with this one

almostbob 866 Retired: passive income ROCKS
insert into #temptable ( IDENTITY(int, 1,1) AS number, select * FROM table ORDER BY score desc) SELECT * FROM #temptable ORDER BY number DROP TABLE #temptable

thought process only, cant guarantee the code
mysql is likely buggy its been a while
select the data you need into a temp table with an autoincrementing field
print the temp table
drop the temp table