rempires

is it possible to search for a word in a text field? what i want to do is have a text field filled with discriptve words ex: fantasy, science, non-fiction, fiction and then a user could search a word and if he typed in say fantasy it would load all the data from that row in the database somthing like SELECT * FROM events WHERE thisTextField contains "keyword"

put the time stamp into your mysql table, when they log in update the time. You can then use that time to check and see if he is still logged in. Whenever he visits a new page update the time in the db with the new time. If that time stamp has not been updated for 5min safe to say he's offline usually and if not when he visits a new page it will update that time stamp and put him back online.

Thanks everyone, those fixes did it. Know i just gotta figure out how to append the URL of a header("location /blah.php"); as i noticed php doesn't auto-append these . i'll probably just make a function that checks if a cookie was set, if so then don't append it. special thanks for revraz and PFMaBiSmAd for your quick and helpful responses, i owe you guys john

session Session Support enabled Registered save handlers files user sqlite Registered serializer handlers php php_binary Directive Local Value Master Value session.auto_start Off Off session.bug_compat_42 On On session.bug_compat_warn On On session.cache_expire 180 180 session.cache_limiter nocache nocache session.cookie_domain no value no value session.cookie_httponly Off Off session.cookie_lifetime 0 0 session.cookie_path / / session.cookie_secure Off Off session.entropy_file no value no value session.entropy_length 0 0 session.gc_divisor 100 100 session.gc_maxlifetime 1440 1440 session.gc_probability 1 1 session.hash_bits_per_character 4 4 session.hash_function 0 0 session.name PHPSESSID PHPSESSID session.referer_check no value no value session.save_handler files files session.save_path no value no value session.serialize_handler php php session.use_cookies On On session.use_only_cookies Off Off session.use_trans_sid 1 1 that's the session information from the phpinfo readout i set trans_sid to 1 and use_only_cookies to 0 but it still won't maintain sessions without cookies can anyone else see anything wrong with this? thanks john

i'm trying to maintain session state even when the user has cookies turned off. infact if you disable cookies in this very forum you can still log on and do everything. i only sue relative URL's so no problem there but as for session.use_cookies = of, wouldn't that turn off coookes no matter what? i would prefer session state to use cookies and only resort to cookiless session if the user won't allow cookies actually i am hosted on a shared server, but the administrator told me that if i put a file called php.inin in each and every directory i want the settings applied, that file will override the master php.ini defaults. I guess he had a lot of people asking for different things or something.

how do you make cookie less session, i thought it could be done by setting this in the php.ini session.use_trans_sid = 1 but apparently it still doesn't work without cookies, is there anything else i have to do?

hmm i wasn't sure if i was supposed to post this here or under mysql help, but here seemed more appropriate I need some help figuring out a design for my database. I have a site were people can make a schedule based of events/locations we have on our site. They choose date (02-06-08), a time like 2pm-6pm, then a place, like This Hotel. From there it builds a schedule (obviously, they add more than one place/time, in fact usually it will span over a week or more time frame). They can then save this schedule so that they can access it from there accounts at any time, my problem is trying to figure out the database layout to use, I've thought out all the javascript/php but the layout for the database is stumping me. i have a table called schedules, and so far it have "scheduleId, scheduleName, allowOtehrsToView, keyWords"<-the keywords,allowOtehrsToView is there only because other users may search for peoples schedule IF that user allows it, this way people can look at others and get an idea of what's "hot". Now I'm trying to figure out were to go form here. All the places/events they can choose are stored in 2 more tables called events and locations. When they view their schedules it will obviously have to load all this data so i was thinking maybe a textField like 02-06-08:2pm-6pm:E1 <- and then using php to split all that apart and saying okay on 02-06-08 at 2-6pm they will be (then select from the events table the event with id 1). this would work but it doesn't seem very efficent on php side, or easy to maintain. My other idea was to split schedules into 2 tables 1 would contain schedule table "scheduleId, scheduleName, allowOtehrsToView, keyWords" and the 2nd one would maintain something like schedule 2 table "Id, scheduleMasterId, timeStart, timeEnd,Date,eventOrLocation, EventLocationId". this would work by first loading the schedule table and getting the sceduleID based on the name when they click on their schedule. Know we would load from schedule2 table all of the data were scheduleMasterId=the sceduleID from the first schedule table. We could then use all that data to get the data from events/locations table. I think the second one would be easier to maintain,work with. But less efficient on the mysql side? any ideas on a better way, any opinions on improvements my way or anything at all would be appriceiated

$loanid = mysql_num_rows($loid) + 1; $lid = "KF402".$loanid; the "." combines the 2

because the mail function in php opens and closes the socket each time it sends a piece of mail apparently, which is really inefficient. so php recommends pear for sending mass email...

Hi, i'm working on a script for a after-school project/competition, well actually a site, but one of the scripts has to send mass emails. Looking at the mail option in php tells me that's not adequate to handle a few hundred email, so i looked up pear, but i'm slightly confused about it. Also we can't use any scripts we didn't create and i don't know if pear would fall under this (although i guess i could argue if php doesn't fall under it then pear shouldn't either ) Could somone please explain pear to me and maybe an example of how it works, as when looking on there website i got kinda confused, or if somone could give me a link they know to another pear tutorial that would be awesome. Are there any other programs out there i could use instead of pear or any other way i could do it? a little background, all the email addresses are stored in a database, pulled out and then need to be sent, the ems sage is an HTML email message that just displays updates about the site, it gets sent to ALL registered suers (that's the site requirements not mine, personally i like giving users options...) by the way, i'm not breaking the rules asking for help, it's a project were we are given about 3months (about 18days left) were your encouraged to learn on your own by finding help, they just don't want others to do the entire website for you, so they banned scripts that aren't yours. thank,s jhon

thanks everyone, that was exactly what i was looking for! john

mysql returns an error when MAX() function is used in the WHERE statement hmm I'm not quite sure if everyone is understanding what I'm asking either so i'll try to re-explain it lets say i have a table that looks like eventName addedToScheduleCurr event1 10 event2 9 event3 28 event4 15 event5 19 i need an sql statement that will pull out "event3" becuase of the fast that it has the highest value in the addedToScheduleCurr column eventName addedToScheduleCurr event1 15 event2 7 event3 9 event4 35 event5 42 in the above example it would pull out event5 because it has the highest addedToSceduleCurr column i'm starting to think this might have to be 2 separate quires...

that returns all the events with different names, and if i group by addedToScheduleCurrthen it returns all of the addedToScheduleCurr with different number. I'm attempting to only retrieve the highest addedToScheduleCurr event name and avoid using 2 sql statementS such as SELECT MAX(addedToScheduleCurr) FROM events and then SELECT eventname, FROM events WHERE addedToScheduleCurr = '$resultFromPreviousSQlStatement'

hmm, okay so i have a query and i want to select the eventName based on the biggest number, but MAX apparently can't be used in the WHERE clause, any help, here is what i attempted SELECT `eventName` FROM events WHERE `addedToScheduleCurr` = MAX(`addedToScheduleCurr`) any idea on how else i could do this thanks, john p.s. phpMyAdmin error says #1111 - Invalid use of group function

thanks you very much, sorry for the delay in response i was outa town for a little bit, that did it...