Penny_Rollo

Webalizer's what I'm used to using - for the last 20 years or so - not all of us are as techie as the people on here Webalizer was provided by the ISP where my site was hosted - and it's been bundled with cpanel last couple of years by huge hosting-providers like 123-reg in the UK, so it's not 'dead', as such, even if it doesn't suit everyone. However clearly not all hosting providers offer it, and I couldn't figure out how to make the most recent version of Webalizer (old though it is) actually *operate* (try though I did, for a long time). Some techie stuff I apparently just can't do (long-standing issue). I guess we all have different capabilities. * *however*. Eleven days ago I found *this* page. https://www.tobias-schwarz.net/programmierung/webalizer_guie.html Absolutely brilliant. Webalizer for Windows. plug-and-play. It was downloaded and installed - and 31 days of logs analysed - in less than an hour. So I've posted the download address above in the hope that other non-techie people will find it. * The Tobias Schwartz page also links to the Stone Steps version of Webalizer - project release notes at https://www.stonesteps.ca/projects/webalizer/releasenotes/ (up to 2015). Stone Steps Webalizer is now hosted on GitHub at https://github.com/StoneStepsInc/StoneStepsWebalizer (latest download version 6.3.0, 29/01/23). The Stone Steps stuff is as unfathomable to me as the original Webalizer 2.23-08 one was, in terms of installation/use, but I've linked it here in case of any interest/use to anyone else who reads this thread.

Appreciate the reply @kicken, however had previously downloaded the webalizer pages from the software archive at the archive site (Webalizer 2.01). Earlier I downloaded Awstats (from https://sourceforge.net/projects/awstats/files/AWStats/7.9/awstats-7.9.zip/download?use_mirror=netix ) as recommended by @gizmola (many thanks for the peripheral info btw) but neither Arachnophilia nor Notepad++ would open the README.md file, and the Windows Installer was not included in the download (ref https://awstats.sourceforge.io/docs/awstats_setup.html ). *however*. In the 'downloads' folder here I then discovered several files, downloaded (somehow) at the time of attempting the download from ftp.mrunix.net via https://webalizer.net/download.html (per link provided by @requinix). These files are: download (2.06Kb) (no idea what this is). webalizer-2.23-08-src.tgz (the file requested). webalizer-2.23-08-src (1).tgz (another copy of same). download (1) (another copy of the first one). webalizer-2.23-08-src.zip webalizer-2.23-08-src (1).zip webalizer-2.23-08-src (2).zip ... all of these must have downloaded during the three minutes of attempting the mrunix.net ftp, even though the ftp program said the connection was not made. Anyway I now have five complete sets of the latest version of Webalizer which is some way further forward from when I first asked the question, so, very much appreciate the replies so far. Next I need to extract the Webalizer files and figure out (a) where to put them [with a log file to test] and (b) how to 'call' the program to start. Any insights would be helpful, along the way.

Thank you for your reply @requinix I went to the linked page, which said "Go to the download page and get yourself a copy." ... so I went to the download page https://webalizer.net/download.html and selected Tar/Gzip archive (.tgz). It wouldn't download. I had selected my FTP program (FlashFXP) and it did try (11 times) before the connection timed out. [17:21:35] FlashFXP 5.4.0 (build 3970) [17:21:35] Support Forums https://www.flashfxp.com/forum/ [17:21:35] [17:21:35] Winsock 2.2 -- OpenSSL 1.1.0e 16 Feb 2017 [17:21:36] [R] Connecting to ftp.mrunix.net -> DNS=ftp.mrunix.net IP=45.76.61.72 PORT=21 [17:21:46] [R] Connection failed (Connection timed out) [17:21:46] [R] Delaying for 10 seconds before reconnect attempt #1 [17:21:56] [R] Attempting to Reconnect. [17:21:56] [R] Connecting to ftp.mrunix.net -> DNS=ftp.mrunix.net IP=45.76.61.72 PORT=21 (attempt # 1) [17:22:06] [R] Connection failed (Connection timed out) [17:22:06] [R] Delaying for 10 seconds before reconnect I've pasted in above, what it said, in case that is of any relevance.

I have no experience of doing command-line stuff, so am hoping to find some way of installing Webalizer that uses simple ftp to upload files and some way of calling the program to run. 25 years internet experience and some ability with php/mysql, but I don't understand where the Webalizer files go (in a directory, yes, and with a log file to analyse) but *where* to put them and *how* to call them, I haven't figured out at all (yet). I have heard that the latest stable Webalizer version is 2.23 but (also) don't know where to get this from. Any help appreciated.

[quote author=mjdamato link=topic=113840.msg465533#msg465533 date=1163097297] No. It is a lot to go through. But, I can tell that there is a lot of unneeded code. For example the big sections where you are echoing out "<? echo $data["BFG002"] ?>" should be put in a function and called, when needed. And it makes no sense to go in and out of PHP code between those values. For example, you can reduce all of this:.... To this: [code]<?php for ($i=1; $i<103; $i++) {   $aryIdx = "BFG" . str_pad($i, 3, '0', STR_PAD_LEFT);   echo " " . $data[$aryIdx]; } ?>[/code][/quote] Thank you :D  I have *no* idea how you wrote that [though maybe I'll figure it out the logic of it in due course, when I understand more about how all this works]. I tried replacing the previous code (on a page which used all 104 boxes for one of the definitions) and it works fine - see http://ccgi.rollobks.force9.co.uk/shellsTESTnew01.php .  For comparison there is the finished page (from the new run I did yesterday) at http://www.happychild.org.uk/gridbuilding/chemistry/shells/index.htm#electrons . I'm keenly aware that the code I write goes very much the-long-way-round but it takes (usually) so very long to discover the ways of doing things at all.  For example I spent four hours the other night trying to fathom out how to get php pages with specific content to be created, for all the new itemfileref themes.  Just couldn't find what I needed and ended up creating them manually, then the individual folders for each on my hard drive to contain the received html page after the individual conversion to static-html was done, then the change-of-name on each file (eg positivechargeindex.htm to an index.htm file within the positivecharge folder, positivechargeindex.htm having been called up singly from positivecharge.php by an individual call-up script).  It's all very laborious!  but I just have to work with whatever I'm capable of doing, at each stage, and trust that somehow I will discover ways to streamline the processes, along the way. Regarding the original question, and your answer, I was able to slightly adapt the code you gave me, that called up the positivecharge itemfileref rows, so as to call up the lines singly for each block.  To achieve this I had to (a) have presorted the database by (a) itemfileref and (b) clusterref, and then go through and put 0001 to however many, in the first column (number) against each individual itemfileref block (eg there were five lines for positivecharge, so it would have had 0001 to 0005, as per the page at http://ccgi.rollobks.force9.co.uk/positivechargeTESTnew01.php ). The code I used was: [quote]<?php $SQL="SELECT * FROM azchem0008 WHERE itemfileref='positivecharge' AND number='0001'"; $result = mysql_query($SQL); $data = mysql_fetch_array($result); ?> [/quote] (ie I was able to create all itemfileref pages with potential lines from 0001 - 0040, to cover present and future eventualities).  It's still "a long way round"!  and having to separately number the lines on the sorted db each time I run it takes a fair while, but *so* much quicker than having to put individual line numbers on each call-up page, each time, which I was having to do initially and the reason why I asked on these boards in the first place.  So I really appreciate you having helped :) Regards, Penny.

[quote author=mjdamato link=topic=113840.msg463730#msg463730 date=1162832823] The fact that data is showing up multiple times (especially with the sample code i provided) leads me to believe that there is another loop inside which the code we are working on exists. Can you post the code for the page in question in it's entirety? Hopefully it is not too massive.[/quote] Hi mjdamoto, did the code help you to figure out what the problem was? Regards, Penny.

[quote author=xtentic link=topic=114045.msg463919#msg463919 date=1162849882] Hi, I understand the solution you have offerd me. But it's not the kind of solution i was hoping for. The list changes regularly so i need to convert the given data from the excel cell in realtime. Some scripts on the internet can do that... But as writen before they cost alot. And i think that the solution should me not that hard... Thanks for your support! :)[/quote] You're welcome :)  sorry the info wasn't exactly what you needed for your application. Regards, Penny.

[quote author=xtentic link=topic=114045.msg463824#msg463824 date=1162839925] Hi all, First i appoligise for my bad english. ;) For a friend i need to create a script that can read XLS documents. Well that's not the problem anymore... with the code (down here) i've already writen i can read tru the document. All rows and colums... but there one fault.. ROW A has normal characters (like A-Z) but row C contains thai carakters (using font : Angsana New in EXCEL or WORD). When i run the following script i see the words on ROW A displayed correctly but on row C wich contains THAI language words i only see ??? ? ? ? ?????.[/quote] Hi xtentic, I understand the problem you're having (sort of) and I know how to get Excel to display the hex codes (or whatever they're called) rather than the foreign language characters, so as to output a .txt file that doesn't have ???? wherever the foreign language characters should be. (see explanation at http://www.phpfreaks.com/forums/index.php/topic,110192.msg444978.html#msg444978 0 ). Not sure what you're doing with the language bits after calling them up, but if it's for a webpage, browsers will display the characters relating to the hex codes accurately, ie if you use the generated hex codes from the Excel conversion in place of the Thai characters. Hope this makes sense :)  please ask, if not. Regards, Penny.

[quote author=mjdamato link=topic=113840.msg463730#msg463730 date=1162832823] The fact that data is showing up multiple times (especially with the sample code i provided) leads me to believe that there is another loop inside which the code we are working on exists. Can you post the code for the page in question in it's entirety? Hopefully it is not too massive.[/quote] Okay, I've quoted it below.  And yes it's fairly long :) Slightly embarrassed at displaying how very rudimentary my knowledge of php/mysql is  :-[  The index pages (eg positivecharge) all have to be created individually on the basis of (a) making a template (b) creating a positivecharge.php file (and each of all the other itemfileref catagories) and then doing a "find" on "zzz" and pasting in line numbers for that specific category (hence the zzz entries further down the page when I had run out of positivecharge lines). [note - afterwards - five of the zzz entries and following blocks have been removed as the post got rejected as over-length, but I've left the one in after the four positivecharge blocks, so you can see what I was referring to - have also had to remove other extraneous bits of the page because of the "length" factor, but nothing that contained any php coding] The db opening bit is at the start, and the close db bit at the end, but it had already struck me that I was asking the db to look at a line and then telling it to look at another, without first telling it to stop looking at the first line.  I recognise that I could have closed the db each time and then re-opened it again before the next instruction but I didn't want to place too much load on the server (it's shared with up to 200,000 other people all customers of the same ISP). Anyway FWIW the page source code is below [I've blanked out the specific db access details, password etc., obviously] [quote] <?php $db = mysql_connect("XXXXXXXX","XXXXXXX","XXXXXXX"); mysql_select_db('XXXXXX', $db); $SQL="SELECT * FROM azchem0003"; $result = mysql_query("Select * from azchem0003 where number='112'"); $data = mysql_fetch_array($result); ?> <HTML> <HEAD> <META NAME="Generator" CONTENT="Corel WordPerfect 8"> <BASE HREF="http://www.happychild.org.uk/gridbuilding/chemistry/<? echo $data["itemfileref"] ?>/index.htm"> <META NAME="DATE" CONTENT="10/10/2006"> <META NAME="Author" CONTENT="Penny"> <meta name="description" content="3D GridBuilding - Chemistry - <? echo $data["itemmc"] ?> - at FREEWAY and Project HappyChild"> <meta name="distribution" content="global"> <meta name="keywords" content="3D gridbuilding, <? echo $data["biol-chem-phys"] ?>, <? echo $data["itemfileref"] ?>, science, freeway, project happychild, educate, education, learn, learning, home, child, children, travel, overseas, help"> <TITLE>3D GridBuilding - Chemistry - <? echo $data["itemmc"] ?> - at Project HappyChild</TITLE> </HEAD> <BODY TEXT="#000000" LINK="#000000" VLINK="#000050" ALINK="#c0c0c0" BGCOLOR="#baac9a"> <CENTER> <TABLE ALIGN="CENTER" BORDER="7" WIDTH="100%" CELLPADDING="0" CELLSPACING="0"> <TR><TD ALIGN="CENTER" BGCOLOR="#fffeff"> <CENTER> <TABLE ALIGN="CENTER" BORDER="0" WIDTH="100%" CELLPADDING="0" CELLSPACING="0"> <TR><TD ALIGN="CENTER" WIDTH="20%"><A HREF="http://www.happychild.org.uk/gridbuilding/index.htm"><img src="http://www.happychild.org.uk/Webimage/gridworld.png" border=0 alt="3D gridbuilding - science"></A></TD> <TD ALIGN="CENTER" WIDTH="60%" BGCOLOR="#c7c7c7"><FONT FACE="Arial" SIZE="-2"><BR></FONT> <FONT FACE="Verdana" SIZE="+3" COLOR="#ffffff"><STRONG><? echo $data["itemmc"] ?></STRONG></FONT></TD> <TD ALIGN="CENTER" WIDTH="20%"><A HREF="http://www.happychild.org.uk/gridbuilding/chemistry/index.htm"><img src="http://www.happychild.org.uk/Webimage/gridworld.png" border=0 alt="3D gridbuilding - <? echo $data["biol-chem-phys"] ?>"></A></TD></TR></TABLE> </CENTER> </TD> </TR></TABLE> </CENTER> <BR> <FONT FACE="Arial" SIZE="-2"><BR></FONT> <FONT FACE="Arial" SIZE="-2"><BR></FONT> <?php $SQL="SELECT * FROM azchem0003"; $result = mysql_query("Select * from azchem0003 where number='112'"); $data = mysql_fetch_array($result); ?> <A NAME="<? echo $data["clusterref"] ?>"></A> <CENTER> <TABLE BGCOLOR="#e2e2e2" ALIGN="CENTER" BORDER="5" WIDTH="100%" CELLPADDING="2" CELLSPACING="4"> <TR> <TD WIDTH="20%" ALIGN="CENTER" BGCOLOR="#ffffff"><A HREF="http://www.happychild.org.uk/gridbuilding/science/AZ/index.htm#<? echo $data["itemfileref"] ?>"><FONT FACE="Arial" SIZE="-2" COLOR="#000000"><STRONG>SCIENCE A-Z<BR> <? echo $data["itemlc"] ?></STRONG></FONT></A></TD> <TD ROWSPAN="2" WIDTH="60%" ALIGN="CENTER" BGCOLOR="#ffffff"><blockquote> <P ALIGN="JUSTIFY"><FONT FACE="Comic Sans MS" SIZE="-1" COLOR="#000000"><STRONG><BR> <? echo $data["BFG001"] ?> <? echo $data["BFG002"] ?> <? echo $data["BFG003"] ?> <? echo $data["BFG004"] ?> <? echo $data["BFG005"] ?> <? echo $data["BFG006"] ?> <? echo $data["BFG007"] ?> <? echo $data["BFG008"] ?> <? echo $data["BFG009"] ?> <? echo $data["BFG010"] ?> <? echo $data["BFG011"] ?> <? echo $data["BFG012"] ?> <? echo $data["BFG013"] ?> <? echo $data["BFG014"] ?> <? echo $data["BFG015"] ?> <? echo $data["BFG016"] ?> <? echo $data["BFG017"] ?> <? echo $data["BFG018"] ?> <? echo $data["BFG019"] ?> <? echo $data["BFG020"] ?> <? echo $data["BFG021"] ?> <? echo $data["BFG022"] ?> <? echo $data["BFG023"] ?> <? echo $data["BFG024"] ?> <? echo $data["BFG025"] ?> <? echo $data["BFG026"] ?> <? echo $data["BFG027"] ?> <? echo $data["BFG028"] ?> <? echo $data["BFG029"] ?> <? echo $data["BFG030"] ?> <? echo $data["BFG031"] ?> <? echo $data["BFG032"] ?> <? echo $data["BFG033"] ?> <? echo $data["BFG034"] ?> <? echo $data["BFG035"] ?> <? echo $data["BFG036"] ?> <? echo $data["BFG037"] ?> <? echo $data["BFG038"] ?> <? echo $data["BFG039"] ?> <? echo $data["BFG040"] ?> <? echo $data["BFG041"] ?> <? echo $data["BFG042"] ?> <? echo $data["BFG043"] ?> <? echo $data["BFG044"] ?> <? echo $data["BFG045"] ?> <? echo $data["BFG046"] ?> <? echo $data["BFG047"] ?> <? echo $data["BFG048"] ?> <? echo $data["BFG049"] ?> <? echo $data["BFG050"] ?>  <? echo $data["BFG051"] ?> <? echo $data["BFG052"] ?> <? echo $data["BFG053"] ?> <? echo $data["BFG054"] ?> <? echo $data["BFG055"] ?> <? echo $data["BFG056"] ?> <? echo $data["BFG057"] ?> <? echo $data["BFG058"] ?> <? echo $data["BFG059"] ?> <? echo $data["BFG060"] ?> <? echo $data["BFG061"] ?> <? echo $data["BFG062"] ?> <? echo $data["BFG063"] ?> <? echo $data["BFG064"] ?> <? echo $data["BFG065"] ?> <? echo $data["BFG066"] ?> <? echo $data["BFG067"] ?> <? echo $data["BFG068"] ?> <? echo $data["BFG069"] ?> <? echo $data["BFG070"] ?> <? echo $data["BFG071"] ?> <? echo $data["BFG072"] ?> <? echo $data["BFG073"] ?> <? echo $data["BFG074"] ?> <? echo $data["BFG075"] ?> <? echo $data["BFG076"] ?> <? echo $data["BFG077"] ?> <? echo $data["BFG078"] ?> <? echo $data["BFG079"] ?> <? echo $data["BFG080"] ?> <? echo $data["BFG081"] ?> <? echo $data["BFG082"] ?> <? echo $data["BFG083"] ?> <? echo $data["BFG084"] ?> <? echo $data["BFG085"] ?> <? echo $data["BFG086"] ?> <? echo $data["BFG087"] ?> <? echo $data["BFG088"] ?> <? echo $data["BFG089"] ?> <? echo $data["BFG090"] ?> <? echo $data["BFG091"] ?> <? echo $data["BFG092"] ?> <? echo $data["BFG093"] ?> <? echo $data["BFG094"] ?> <? echo $data["BFG095"] ?> <? echo $data["BFG096"] ?> <? echo $data["BFG097"] ?> <? echo $data["BFG098"] ?> <? echo $data["BFG099"] ?> <? echo $data["BFG100"] ?> <? echo $data["BFG101"] ?> <? echo $data["BFG102"] ?> <? echo $data["BFG103"] ?> <? echo $data["BFG104"] ?></STRONG></FONT></P> </blockquote></TD> <TD WIDTH="20%" ALIGN="CENTER" BGCOLOR="#ffffff"><A HREF="http://www.happychild.org.uk/gridbuilding/chemistry/AZ/index.htm#<? echo $data["itemfileref"] ?>"><FONT FACE="Arial" SIZE="-2" COLOR="#000000"><STRONG>CHEMISTRY A-Z<BR> <? echo $data["itemlc"] ?></STRONG></FONT></A></TD> <TR><TD WIDTH="20%" ALIGN="CENTER" BGCOLOR="#ffffff"><A HREF="http://www.happychild.org.uk/gridbuilding/science/AZ/index.htm#<? echo $data["clusterref"] ?>"><FONT FACE="Arial" SIZE="-2" COLOR="#000000"><STRONG>SCIENCE A-Z<BR> cluster: <? echo $data["clusterlc"] ?></STRONG></FONT></A></TD> </TD> <TD WIDTH="20%" ALIGN="CENTER" BGCOLOR="#ffffff"><A HREF="http://www.happychild.org.uk/gridbuilding/chemistry/AZ/index.htm#<? echo $data["clusterref"] ?>"><FONT FACE="Arial" SIZE="-2" COLOR="#000000"><STRONG>CHEMISTRY A-Z<BR> cluster: <? echo $data["clusterlc"] ?></STRONG></FONT></A></TD></TD> </TABLE> </CENTER> <BR> <?php $SQL="SELECT * FROM azchem0003"; $result = mysql_query("Select * from azchem0003 where number='113'"); $data = mysql_fetch_array($result); ?> <A NAME="<? echo $data["clusterref"] ?>"></A> <CENTER> <TABLE BGCOLOR="#e2e2e2" ALIGN="CENTER" BORDER="5" WIDTH="100%" CELLPADDING="2" CELLSPACING="4"> <TR> <TD WIDTH="20%" ALIGN="CENTER" BGCOLOR="#ffffff"><A HREF="http://www.happychild.org.uk/gridbuilding/science/AZ/index.htm#<? echo $data["itemfileref"] ?>"><FONT FACE="Arial" SIZE="-2" COLOR="#000000"><STRONG>SCIENCE A-Z<BR> <? echo $data["itemlc"] ?></STRONG></FONT></A></TD> <TD ROWSPAN="2" WIDTH="60%" ALIGN="CENTER" BGCOLOR="#ffffff"><blockquote> <P ALIGN="JUSTIFY"><FONT FACE="Comic Sans MS" SIZE="-1" COLOR="#000000"><STRONG><BR> <? echo $data["BFG001"] ?> <? echo $data["BFG002"] ?> <? echo $data["BFG003"] ?> <? echo $data["BFG004"] ?> <? echo $data["BFG005"] ?> <? echo $data["BFG006"] ?> <? echo $data["BFG007"] ?> <? echo $data["BFG008"] ?> <? echo $data["BFG009"] ?> <? echo $data["BFG010"] ?> <? echo $data["BFG011"] ?> <? echo $data["BFG012"] ?> <? echo $data["BFG013"] ?> <? echo $data["BFG014"] ?> <? echo $data["BFG015"] ?> <? echo $data["BFG016"] ?> <? echo $data["BFG017"] ?> <? echo $data["BFG018"] ?> <? echo $data["BFG019"] ?> <? echo $data["BFG020"] ?> <? echo $data["BFG021"] ?> <? echo $data["BFG022"] ?> <? echo $data["BFG023"] ?> <? echo $data["BFG024"] ?> <? echo $data["BFG025"] ?> <? echo $data["BFG026"] ?> <? echo $data["BFG027"] ?> <? echo $data["BFG028"] ?> <? echo $data["BFG029"] ?> <? echo $data["BFG030"] ?> <? echo $data["BFG031"] ?> <? echo $data["BFG032"] ?> <? echo $data["BFG033"] ?> <? echo $data["BFG034"] ?> <? echo $data["BFG035"] ?> <? echo $data["BFG036"] ?> <? echo $data["BFG037"] ?> <? echo $data["BFG038"] ?> <? echo $data["BFG039"] ?> <? echo $data["BFG040"] ?> <? echo $data["BFG041"] ?> <? echo $data["BFG042"] ?> <? echo $data["BFG043"] ?> <? echo $data["BFG044"] ?> <? echo $data["BFG045"] ?> <? echo $data["BFG046"] ?> <? echo $data["BFG047"] ?> <? echo $data["BFG048"] ?> <? echo $data["BFG049"] ?> <? echo $data["BFG050"] ?>  <? echo $data["BFG051"] ?> <? echo $data["BFG052"] ?> <? echo $data["BFG053"] ?> <? echo $data["BFG054"] ?> <? echo $data["BFG055"] ?> <? echo $data["BFG056"] ?> <? echo $data["BFG057"] ?> <? echo $data["BFG058"] ?> <? echo $data["BFG059"] ?> <? echo $data["BFG060"] ?> <? echo $data["BFG061"] ?> <? echo $data["BFG062"] ?> <? echo $data["BFG063"] ?> <? echo $data["BFG064"] ?> <? echo $data["BFG065"] ?> <? echo $data["BFG066"] ?> <? echo $data["BFG067"] ?> <? echo $data["BFG068"] ?> <? echo $data["BFG069"] ?> <? echo $data["BFG070"] ?> <? echo $data["BFG071"] ?> <? echo $data["BFG072"] ?> <? echo $data["BFG073"] ?> <? echo $data["BFG074"] ?> <? echo $data["BFG075"] ?> <? echo $data["BFG076"] ?> <? echo $data["BFG077"] ?> <? echo $data["BFG078"] ?> <? echo $data["BFG079"] ?> <? echo $data["BFG080"] ?> <? echo $data["BFG081"] ?> <? echo $data["BFG082"] ?> <? echo $data["BFG083"] ?> <? echo $data["BFG084"] ?> <? echo $data["BFG085"] ?> <? echo $data["BFG086"] ?> <? echo $data["BFG087"] ?> <? echo $data["BFG088"] ?> <? echo $data["BFG089"] ?> <? echo $data["BFG090"] ?> <? echo $data["BFG091"] ?> <? echo $data["BFG092"] ?> <? echo $data["BFG093"] ?> <? echo $data["BFG094"] ?> <? echo $data["BFG095"] ?> <? echo $data["BFG096"] ?> <? echo $data["BFG097"] ?> <? echo $data["BFG098"] ?> <? echo $data["BFG099"] ?> <? echo $data["BFG100"] ?> <? echo $data["BFG101"] ?> <? echo $data["BFG102"] ?> <? echo $data["BFG103"] ?> <? echo $data["BFG104"] ?></STRONG></FONT></P> </blockquote></TD> <TD WIDTH="20%" ALIGN="CENTER" BGCOLOR="#ffffff"><A HREF="http://www.happychild.org.uk/gridbuilding/chemistry/AZ/index.htm#<? echo $data["itemfileref"] ?>"><FONT FACE="Arial" SIZE="-2" COLOR="#000000"><STRONG>CHEMISTRY A-Z<BR> <? echo $data["itemlc"] ?></STRONG></FONT></A></TD> <TR><TD WIDTH="20%" ALIGN="CENTER" BGCOLOR="#ffffff"><A HREF="http://www.happychild.org.uk/gridbuilding/science/AZ/index.htm#<? echo $data["clusterref"] ?>"><FONT FACE="Arial" SIZE="-2" COLOR="#000000"><STRONG>SCIENCE A-Z<BR> cluster: <? echo $data["clusterlc"] ?></STRONG></FONT></A></TD> </TD> <TD WIDTH="20%" ALIGN="CENTER" BGCOLOR="#ffffff"><A HREF="http://www.happychild.org.uk/gridbuilding/chemistry/AZ/index.htm#<? echo $data["clusterref"] ?>"><FONT FACE="Arial" SIZE="-2" COLOR="#000000"><STRONG>CHEMISTRY A-Z<BR> cluster: <? echo $data["clusterlc"] ?></STRONG></FONT></A></TD></TD> </TABLE> </CENTER> <BR> <?php $SQL="SELECT * FROM azchem0003"; $result = mysql_query("Select * from azchem0003 where number='114'"); $data = mysql_fetch_array($result); ?> <A NAME="<? echo $data["clusterref"] ?>"></A> <CENTER> <TABLE BGCOLOR="#e2e2e2" ALIGN="CENTER" BORDER="5" WIDTH="100%" CELLPADDING="2" CELLSPACING="4"> <TR> <TD WIDTH="20%" ALIGN="CENTER" BGCOLOR="#ffffff"><A HREF="http://www.happychild.org.uk/gridbuilding/science/AZ/index.htm#<? echo $data["itemfileref"] ?>"><FONT FACE="Arial" SIZE="-2" COLOR="#000000"><STRONG>SCIENCE A-Z<BR> <? echo $data["itemlc"] ?></STRONG></FONT></A></TD> <TD ROWSPAN="2" WIDTH="60%" ALIGN="CENTER" BGCOLOR="#ffffff"><blockquote> <P ALIGN="JUSTIFY"><FONT FACE="Comic Sans MS" SIZE="-1" COLOR="#000000"><STRONG><BR> <? echo $data["BFG001"] ?> <? echo $data["BFG002"] ?> <? echo $data["BFG003"] ?> <? echo $data["BFG004"] ?> <? echo $data["BFG005"] ?> <? echo $data["BFG006"] ?> <? echo $data["BFG007"] ?> <? echo $data["BFG008"] ?> <? echo $data["BFG009"] ?> <? echo $data["BFG010"] ?> <? echo $data["BFG011"] ?> <? echo $data["BFG012"] ?> <? echo $data["BFG013"] ?> <? echo $data["BFG014"] ?> <? echo $data["BFG015"] ?> <? echo $data["BFG016"] ?> <? echo $data["BFG017"] ?> <? echo $data["BFG018"] ?> <? echo $data["BFG019"] ?> <? echo $data["BFG020"] ?> <? echo $data["BFG021"] ?> <? echo $data["BFG022"] ?> <? echo $data["BFG023"] ?> <? echo $data["BFG024"] ?> <? echo $data["BFG025"] ?> <? echo $data["BFG026"] ?> <? echo $data["BFG027"] ?> <? echo $data["BFG028"] ?> <? echo $data["BFG029"] ?> <? echo $data["BFG030"] ?> <? echo $data["BFG031"] ?> <? echo $data["BFG032"] ?> <? echo $data["BFG033"] ?> <? echo $data["BFG034"] ?> <? echo $data["BFG035"] ?> <? echo $data["BFG036"] ?> <? echo $data["BFG037"] ?> <? echo $data["BFG038"] ?> <? echo $data["BFG039"] ?> <? echo $data["BFG040"] ?> <? echo $data["BFG041"] ?> <? echo $data["BFG042"] ?> <? echo $data["BFG043"] ?> <? echo $data["BFG044"] ?> <? echo $data["BFG045"] ?> <? echo $data["BFG046"] ?> <? echo $data["BFG047"] ?> <? echo $data["BFG048"] ?> <? echo $data["BFG049"] ?> <? echo $data["BFG050"] ?>  <? echo $data["BFG051"] ?> <? echo $data["BFG052"] ?> <? echo $data["BFG053"] ?> <? echo $data["BFG054"] ?> <? echo $data["BFG055"] ?> <? echo $data["BFG056"] ?> <? echo $data["BFG057"] ?> <? echo $data["BFG058"] ?> <? echo $data["BFG059"] ?> <? echo $data["BFG060"] ?> <? echo $data["BFG061"] ?> <? echo $data["BFG062"] ?> <? echo $data["BFG063"] ?> <? echo $data["BFG064"] ?> <? echo $data["BFG065"] ?> <? echo $data["BFG066"] ?> <? echo $data["BFG067"] ?> <? echo $data["BFG068"] ?> <? echo $data["BFG069"] ?> <? echo $data["BFG070"] ?> <? echo $data["BFG071"] ?> <? echo $data["BFG072"] ?> <? echo $data["BFG073"] ?> <? echo $data["BFG074"] ?> <? echo $data["BFG075"] ?> <? echo $data["BFG076"] ?> <? echo $data["BFG077"] ?> <? echo $data["BFG078"] ?> <? echo $data["BFG079"] ?> <? echo $data["BFG080"] ?> <? echo $data["BFG081"] ?> <? echo $data["BFG082"] ?> <? echo $data["BFG083"] ?> <? echo $data["BFG084"] ?> <? echo $data["BFG085"] ?> <? echo $data["BFG086"] ?> <? echo $data["BFG087"] ?> <? echo $data["BFG088"] ?> <? echo $data["BFG089"] ?> <? echo $data["BFG090"] ?> <? echo $data["BFG091"] ?> <? echo $data["BFG092"] ?> <? echo $data["BFG093"] ?> <? echo $data["BFG094"] ?> <? echo $data["BFG095"] ?> <? echo $data["BFG096"] ?> <? echo $data["BFG097"] ?> <? echo $data["BFG098"] ?> <? echo $data["BFG099"] ?> <? echo $data["BFG100"] ?> <? echo $data["BFG101"] ?> <? echo $data["BFG102"] ?> <? echo $data["BFG103"] ?> <? echo $data["BFG104"] ?></STRONG></FONT></P> </blockquote></TD> <TD WIDTH="20%" ALIGN="CENTER" BGCOLOR="#ffffff"><A HREF="http://www.happychild.org.uk/gridbuilding/chemistry/AZ/index.htm#<? echo $data["itemfileref"] ?>"><FONT FACE="Arial" SIZE="-2" COLOR="#000000"><STRONG>CHEMISTRY A-Z<BR> <? echo $data["itemlc"] ?></STRONG></FONT></A></TD> <TR><TD WIDTH="20%" ALIGN="CENTER" BGCOLOR="#ffffff"><A HREF="http://www.happychild.org.uk/gridbuilding/science/AZ/index.htm#<? echo $data["clusterref"] ?>"><FONT FACE="Arial" SIZE="-2" COLOR="#000000"><STRONG>SCIENCE A-Z<BR> cluster: <? echo $data["clusterlc"] ?></STRONG></FONT></A></TD> </TD> <TD WIDTH="20%" ALIGN="CENTER" BGCOLOR="#ffffff"><A HREF="http://www.happychild.org.uk/gridbuilding/chemistry/AZ/index.htm#<? echo $data["clusterref"] ?>"><FONT FACE="Arial" SIZE="-2" COLOR="#000000"><STRONG>CHEMISTRY A-Z<BR> cluster: <? echo $data["clusterlc"] ?></STRONG></FONT></A></TD></TD> </TABLE> </CENTER> <BR> <?php $SQL="SELECT * FROM azchem0003"; $result = mysql_query("Select * from azchem0003 where number='115'"); $data = mysql_fetch_array($result); ?> <A NAME="<? echo $data["clusterref"] ?>"></A> <CENTER> <TABLE BGCOLOR="#e2e2e2" ALIGN="CENTER" BORDER="5" WIDTH="100%" CELLPADDING="2" CELLSPACING="4"> <TR> <TD WIDTH="20%" ALIGN="CENTER" BGCOLOR="#ffffff"><A HREF="http://www.happychild.org.uk/gridbuilding/science/AZ/index.htm#<? echo $data["itemfileref"] ?>"><FONT FACE="Arial" SIZE="-2" COLOR="#000000"><STRONG>SCIENCE A-Z<BR> <? echo $data["itemlc"] ?></STRONG></FONT></A></TD> <TD ROWSPAN="2" WIDTH="60%" ALIGN="CENTER" BGCOLOR="#ffffff"><blockquote> <P ALIGN="JUSTIFY"><FONT FACE="Comic Sans MS" SIZE="-1" COLOR="#000000"><STRONG><BR> <? echo $data["BFG001"] ?> <? echo $data["BFG002"] ?> <? echo $data["BFG003"] ?> <? echo $data["BFG004"] ?> <? echo $data["BFG005"] ?> <? echo $data["BFG006"] ?> <? echo $data["BFG007"] ?> <? echo $data["BFG008"] ?> <? echo $data["BFG009"] ?> <? echo $data["BFG010"] ?> <? echo $data["BFG011"] ?> <? echo $data["BFG012"] ?> <? echo $data["BFG013"] ?> <? echo $data["BFG014"] ?> <? echo $data["BFG015"] ?> <? echo $data["BFG016"] ?> <? echo $data["BFG017"] ?> <? echo $data["BFG018"] ?> <? echo $data["BFG019"] ?> <? echo $data["BFG020"] ?> <? echo $data["BFG021"] ?> <? echo $data["BFG022"] ?> <? echo $data["BFG023"] ?> <? echo $data["BFG024"] ?> <? echo $data["BFG025"] ?> <? echo $data["BFG026"] ?> <? echo $data["BFG027"] ?> <? echo $data["BFG028"] ?> <? echo $data["BFG029"] ?> <? echo $data["BFG030"] ?> <? echo $data["BFG031"] ?> <? echo $data["BFG032"] ?> <? echo $data["BFG033"] ?> <? echo $data["BFG034"] ?> <? echo $data["BFG035"] ?> <? echo $data["BFG036"] ?> <? echo $data["BFG037"] ?> <? echo $data["BFG038"] ?> <? echo $data["BFG039"] ?> <? echo $data["BFG040"] ?> <? echo $data["BFG041"] ?> <? echo $data["BFG042"] ?> <? echo $data["BFG043"] ?> <? echo $data["BFG044"] ?> <? echo $data["BFG045"] ?> <? echo $data["BFG046"] ?> <? echo $data["BFG047"] ?> <? echo $data["BFG048"] ?> <? echo $data["BFG049"] ?> <? echo $data["BFG050"] ?>  <? echo $data["BFG051"] ?> <? echo $data["BFG052"] ?> <? echo $data["BFG053"] ?> <? echo $data["BFG054"] ?> <? echo $data["BFG055"] ?> <? echo $data["BFG056"] ?> <? echo $data["BFG057"] ?> <? echo $data["BFG058"] ?> <? echo $data["BFG059"] ?> <? echo $data["BFG060"] ?> <? echo $data["BFG061"] ?> <? echo $data["BFG062"] ?> <? echo $data["BFG063"] ?> <? echo $data["BFG064"] ?> <? echo $data["BFG065"] ?> <? echo $data["BFG066"] ?> <? echo $data["BFG067"] ?> <? echo $data["BFG068"] ?> <? echo $data["BFG069"] ?> <? echo $data["BFG070"] ?> <? echo $data["BFG071"] ?> <? echo $data["BFG072"] ?> <? echo $data["BFG073"] ?> <? echo $data["BFG074"] ?> <? echo $data["BFG075"] ?> <? echo $data["BFG076"] ?> <? echo $data["BFG077"] ?> <? echo $data["BFG078"] ?> <? echo $data["BFG079"] ?> <? echo $data["BFG080"] ?> <? echo $data["BFG081"] ?> <? echo $data["BFG082"] ?> <? echo $data["BFG083"] ?> <? echo $data["BFG084"] ?> <? echo $data["BFG085"] ?> <? echo $data["BFG086"] ?> <? echo $data["BFG087"] ?> <? echo $data["BFG088"] ?> <? echo $data["BFG089"] ?> <? echo $data["BFG090"] ?> <? echo $data["BFG091"] ?> <? echo $data["BFG092"] ?> <? echo $data["BFG093"] ?> <? echo $data["BFG094"] ?> <? echo $data["BFG095"] ?> <? echo $data["BFG096"] ?> <? echo $data["BFG097"] ?> <? echo $data["BFG098"] ?> <? echo $data["BFG099"] ?> <? echo $data["BFG100"] ?> <? echo $data["BFG101"] ?> <? echo $data["BFG102"] ?> <? echo $data["BFG103"] ?> <? echo $data["BFG104"] ?></STRONG></FONT></P> </blockquote></TD> <TD WIDTH="20%" ALIGN="CENTER" BGCOLOR="#ffffff"><A HREF="http://www.happychild.org.uk/gridbuilding/chemistry/AZ/index.htm#<? echo $data["itemfileref"] ?>"><FONT FACE="Arial" SIZE="-2" COLOR="#000000"><STRONG>CHEMISTRY A-Z<BR> <? echo $data["itemlc"] ?></STRONG></FONT></A></TD> <TR><TD WIDTH="20%" ALIGN="CENTER" BGCOLOR="#ffffff"><A HREF="http://www.happychild.org.uk/gridbuilding/science/AZ/index.htm#<? echo $data["clusterref"] ?>"><FONT FACE="Arial" SIZE="-2" COLOR="#000000"><STRONG>SCIENCE A-Z<BR> cluster: <? echo $data["clusterlc"] ?></STRONG></FONT></A></TD> </TD> <TD WIDTH="20%" ALIGN="CENTER" BGCOLOR="#ffffff"><A HREF="http://www.happychild.org.uk/gridbuilding/chemistry/AZ/index.htm#<? echo $data["clusterref"] ?>"><FONT FACE="Arial" SIZE="-2" COLOR="#000000"><STRONG>CHEMISTRY A-Z<BR> cluster: <? echo $data["clusterlc"] ?></STRONG></FONT></A></TD></TD> </TABLE> </CENTER> <BR> <?php $SQL="SELECT * FROM azchem0003"; $result = mysql_query("Select * from azchem0003 where number='zzz'"); $data = mysql_fetch_array($result); ?> <A NAME="<? echo $data["clusterref"] ?>"></A> <CENTER> <TABLE BGCOLOR="#e2e2e2" ALIGN="CENTER" BORDER="5" WIDTH="100%" CELLPADDING="2" CELLSPACING="4"> <TR> <TD WIDTH="20%" ALIGN="CENTER" BGCOLOR="#ffffff"><A HREF="http://www.happychild.org.uk/gridbuilding/science/AZ/index.htm#<? echo $data["itemfileref"] ?>"><FONT FACE="Arial" SIZE="-2" COLOR="#000000"><STRONG>SCIENCE A-Z<BR> <? echo $data["itemlc"] ?></STRONG></FONT></A></TD> <TD ROWSPAN="2" WIDTH="60%" ALIGN="CENTER" BGCOLOR="#ffffff"><blockquote> <P ALIGN="JUSTIFY"><FONT FACE="Comic Sans MS" SIZE="-1" COLOR="#000000"><STRONG><BR> <? echo $data["BFG001"] ?> <? echo $data["BFG002"] ?> <? echo $data["BFG003"] ?> <? echo $data["BFG004"] ?> <? echo $data["BFG005"] ?> <? echo $data["BFG006"] ?> <? echo $data["BFG007"] ?> <? echo $data["BFG008"] ?> <? echo $data["BFG009"] ?> <? echo $data["BFG010"] ?> <? echo $data["BFG011"] ?> <? echo $data["BFG012"] ?> <? echo $data["BFG013"] ?> <? echo $data["BFG014"] ?> <? echo $data["BFG015"] ?> <? echo $data["BFG016"] ?> <? echo $data["BFG017"] ?> <? echo $data["BFG018"] ?> <? echo $data["BFG019"] ?> <? echo $data["BFG020"] ?> <? echo $data["BFG021"] ?> <? echo $data["BFG022"] ?> <? echo $data["BFG023"] ?> <? echo $data["BFG024"] ?> <? echo $data["BFG025"] ?> <? echo $data["BFG026"] ?> <? echo $data["BFG027"] ?> <? echo $data["BFG028"] ?> <? echo $data["BFG029"] ?> <? echo $data["BFG030"] ?> <? echo $data["BFG031"] ?> <? echo $data["BFG032"] ?> <? echo $data["BFG033"] ?> <? echo $data["BFG034"] ?> <? echo $data["BFG035"] ?> <? echo $data["BFG036"] ?> <? echo $data["BFG037"] ?> <? echo $data["BFG038"] ?> <? echo $data["BFG039"] ?> <? echo $data["BFG040"] ?> <? echo $data["BFG041"] ?> <? echo $data["BFG042"] ?> <? echo $data["BFG043"] ?> <? echo $data["BFG044"] ?> <? echo $data["BFG045"] ?> <? echo $data["BFG046"] ?> <? echo $data["BFG047"] ?> <? echo $data["BFG048"] ?> <? echo $data["BFG049"] ?> <? echo $data["BFG050"] ?>  <? echo $data["BFG051"] ?> <? echo $data["BFG052"] ?> <? echo $data["BFG053"] ?> <? echo $data["BFG054"] ?> <? echo $data["BFG055"] ?> <? echo $data["BFG056"] ?> <? echo $data["BFG057"] ?> <? echo $data["BFG058"] ?> <? echo $data["BFG059"] ?> <? echo $data["BFG060"] ?> <? echo $data["BFG061"] ?> <? echo $data["BFG062"] ?> <? echo $data["BFG063"] ?> <? echo $data["BFG064"] ?> <? echo $data["BFG065"] ?> <? echo $data["BFG066"] ?> <? echo $data["BFG067"] ?> <? echo $data["BFG068"] ?> <? echo $data["BFG069"] ?> <? echo $data["BFG070"] ?> <? echo $data["BFG071"] ?> <? echo $data["BFG072"] ?> <? echo $data["BFG073"] ?> <? echo $data["BFG074"] ?> <? echo $data["BFG075"] ?> <? echo $data["BFG076"] ?> <? echo $data["BFG077"] ?> <? echo $data["BFG078"] ?> <? echo $data["BFG079"] ?> <? echo $data["BFG080"] ?> <? echo $data["BFG081"] ?> <? echo $data["BFG082"] ?> <? echo $data["BFG083"] ?> <? echo $data["BFG084"] ?> <? echo $data["BFG085"] ?> <? echo $data["BFG086"] ?> <? echo $data["BFG087"] ?> <? echo $data["BFG088"] ?> <? echo $data["BFG089"] ?> <? echo $data["BFG090"] ?> <? echo $data["BFG091"] ?> <? echo $data["BFG092"] ?> <? echo $data["BFG093"] ?> <? echo $data["BFG094"] ?> <? echo $data["BFG095"] ?> <? echo $data["BFG096"] ?> <? echo $data["BFG097"] ?> <? echo $data["BFG098"] ?> <? echo $data["BFG099"] ?> <? echo $data["BFG100"] ?> <? echo $data["BFG101"] ?> <? echo $data["BFG102"] ?> <? echo $data["BFG103"] ?> <? echo $data["BFG104"] ?></STRONG></FONT></P> </blockquote></TD> <TD WIDTH="20%" ALIGN="CENTER" BGCOLOR="#ffffff"><A HREF="http://www.happychild.org.uk/gridbuilding/chemistry/AZ/index.htm#<? echo $data["itemfileref"] ?>"><FONT FACE="Arial" SIZE="-2" COLOR="#000000"><STRONG>CHEMISTRY A-Z<BR> <? echo $data["itemlc"] ?></STRONG></FONT></A></TD> <TR><TD WIDTH="20%" ALIGN="CENTER" BGCOLOR="#ffffff"><A HREF="http://www.happychild.org.uk/gridbuilding/science/AZ/index.htm#<? echo $data["clusterref"] ?>"><FONT FACE="Arial" SIZE="-2" COLOR="#000000"><STRONG>SCIENCE A-Z<BR> cluster: <? echo $data["clusterlc"] ?></STRONG></FONT></A></TD> </TD> <TD WIDTH="20%" ALIGN="CENTER" BGCOLOR="#ffffff"><A HREF="http://www.happychild.org.uk/gridbuilding/chemistry/AZ/index.htm#<? echo $data["clusterref"] ?>"><FONT FACE="Arial" SIZE="-2" COLOR="#000000"><STRONG>CHEMISTRY A-Z<BR> cluster: <? echo $data["clusterlc"] ?></STRONG></FONT></A></TD></TD> </TABLE> </CENTER> <BR> <FONT FACE="Arial" SIZE="-2"><BR></FONT> <FONT FACE="Arial" SIZE="-2"><BR></FONT> <CENTER> <TABLE BGCOLOR="#e2e2e2" ALIGN="CENTER" BORDER="2" WIDTH="100%" CELLPADDING="2" CELLSPACING="2"> <TR> <TD WIDTH="10%" ALIGN="CENTER" BGCOLOR="#d3ccd6"><FONT FACE="Arial" SIZE="-2" COLOR="#808080"><STRONG><A HREF="http://www.happychild.org.uk/gridbuilding/biology/index.htm">biology</A></STRONG></FONT></TD> <TD WIDTH="10%" ALIGN="CENTER" BGCOLOR="#ffffff"><FONT FACE="Arial" SIZE="-2" COLOR="#808080"><STRONG><A HREF="http://www.happychild.org.uk/gridbuilding/physics/index.htm">physics</A></STRONG></FONT></TD> <TD WIDTH="10%" ALIGN="CENTER" BGCOLOR="#d3ccd6"><FONT FACE="Arial" SIZE="-2" COLOR="#808080"><STRONG><A HREF="http://www.happychild.org.uk/gridbuilding/chemistry/index.htm">chemistry</A></STRONG></FONT></TD> <TD WIDTH="17%" ALIGN="CENTER" BGCOLOR="#ffffff"><FONT FACE="Arial" SIZE="-2" COLOR="#808080"><STRONG><A HREF="http://www.happychild.org.uk/gridbuilding/chemistry/AZ/index.htm">A-Z Chemistry</A></STRONG></FONT></TD> <TD WIDTH="17%" ALIGN="CENTER" BGCOLOR="#d3ccd6"><FONT FACE="Arial" SIZE="-2" COLOR="#808080"><STRONG><A HREF="http://www.happychild.org.uk/gridbuilding/chemistry/elements/AZ/index.htm">A-Z Elements</A></STRONG></FONT></TD> <TD WIDTH="17%" ALIGN="CENTER" BGCOLOR="#ffffff"><FONT FACE="Arial" SIZE="-2" COLOR="#808080"><STRONG><A HREF="http://www.happychild.org.uk/gridbuilding/chemistry/periodictable/index.htm">periodic table</A></STRONG></FONT></TD> <TD WIDTH="17%" ALIGN="CENTER" BGCOLOR="#d3ccd6"><FONT FACE="Arial" SIZE="-2" COLOR="#808080"><STRONG><A HREF="http://www.happychild.org.uk/gridbuilding/AZ/index.htm">A-Z Science</A></STRONG></FONT></TD> </TR> </TABLE> </CENTER> <BR> <CENTER> <TABLE BGCOLOR="#e2e2e2" ALIGN="CENTER" BORDER="2" WIDTH="100%" CELLPADDING="2" CELLSPACING="2"> <TR> <TD WIDTH="60%" ALIGN="CENTER" BGCOLOR="#ffffff"><FONT FACE="Arial" SIZE="-2" COLOR="#808080"><STRONG>Validation of content  by Anne Evans B.Sc. - all pages under construction - see <A HREF="http://www.happychild.org.uk/gridbuilding/chemistry/index.htm">index</A>.</STRONG></FONT></TD> <TD WIDTH="40%" ALIGN="CENTER" BGCOLOR="#ffffff"><FONT FACE="Arial" SIZE="-2" COLOR="#808080"><STRONG>Offers of free graphics appreciated - see <A HREF="http://www.happychild.org.uk/gridbuilding/chemistry/index.htm">index</A>.</STRONG></FONT></TD> </TR> </TABLE> </CENTER> <BR> <?php $SQL="SELECT * FROM azchem0003"; $result = mysql_query("Select * from azchem0003 where number='112'"); $data = mysql_fetch_array($result); ?> <CENTER> <TABLE BGCOLOR="#e2e2e2" ALIGN="CENTER" BORDER="3" WIDTH="100%" CELLPADDING="3" CELLSPACING="3"> <TR><TD ALIGN="CENTER" BGCOLOR="#d3ccd8"><FONT FACE="Comic Sans MS" SIZE="-1"><STRONG>The Web address for this page is <A HREF="http://www.happychild.org.uk/gridbuilding/chemistry/<? echo $data["itemfileref"] ?>/index.htm">http://www.happychild.org.uk/gridbuilding/chemistry/<? echo $data["itemfileref"] ?>/index.htm</A></STRONG></FONT></TD></TR></TABLE> </CENTER> <BR> <CENTER> <TABLE BGCOLOR="#e2e2e2" ALIGN="CENTER" BORDER="3" WIDTH="100%" CELLPADDING="3" CELLSPACING="3"> <TR><TD ALIGN="CENTER" BGCOLOR="#ffffff" WIDTH="20%"><A HREF="http://www.happychild.org.uk/pnrefer02.htm"><img src="http://www.happychild.org.uk/Webimage/f9plusnet01.jpg" align="bottom" border=0 alt="Force 9 webhosting - excellent deals on webspace"></A></TD> <TD ALIGN="CENTER" BGCOLOR="#ffffff" WIDTH="20%"><A HREF="http://www.happychild.org.uk/disclaim.htm"><FONT FACE="Comic Sans MS" SIZE="-1" COLOR="#687a95"><STRONG>copyright</STRONG></FONT></A></TD> <TD ALIGN="CENTER" BGCOLOR="#ffffff" WIDTH="20%"><FONT FACE="Comic Sans MS" SIZE="-2" COLOR="#000050"><STRONG><img src="http://ccgi.rollobks.force9.co.uk/cgi-bin/counter/count.pl?did=gridbuilding.<? echo $data["biol-chem-phys"] ?>.<? echo $data["itemfileref"] ?>" width="1" height="1" align="bottom" alt=""><A HREF="http://www.happychild.org.uk/pnrefer02.htm"><!-- begin: LiveCounter Classic CGI backup counter --><img src="http://ccgi.rollobks.force9.co.uk/cgi-bin/livecntr.pl?0+8" width="15" height="20" align="bottom" border=0 alt=""><img src="http://ccgi.rollobks.force9.co.uk/cgi-bin/livecntr.pl?1+8" width="15" height="20" align="bottom" border=0 alt=""><img src="http://ccgi.rollobks.force9.co.uk/cgi-bin/livecntr.pl?2+8" width="15" height="20" align="bottom" border=0 alt=""><img src="http://ccgi.rollobks.force9.co.uk/cgi-bin/livecntr.pl?3+8" width="15" height="20" align="bottom" border=0 alt=""><img src="http://ccgi.rollobks.force9.co.uk/cgi-bin/livecntr.pl?4+8" width="15" height="20" align="bottom" border=0 alt=""><img src="http://ccgi.rollobks.force9.co.uk/cgi-bin/livecntr.pl?5+8" width="15" height="20" align="bottom" border=0 alt=""><img src="http://ccgi.rollobks.force9.co.uk/cgi-bin/livecntr.pl?6+8" width="15" height="20" align="bottom" border=0 alt=""><img src="http://ccgi.rollobks.force9.co.uk/cgi-bin/livecntr.pl?7+8" width="15" height="20" align="bottom" border=0 alt=""><!-- end: LiveCounter Classic CGI backup counter --><img src="http://ccgi.rollobks.force9.co.uk/cgi-bin/freeway/livecntr.pl?h+9" border=0 width="2" height="2" alt=""><img src="http://ccgi.rollobks.force9.co.uk/cgi-bin/gridbuilding/livecntr.pl?h+9" border=0 width="2" height="2" alt=""><img src="http://ccgi.rollobks.force9.co.uk/cgi-bin/gridbuilding/chemistry/livecntr.pl?h+9" border=0 width="2" height="2" alt=""><img src="http://ccgi.rollobks.force9.co.uk/cgi-bin/gridbuilding/chemistry/<? echo $data["itemfileref"] ?>/livecntr.pl?h+9" border=0 width="2" height="2" alt=""></A></STRONG></FONT></TD> <TD ALIGN="CENTER" BGCOLOR="#ffffff" WIDTH="20%"><A HREF="http://www.happychild.org.uk/pnrefer02.htm"><FONT FACE="Comic Sans MS" SIZE="-1" COLOR="#8f9db1"><STRONG>webmaster</STRONG></FONT></A></TD> <TD ALIGN="CENTER" BGCOLOR="#ffffff" WIDTH="20%"><A HREF="http://www.happychild.org.uk/pnrefer02.htm"><img src="http://www.happychild.org.uk/Webimage/f9plusnet01.jpg" align="bottom" border=0 alt="Force 9 webhosting - excellent deals on webspace"></A></TD></TR></TABLE> </CENTER> <BR> <CENTER> <TABLE BGCOLOR="#e2e2e2"  ALIGN="CENTER" BORDER="2" WIDTH="100%" CELLPADDING="2" CELLSPACING="2"> <TR><TD ALIGN="CENTER" BGCOLOR="#d3ccd7"><FONT FACE="Arial" SIZE="-2"><STRONG>Design and layout of all pages at <A HREF="http://www.freeway.plus.com">FREEWAY</A> &copy; Penny Midas Rollo 2000-2006 [<A HREF="http://www.freeway.plus.com/disclaim.htm">disclaimer</A>]. World rights reserved.</STRONG></FONT></TD></TR></TABLE> </CENTER> </BODY> </HTML> <? mysql_close($db); ?> [/quote] Regards, Penny.

[quote author=mjdamato link=topic=113840.msg463660#msg463660 date=1162827786] The only reason why the pages would have the same data repeated multiple times is if the code is within a loop. The code example I gave you was a perfect example. It should simply write the entire dataset to the page - one time only. The fact that it was displayed multiple times suggests that it is inside another loop on that page that you haven't provided code for.[/quote] Sort of understand where you're coming from :) The way I had the page set originally up (to work with the line numbers as previously referenced within each block) is as follows: [quote](this is just a quote of the first block; the sequential blocks would have had sequential line numbers) [quote] <?php $SQL="SELECT * FROM azchem0003"; $result = mysql_query("Select * from azchem0003 where number='112'"); $data = mysql_fetch_array($result); ?> <A NAME="<? echo $data["clusterref"] ?>"></A> <CENTER> <TABLE BGCOLOR="#e2e2e2" ALIGN="CENTER" BORDER="5" WIDTH="100%" CELLPADDING="2" CELLSPACING="4"> <TR> <TD WIDTH="20%" ALIGN="CENTER" BGCOLOR="#ffffff"><A HREF="http://www.happychild.org.uk/gridbuilding/science/AZ/index.htm#<? echo $data["itemfileref"] ?>"><FONT FACE="Arial" SIZE="-2" COLOR="#000000"><STRONG>SCIENCE A-Z<BR> <? echo $data["itemlc"] ?></STRONG></FONT></A></TD> <TD ROWSPAN="2" WIDTH="60%" ALIGN="CENTER" BGCOLOR="#ffffff"><blockquote> <P ALIGN="JUSTIFY"><FONT FACE="Comic Sans MS" SIZE="-1" COLOR="#000000"><STRONG><BR> <? echo $data["BFG001"] ?> <? echo $data["BFG002"] ?> <? echo $data["BFG003"] ?> <? echo $data["BFG004"] ?> <? echo $data["BFG005"] ?> <? echo $data["BFG006"] ?> <? echo $data["BFG007"] ?> <? echo $data["BFG008"] ?> <? echo $data["BFG009"] ?> <? echo $data["BFG010"] ?> <? echo $data["BFG011"] ?> <? echo $data["BFG012"] ?> <? echo $data["BFG013"] ?> <? echo $data["BFG014"] ?> <? echo $data["BFG015"] ?> <? echo $data["BFG016"] ?> <? echo $data["BFG017"] ?> <? echo $data["BFG018"] ?> <? echo $data["BFG019"] ?> <? echo $data["BFG020"] ?> <? echo $data["BFG021"] ?> <? echo $data["BFG022"] ?> <? echo $data["BFG023"] ?> <? echo $data["BFG024"] ?> <? echo $data["BFG025"] ?> <? echo $data["BFG026"] ?> <? echo $data["BFG027"] ?> <? echo $data["BFG028"] ?> <? echo $data["BFG029"] ?> <? echo $data["BFG030"] ?> <? echo $data["BFG031"] ?> <? echo $data["BFG032"] ?> <? echo $data["BFG033"] ?> <? echo $data["BFG034"] ?> <? echo $data["BFG035"] ?> <? echo $data["BFG036"] ?> <? echo $data["BFG037"] ?> <? echo $data["BFG038"] ?> <? echo $data["BFG039"] ?> <? echo $data["BFG040"] ?> <? echo $data["BFG041"] ?> <? echo $data["BFG042"] ?> <? echo $data["BFG043"] ?> <? echo $data["BFG044"] ?> <? echo $data["BFG045"] ?> <? echo $data["BFG046"] ?> <? echo $data["BFG047"] ?> <? echo $data["BFG048"] ?> <? echo $data["BFG049"] ?> <? echo $data["BFG050"] ?>  <? echo $data["BFG051"] ?> <? echo $data["BFG052"] ?> <? echo $data["BFG053"] ?> <? echo $data["BFG054"] ?> <? echo $data["BFG055"] ?> <? echo $data["BFG056"] ?> <? echo $data["BFG057"] ?> <? echo $data["BFG058"] ?> <? echo $data["BFG059"] ?> <? echo $data["BFG060"] ?> <? echo $data["BFG061"] ?> <? echo $data["BFG062"] ?> <? echo $data["BFG063"] ?> <? echo $data["BFG064"] ?> <? echo $data["BFG065"] ?> <? echo $data["BFG066"] ?> <? echo $data["BFG067"] ?> <? echo $data["BFG068"] ?> <? echo $data["BFG069"] ?> <? echo $data["BFG070"] ?> <? echo $data["BFG071"] ?> <? echo $data["BFG072"] ?> <? echo $data["BFG073"] ?> <? echo $data["BFG074"] ?> <? echo $data["BFG075"] ?> <? echo $data["BFG076"] ?> <? echo $data["BFG077"] ?> <? echo $data["BFG078"] ?> <? echo $data["BFG079"] ?> <? echo $data["BFG080"] ?> <? echo $data["BFG081"] ?> <? echo $data["BFG082"] ?> <? echo $data["BFG083"] ?> <? echo $data["BFG084"] ?> <? echo $data["BFG085"] ?> <? echo $data["BFG086"] ?> <? echo $data["BFG087"] ?> <? echo $data["BFG088"] ?> <? echo $data["BFG089"] ?> <? echo $data["BFG090"] ?> <? echo $data["BFG091"] ?> <? echo $data["BFG092"] ?> <? echo $data["BFG093"] ?> <? echo $data["BFG094"] ?> <? echo $data["BFG095"] ?> <? echo $data["BFG096"] ?> <? echo $data["BFG097"] ?> <? echo $data["BFG098"] ?> <? echo $data["BFG099"] ?> <? echo $data["BFG100"] ?> <? echo $data["BFG101"] ?> <? echo $data["BFG102"] ?> <? echo $data["BFG103"] ?> <? echo $data["BFG104"] ?></STRONG></FONT></P> </blockquote></TD> <TD WIDTH="20%" ALIGN="CENTER" BGCOLOR="#ffffff"><A HREF="http://www.happychild.org.uk/gridbuilding/chemistry/AZ/index.htm#<? echo $data["itemfileref"] ?>"><FONT FACE="Arial" SIZE="-2" COLOR="#000000"><STRONG>CHEMISTRY A-Z<BR> <? echo $data["itemlc"] ?></STRONG></FONT></A></TD> <TR><TD WIDTH="20%" ALIGN="CENTER" BGCOLOR="#ffffff"><A HREF="http://www.happychild.org.uk/gridbuilding/science/AZ/index.htm#<? echo $data["clusterref"] ?>"><FONT FACE="Arial" SIZE="-2" COLOR="#000000"><STRONG>SCIENCE A-Z<BR> cluster: <? echo $data["clusterlc"] ?></STRONG></FONT></A></TD> </TD> <TD WIDTH="20%" ALIGN="CENTER" BGCOLOR="#ffffff"><A HREF="http://www.happychild.org.uk/gridbuilding/chemistry/AZ/index.htm#<? echo $data["clusterref"] ?>"><FONT FACE="Arial" SIZE="-2" COLOR="#000000"><STRONG>CHEMISTRY A-Z<BR> cluster: <? echo $data["clusterlc"] ?></STRONG></FONT></A></TD></TD> </TABLE> </CENTER> <BR> [/quote] (so the next block would have had where number='113', etc.)[/quote] The code you've provided already [quote] <?php $SQL="SELECT * FROM azchem0003 WHERE itemfileref='positivecharge' ORDER BY clusterref ASC"; $result = mysql_query($SQL); $data = mysql_fetch_array($result); ?> [/quote] will call up all-four-together of the positivecharge db lines but presumably I need to be able to make the php to only call up one of the lines at a time so it extracts the correct data from a specified single line out of the already-identified block of four lines. Does this help?  Sorry but I didn't previously understand quite what it was you were asking me for. Regards, Penny.

mjdamato, do you have any further ideas on this? I've just input the next massive block of definitions and I will need to generate a new block of index pages, shortly. Appreciate your time (EST?) is probably different from that here (GMT) but I really need to process the index pages today if at all possible.  Even if a solution isn't possible for this block, wd still appreciate your views as it might make generating the next block easier :) Regards, Penny.

Just as an afterthought, I will already have had to have pre-sorted the db to enable the generation of the page at http://www.happychild.org.uk/gridbuilding/chemistry/AZ/index.htm .  I actually create the db in MS Works 2000 [haven't fathomed out how to get "form" view in Excel], do the sort by (a) itemfileref and (b) clusterref, *then* add sequential numbers down the first column [so the numbers match the result order of the double alphabetical sort], export as a .txt file and then upload into mysql via telnet. So the A-Z page php template calls up all the content by sequential line numbers. Given that the http://ccgi.rollobks.force9.co.uk/positivechargetabletest01.php page already shows the line numbers, is there any way of getting the code to call up the line arrays in sequence for the positivecharge index page, without specifying specific line numbers, if it proves impossible to call them up individually just using clusterref? Just struggling here with the technicalities.  Thank you for your charitable comments earlier :)  keenly aware of how little I understand compared with most of you. Regards, Penny.

[quote author=mjdamato link=topic=113840.msg463031#msg463031 date=1162682799] That's not what I was looking for. Somewhere you have a loop that is actually creating the HTML to "print" that data to the page. Try this. [/quote] Totally lost now :))  but I've done as requested (I think!) and replaced [quote]<?php $SQL="SELECT * FROM azchem0003 WHERE itemfileref='positivecharge' ORDER BY clusterref ASC"; $result = mysql_query($SQL); $data = mysql_fetch_array($result); ?> [/quote] with [quote]<?php $SQL="SELECT * FROM azchem0003 WHERE itemfileref='positivecharge' ORDER BY clusterref ASC"; $result = mysql_query($SQL); echo "<table border=1>"; while ($data = mysql_fetch_array($result)) {     echo "<tr>";     foreach ($data as $value) { echo "<td>$value</td>"; }     echo "</tr>";  } echo "</table>"; ?>[/quote] which has produced the output shown at http://ccgi.rollobks.force9.co.uk/positivechargetabletest01.php [which has called up the same four results shown at http://www.happychild.org.uk/gridbuilding/chemistry/positivecharge/index.htm (see cluster links bottom right of each on page) , same set of 4 results for all 12 requests on the positivecharge index page].  I hope this clarifies something. The call-up at the beginning of the page (above the html <HEAD> etc.) is to generate the data for the meta-tags etc.; the call-ups further down are to produce data as required (just set for 10 possible entries until it all gets somewhat more comprehensively filled out). The only php code I've got on the page is (a) at the top to open the db, with the mysql stuff already quoted, (b) 10 blocks of the quoted thing each followed by numerous echo commands, and one lot at the foot to generate the page address etc. (this I think will need to have a line ref as it needs the same data as one of the first ones before lines with positivecharge in them run out). I hope this all makes sense.  The table lines have 104 fields by the way, though most lines don't use that many. Regards, Penny. Afterthought:  sample echo command is <? echo $data["itemlc"] ?> all the existing ones have worked fine for the pages provided that I have specified the relevant db line immediately before them.

[quote author=mjdamato link=topic=113840.msg463000#msg463000 date=1162677049] Anyway please post the code following the query and I can help further. But, I may not be able to get back to this until later.[/quote] code is [quote][code]<?php $SQL="SELECT * FROM azchem0003 WHERE itemfileref='positivecharge' ORDER BY clusterref ASC"; $result = mysql_query($SQL); $data = mysql_fetch_array($result); ?>[/code][/quote] which is the same in all 12 instances except the first one which actually includes the opening of the database (db is closed at the end of the php page).  Pages are set in html and then output from the php page through a separate call-up page which generates a static html page (one page at a time but I haven't found any other way of converting automatically that definitely always works). Do hope the code above will give you some clue as to why the entries are all the same.  If it does prove possible to fix, it will save *so* much work in putting together the science resource. I'm going away now to replicate all the db lines for each item they contain (changing the item refs as appropriate) so as to get a full set of references for everything, for the index pages in due course.  Somewhat longwinded process, but you'll have gathered by now I tend to take the long way round, most of the time, whilst I'm not very sure what I'm doing :)  I'll check back here every now and again, appreciate you too have other things to do.  Just grateful for your help. Regards, Penny.

[quote author=mjdamato link=topic=113840.msg462992#msg462992 date=1162675690] Also, if you are using your actual server to test code, that is kind of inefficient. You could download an all-in-one package like XAMPP. It is a web server, php, & MySQL server in one package. All you have to do is copy the files to a directory and run the console and you can easily develope on your desktop. [/quote] Sorry, I was writing my post as yours went up, so as you'll see I'd done the quotes thing.  Don't think I can use the XAMPP package as I have to work in conjunction with my ISP's MySQL server. It's probably not an ideal way of doing things but it works, most of the time :) Regards, Penny.

[quote author=mjdamato link=topic=113840.msg462975#msg462975 date=1162672507] So the code should be: [code]<?php $SQL=""SELECT * FROM azchem0003 WHERE itemfileref='positivecharge' ORDER BY clusterref ASC"; $result = mysql_query($SQL) $data = mysql_fetch_array($result); ?>[/code][/quote] I have tried that (for all 12 occurrences) but just get Parse error: parse error, unexpected T_STRING in ... on line 4 [which at the start of the document is the one with ""SELECT on it]. Tried replacing the double-double near the beginning of the $SQL line with just-one-double, and got the page to output (but again with all 10 entries the same). At some stage I also added a ; to the end of the $result line which stopped a parse query (though again I don't know if I've done the right thing). Anyway, [quote]<?php $SQL="SELECT * FROM azchem0003 WHERE itemfileref='positivecharge' ORDER BY clusterref ASC"; $result = mysql_query($SQL); $data = mysql_fetch_array($result); ?> [/quote] will generate the page, but the entries are all the same.  clusterref has all sorts in it (eg nucleus, protons, etc.) but how does the php know to call up those entries alphabetically within the positivecharge itemfileref? You probably think by this stage that I'm exceptionally dense but I truthfully don't understand how this "sort" aspect works (unless it's alphabetical somehow) - and if it's alphabetical, why does it keep calling the first one?  As you'll see from http://ccgi.rollobks.force9.co.uk/positivecharge10same.php , it is correctly calling the first item, but the page at http://www.happychild.org.uk/gridbuilding/chemistry/positivecharge/index.htm shows the correct order [pls ignore the meta-tags, I've changed the call-ups since then but unable to update the generated .htm page till I can get the php output correct again]. Regards, Penny.

[quote author=mjdamato link=topic=113840.msg462975#msg462975 date=1162672507] That first line does absolutely nothing sionce you don't use the variable![/quote] :-[  yes I just discovered that :D Had just discovered the mistake/s in the order of quotes-semi-colon-bracket and changed that to [quote]<?php $SQL="SELECT * FROM azchem0003"; $result = mysql_query("SELECT * FROM azchem0003 WHERE itemfileref='positivecharge' ORDER BY clusterref ASC"); $data = mysql_fetch_array($result); ?> [/quote] and got a fully-working page with all 10 outputs the same, at the same time as you posted (see http://ccgi.rollobks.force9.co.uk/positivecharge10same.php ). At least the page is visible, so am now going to try pasting in what you've added (just didn't want not to reply initially as all this usually takes quite some time).  Thank you for bearing with me :) Regards, Penny.

[quote author=mjdamato link=topic=113840.msg462935#msg462935 date=1162666363] What you need to do is create a new field in the database called 'sortOrder' or something to that effect. The sort order will specify what order records with the same itemfileref will be displayed in. In other words the sort order for each itemfileref is independant of each other - each one will have an entry with a sort order of 1. You can then pull your data - in the correct order - like this: SELECT * FROM azchem0003 WHERE itemfileref='positivecharge' ORDER BY sortOrder ASC Now it will not matter where a record exists in the database. Your first record could be the last one in the database, but you can still display then in the order you want. [/quote] Thank you mjdamato :D  much appreciate the reply. I think I have understood what you said about databases! though it's some way beyond my grasp of things so far (I'm not at all technically-minded). I already have a column that "sorts" (usually I sort the db alphabetically by (a) itemfileref and (b) clusterref, before I work with it, so I have put clusterref in place of sortOrder, and now have [quote] <?php $SQL="SELECT * FROM azchem0003"; $result = mysql_query("SELECT * FROM azchem0003 WHERE itemfileref='positivecharge' ORDER BY clusterref ASC;) $data = mysql_fetch_array($result); ?> [/quote] in all the places I previously had a line-number call-up as quoted previously. However I am now getting the error message: Parse error: parse error, unexpected T_STRING in /positivecharge.php on line 10 (line 10 is <BASE HREF="http://www.happychild.org.uk/gridbuilding/chemistry/<? echo $data["itemfileref"] ?>/index.htm"> ... the first place I have an echo call-up. Presumably I've stuffed up on precisely how the sort factor should have been input - I've tried several variables but I'm not getting anywhere. Any ideas? Thanks, Penny.

[quote author=Penny_Rollo link=topic=110192.msg447711#msg447711 date=1160097176] I've also read that "text" allows more than the 255 chars of varchar, but can't confirm that until I finish the set-ups and try outputting some of the Russian-English worksheets (entries are very long as entirely composed of hex codes because of the Cyrillic alphabet). I'll let you know what happens :)[/quote] Just to update here that "text" allowed the maximum number of characters actually required (up to 500 in some boxes) and the Russian seemingly output fine. Regards, Penny.

Currently building an A-Z science db in mysql. Call-ups work fine for existing data being drawn from the db by php, but I need to know how to sequence call-ups for index pages.  eg "positivecharge" might appear on lines 40, 41, 42, 43, 44 of the db - so for the positive charge index page I am currently having to amend the template to read (for example): [quote]<?php $SQL="SELECT * FROM azchem0003"; $result = mysql_query("Select * from azchem0003 where number='040'"); $data = mysql_fetch_array($result); ?> (followed by block of echo call ups from a single db line, all of which work fine)[/quote] ie I am having to go through and paste in the correct line no. from the database before each new block of info, on *each* separate index page.  (so the next one on the positive charge page would be [quote]<?php $SQL="SELECT * FROM azchem0003"; $result = mysql_query("Select * from azchem0003 where number='041"); $data = mysql_fetch_array($result); ?>[/quote] (etc.) It gets more complex because every time I add new stuff to the db and sort it alphabetically, positive charge will start on a differently-numbered line (so I have to go through and re-number every index-page template individually). Logic tells me it must be possible to automate this somehow such that I could have something along the lines of [quote]<?php $SQL="SELECT * FROM azchem0003"; $result = mysql_query("Select * from azchem0003 where itemfileref='positivecharge'"); $data = mysql_fetch_array($result); ?>[/quote] but I need (something) to specify that only the first-appearing-line with positivecharge as the itemfileref is used, until replaced by the next-appearing-line with positivecharge as the itemfileref (until it runs out of lines that meet that criteria). If necessary I could work on the basis of actually stating the first line number as "n" (or whatever) then the next being "n+1" [I haven't the remotest idea how to code this] but ideally I would like to find a way to call up all the lines with that itemfileref in sequence (and only those lines) so that I don't have to go through and manually amend every single call-up-index-page every time the actual line numbers change. Don't want to write screeds here :) but hope I've explained this well enough and would really appreciate some help if anyone can explain what I need to do, in words of one syllable. Regards, Penny.

[quote author=Penny_Rollo link=topic=110192.msg444978#msg444978 date=1159754795] Do a find-and-replace on [color=orange]&#[/color] , to [color=orange]&amp;#[/color] .  Coding the ampersand will/should compel Excel to visibly display the hex codes (rather than the foreign-language characters) which can then be output into a text-and-tabs .txt file the content of which can then be telnetted into your mysql db.[/quote] Hi maiatot, It occurs to me to add to this, that it might be useful to have set up your mysql database, that the .txt file is to be uploaded into, with "text" rather than "varchar" for the cells.  I've already used "text" with Polish character hex codes (which worked for the output pages, both php and static html). I've also read that "text" allows more than the 255 chars of varchar, but can't confirm that until I finish the set-ups and try outputting some of the Russian-English worksheets (entries are very long as entirely composed of hex codes because of the Cyrillic alphabet). I'll let you know what happens :) Regards, Penny.

[quote author=steveclondon link=topic=110196.msg445103#msg445103 date=1159782294] Hi, you need mod rewrite to write your pages from static to your php pages. This uses reg expressions and redirects to which ever script your set in your .htaccess. Contact your administrator and ask if you have access to this. I just skated through your post (it was like a book), am waiting for part two to come out. I see that barand has given a link to a site that will give some help regarding alot of this. If you are still stuck come back and let us know. P.S. Not everyone that answers is in another country some of us are in the UK.[/quote] Thanks Steve and Barand, appreciate the replies. Some long time after posting here, I solved the first question, that of calling up a specific row, and then calling off values within the page.  Code used was: [quote] <?php $db = mysql_connect("hostname","username","password"); mysql_select_db('database_name', $db); $SQL="SELECT * FROM tablename"; $result = mysql_query("Select * from tablename where number='004'"); $data = mysql_fetch_array($result); ?> [/quote] I've left in the "number" (being the field name of my first column) and "004" (being the entry in the nominated row of the "number" column) so it might be clearer for other people to see what worked for this. All I did to call up the values from the specified row was to put [quote] <? echo $data["categorywspaces"] ?> [/quote] (or whatever the column name was, within the bracketed-area) wherever I needed to have a value from that row appear in the document.  Worked for the meta-tags also (had to put the big block of initial code above the initial <HTML> at the top of the page). What needs to be figured out now, is: (1) how to get the content of the output php page (which is accurate) to be saved into an html file.  There are a great many people on the Internet asking the same question, and I have dredged through endless "guides" without finding anything that actually works. One that looked as if it might work, was: [quote] <? $file_to_parse="http://ccgi.rollobks.force9.co.uk/polishvocab004.php"; $out_put_file = "http://ccgi.rollobks.force9.co.uk/calendar02.htm"; exec(" -f $file_to_parse > $out_put_file"); ?> [/quote] (but it didn't)  It gave me a blank output page (so presumably there weren't any faults in the coding) but it didn't seem to actually "do" anything or rewrite the French calendar02 file I had stuck up on line to see if it would be overwritten (at http://ccgi.rollobks.force9.co.uk/calendar02.htm ). Well blow me down.  The Polish has overwritten the French :))) however I haven't the vaguest idea (yet) what achieved this.  There were quite a lot of attempts at call-up pages ..... and there was also a cron script to (supposedly) get the Apache server to make the change at 4pm UK time. Okay.  I have put a calendar03.php file up (English-Polish) at http://ccgi.rollobks.force9.co.uk/calendar03.php , and put a calendar03.htm file (English-French) at http://ccgi.rollobks.force9.co.uk/calendar03.htm .[Should explain at this point, incidentally, that the Polish content is only from a test database and the finished version may differ in some respects; the French-English worksheets are part of an existing on-line resource.] Now to figure out what caused the change ..... (*pause of several hours*) Eureka.  I have located the script ..... and, after testing, discovered that not only will it do this for more than one file at a time, but also it doesn't need an html file with the correct output url, already in place on the server, to have the content replaced.  Awesome :) New files (for which I created only the PHP pages calendar05.php, calendar06.php and calendar07.php) have just output as http://ccgi.rollobks.force9.co.uk/calendar05.htm , http://ccgi.rollobks.force9.co.uk/calendar06.htm and http://ccgi.rollobks.force9.co.uk/calendar07.htm . And this is the script that was used to create static html pages from the php output pages: [quote] <?php function wwwcopy($link,$file) { $fp = @fopen($link,"r"); while(!feof($fp)) { $cont.= fread($fp,1024); } fclose($fp); $fp2 = @fopen($file,"w"); fwrite($fp2,$cont); fclose($fp2); } //Example on using this function wwwcopy("http://ccgi.rollobks.force9.co.uk/calendar05.php", "calendar05.htm"); //Another example wwwcopy("http://ccgi.rollobks.force9.co.uk/calendar06.php", "calendar06.htm"); //Another example wwwcopy("http://ccgi.rollobks.force9.co.uk/calendar07.php", "calendar07.htm"); ?> [/quote] Code from a guy called almahdi on page http://www.webhostingtalk.com/archive/index.php/t-402191.html .  Did a look-up on Google for part of the code I'd used, in the end, for somehow it wasn't amongst the 32 references I'd bookmarked whilst looking and trying things out .....  Awesome guy.  This script is going to save me *so* much work ..... :)))   and lots of other people too, probably. Cannot quite believe I have been able to find my way through some sort of basic knowledge of both mysql and PHP in the space of 48 hours :)  have to admit it has taken me four and a half *years* to actually embark on fathoming all this out.  You would not believe the workarounds I have done to avoid tackling learning these two :) Not there, yet, of course!  but I've probably got enough of the basics to enable me to do what I need to, for now.  Seemingly I'm going to need to create the 471 php files separately (PHP/mysql text as per original post, with the individually-relevant line number pasted in for each) though I guess I might learn to automate that side of things eventually ;)  Long way to go but I feel like I've taken my first real steps along the road.  Starting to understand why the rest of you find php/mysql so fascinating, maybe. And yes this is very much "another book", "part two", Steve :)  guess I don't go in for short posts much.  Though the one at http://www.phpfreaks.com/forums/index.php/topic,110192.msg444978.html#msg444978 was somewhat briefer ... Hope the info/scripts I've put on line here will be of interest/use to others, along the way :)  I'll be back - probably!  just got rather a lot else to deal with, right now. Best regards, Penny. Edited to remove one of the links [might have to remove more, later, as a number of the file refs will be used for other languages in due course].

[quote author=maiatot link=topic=110192.msg444960#msg444960 date=1159752139] I have problem on displaying japanese text from a data retrieved from Mysql. Displaying static text in HTML and with the use of declaring the japanese text in PHP it displays as japanese text. But once I retrieve a data from Mysql which is in japanese when it is displayed the only thing that appears are "??????".[/quote] Hi maiatot, I know very little yet about php/mysql *but* have had some experience with character displays for html pages so I hope this helps :)  took me five months to figure out how to do this though I can't guarantee it will work for what you want (I discovered it whilst trying to get Excel to display hex codes rather than Russian characters, for the free dual-language worksheets being put together via http://www.happychild.org.uk/freeway/xxxxlanguage/translators01.htm ). Try putting your mysql data into an Excel db/spreadsheet, then use Tools - Macro - Microsoft Script Editor, where the Japanese text will display as something like &#1072;&#1074;&#1075;&#1091;&#1089;&#1090; (this is actually Russian but the only example I have to hand, to use). Do a find-and-replace on [color=orange]&#[/color] , to [color=orange]&amp;#[/color] .  Coding the ampersand will/should compel Excel to visibly display the hex codes (rather than the foreign-language characters) which can then be output into a text-and-tabs .txt file the content of which can then be telnetted into your mysql db. Hope this works for you :) Regards, Penny. 

Hello to everyone ..... realise it's early evening for most, but here in England it is the early hours of the morning and I guess this posting is, for me, a last ditch attempt to get things sorted :) Most of this weekend has been spent grasping the basics of mysql and I have finally managed to get a database uploaded to my ISP's server.  Database is 34 columns across and 471 rows downwards.  The first column has 001, 002, 003 (etc.) downwards on the rows.  All fields are named (first one is just called "number"). I have managed to code in the php connection to the database to get the output at http://ccgi.rollobks.force9.co.uk/polishvocab11.php . (using the following code) [quote] <?php $db = mysql_connect("hostname","username","password"); mysql_select_db('database_name', $db); $SQL="SELECT * FROM tablename"; $RESULT=mysql_query($SQL); $myrow=mysql_fetch_array($RESULT) ?> [/quote] I also previously managed to get the output at http://ccgi.rollobks.force9.co.uk/polishvocab02.php to register the number of rows (at the top, in black) using slightly different coding of [quote] <?php $link = mysql_connect("hostname","username","password"); $db_selected = mysql_select_db('database_name', $link); $result = mysql_query("SELECT * FROM tablename", $link); $num_rows = mysql_num_rows($result); echo "$num_rows Rows\n"; ?> [/quote] so I'm assuming that the [url=http://ccgi.rollobks.force9.co.uk/polishvocab11.php]polishvocab11.php[/url] page also has a working connection to the db (as no errors were generated when calling up the page). I need help (please!) with three things. Firstly how to get php to call up the content of one row at a time (so as to fill in the blanks for English 01, XXXXlang 01, etc. which are fields in the database, and where I understand "echo" commands are needed at the relevant points in the html template where currently there are %%xxxx%% entries. Secondly how to then get php to call up the "next row" against the same html template (right through the 471 rows) so that each newly-generated page has the right content from the called-up line of the database. Thirdly how to get php to give the output page a new URL with the format [quote] <BASE HREF="http://www.happychild.org.uk/freeway/polish/vocab/%%category%%%%cat no%%.htm"> [/quote] so that I can store the 471 outputs as (separate) static html pages. I'm not sure if this is something of a tall order! but it's what I need to achieve, and time is at something of a premium right now. I also need to know how to call up a specific table cell (given the parameters of field name and the numerical entry in the first column, which seemed the most logical way to identify separate rows) in order to achieve output pages like http://www.happychild.org.uk/freeway/french/vocab/houseoverview.htm . I'm involved in a (fairly huge) project to provide free dual-language worksheets for kids, for a number of languages including Romanian-English, Polish-English, Bulgarian-English, Russian-English etc., and several of the translated databases will be ready soon [all the translations are being done in similar formats].  The overview page content was achieved previously (for the English-French content) by using mail-merge on MS Works against an MS Works db (and then pasting each lot of table contents onto the page), but because of the length of the foreign-language-character entries (much of which have had to be converted into hex codes) the program truncates them, so I need to find a way of calling up a single cell at a time, to get the full text, but by a more automated process. Logic tells me it must be possible!  but I simply can't get the content of individual cells in the database to be called up by the PHP code to appear on the page.  If any of you PHP experts could help I would very much appreciate this :)  Project HappyChild is "not for profit" and run very much on a shoestring, so there's no "profit motive" in doing this, but it will make a lot of difference for kids in various countries. And I will be slightly saner if I can find a workaround for this - have tried out *loads* of PHP text copied laboriously from lots of tutorials but don't have the time to give to endlessly experimenting when I seem to be getting absolutely nowhere :/ Sorry this first post is so very long but I figured it might help if I explained something about why this needs to be done and exactly what help is needed, if anyone could explain what I need to do.  I'm not the most "technically-minded" of people! but I do grasp things *eventually* :) Regards, Penny.