Adam

.... oh wait. Do you want them in format like: record 1 .. record 2 record 3 .. record 4 or.. record 1 .. record 3 record 2 .. record 4 ??

Ah right well, the method I showed you before will basically take one record at a time and you can save whatever fields you like into an array that alternates each time.. effictely being like.. "one for you and one for me" between the two arrays. So record 1 is in array 1, record 2 is in array 2, record 3 is in array 1, record 4 is in array 2, etc. So basically splitting the records into lists, or columns if you were to display the lists at the side of each other. you don't need to count them up, that would sort of be a long way round. All you then do is loop thru each array and print out the contents in the array... Adam

Oh wait sorry, fields? So for each record in db table, you want to split the field into two and put half in one list, and half in the other list? Or do you mean like two records at the side of each other.. like: record1 record2 record3 record4 etc.. ? Adam

Could do something like.. <?php // assuming you've connected and made the query $col = 1; while ($record = mysql_fetch_array($yourQuery)) { if ($col == 1) { $col1[] = $record['someField']; $col = 2; } else { $col2[] = $record['someField']; $col = 1; } } print '<ul>'; foreach ($col1 as $data) { print '<li>' .$data. '</li>'; } print '</ul>'; print '<ul>'; foreach ($col2 as $data) { print '<li>' .$data. '</li>'; } print '</ul>'; ?> Could be a simpler way.. just a quick idea.. Adam

Use GET instead of POST .. for example, on query.php the link to download it should be something like... <a href="downloadxls.php?Organism=<?php print $orn; ?>&Category=<?php print $cag; ?>"> Then instead of using: $orn=$_POST['Organism']; $cag=$_POST['Category']; ... in downloadxls.php, use: $orn=$_GET['Organism']; $cag=$_GET['Category']; ... and you shouldn't have a problem. Adam

Don't understand what you're trying to do there though... $size=filesize($_FILES['image']['tmp_name']); if ($size == $_FILES['filename']['size']); { echo 'You have exceeded the size limit!'; echo $size; $errors=1; die (); } $_FILES['image'] .. isn't actually used on the form, not sure why you have lots of references to it? But you need to set a size limit yourself. with that you're basically setting the filesize limit to equal the filesize of a file i'm not even sure exists; filesize($_FILES['image']['tmp_name']) ...? should look something more like: if ($_FILES['filename']['size'] >= 1048576) { echo 'You have exceeded the size limit of 1Mb!'; echo ' Actual size: '.$_FILES['filename']['size']; $errors=1; die (); }

if's need brackets.. if (something == something) { ... } should be: if ($size == $_FILES['filename']['size'])

oh yeah you changed it to: function file_extension($filename) { $path_info = pathinfo($filename); return $path_info['extension']; } ... so needs to be: $filename = stripslashes($_FILES['filename']['name']); $type = strtolower( file_extension( $filename));

You're using $_FILES['image'] and $_FILES['filename'] when it should be (as it is on the form) $_FILES['filename'] ..

$filename = stripslashes($_FILES['image']['name']); $type = getExtension($name); $type = strtolower($extension); Problem is here i think, should be: $filename = stripslashes($_FILES['filename']['name']); $type = strtolower( getExtension( $filename));

try to find some errors... for example on querys like: $result = mysql_query($sql); add: $result = mysql_query($sql) or die('MySQL Error: ' .mysql_error()); Also echo out your inputs to make sure they're valid.. $ids = $_GET["id"]; $tabsl = $_GET["base"]; die('INPUTS: ' .$ids. ' ... ' .$tabsl); You may also want to make sure there's actually a record being retrieved from the database: $result = mysql_query($sql); if (mysql_num_rows($result) == 0) { print 'No record found!'; } else { $myrow = mysql_fetch_assoc($result); // print out form } Your codes very minimal at the minute.. Adam

oh aye.. must have skimmed over it ??? Well as fireball5 said, AJAX is the answer.. but the bit of code I showed you before with a few small changes will function as the PHP side of it... <?php // connect $username = mysql_real_escape_string($_POST['username']); $check = mysql_query("SELECT userField FROM yourUserTable WHERE userField = '{$username}'"); if (mysql_num_rows($check) > 0) { print 1; } else { print 0; } ?> Then just follow a tutorial such as http://www.w3schools.com/Ajax/ajax_database.asp .. to setup the javascript side of it. Any help? Adam

The function "pathinfo" - http://uk2.php.net/pathinfo - returns an array of information about a filepath .. are you using PHP4?

Use something like: <?php $username = mysql_real_escape_string($_POST['username']); $check = mysql_query("SELECT userField FROM yourUserTable WHERE userField = '{$username}'"); if (mysql_num_rows($check) > 0) { print 'Username taken!'; } else { print 'Username available!'; } ?> Adam

if (PEAR::isError($mail)) { echo("<p>" . $mail->getMessage() . "</p>"); } else { "<a href='PeterBonConfirmation.html'></a>"; } That's whats printing out: <p>Failed to set sender: @localhost [sMTP: Invalid response code received from server (code: 501, response: <@localhost>: no local part)]</p> Perhaps show us the entire script, mainly after what you've shown us already?? I've seen it happen before, all it is is the HTML after the script would contain a closing tag or another column which forces the form back into it's right place... If you notice after the form is submitted the adverts on the right side dissapear... Adam

Don't need to use: die(' .. '); .. can use: die(" .. "); ??? Is it actually showing ANYTHING in the source? Namely the HTML tags before and after the script?? Adam

From what I can see you're not outputting the rest of the page after the PHP output.. you look at the source before the form is submitted and you can see a closing body and html tag, but when you look at the source after the form is submitted and there's no body or html tag and it ends with: <p>Failed to set sender: @localhost [sMTP: Invalid response code received from server (code: 501, response: <@localhost>: no local part)]</p> So basically after your script you need to output the rest of the page and that will make it align correctly.. Adam

Should be: while ($row = mysql_fetch_array($query)) { echo "<br /> Title: " .$row['Title']. "<br /> Story: " .$row['Content']; } EDIT: Notice the quote removed from the end...

Try echo'in out $tabs and make sure its correct, and also change: $result = mysql_query("select * from $tabs order by id"); to.. $result = mysql_query("select * from {$tabs} order by id") or die('MySQL Error: ' .mysql_error()); ...then see what happens. Adam

Reckon I've got the logic right, but can't get it to work properly... <?php $resSQL = "SELECT * FROM reservations WHERE (datefrom BETWEEN '{$year}/{$month}/01' AND '{$year}/{$month}/{$daysInMonth}' OR ((datefrom BETWEEN '{$year}/{$month}/01' AND '{$year}/{$month}/{$daysInMonth}') AND (dateto BETWEEN '{$year}/{$nextMonth}/01' AND '{$year}/{$nextMonth}/{$daysInMonth}')))"; ?> What is working is that it's returning any reservations where the starting date is in $month .. however still the overlapping reservations are left out, both any at the start or end of month.. I may have overused brackets starting at the "OR"... All variables are correct, double checked. I think it's just something wrong with either bracket use or slight logic problem. What does a fresh pair of eyes see? Any help appreciated, Cheers! Adam

I imagine then that your just sort of incrementing the current ID by 1 for the "next" button? Seen as the IDs don't match up and you can't always guarantee that they will all be flowing one after another, you could try something more like: <?php $record = (int) $_GET['record']; $query = mysql_query("SELECT * FROM table LIMIT {$record}, 1"); //... ?> That would return the first, second, third record or whatever from the table.. obviouslly it won't always match the ID, but you could still do a check for that.. like if they go to .. adult.php?id=3 .. then you select it by the ID, or if its .. adult.php?record=2 .. then you select it by the record number or something? I don't know but it's a an idea, would allow you to keep the "next" button feature... Adam

As chronsiter says, can't really detect refresh with PHP... But why would you want to log them off if they refreshed?? It would get really annoying if every time I refreshed the page I was logged out... I'd reccomend database sessions aswell, sounds like you want it closely montiored and secure so they're your best bet! Adam

Could try JOINs.. http://www.google.co.uk/search?hl=en&q=mysql+join Or perhaps this may help.. http://www.astahost.com/info.php/mysql-multiple-tables_t12815.html Adam

double check $filename 's what its supposed to be ..

Hate working with dates in MySQL, but here's the problem: "SELECT * FROM reservations WHERE (datefrom BETWEEN '{$year}/{$month}/01' AND '{$year}/{$month}/{$daysInMonth}')"; That works almost perfectly, except for it won't return reservations that overlap months (in the next month anyway). So if the datefrom date is january 29th, it won't show the reservation in february... The dates are stored in "date" (YYYY-MM-DD) format. I sort of come close to working it out then my mind goes blank and i can't think... doing my head in! Anybody have any possibilities? Cheers, Adam!!