otd

i have managed to sort this now, ive anyone wanted to knw the answer - UPDATE yourtable SET yourcolumn = SUBSTRING(yourcolumn FROM 1 FOR POSITION('<script' IN yourcolumn) - 1)

Good Afternoon Folks, After a bit of help with a SQL query, i need to run a query in Mysql. i have a table with approx 450 records and in a particular column for every record i have some text followed by <script blah blah etc... and i need to run a query to delete everything including and after the <script. Can anyone help me on the command i would need. Thank you for any help received in advance. Many Thanks

Good Afternoon, im a bit of a newbie in mysql really and ive got a bit code that im struggling on and any help in this would be greatly appreciated. if i have the below in the code - <?php echo $ccAdminData[0]['adminId']; ?> it displays 9, what i want to do is <?php $result = mysql_query("SELECT * FROM invoice WHERE admin_id_invoice='$ccAdminData[0]['adminId']'"); while($row = mysql_fetch_array($result)) { echo $row['admin_name'] . " " . $row['total_sales']; echo "<br />"; }?> so it displays information relating to $ccAdminData[0]['adminId']; but obviously this doesnt work.. Im guessing im making a silly mistake. Any Ideas??? :-\

Hello Folks, Dont know if this is the right place to post this, but im really struggling and could do with any help any one can give me on this, we are currently using cubecart on a windows dedicated server using iis 6, the store is to sell digital downloads....music tracks. everything is working fine apart from one problem when you download your track it is stopping at 7mb or 6mb dead on instead of 10.14mb that the track actually is, so its cutting it short. Cubecart uses PHP to download the track so the direct link to the track is hidden, does any one know what could be stopping the download on 7 mb?? looked all through php.ini but cant find anything, any help in this is greatly appreciated Many Thanks