GoneNowBye

\n and \r both represent a linebreak. a linebreak (or carrage return) in HTML is <br />

limit y,x is a different (and thus alternate) syntax to limit x..... the OP now knows both versions of it... okay?

Yes set youre primary key to "varchar6" and uncheck autoincrement? or create another index with "key" as the field name and index that against ID (For efficency)

First of all break the input into chunks. $data explode(" ",$string); will work $data[0] now = 'john' $data[1] now = 'smith' Now. Select * from database table where lname like '%$data[1]%' and fname like '%$data[0]%' The % mean anything so something% means any record where the field starts with something. good luck

I was just noting the alternate syntax incase he ever needed it. or did why i did and not research and just make PHP (or whatever) ignore the first ten and limit 30.

he means select * from table where x=y group by whatever LIMIT 20 this will limit it to 20 reconds if you want to limit it to 20 records after the first 10 LIMIT 10,20

sure i'll do one later. i'll post a graph.

If its not faster for small amounts of data, you dont have it indexed correctly the only time that reading a file will be faster really is when you are reading it per line, and not sorting in anway; I've used both and do use both, XML is better as a ... bridge, an API between two systems, MySQL is faster in every instance.

Do you follow my sollution?

You're in luck <?php class XMLParser{ var $parser; var $filePath; var $document; var $currTag; var $tagStack; var $data; var $state; function XMLParser($path,$state) { $this->parser = xml_parser_create(); $this->filePath = $path; $this->document = array(); $this->currTag =& $this->document; $this->tagStack = array(); $this->state = $state; } function parse(){ xml_set_object($this->parser, $this); xml_set_character_data_handler($this->parser, 'dataHandler'); xml_set_element_handler($this->parser, 'startHandler', 'endHandler'); if($this->state == 0) { if(!($fp = fopen($this->filePath, "r"))) { die("Cannot open XML data file: $this->filePath"); return false; } while($data = fread($fp, 40960)) { if(!xml_parse($this->parser, $data, feof($fp))) { die(sprintf("XML error: %s at line %d", xml_error_string(xml_get_error_code($this->parser)), xml_get_current_line_number($this->parser))); } $this->data = $this->data.$data; fclose($fp); } } else { $data = $this->filePath; if(!xml_parse($this->parser, $data, false)) { die(sprintf("XML error: %s at line %d", xml_error_string(xml_get_error_code($this->parser)), xml_get_current_line_number($this->parser))); } } xml_parser_free($this->parser); return true; } function startHandler($parser, $name, $attribs) { if(!isset($this->currTag[$name])) $this->currTag[$name] = array(); $newTag = array(); if(!empty($attribs)) $newTag['attr'] = $attribs; array_push($this->currTag[$name], $newTag); $t =& $this->currTag[$name]; $this->currTag =& $t[count($t)-1]; array_push($this->tagStack, $name); } function dataHandler($parser, $data){ $data = trim($data); if(!empty($data)) { if(isset($this->currTag['data'])) $this->currTag['data'] .= $data; else $this->currTag['data'] = $data; } } function endHandler($parser, $name) { $this->currTag =& $this->document; array_pop($this->tagStack); for($i = 0; $i < count($this->tagStack); $i++) { $t =& $this->currTag[$this->tagStack[$i]]; $this->currTag =& $t[count($t)-1]; } } } ?> Enjoy, heres how to use. <?php $result1 = $xml_class_name->document['OPENINGTAG'][0]['ROW'][$x]['attr']['ATTRIBUTE']; //or data $result2 = $xml_class_name->document['OPENINGTAG'][0]['ROW'][$x]['data']; ?> <openingtag> <row attribute="12">Some data</row> <row attribute="13">Some more</row> </openingtag> Result1 = 12 assuming x is 0 Result2 = Some data assuming x is 0 Result1 = 13 assuming x is 1 Result2 = Some more assuming x is 1 Result1 & 2 = null assuming x is greater then 1 [EDIT] However MySQL is a hell of alot quicker.

key is reserevered, but that always gets me. Here's what i do query failed; copy and paste it into the mysql gui tools if a keyword exists it goes blue you use ` quotes around fields normally, by default SQL looks for these however the ability to do it without quotes is a feture. so key - > `key` the quotes can be found above tab and left of 1 good luck

you wont get that; php is done SERVER SIDE the clients never see it, The only thoing you could do and still use php is: <?php header('refresh: this.page.php; time=5'); ?> HOWEVER YOU MAY NEED TO CHECK THE SYNTAX, i dont use refresh, never needed to, sounds like you want javascript, but i am not sure if it has the power to make everything stop, and that is client side, however clients can just turn it off. the javascript that is.

refresh.php, problem no timelimit is said, and you are refreshing it to the refresh page. most browsers will ignore it 1) because it redirects to the same page 2) because its a loop. solution <?php header('location: mypage.php'); ?> and you can google the refresh one, it does have a timer that goes with it (eg x seconds)

If you want to do this in php you need something like the following: endtime = (timecode of endtime) current_time = time() if (current_time >= endtime) { echo('TIMER EXPIRED'); } else { echo('time remaining: '.(endtime - current_time)); } endtime for 30 seconds from now would be: time() + 30, but if you do this on the page that the timer is calculated it will never expire you need to save it somewhere.

Bugger that was quick.... would of been nicer if more of a PHP nub did it XD. Okay, I'll add to this tonight get some of the theories done (criptogaphy facintes me)

Sorry for my spelling, dislexic power guys sorry. Anyway, challange for you today. hopefully I can help someone This challange here, is a decode chalanage, i will give you some clues. I want you to decode the following, I know what the key is and what i started with. so.... here's the code pEVCDXYUR^YPVU[RCXSRT^G_REC_^DERV[[NREZ~CU__VARYX^SRV@_VC^D_XB[s@E^CR_RERXC_REC_RYPEVCDXQTREZ:=:=DCV[[:=:=DCV[[:=:=DCV[[:=:=tXYPEVCB[VC^XYDXYGVDD^YPC_RT_V[VYPR:=:=VAX\:= ....Yeah thats a message Right now the cipher. The key is one character long. and the method is Xor. Xor takes binary data and does something with it so if we have the following: Data: 0000 Key : 1111 result: 1111 to get it back out: result = data Data: 1111 Key : 1111 result: 0000 where A and B are inputs and c is an output A B C 1 0 1 0 1 0 1 1 0 0 0 0 happy playing if anyone needs any more clues.... btw the key character isnt some uber ellaborate key that knowone has, its on every english type keybord ~Havok

You put the adress in the href tag attribute normally, but that's HTML. erm... also in php if you want to put something out you need the function "echo" so something.....<?php echo('test'); ?>.....something becomes semething.....test....something Helped?