[N64 Games]

1. banjo kazooie!!  its a classic

2. shadowman

 

and on snes the almighty terranigma

[Is this funny or am i just a sick little boy?]

Is this funny or am i just a sick little boy?

 

http://www.youtube.com/watch?v=kxZRKr7fVkg

 

I find it quite hilarious!

[Getting started with API - How?]

An rss feed is an API, its really that simple - you can make it any type of application

 

http://site.com/example.php: (on your site)

 

<?php

$go = $_GET['q'];

echo $go;

?>

 

On the developers site

 

echo file_get_contents('http://site.com/example.php?q=funny');

 

Which will output "funny" on the developers site

 

Thats all an API is

[Need a partnership]

Dont have any of them. If you want to make a search engine start with this crawler, it can index 1000's of urls in seconds

 

http://www.wizecho.com/nav=scripts&s=spider

[Need a partnership]

url: varchar 255

id: bigint 11

desc: text

meta: varchar 255

scan: tinyint 1 , default 0 (0 for url not in database already, 1 for it being there)

 

index the desc and meta fields

 

otherwise make desc fulltext and have a search engine type results based on how many times the keyword is in the description (content)

[Downloading Music Files: Where do I Start?]

Dont store any files on your server or youll get nicked, just index them and point your mp3 player to the file.

 

Findtail has the same structure http://www.findtail.com/type=MP3

[DISTINCT help]

you should still GROUP BY when selecting distinct

 

eg:

 

SELECT DISTINCT * FROM `table` WHERE `title`='funny' GROUP BY `title`

[Error on line .. but can't figure out why]

It just means your csv dosnt have a value for that field your inserting.

 

Itll be one of your blank  fields thats causing the problem. You should "As defined"  your field default and give it some default value.

[Trying to query some fulltext results with php from MySQL.]

In phpmyadmin select "structure" then look for the "T" hover over it and it will say "fulltext"

[Trying to query some fulltext results with php from MySQL.]

Have you made title and tag fields fulltext?

 

Also im not sure if you can match 2 fields try OR instead

 

$query="SELECT * FROM `tutorials` WHERE MATCH `title` AGAINST ('{$searchform}') OR MATCH `tags` AGAINST('{$searchform}') ";

[PHP Squisher?]

just a guess, but itll remove all whitespace in a string making it into 1 line of  code

[PHP Squisher?]

strip($text, $replace = ' ')
{
        return preg_replace('!\s+!', $replace, $text);
} 

[Check box results]

http://www.wizecho.com/nav=scripts&s=ajax_form

[Check box results]

<?php
//select query

//assign data
$check = $row['check'];
?>
<input type='checkbox' name='fin' <?php if($check == 1){echo 'checked';}?> > Checkbox

[StarCraft 2]

I hate sims - it makes one scream out for a real life!

[The fat guy]

In 2000 - 2002 "A current affair" showed a fat software developer who had stuck it rich creating some kind of software in Australia, all i can remember is that the reporter asked him if he would like to say anything to the world and he said "Look girls - im here", he also had 7 or so employees at the time.

 

Did anyone else see this or  know what he might have developed??

[PHP Email form and reCaptcha]

At the top of your php script - once the capatcha has been confirmed then you can process the form

[PHP Menu?]

Smarty! All the cool programmers use it

 

Otherwise just include it in php

 

<?php

 

include('header.php');

 

 

//other stuff

?>

[Smarty 3 is HERE!]

Template engines suck.

 

Just think about all the fun your missing out on by learning another language.

 

AND

 

Calling functions with a simple deliminator {$smarty|function}......it sends chills down my spine

[How to manipulate array data in smarty]

PHP:

$title = 'test'; //variable example
$arr[] = array('id' => 10, 'title' => $title);
$smarty->assign( 'arr', $arr);

 

TEMPLATE:

{section name=i loop=$arr}
{$arr[i].id}<br>
{$arr[i].title}<br>
etc....
{/section}

[I Want to search more in LIKE CLAUSE..]

Azaz you like totally ignored my post, which is also the second post in this thread.

 

Yea, I got that, thank you!!

 

I am just curious on why he thinks the other way is faster and it'snot finding like it's finding the exact which i don't need in the first place,lol

 

How old are you? 12yo?

 

SELECT * FROM  `table` WHERE  `row` LIKE  '%Silvin%' OR `row` LIKE  '%wts%'

 

and

 

SELECT * FROM  `table` WHERE  MATCH `row` AGAINST( 'Silvin wts')

 

Will produce the same result....except MATCH doesnt have to scan the database to find a like and it IS faster

 

BOOYA!

 

[I Want to search more in LIKE CLAUSE..]

?? I'm not looking for the exact find anyway, your are nothing to me (Im talking about your post) when u decide to put in a statement that might be biased, sorry.

 

Your funny! But enough with the comedy man.......Your kidding about which is faster right?

[I Want to search more in LIKE CLAUSE..]

You can also use

 

MATCH `field` AGAINST('{$query}')

 

Which is alot faster than scanning the database with

 

`field` like '%{$query}%'

 

 

who says it's faster? do you have proof? your nothing to me w/o proof

 

HA! nice try - im not writing the script for you.

 

The only proof you need is my experience with large databases

[Image Verification]

Capatcha?

[I Want to search more in LIKE CLAUSE..]

You can also use

 

MATCH `field` AGAINST('{$query}')

 

Which is alot faster than scanning the database with

 

`field` like '%{$query}%'