[using variable as math operator]

$c = eval("$b ".$a);

 

would make sense.

[input type email]

The "email" type attribute will actually validate the data it contains if you set the "required" attribute.

 

Of course, not all browsers yet support this functionality however.

 

I actually forgot that it validates it's contents if required.

Here is the regex that it uses for validation:

 

/^[a-zA-Z0-9.!#$%&’*+/=?^_`{|}~-]+@[a-zA-Z0-9-]+(?:\.[a-zA-Z0-9-]+)*$/

 

not the tightest regex, but efficient enough.

 

and the w3 docs if anyone cares to see: http://dev.w3.org/html5/markup/input.email.html

 

but yah as noted, not all browsers yet support this and server side validation is still required.

[Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given i]

my money is on an ambiguity issue with Resource_ID, but add this to the query:

 

$sql="SELECT * FROM resource l
inner join resource_skill ln on l.Resource_ID = ln.Resource_ID
inner join skill n on ln.Skill_ID = n.Skill_ID
WHERE Resource_ID=" . $contactid;

//-run  the query against the mysql query function
$result=mysql_query($sql) or die(mysql_error() . '<br />' . $sql);

 

post the results.

[How do I block visitors from certain countries?]

It's not a very reliable or hard to work around solution but, you could find out what ip ranges are allocated to that country and use a Deny rule to block that ip range.

 

http://httpd.apache.org/docs/2.2/howto/access.html

[Unable to fetch data from mysql]

certain browsers will stop parsing when an error is encountered.

As the error says, bgcolor is not a valid css property, background-color is.

 

 body{background-color:#E0E0E0;} //change accordingly

[input type email]

you can have some sort of validation client side, but should always also have validation server side, just in case JS is disabled, this will prevent security leaks. as jesirose already stated.

[#1045 - Access denied for user 'root'@'localhost' (using password: NO)]

yes, you said you are using mysql console vial shell, right?

[mysql select datas after time interval]

select col_name from tbl_name where timestamp_field = NOW()

 

[The PHP Side]

Thanks but I dont necessarily (and correct me if I am wrong by all means) think this is how Tumblr or Blogger (Google) do it.

 

Why would you make such a claim?

This is the typical way to go about this.

[function to change input text name]

yah, http://api.jquery.com/attr/

[Unable to fetch data from mysql]

at first glance the script looks to be fine, except you specify q twice in the query string.

What happens when the script is ran?

Have you tried debugging the script using alert()s?

[How do i make images appear when making a search from a MYSQL database?]

the first statement, add either a class or an id (depending upon how many images you want the css to affect) and style it in an external css page.

[function to change input text name]

You want JS/Jquery, what have you tried so far?

[How do i make images appear when making a search from a MYSQL database?]

remove the <br>\n from the previous line.

You can add CSS to the image also.

[How do i make images appear when making a search from a MYSQL database?]

again, this code will need to be tweaked so it looks right:

 

while($row = mysql_fetch_array($result)) {     // Loop through results
        $i++;
        echo "Displaying record $i<br>\n";
        echo "<b>" . $row['id'] . "</b><br>\n";      // Where 'id' is the column/field title in the database
        echo $row['Location'] . "<br>\n";            // Where 'location' is the column/field title in the database
        echo $row['Property_type'] . "<br>\n";       // as above
        echo $row['Number_of_bedrooms'] . "<br>\n";  // ..
        echo $row['Purchase_type'] . "<br>\n";       // ..
        echo $row['Price_range'] . "<br>\n";         // ..
        echo '<img src="'. $row['images'] .'" />';   //image
    }

[How do i make images appear when making a search from a MYSQL database?]

Here is some Pseudo code to get you going:

$sql = 'SELECT * from table';
$query = mysql_query($sql) or die(mysql_error() . '<br />' . $sql);
while($row = mysql_fetch_assoc($query))
{
    ?>
        <img src="<?php echo $row['images']; ?>" />
    <?php
}

 

this will simply display each image in the table, you will need to tweak it to suit your needs.

[How do i make images appear when making a search from a MYSQL database?]

looks right.

Now you need to grab that data from the db using a select statement.

Have you attempted a query yet?

[How do i make images appear when making a search from a MYSQL database?]

create a varchar type field named whatever and insert the file paths.

So if you have an image at /some/file/path/image.jpg, that is what will go into that field, along with any other corresponding image data that you want.

[How do i make images appear when making a search from a MYSQL database?]

Typically, the images are stored in a directory and the file paths are stored in the database.

[How do i make images appear when making a search from a MYSQL database?]

Where are the images coming from?

[Warning: mysql_fetch_array()]

the query that you are providing mysql_fetch_array() is returning a boolean false.

The problem lies there.

[Update is not working in an if statement]

I'd never even seen the syntax, I was just responding to the person who said they needed an endif.

 

you misread, I said it shouldn't be there.

[Our Site Version 3]

Nice layout, nice text colors, overall a nice site.

 

1. The green top nav buttons seem a little random to me, doesn't really go with the color scheme imo.

 

2. maybe change the top user/pass inputs from the default outline.

 

I will update my list if I spot anything else.

This is a good looking site.

[newb - a simple array , then sort it ?]

Someone is just inputting it on screen

 

The data needs to be stored somewhere.

How will there be 120 users if the data is not stored?

[newb - a simple array , then sort it ?]

Its not from a database.

 

It should be.

How is the data saved?

Please don't say to a .txt file.