[Need help choosing a PHP Framework/CMS]

Depends what the site is going to be used for. If it is going to be a fully fledged e commerce site then drupal would be a good bet. If it is just a simple blog style site then have a look at using something like wordpress.

Its all down to personal preference, and if you want to build it yourself or not. Even though these packages are proven and tested it never hurts to have a go yourself. This helps to give you a better understanding of the principles involved, i.e design patterns etc.

[need help with php :(]

$res = mysql_query("SELECT * FROM cities", $hd)
echo "<form action ='' method='POST'>";
echo "<select>";
while($row = mysql_fetch_array($res))
{
  echo "<option value='{$row['city_code']}'>{$row['city_name']}</option>";}echo "</select>
}
echo "</select>";

echo "<input type='submit' name='submitForm' value="Submit"/>";

</form>

[need help with php :(]

$res = mysql_query("SELECT * FROM cities", $hd)
echo "<select>";
while($row = mysql_fetch_array($res))
{
   echo "<option value='{$row['code']}'>{$row['city']}</option>";
}
echo "</select>";

[ajax jquery help]

data: dataString,

 

where are you declaring your dataString variable ?

[ajax jquery help]

if(isSet($_POST['recordPurchaseState'])){

this needs to be lower case isset

[FCOMMENT?]

FCOMMENT is just an alias name given to the fieldname, it could be called bob for all the difference it would make. Your mysql error is actually telling you that your error is with:

t1.*

[How does one refer to empty cells in mysql?]

firstly, what datatype is the relation field ? is it an int, char etc.....

[PHP pages resolving extremely slow!]

have you added any extra queries to the site in the last week, could be a memory leak caused by your sql. have a look at setting up the mysql slow query logs and see if that's causing an issue?

[AJAX call issue?]

{"responseStatus":"err","responseMsg":"ajax"}

if (response.responseStatus == 'err') {

    if (response.responseMsg == 'ajax') {

      alert('Error - this script can only be invoked via an AJAX call.');

 

your code is doing exactly what it is coded to do. What is the problem?

 

[query question.]

Which column does the variable relate to?, for example if it related to the Mobile column:

SELECT Business_Name,First_Name,Last_Name,Username,Email,Phone,Mobile,Social_Media,Web_Site,User_Language,Admin_Level FROM customer WHERE Mobile = '$variable'

[Wrong date?]

Instead of passing the datetime and then running another function to reformat, try using the

Date_format(mydateField, 'd/m/Y H:i:s')

Within your query. The main reason you use a datetime in mysql is that it has an enormous array of functions that can be run against it, one of them

Being formatting.

[Images as variables.]

damn extra speech mark. gets me every time.

[Images as variables.]

well spotted lol

[Images as variables.]

1. does the image exist on the server / your pc.

2. is the images folder sitting in the same directory as this test script.

3. you could try and see if the file exists:

 if (file_exists("images/bottlesandcaps/diamondbottles/smalldiamonddarkblue.gif")) {
        echo"image exists!";
    } else {
        echo"image does not exist!";
    }

 

[Inject string at a certain position]

Sorry, i thought it wouldnt be a great leap for him to follow the syntax:

$string = '74342';
$newstring=substr_replace($string, '.', -2, 0);
echo $newstring;

// result = 743.42

 

[myqSL 1064 Error]

looks like your trying to upload your code files into your database, not your sql dump.

[Inject string at a certain position]

$newstring=substr_replace($orig_string, $insert_string, $position, 0);

[how to use xampp]

if you are using windows however it will more than likely be:

c:/xammp/htdocs/

[PHP function within a mysql select statement.]

You cant execute or call php functions directly from within an sql statement

[myqSL 1064 Error]

why are you trying to import html direct into the database?

[PHP function within a mysql select statement.]

SELECT * FROM table WHERE field1 + field2 = '3'"

given that field 1 and 2 where both INT fields

[Best Backup Software / Tools]

I have always found this to be a really good and easy reference to get you started:

 

http://www.abbeyworkshop.com/howto/misc/svn01/

[Best Backup Software / Tools]

you should look at using a code source reporitory. such as subversion, cvs or git

[adding 2 hours to now()??]

  $date=date("Y-m-d H:i:s",time() + 7200);

[Updating specific record in mysql field]

<?php

// connect to the database
include('connect-db.php');

// get id value
$id = $_GET['id'];
echo "$id";

$sql="SELECT * FROM events WHERE type='beacon'";
$result=mysql_query($sql);


$active=($result['publish']=='')?'Yes':'No';
echo "$active";

if ($active='Yes') {
    $active='No';
} else {
    $active='Yes';
}
$sqltwo = "UPDATE events SET publish='$active' WHERE ID='$id'";
$resulttwo = mysql_query($sqltwo);

// header("Location: beacon.php");
?>