Topshed

One of my tables "lner" in my steam db is being trashed by an evil person and I need some help and advice please For instance I have a field called 1946# which should show a year and a month eg "1946#Jan" however in a table of 10500 record 7000 have be replace with 255 not all of them had an entry but I need to remove the 255. I can normaly change field content with something like UPDATE lner SET 1946# = REPLACE(1946#, "255" , "") However this fails although it works on other fields The evil one has also changed my 255 byte notes (Blob) a with randon 5 digit numbers or just 0 I have no idea how to delete an 0 without wrecking other valid numbers that i do not want changed. can I isolate the 0 so it is the only one effected ? Apart from changing my password again (it has happend before) how else can I protect my data any assistance would be most welcome Regards Topshed

Thank you all for your help and patience Problem solved Regards Topshed

http://www.britishsteam.com/gwr/tanks/9700.php

Sorry that was sloppy, I make dreamweaver templates because any one gallery can have 100plus scripts. and I decided to clean up the comments that only Dreamweaver reads, and left that little piece behind so a false lead so to speak. How the & got it your code I do not know I always use cut and paste the amended bit shows <tr> <?php if ( isset($rows['Notes'])&&trim($rows['Notes'])!='' ) echo "<td colspan='5'>Notes: {$row['Notes']}</td>"; ?> </tr> but alsa still nothing shows BTW it should show "testing" URL http://www.britishsteam.com/gwr/tanks/9700.php Sorry Topshed

Hi Guru, A block of the code follows <table id='w1020'> <tr> <th>BR No.</th> <th>GWR No.</th> <th>Pre GWR No.</th> <th colspan='2'>Loco Name</th> </tr> <tr> <?php echo "<td>".$row['br_no']."</td>"; ?> <?php echo "<td>".$row['other_no']."</td>"; ?> <?php echo "<td>".$row['prev']."</td>"; ?> <?php echo "<td colspan='2'>".$row['loco_name']." </td>"; ?> </tr> <tr> <th colspan="2">Build Details</th> <th colspan='2'>Withdrawal Details</th> <th>Cut / Fate / Preservation Details</th> </tr> <tr> <?php echo "<td colspan='2'>".$row['builder']." no.".$row['build_no'].", ".$row['mm_build']."-".$row['yy_build']."</td>"; ?> <?php echo "<td colspan='2'>".$row['mm_wdn']."-".$row['yy_wdn']." <b>(".$row['code'].")</b>".$row['last_shed']."</td>"; ?> <?php echo "<td>".$row['mm_cut']."-".$row['yy_cut'].", ".$row['cut']."</td>"; ?> </tr> <tr> <th colspan='5'><strong>Photograph Copyright © </strong><!-- N.L.Browne(print)<strong> all rights reserved</strong></th> </tr> <tr> <td colspan='5'>A most un-GWR type with outside Walschaerts valve gear, on shed at Southall Apr-1957</td> </tr> <tr> <td colspan='5'><?php echo $row['Notes']; ?></td> </tr> <tr> <th colspan='5'><img src="image/1505.jpg" alt="pannier tank 1805" width="1020" height="680"/></th> </tr> </table> I Hope this clarifies the problem Topshed...

Thank you both for your replies, but I cannot get a result from either administrator your code snippit still does not print out the info when it is there <tr> <?php if ( isset($rows['Notes'])&&trim($rows['Notes'])!='' ) echo "<td colspan='5'>Notes: {$row['$Notes']}</td>"; ?> </tr> Alpine your code produces an error which I do not understand $notes = (!empty($rows['notes'] ? $rows['notes'] : ''); Parse error: syntax error, unexpected '?', expecting ')' in /home4/topshed/public_html/britishsteam.com/gwr/tanks/9700.php on line 77 So some more assistance would be very nice Regards Topshed

HI some help badly needed please I have an SQL database that I use to furnish details about any picture in a gallery One of the fields is for Notes and I want to only echo if it is not null in it's plain form it looks like this <td colspan='5'>Notes <?php echo $row['Notes']; ?></td> The code I am trying to get to work follows <td colspan='5'><?php if (is_null($rows['Notes'])) echo ""; else ?> <td colspan='5'>Notes <?php echo $row['Notes']; ?></td> </tr> Thanks Topshed

Thank you all for your support. I found after much conversation that my hosting site, Cpanel was exporting garbage because when they tried to export as a user (me) it also failed So they did a local dump and made it available to me to use. I am now waiting for an "It's fixed" from them. Regards Topshed2

Hi, thanks for the reply ENGINE=MyISAM Unfortunatly that chage stops the import straight away Regars Toppy

Please help I am in deep trouble working in phpmyadimin I have wrecked a table of 15559 Records I have a backup but when I try to restore it I get an error message that ends Line 40 does indeed say The only differance I can find is the number according to my existing file is 15646 I have tried editing the number down to 15559 with no effect I have also flushed the recieving table which also make no differance I do hope someone can hrlp Please ....

Thanks for the clarification but unfortunatly 28 pages to sort thru was not the quick fix I was looking for, rather just a correction to my inept code Regards..

Thanks for the reply, but no Joy, assuming that you ment REPLACE lms SET cut = 'Co.T' WHERE cut = 'Co.,T' Topshed

mySQL ver: 5.1.30 PHP ver: 5.2.8 I have a typo in over 400 records and I want to fix it in phpmyadmin The field is tinytext and the string I am trying to fix is 91 chars long I am trying to fix a small section of the string My efforts are a dismal failure ie: UPDATE lms SET cut = 'Co.T' WHERE cut = 'Co.,T' Your help would be most welcome Topshed

Hi . I am using PHP ver 5.2.8 mySQL ver 5.1.30 I have backed up my database and tables to my WAMP server and I have been cleaning them up and updating some of the records My Question: How do I transfer the latest table back to my Hosting server so that it updates all the changes and the 2 tables match exactly Preferably using phpMYadmin Thanks Topshed

Thank so much for Un-Muddying my thinking on this, a little basic knowledge goes a long way Kind Regards Topshed