Re: [PHP-DB] PHP MySQL and updating

2002-02-10 Thread Jason Cox
Jennifer, I am having trouble with updating. How do I tell php to update the database at mid night instead of every time the browser is refreshed? I have looked for it but can't find the info. You would need to have your code check the time and decide whether or not to run the query. I can

[PHP-DB] If Statement that makes me cry

2002-02-10 Thread Todd Williamsen
This script is confusing the hell out of me... What its suppose to do is do a search on documents, and then is it finds something say who and where it is, but it repeats the message for every hit. Same goes with the message when there is no results, it repeats it for every record. All I want it

RE: [PHP-DB] If Statement that makes me cry

2002-02-10 Thread Peter Lovatt
hi A few thoughts Firstly wouldn't it be easier to store the resumes in the database? then 'SELECT * from table where cand_resume_text LIKE %keyword[1]% or cand_resume_text LIKE %keyword[2]% bit inefficient but it works, and opening lots of files is also inefficient. or SELECT * from table

[PHP-DB] RE: Outputing Distinct rows

2002-02-10 Thread Adam Royle
What you *should* do is have a lastUpdated field in your posts table, and the value inserted into their is the date when you update it. Then your query would be like $sql = SELECT posts.topic_id, posts.forum_id, topics.topic_title, topics.topic_replies WHERE topics.topic_id =

[PHP-DB] Magic quotes sybase

2002-02-10 Thread Adi Wibowo
Hi, can I enabled or disabled magic_quotes_sybase at runtime? Or is there any workaround so character (') doesn't treated as (''), because of magic_quotes_sybase ? Thanks, -- Adi Wibowo -- http://dewey.petra.ac.id * Work matter: [EMAIL PROTECTED] * Private matter : [EMAIL PROTECTED]

[PHP-DB] javascipt window

2002-02-10 Thread Mike
I am wondering why the following will not launch a window using javascript. I have tried escaping the Html at various points with no success: echo td ALIGN='CENTER'a href='javascript:launchwin('$row[5].htm','newwindow','height=480,width=640') '.$format./a/td/tr; the href works fine when I am

RE: [PHP-DB] javascipt window

2002-02-10 Thread Beau Lebens
Mike, you have a conflict with your different quote-styles, have a look at the source code when you output that and you will see what i mean, you need to do something like this; echo td ALIGN=\CENTER\a href=\javascript:launchwin('$row[5].htm','newwindow','height=480,width=640'

Re: [PHP-DB] javascipt window

2002-02-10 Thread Mike
Hi, Thanks, that worked fine Mike Beau Lebens [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Mike, you have a conflict with your different quote-styles, have a look at the source code when you output that and you will see what i mean, you need to do something