[help for the Picture and form upload in DB]

People are here to help you with problems that you may have WITH CODE THAT YOU HAVE TRIED TO WRITE YOURSELF. If you want someone to write it for you from scratch then you need to post this in the freelance section and expect to pay for the work. Other wise you will more than likely be out of luck.

[fixing query]

remove "// link to update.php and send value of id"  from your script

[Query empty]

if (!mysql_query($sql,$con))

should be

if (!mysql_query($mysql,$con))

[My localhost can't accept session and header in php pages]

this is nothing to do with your localhost not being able to accept sessions. this error :

Warning: Cannot modify header information - headers already sent by .....

means that somewhere in your code you are trying to send a header AFTER something has been sent to the page. There are two basic rules for using headers :

[*]Ensure thats there is no whitespace directly after the opening / closing tags

[*]Ensure that nothing is printed to the page before any kind of header redirect etc.

 

to help you further we need to see some code

[mail]

huh?

[Upgraded from PHP4 to 5 syntax error?]

turn on your error reporting and see what error it throws:

<?php
ini_set('display_errors',1);
error_reporting(E_ALL);
?>

 

put that at the top of your script, just below the opening php tag. post the errors here

[User Management System]

look at using sessions http://php.net/manual/en/ref.session.php.

sudo code for your page would look something like this:

 

<?php
session_start();

if(the users has a valid session){
profile block
}
else
{
dont display block
}
?>

[Google Map Clustering]

where is your createMarker function defined? looking at the google map api you make your own createMarker function. I could be wrong, but it looks like you have to build your own function

[How do I select only words that start with A out of mysql?]

$SQL ="SELECT * FROM dictionary where word LIKE 'A%'"

[Seeking Help with Emailing multiple addresses in PHP Contact Form]

try:

<?php
$emails = array("name1" => "name1@domain.com", "name2" => "name2@domain.com", "name3" => "name3@domain.com", "name4" => "name4@domain.com");

  switch ($Dept) 
  {
    case "Customer Service":
      $email_to = $emails['name1'] . ", " . $emails['name2']. ",".$emails['name3'] ; 
      break;
?>

[PHP memory usage optimization]

errrrr??? is your production server being used by users?

[csv uploading]

What have you tried so far? You cant just ask people to write the upload code for you. if you want someone to do it for you then you need to post this in the freelance section. With that said, look at using fgetcsv.

There are examples on how to read csv's. you also need to lookk at how to upload and move files on the server and using functions like fopen

[Not pulling info from DB]

where are you declaring

$tbl_name and $tblname2

???????????

[mail limit on hosting]

thats an issue between you and your hosing company.

[No permission when trying to call htm file on local host]

No, you do however need to read up on managing access and permissions in linux. using 777 is a very bad option so dont go using that all of the time. It is basically granting all read and write permissions for that file, and as you can guess can lead to security problems.

 

http://www.linuxforums.org/forum/linux-tutorials-howtos-reference-material/10862-linux-file-permissions.html

 

a starting point

 

[No permission when trying to call htm file on local host]

nothing 'mystrious' about it, what permissions are set for the .htm file. run

chmod 777 /var/www/html/filename/htm

and try again

[Find the rank of a user on my web site]

sorry, remove the 'where user=' part out of the query

[Find the rank of a user on my web site]

$u_count	= mysql_result(mysql_query("SELECT COUNT(*) AS 'Total Entries', user FROM directory WHERE user='$u_id' AND status='1' GROUP BY user  ORDER BY 'Total Entries' DESC LIMIT 5"),0);

[How can i do this?]

your query can't be TWO dates at the same time. use between:

<?php
SELECT name, date, comment
FROM narvaro_all
WHERE date BETWEEN '2011-07-14' AND '2011-07-20'
?>

[DATE...TIME]

<?php
// offset diefference between you and the server
$offset = 6;
$now = date('Y-m-d H:i:s', time()+$offset*60*60)
?>

[DATE...TIME]

where in the world are you?

[DATE...TIME]

sounds like your server is not in the same timezone as you . Is this your own server?

you could try passing in the time on the php side:

<?php
$now = date('Y-m-d H:i:s', time())
?>

[DATE...TIME]

and what time do you think it should be?

[DATE...TIME]

INSERT INTO table (datetimeField) values (now())

[mysql_query in while loop]

http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html#function_in

use the IN function in mysql. example:

 

<?php
$exampleValues = array(1,2,3,4,5,6,7,;
$sql ="update table1 set field1 = 1 where field2 IN($exampleValues)";
?>