[PHP-DB] Re: Building A Web Site Search Engine Using PHP / mySQL

2004-09-07 Thread Per Lundkvist
Or: http://www.aspseek.org/ Per "Ron Piggott" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I wanted to also ask about how you would build a web site search engine with > php and mySQL. > > I had thought of setting up a table with a few columns --- > > one for the URL of the spec

Re: [PHP-DB] Building A Web Site Search Engine Using PHP / mySQL

2004-09-07 Thread zareef ahmed
Hi, http://www.zend.com/php5/casestudies/php5-orase.php You may have some lead. zareef ahmed --- Ron Piggott <[EMAIL PROTECTED]> wrote: > I wanted to also ask about how you would build a web > site search engine with > php and mySQL. > > I had thought of setting up a table with a few > colu

Re: [PHP-DB] error on count()

2004-09-07 Thread zareef ahmed
> > 1. I tired to get the array like this: > > $una = $check["uname"]; > > function orderquantity ($una) { > > $pss = mysql_query("SELECT OID FROM orders WHERE > una = '".trim($una)."'") or die (mysql_error("Query > error on Order search")); > > while($pisao=mysql_fetch_array($pss)) { > > re

Re: [PHP-DB] Building A Web Site Search Engine Using PHP / mySQL

2004-09-07 Thread Peter Ellis
Well, this is from the "why reinvent the wheel" department -- have you looked at htdig://? http://www.htdig.org/ Might save you some work. Just a thought :) More constructive replies regarding actual code are forthcoming, I'm sure. -- Peter Ellis - [EMAIL PROTECTED] Web Design and Development

[PHP-DB] Building A Web Site Search Engine Using PHP / mySQL

2004-09-07 Thread Ron Piggott
I wanted to also ask about how you would build a web site search engine with php and mySQL. I had thought of setting up a table with a few columns --- one for the URL of the specific page (This could become a link when a match is found for that page) second with the page title --- used in display

Re: [PHP-DB] Re: Another newbie question -- ANSWERED!!

2004-09-07 Thread randy
On Tue, 7 Sep 2004 13:16:20 -0400 (EDT), Pete Holsberg <[EMAIL PROTECTED]> wrote: > With a Unix shell programming background, I'm puzzled by > the use of 'tics' (single quotes, apostrophes' around > %$search_string%. I would have though that they would have > removed the special meaning of the $.

Re: [PHP-DB] Re: Another newbie question -- ANSWERED!!

2004-09-07 Thread John Holmes
From: "Pete Holsberg" <[EMAIL PROTECTED]> $sql = "SELECT * FROM $table "; $sql .= "WHERE `LastName` LIKE` '%$search_string%' "; $sql .= "OR `FirstName` LIKE '%$search_string%' "; $sql .= "OR `Spouse` LIKE '%$search_string%' "; $sql .= "OR `Street` LIKE '%$search_string%' "; $sql .= "OR `Email` LIKE

Re: [PHP-DB] Re: Another newbie question -- ANSWERED!!

2004-09-07 Thread Greg Donald
On Tue, 2004-09-07 at 12:16, Pete Holsberg wrote: > Also, should I have back tics around a column name > EVERYWHERE it's used in a SELECT (in this case, following > ORDER)? Only if you plan to use keywords as field names, otherwise it's pointless. -- Greg Donald -- PHP Database Mailing List (

[PHP-DB] Re: Another newbie question -- ANSWERED!!

2004-09-07 Thread Pete Holsberg
On Mon, 6 Sep 2004, Pete Holsberg wrote: > The following code results in the error message "Couldn't > execute query." > $sql = "SELECT * FROM $table "; > $sql .= "WHERE `LastName` LIKE $search_string "; > $sql .= "OR `FirstName` LIKE $search_string "; > $sql .= "OR `Spouse` LIKE $search_string "

Re: [PHP-DB] Another newbie question

2004-09-07 Thread Wolfgang Ebneter
charset="iso-8859-15" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Am Montag, 6. September 2004 23:50 schrieb Pete Holsberg: [...] > $sql =3D "SELECT * FROM $table "; > $sql .=3D "WHERE `LastName` LIKE $search_string "; > $sql .=3D "OR `FirstName` LIKE $search_s

Re: [PHP-DB] error on count()

2004-09-07 Thread Peter Ellis
You need to pass the functions a variable to work with because you've specified parameters. Try: $okuan = orderquantity($una); Ditto for the other function call. -- Peter Ellis - [EMAIL PROTECTED] Web Design and Development Consultant naturalaxis | http://www.naturalaxis.com/ On Tue, 2004-09-0

Re: [PHP-DB] functions via event handlers

2004-09-07 Thread Neil Smith [MVP, Digital media]
Or you could use XMLHTTP on the browser side (supported by IE and Mozilla variants) You'd send a GET request to the page, it would return - often - an XML record set, or you can return text, and indeed you can even query page status codes from the client side. The point is, you no longer need

[PHP-DB] mysqli and prepare

2004-09-07 Thread Joerg Forg
Hi @ all, i´ve some questions about the new mysqli. I build my own dbmanagement for mysqli and now i´ve a problem with dynamic bind for params. bind_param only alows to set primitive datatypes and i don´t have any idea to make it dynamic like: function bind_MyParams($array_myParams) like pear::db

[PHP-DB] Re: php Form Validation help

2004-09-07 Thread Neil Smith [MVP, Digital media]
At 11:09 07/09/2004 +, you wrote: From: "Vincent Jordan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Date: Mon, 6 Sep 2004 19:20:16 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_NextPart_000_0004_01C49446.8C688C60" Subject: php Form Validation help have a

[PHP-DB] error on count()

2004-09-07 Thread Sancerni Veronica
hello, this is problably newbie question, but I can not understand why my count() function doesn't work. I need to count how many items has a determinated customer ordered ever. 1. I tired to get the array like this: $una = $check["uname"]; function orderquantity ($una) { $pss = mysql_query(

[PHP-DB] Re: Antwort: [PHP-DB] php and oracle

2004-09-07 Thread D.Wilkening
This sounds interesting! We'll try this. Thanks and greetings from Essen :), Dieter -- Dieter Wilkening Software-Entwickler Baumann Technologie GmbH [EMAIL PROTECTED] [EMAIL PROTECTED] sagte: > > I tried to compile PHP 4.3.8 with OCI and oracle_LIB 32bit somewhere in > $ORACLE_HOME/../lib32 >

[PHP-DB] Fetch Array, Display and Update, all in one ?

2004-09-07 Thread GamCo - Gawie J Marais
Hi All, I have designed a debit-system database with a PHP frontend. The amounts need to be updated on a monthly basis. now i have 10 clients in the system. i can get all the fields and display them, but next to that, i need to insert a field where we can enter an amount per client and after all t

[PHP-DB] php and oracle

2004-09-07 Thread D.Wilkening
Hi everyone, i've a problem using php with oracle 10g. (php 5.0.1 compiled against Oracle 10.1.0.2-libs, apache2 and apache1) One or two days, everything looks good. Then, by pressing (once a second) reload in your browser, you sometimes get an ERROR #: 2 ERROR DESC: oci_execute() [function.oci-ex