Tpojka 56 makingMagic(true);
Tpojka 56 makingMagic(true);

Welcome to aboard.
First, you shouldn't use mysql driver but you should use mysqli if procedural (as this example is) or PDO (preferable) if OOP.
Secondly, you need to loop over returned results. Check example 2.

Also, check what have you got if print_r($result) without html tags.

Tpojka 56 makingMagic(true);

Can you test it on non secured page and check results,
some development environment maybe?

Tpojka 56 makingMagic(true);

If you ask that. you probably didn't set anything about it.
But just in case see your localhost file how is set and post the code here.
.htaccess file is usually in root directory. But also more files with that name can be found in subdirs as well.

Tpojka 56 makingMagic(true);

Check if .htaccess is written well for online environment.

Tpojka 56 makingMagic(true);

I think, all in case it is about pure PHP, class is more than that.
Someone made it, name it as IO so probably class has many methods for inputs and outputs like checking, returning etc.
Example @veedeoo gave is good one.

Tpojka 56 makingMagic(true);

So, is there class I assumed?

Tpojka 56 makingMagic(true);

It looks like there is IO.php (not necessarily) file with same class name (mandatory) in it to me.
I would say there is
public static function intValue($int = FALSE){}
or something like that inside class.

Are you familiar with OOP?

Tpojka 56 makingMagic(true);

Try with setting:
$db[‘default’][‘db_debug’] = false;
in database.php file.

ravi142 commented: @Tpojka : Thank You +1
Tpojka 56 makingMagic(true);

Revert the loop code. It is fine.
Variable is created and you can use it next in code.
My question is where do you pick $_POST['edit_event'] in your form?
Because you set condition for fetching data if edit_event is posted.

Tpojka 56 makingMagic(true);

Nice. Mark it as solved.

Tpojka 56 makingMagic(true);

Check this code. Bit different than yours.

Tpojka 56 makingMagic(true);

User's login to management page should check DB table column to see if it is available or not. That is column which value is changed by admin.
So, when user logs in to account or even as logged in member click the link to management page (in case there is some area you can still visit), there should be also check to see the value of deadline_expired (I.E.) column. That can be date or boolean or some in code predefined INT.

On admin page I soppose you have edit user. Just add one more input field for deadline_expired column

Is that good enough for you?

Tpojka 56 makingMagic(true);

Since you are using javascript field validation,
take a look of this integrated jQuery solution.

Tpojka 56 makingMagic(true);

I don't know are you trying to get map center from details of your DB or dinamically of some marker triggered event.
If it is first case, just add PHP echo in your JS code.
If it is second case, you can use panTo() method.
I've make little function from basic example of gmap v3 you can check:

<!DOCTYPE html>
<html>
  <head>
    <meta charset="utf-8">
    <title>Map moving to the marker position</title>
    <style>
      html, body, #map-canvas {
        height: 100%;
        margin: 0px;
        padding: 0px
      }
    </style>
    <script src="https://maps.googleapis.com/maps/api/js?v=3.exp&sensor=false"></script>
    <script>
// The following example creates a marker in 
// Stockholm, Sweden using a DROP animation. 
// Dragging marker on map will set new center position of map.

var stockholm = new google.maps.LatLng(59.32522, 18.07002);
var parliament = new google.maps.LatLng(59.327383, 18.06747);
var marker;
var map;

function initialize() {
  var mapOptions = {
    zoom: 13,
    center: stockholm
  };

  map = new google.maps.Map(document.getElementById('map-canvas'),
          mapOptions);

  marker = new google.maps.Marker({
    map:map,
    draggable:true,
    animation: google.maps.Animation.DROP,
    position: parliament
  });
  google.maps.event.addListener(marker, 'mouseup', panMapToMarker);
}

function panMapToMarker() {

  if (marker.getPosition() != null) {
    map.panTo(marker.getPosition());
  }
}

google.maps.event.addDomListener(window, 'load', initialize);

    </script>
  </head>
  <body>
    <div id="map-canvas"></div>
  </body>
</html>

I hope you will find something usefull. Cheers.

edit: I have modified code sample from this page.

Tpojka 56 makingMagic(true);

I am really busy right now here, but regardless this topic is for JS subforums, you should check Marker class, position_changed event and getPosition() method.

Tpojka 56 makingMagic(true);

Try with:
center = new google.maps.LatLng(30.0599153,31.2620199,13) || map.setCenter(marker.getPosition());

Tpojka 56 makingMagic(true);

You can use js or some of jquery functions [add(), append(), appendTo()] to get such result.

Tpojka 56 makingMagic(true);

What do you want to echo?

What type of data is $var?

You have reference here of using do_shorcode() function.

Try to var_dump() $var after assigning value to it to see what have you got.

Tpojka 56 makingMagic(true);

Is this your solution:

<?php 
function jde_date_conv($jde_date) 
{ 

$ct = substr($jde_date,0,1); 
$yr = substr($jde_date,1,2); 
$dy = substr($jde_date,3,3); 

if($ct == 0) $yr_pfx = 19; 
if($ct == 1) $yr_pfx = 20; 

$tlt_yr = $yr_pfx.$yr; 

$base_time = mktime(0,0,0,1,0,$tlt_yr); 

$unix_time = ($dy * 86400) + $base_time; 

return date("d-m-Y" , $unix_time); 
} 
?>

Edit: you have shorter solution above.

Tpojka 56 makingMagic(true);

I think those are just safety and security improvements. If your code is clean way and well coding habit guarded (i.e. if you have coded nice bridge if required file doesn't exists), there is no need to worry about.
Here you have changing log and list of what is done in 5.4.0 version.
Also, those are changes related to 5.3.10 subversio. Check what exact (sub)version was your 5.3 on the same link and compare changes to it.

Tpojka 56 makingMagic(true);

It can be solved just putting @ sign infront of domain name:
@unwantedmail.tld

Tpojka 56 makingMagic(true);

You can use bunch of php inbuilt functions. Here is an example of preg_match().

if (preg_match('|@onlyalloweddomain.com$|', $registrantMailAddress;
{
    // continue with registration
}

I found it on sof.

Tpojka 56 makingMagic(true);

Since you are going to fetch only one row from DB table regarding to requested id by method get, it would be more convenient to use mysql_fetch_row() function.

Also make check for your input, something like:

$id = isset($_GET['id'] && (int)($_GET['id']) !== FALSE) ? $_GET['id'] : 'exit';

if ($id === 'exit')
{
    header('Location: http://www.example.com/'); // or some predefined page in this case
    exit();
}
//rest of your code here
Tpojka 56 makingMagic(true);

Happy New Year you too.

First part of question you can make answered with just output of array:

$myArray = array('zero' => '0', 'first' => '1st', 'second' => '2nd', 'third' => '3rd');
print_r($myArray);

Second part of question you can solve with function min but also depends of type of variables you have in values of array.

Tpojka 56 makingMagic(true);

I see there many syntax errors.
Mayby you could try this way:

$catsql = "SELECT * FROM categories";
$catres = mysql_query($catsql);
while($catrow = mysql_fetch_assoc($catres)){
    echo "<a href=" . $config_basedir . "/products.php?id=" . $catrow['name'] . "</a>";}
Tpojka 56 makingMagic(true);

Try with:
while($row = mysql_fetch_assoc($userquery))

Tpojka 56 makingMagic(true);

what wronh with this line

$userquery = mysql_query("SELECT * FROM members WHERE username= '$email'") or die ("the query");

If you have changed $_GET['username'] variable to $user, you need to change it in query too instead *$email* variable.

Tpojka 56 makingMagic(true);

You have conflict with your $email variable
Here in code (even it ain't all as code lines as descripted), in line 5., you have:

$email = $_GET['username'];

and than in line 19., you have rewriten variable

$email = $row['email'];

Try to use different names for each of them.