doing SELECTS and keeping the array intact with php

Hi all, this has been bugging me for some time now. I want to do a mysql select then using php while ($a_row = mysql_fetch_array($result)) { do something to get a small portion of the data } and that works fine. Then later I need to access $result as a complete array again. Is there a way I can k

filter input

Hi all, I want to insert some text into my database, but I'm worried about bad data - metacharacters etc. So I need to filter the input and remove bad characters. Which characters should I remove? What is bad for mysql? does anyone know a good subroutine (or webpage telling me all about it) for

Re: select statements

such phrases seem pretty useless! Thanks for your time Jules - Original Message ----- From: "Jed Verity" <[EMAIL PROTECTED]> To: "julian haffegee" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, September 06, 2002 3:42 AM Subject: Re: select stat

select statements

Hi all, I have a database of names and email addresses, that I want to email. $result = mysql_query("SELECT emailAddress FROM subscribers_html WHERE mailingGroup='$toText'"); The select statement needs to return a row when mailingGroup='$toText', but $toText is an array. How should I write thi

order by date

This must be a regularly appearing problem, which is why i'm surprised I can't find a webpage on it.. I have $result = mysql_query("SELECT title, url, description, author, date_format(date,'%D %M %Y') AS date FROM documents_tbl, url_tbl WHERE documents_tbl.title_id = url_tbl.url_id ORDER BY d

pattern matching (in text field)

Hi all, I currently have $result = mysql_query ("SELECT title_id, title FROM documents_tbl, url_tbl WHERE (documents_tbl.title_id = url_tbl.url_id) AND keywords LIKE '%$temp%' AND title_id != '$myrow[title_id]'"); this works to an extent, but 'keywords' is a text field and if $temp is for exam

Re: site search

Thanks Kim and Georg, but I want to do this myself! Ok it may be hard, but i'm confident I have taught myself an awful lot by having a 'difficult' project on the go so, bearing that in mind, can I re-ask my question! thanks again incidently I am making a SITE search, not a web search engin

site search

Hi everyone, I want to build a MySQL site search. Can anyone help with my 'overview' I have written a perl programme to open each html file, cut out all the tags and create a hash of hashes each word is a key, then the secondary key is the filename, then the value is the number of occurances in

where

Hi, I have recently gained access to mysql (new isp), and am converting my old text databases to sql ones. I had a text database with a field 'keywords'. I have entered them as one field, What I want to do is submit a query where I can ask if this field CONTAINS rather than equals a string. Can y

Re: date_format

Thanks this works the difference was the 'AS datefield' what is this bit doing? I searched for AS (in the SELECT description in my book) but it does not mention it; though I have seen it in examples. I like to understand why I use the code I do... I looked at http://www.mysql.com/ but can fi

date_format

Hello, i'm new to mysql, so please bear with me... My database has a field called datafield as datetime. I want to display just the date #1 this works but gives the full datetime $result = mysql_query ("SELECT title, description, url, author, datefield FROM documents"); #2 All I have read on