mapleleaf

<?php $to = 'nobody@example.com'; $subject = 'the subject'; $message = 'hello'; $headers = 'From: webmaster@example.com' . "\r\n" . 'Reply-To: webmaster@example.com' . "\r\n" . 'X-Mailer: PHP/' . phpversion(); mail($to, $subject, $message, $headers); ?> from http://php.net/manual/en/function.mail.php which is a really good resource

$checkforprev = mysql_num_rows($resultcheck); Missing semi-colon; what are you using for a text editor as it should catch things like that for you?

yes it is possible. You will also need to factor in dates I imagine but in the table you will have table_ids and date You then "SELECT * FROM tables; Then in results view you simply put an if statement such as Run a foreach($row) and within that if (date == today) { //you will change the today to whatever date they are choosing of course echo 'Booked'; //you might just color the table using css }else{ echo 'Available'; } I hope this gives the idea.

Is the row returned the one with the Maximum length in region 1? Do you want the max(length) per team or angler?

For example having done the query: <input name="first_name" type="text" value="<?php echo $row['first_name'];?>">

I think you are looking for is_numeric() instead of is_int()

Sounds like you need a subquery Select * from the list WHERE city_id = '(select city_id from the list where address='%$searchString')' ; My syntax is almost certainly wrong but you get the idea and can probably look up subqueries somewhere.

max_exection_time is probably 30 seconds. You will need to increase it though that isn't practical as most people won't wait so long to find out. How did you end up with 70,000 US zip codes? My database of zips has only 43,000 or thereabouts. I would suggest not allowing searches of more than 50 miles or find a way of caching as checking against every zip is a lot of queries. With 800,000 zips it will be too much for most to wait for even if you get the execution time sorted.

I think you are looking for FIND_IN_SET(5, group)

so each image is associated with a book so you need the path to the image in the database in a field with the book entry Then you for example: ///$site_url is the full path of your domain $sql = "SELECT url WHERE book_id = '$book_id'"; $result = mysql_query($sql); $row = mysql_fetch_array($result); echo $site_url.'/images/'.$row['url']; something like that

mysql_query("SELECT points from members where username = '$username'") or die(mysql_error()); You might be getting $username from a session or $_POST. Not clear from your post

Codeigniter has the best documentation around. Read the manual.

It will be better to store the image name(and path if needed) in the database and store the images in a directory.

You should be able to save the url as a variable and insert it at the same time as the rest of the Insert or if the INSERT has happened you will need to UPDATE referencing the last_insert_id assuming it happened in the same script.

you should be able to copy most of the tables over from the previous installation but be careful with some of the settings tables as their might be urls in them. There is probably a better way. Try their own forum for help.

$sql = "SELECT * FROM pools WHERE poolid like '347%'";

I would go for the one table. Less code for all your queries and simpler queries. MYSQL tends to be fast when indexed.

UPDATE Dis_Status SET status = 'Status' WHERE username = 'whatever'; It is an UPDATE that you need not INSERT. Obviously that query is not exact but I hope it gives the idea. Also it is easier to read if you put code in the code tags

Your query isn't using the users table so you can remove that and also the order by won't know which id to order by unless you specify a table. That may not be why things are coming twice but it might help

<?php echo $url$row['photoAnimal']; ?> should be: <?php echo $url.$row['photoAnimal']; ?>

Depends how busy your site is and how important the timing of the scheduled task is. Your home page could always hit the database and check if a task has been run and if not run it. You would need to set up the intervals etc and just update the database when i is done adding a new time to run it. Cron is way better of course

http://jqueryui.com/demos/datepicker/

I think you are looking for tinyme or fckEditor

Got the solution elsewhere Here for anyone who might be looking is(':visible') ) was the magic needed. if( $('#bonuses').is(':visible') ) { // it's visible, do something }

Try this: echo 'Photo: <img src="'.$url.$row['photoAnimal'].'"><br/>';