In my database the table is set out like this:

id | title | category

There is about 1000 records in there and i want to be able to create a list of the categories but if i do a foreach statement i just get the same categories over and over.

try this

Code:

$select = "SELECT subcategory FROM recipes WHERE category = '" . $row['category'] . "' GROUP BY subcategory";

don't do this in php, use a mysql query.
Code:

SELECT DISTINCT ( category ) FROM mytable

OR

Code:

SELECT category FROM mytable GROUP BY category

I am building a small vulnerability tester in PHP that checks a URL for vulnerabilities. The check uses a function that either outputs Yes, or No. instead of having to wait for the whole page to load, is there a way to print them out one at a time as they are checked?

I think its depends on the browser, it will display line per line.

after you echo the line use these 2 lines:

ob_flush();
flush();

When we execute a php file under command line, that includes large functionality and it takes 2 or 3 minutes to complete the task, What is my doubt is while running that file under command line,will script time out error occur?

Increase the max_execution_time variable in php.ini to the required time and you should be ok.

use this code

Code:

set_time_limit(0);

I have a page that does many regexes with large files and iit’s giving me the 60 seconds time out. Is there a good way of avoiding this?

You can do it several ways..

If the hosting server does not have safe mode enabled, you should be able to use ini_set(max_execution_time, ###);

Otherwise, what you can do, is have the script open the file, and read 100 lines… pause, then reload and read the next 100 lines…

Use set_time_limit(99999999);

thanx for reply

I have a set of 10 textboxes with 10 url’s and my page should extract their titles and metas and lots of other details using regex and it timeouts. I really would like to know if it’s possible to run this job with reloads.

try using (.*?) between title…

and, only get the first half a kb per site

I want to make my website pages more dynamic.
Can I do this using:

$file=”articledetails.php”;
include(‘$file’);

You can also use like this: include(“$file”);

variables won’t be parsed between single quotes.

Code:

include($file);

i m looking for a if not statement code.

is this an if not statement:

if!()
{
}

try this code

Code:

if(!file_exists("foobar"))
{
        mkdir("foobar");
}
Just move the ! inside the parentheses, like this
Code:

if(!)
{
}

use it

Code:

if (!isset($var)) { }

or

if (empty($var)) {}

or

if (!something) {}

yes ! shuld be infront and in parentheses. like
 
 
 if(!$var)
 
 {
 
 do something
 
 }

I have match against works fine with mysql. However I can not match h2o. Is there anything special with this phrase?

By default MySQL full text searches are limited to phrases of four or more characters. If you have access to the MySQL configuration options for the server it can be changed. However in most shared hosting environments you will not be able to change it.