[PHP-DB] mySQL searching through serialized arrays

2004-09-06 Thread rolando g
I am storing array of user IDs as TEXT using the serialize() function on the array, since several users, one or none can be part of each record... and I noticed that the serialized array has the values in double quotes like :"21"; for example... so since I know that the values will be enclosed,

Re: [PHP-DB] functions via event handlers

2004-09-06 Thread zareef ahmed
Hi, A small example function call_me() { window.location="script.php"; } click me If you are thinking about some live experience like javascirpt with PHP you can go for flash and php. In Flash Event calls php scripts and get the value without reloading the flash movie. Zareef Ahmed -

Re: [PHP-DB] functions via event handlers

2004-09-06 Thread Joseph Crawford
the closest you could come is to make javascript functions call php pages basically redirects that would call the php functions. -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/

Re: [PHP-DB] functions via event handlers

2004-09-06 Thread Philip Thompson
Yemi, On Sep 6, 2004, at 7:14 AM, Yemi Obembe wrote: i'd just luv to ask if it is possibble to call a function in PHP by using event handlers (like onmouseover, onload) as done in javascript? if its possible, i'd appreciate someone to tutor me on it. As far as I know, this is not possible. Since

Re: [PHP-DB] php Form Validation help

2004-09-06 Thread Peter Ellis
See below for point-by-point. ... > > > > $state = $_POST['state']; > > if ($state = 0) { = is an assignment operator. This will always test true, because $state is set to 0 every time this is called. You want ==, which is a comparison operator. > print 'Please select your St

[PHP-DB] php Form Validation help

2004-09-06 Thread Vincent Jordan
have a form that I would like to validate before it is submitted to the DB. I am having trouble with a couple of sections. I have a select box with a listing of all the states, the first option is "Choose One" with a value of "0". Would this be the correct way to "validate" this field?

Re: [PHP-DB] Another newbie question

2004-09-06 Thread Pete Holsberg
> --- Pete Holsberg <[EMAIL PROTECTED]> wrote: > > > On Mon, 6 Sep 2004 > > [EMAIL PROTECTED] wrote: > > > > > you should copy/paste that into a command-line > > msyql > > > session and see if that works. > > > > > > I cut the query back to > > > > SELECT * FROM Directory WHERE `LastName` LIKE

Re: [PHP-DB] Another newbie question

2004-09-06 Thread Stuart Felenstein
I think you need to put '' around joe 'joe' Stuart --- Pete Holsberg <[EMAIL PROTECTED]> wrote: > On Mon, 6 Sep 2004 > [EMAIL PROTECTED] wrote: > > > you should copy/paste that into a command-line > msyql > > session and see if that works. > > > I cut the query back to > > SELECT * FROM Direc

Re: [PHP-DB] Another newbie question

2004-09-06 Thread Pete Holsberg
On Mon, 6 Sep 2004 [EMAIL PROTECTED] wrote: > you should copy/paste that into a command-line msyql > session and see if that works. I cut the query back to SELECT * FROM Directory WHERE `LastName` LIKE Joe ORDER BY Street, HouseNum, LastName and ran it manually. I got --- SQL-query : SELE

[PHP-DB] Another newbie question

2004-09-06 Thread Pete Holsberg
The following code results in the error message "Couldn't execute query." --- Search Results http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Reload page on after sending data to mysql database

2004-09-06 Thread Javier Carlos Viegas
Hi, i´ve got a flash form that send inserted data to a page called insert.php and after sending data to the mysql database the page reloads the flash form for a new entry, but it reloads it on a new page i want to reloadit on the same page that i ´ve enter the previous entry. I´m posting the releva

Re: [PHP-DB] Re: Newbie Questions

2004-09-06 Thread anirudh dutt
> > Well, I have this: > > > > $result=mysql_query('SELECT * FROM $table ORDER BY lastname, street, housenum > > ASC'); > > if u're trying to use variables like $table in the query (which i think u are), they need to be in double quotes : "" not single quotes. so the line should be: $result=

Re: [PHP-DB] Re: Name searches for the spelling impaired

2004-09-06 Thread Pete Holsberg
On Mon, 6 Sep 2004, Zareef Ahmed wrote: > HI , > > Following php functions may be usefull > > http://www.php.net/soundex > http://www.php.net/similar_text > > > Just try to make good algoritham ;) > > Zareef Ahmed Thanks! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] Re: Name searches for the spelling impaired

2004-09-06 Thread Pete Holsberg
On Mon, 6 Sep 2004, David Robley wrote: > On Mon, 6 Sep 2004 11:09, Pete Holsberg wrote: > > > Is there a way to program MySQL so that it can find the > > name "Smyth" if the user looks for "Smith"? And similar > > mispellings that are similar in sound. > > The SOUNDEX string function in mysql m

[PHP-DB] functions via event handlers

2004-09-06 Thread Yemi Obembe
i'd just luv to ask if it is possibble to call a function in PHP by using event handlers (like onmouseover, onload) as done in javascript? if its possible, i'd appreciate someone to tutor me on it. - A passion till tomorrow, www.opeyemi.tk

Re: [PHP-DB] how to show this querry

2004-09-06 Thread peppe
Hi Balwant your answer helpd me only I have a problem showing the projects starting 06-05-2004 and ending 09-09-2005 I need to show also those projects beacuse of end date is 2005 "Balwantsingh" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > try this > SELECT start_date, end_date, p

RE: [PHP-DB] how to show this querry

2004-09-06 Thread balwantsingh
try this SELECT start_date, end_date, project_title from tablename where month(start_date)=09 and year(start_date)=04 this will show only the data pertaining to 09 month and 04 year. hope this will resolve your problem. with best wishes balwant -Original Message- From: peppe [mailto:[EM

[PHP-DB] how to show this querry

2004-09-06 Thread peppe
Hi , I have a problem with showing a query I have a table project with start date end date and project title I want to show only the projects that they are given in table for that month, for example project that starts 06-09-04 and ends 09-09-04 or ends 12-02-05 but nt the projects that starts 06-

[PHP-DB] Re: Name searches for the spelling impaired

2004-09-06 Thread Zareef Ahmed
HI , Following php functions may be usefull http://www.php.net/soundex http://www.php.net/similar_text Just try to make good algoritham ;) Zareef Ahmed "Pete Holsberg" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Is there a way to program MySQL so that it can find the > n