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
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
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
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
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
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")
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
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
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
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
10 matches
Mail list logo