[Need: Recursive function for menue]

try:

 <ul>
            <?php $result = mysql_query("SELECT * FROM pages INNER JOIN parent_pages ON pages.parentID=parent_pages.ID WHERE pages.parentID=parent_pages.ID");
            while ($row = mysql_fetch_assoc($result)):?>
            <li class="mainnav"><a rel='nofollow' href='view.php?id=<?php print $row['ID'];?>'><?php print $row['Name'];?></a>
                <ul>
                    <li class="subnav"><a rel='nofollow' class="sublink_nav" href='viewpage.php?pageid=<?php echo $row['pageID'];?>'><?php print $row['pageName'];?></a></li>
                </ul>
            </li>
            <?php endwhile;?>
            <?php $result2 = mysql_query("SELECT * FROM parent_pages WHERE pageID='0'");
            while ($row2 = mysql_fetch_assoc($result2)):?>
            <li class="mainnav"><a rel='nofollow' href='view.php?id=<?php print $row2['ID'];?>'><?php print $row2['Name'];?></a></li>
            <?php endwhile;?>
            </ul>

[MySQL Error 1146 Help.]

is your new database table definitely called webestat_site and not webstats_site. And the table called stats?

[Need: Recursive function for menue]

Have you even attempted this on your own? you will be hard pushed to find someone who will write an entire script for you from scratch. If you have attempted this then please post some of your code

[Joins in MySQL]

Google is your friend:

http://dev.mysql.com/doc/refman/5.0/en/join.html

 

[Issues selecting multiple rows]

there is a bult in function in mysql that allows you to pass in an array as a parameter:

$array = (1,2,3,4);
SELECT *, CONCAT(locations.zip_code, ' ', locations.city) as location from locations, locations_associations where locations.zip_code = locations_associations.zip_code AND client_id IN ($array);

[collapsing HTML table]

<table style="width:700px;display:none;">

[what site do i use to check for possible issues on my site ?]

you could use the google webmaster tools. this will show you all traffic data etc for your site. Also it allows you to upload you sitemap, which could increase your ranking and searchability.

 

https://www.google.com/accounts/ServiceLogin?service=sitemaps&passive=true&nui=1&continue=https://www.google.com/webmasters/tools/&followup=https://www.google.com/webmasters/tools/&hl=en

 

[A difficult challenge-- How to calculate sum of earlier date records for each li]

firstly, try not to use sum as a field name. this is a reserved word in mysql. You can try something like this:

INSERT INTO table (Date, Value, TotalSum) VALUES ('$date', '$value', (SELECT SUM(value) FROM table WHERE Date < '$date'))

Note that i am presuming your ID is auto incimenting so i havent included it

[Need help with my PHP and database issue]

err? your missing part and email from your post declarations

[Why should you learn javascript when you know php?]

Drag and drop, sortable lists on the fly without page reloading......................... the list goes on

[Language combo]

firstly,try to learn the an Object Oriented approach to your coding. Other languages to think of are Ext JS, Extjs Touch( mobile), also read up on Design Patterns

[PHP Inside Of Jquery]

$('#account_setting').attr('href', '<?PHP url_for('Account/Settings/site_id/'+data)) ?>';

["\" sign immediatly after "<a href="]

It is escaping the string for you. because you are using double quotes within double qoutes then without them your echo would output: <a href= onely,  and the rest would be ignored / thrown error

[Inserting array of data into database]

foreach($_SESSION as $product => $quantity)
{
INSERT INTO table1 (product_id, quantity) VALUES ('$product', '$quantity') .......
}

 

looks like the session is holding a key-pair array of data, so a simple foreach loop will extract what you need

[Little help with submit button and field check.]

use some javascript on the client side and then some further validation on the server side:

pop an id into each of the field tags and try something like

var hpl = document.getElementById('hpl')

 

[DOB problems]

what is the data type for your dob field? If you used a date type then you can just do it all in one query

SELECT * FROM detail WHERE dob = CURDATE()

 

and if you use a datetime datatype:

SELECT * FROM detail WHERE DATE(dob) = CURDATE()

 

and if you wanted to get everyone who had a birthday tomorrow:

SELECT * FROM detail WHERE DATE(dob) = DATE_ADD(CURDATE(), INTERVAL 1 DAY);

 

etc.....................

[PDO Exception and object problem]

The exception is telling you that you have a syntax error in your query. This could be due to an escape character being passed into the user variable. Try doing:

$query = "SELECT * FROM `users` WHERE `username` = '".$user."' AND `password` = '".$pw."'";

Also try and echo out

$query

to see what the query looks like

[Mysql daily back-up]

If you have access to setup up cron jobs then set a cron to run

 mysqldump -u<your username> -p< your password> <database name> | <compression type e.g gzip> > location

[onclick help]

youve got the div's style set to hidden. So it wont diplay enything until you add the display block to it

[header location using if-not working]

Remove any whitespace

[For Loop.]

Mjdamato is right, the php.net manually is a life saver. A great reference

[Please help, submitting to DB when form not complete.]

You have your database insert sitting outside of your error logic. So no matter what you are executing the query. Move the query into the else statement

[For Loop.]

Try

($num = 10; $num >= 1; $num--)

[Auto clear php form n conenction bet php n flex project]

Try sending a static email to test if the actual email functionality is working

mail('youremailaddress@somewhere','test subject','test message');

 

If that dosent send then you need to ensure your web hosting has email functionality enabled. Otherwise you need to echo out each of the variables. Your 'from' is a header parameter and should be in the correct format 'From : me@emailaddress.com'

[Auto clear php form n conenction bet php n flex project]

For starters you haven't added the message into the Mail function. secondly, are you testing this from your localhost, and if so do u have an email server installed?