[PHP-DB] Re: MySQL Query Acting Up

2002-06-20 Thread Seth Yount
in your SET title=\"$title\", statement you forgot the second backslash before the double quote. I would start there. Martin Clifford wrote: > Howdy all, > > If someone call tell me why this MySQL query is not working, I'd be VERY thankful. >I don't see a damn thing wrong with it, but

[PHP-DB] Finding numbers in a string

2002-06-21 Thread Seth Yount
Forgot my email on that last one ;) Hello all - I am trying to seperate numberic characters from a string. The book I was looking at described something like this: if(ereg("[[:alnum]]+", $textandnumbers, $numbers)) { print("$numbers"); } When I run my script I receive this error: W

[PHP-DB] Re: password()... is it possible?

2002-06-22 Thread Seth Yount
I am not sure of the decrypting procedure for password(), but if your admin needs to view the passwords for the purpose of changing or notifying forgotten passwords to the custormer you could use this approach: Generate a random password (numbers and letters) that is emailed to

[PHP-DB] Re: force no results

2002-06-24 Thread Seth Yount
Have you tried using and ' NOT IN ' statement in your WHERE clause? There are many comparison operators that you might find useful. They are covered in 6.3.1.2 of the MySQL Manual, you may also follow this link : http://www.mysql.com/doc/C/o/Comparison_Operators.html. If you can't solve this

[PHP-DB] Re: never seen this before..

2002-06-24 Thread Seth Yount
I believe your assumption is correct. VARCHAR is not the best datatype suitable for indexing. I understand why you want to utilize this type, so that you are not storing empty characters. I am assuming that the id column is numerical in nature. In that case, make the data type INT. This wa

[PHP-DB] Re: what the heck? (elementary question)

2002-06-24 Thread Seth Yount
in you print statement you have ?lastname=%s, shouldn't that be '$s' denoting a variable being passed? Try that out. gl -- Seth Matthew Crouch wrote: > this bit from my index page is giving me 2 headaches: > 1. it isn't passing anything into the URL > 2. the page that gets called ("name.php")

[PHP-DB] Re: brand new elementary question

2002-06-24 Thread Seth Yount
initially I would look at your button type in the source code. Their are two basic types of buttons, the ' submit ' and the ' clear form '. If that doesn't work, post back gl -- Seth Matthew Crouch wrote: > got my other one sorted out; thanks everyone. > now: > how do i get it so when you hi

[PHP-DB] Re: PHP in Database Fields..

2002-06-24 Thread Seth Yount
do you have an example of your text. I came across a situation earlier where I had to build part of my SQL statement. This statement depended on variables that were generated from PHP. If you can give me an example of your code, I may be able to help gl -- Seth Matthew Tedder wrote: > Ques

[PHP-DB] converting a string to a date

2002-06-26 Thread Seth Yount
I am trying to find an example of converting a string to a date format suitable for MySQL input. for example... ' 2002 March 15 ' needs to be converted to ' 02-03-15 ' I can reverse this process fine, but am having trouble doing it this way -- Seth -- PHP Database Mailing List (http://www.p

[PHP-DB] Re: converting a string to a date

2002-06-26 Thread Seth Yount
My fault... wasn't looking hard enough i guess, thats what 2 a.m. will do to you I guess. here is how to do it, for anyone who finds themselves in a similar situation: $result = date( "y m d", strtotime("$aDay $aMonth $aYear")); echo $result; Seth Yount