gerkintrigg

Thanks Lite, I'll give it a try and let you know how it goes.

Normally this is a good thing right? Well I remember on my old server I could have lots of lovely red errors when I made a mistake with coding. These are just not there any more, the script stops, but no errors. Is there a way to turn these back on as I found them REALLY useful in debugging. Thanks in advance.

Hi everyone. I'm trying to work out Crons. I think I have done it correctly using my Plesk control panel (weird system...) but I would like to find out whether it's right. For the heading: "Command" I've put: httpdocs/includes/cron/delete_ppl_online.php but I'm not sure if this is the right thing. I simply want to delete all records from a database once every month. Any ideas whether I'm doing it right or am I being too ambiguous?

Ideally I'd like for my users to upload data to the database from an excel file rather than comma seperated values. I know how to do it, but the poor little tykes might not. I'd also like to avoid phpMyAdmin too. It's too powerful to let my boss play with it ;o) Thanks for the info about the columns & fields. Does this also cuase problems if the id field is left out because it auto-increments?

Hi everyone. I'm trying to work out how to populate my database from an Excel spreadsheet. Does anyone have any ideas how I'd go about doing that? I've seen the tutorials on exporting the sql into excel, but can't begin to figure it out the other way. Are there any free resourses or tutorials that you know of? Thanks in advance.

Hi all. I'm trying to loop through an SQL array (something I've done numerous times before) but this time it's retrieving all but one of the results... here's the code I'm using: [code]<?php $sql = mysql_query("SELECT * FROM scenes LIMIT 9999");                       $p = mysql_fetch_array($sql);?>                       <select name="select" class="search">                       <?php while ($p = mysql_fetch_array($sql)){                       echo '<option value="'.$p['scene_number'].'">Scene '.$p['scene_number'].' - Containing '.$p['no_of_shots'].' Shots</option>';                         }                         ?>[/code] It's for a database of shots and can be found at [a href=\"http://www.magic2k.com/422/search/\" target=\"_blank\"]My development page[/a] I've been staring at it for too long perhaps. If anyone can help or suggest anything that could sort the problem that'd be great. Many thanks.

Hi everyone. I was wondering if there was some kind of stock command or stock script out there in cyber land that would allow me to break apart an SQL result string to add commas into a number. For example: instead of 123456789.00 it'd be: 123,456,789.00 I'd just like to make the (price) results look a little nicer for my site visitors. I've been playing with the explode & implode functions but they seem to be rather flakey. Probably just my syntax, but any help would be greatly appreciated.

array(1)=array_unique(array(1)); doesn't work?

.htaccess can become rather unwieldy if too many members join. While it's good for a few users, I found it becoming a right royal pain in the bum when I had 150 members... now I have almost 550, I can't imagine what it'd have been like without a database!

I'm having problems trying to understand exactly what I'm supposed to be doing. I want to alter my existing a website (www.magic2k.com) by adding a login page, rather than using HTAccess (which is fine for a the moment, but the member list's growing and I'm having problems managing the data - hense the database (to make things easier, which it undoubtably does). I need to know what to do (not necessarily how to do it) in logical steps. For example: I've got a page set up at the moment that determines whether the user COULD login. but I heard something about a session and cookies and all that stuff and don't know what to do. I'd like some advice in this sort of format: 1 - visitor enters info 2 - info checked 3 - if correct start session & write cookie 4 - blah blah blah... you get the idea. I just need to know where I'm starting really. Thanks for your time.