Re: identifying multi-byte characters / coverting

apply htmlentities to the output. ty abs --- [EMAIL PROTECTED] wrote: > Hi abs, > > My first post seem to be vanished, so excuse me if > this is double. > > I am not sure if I understand youir problem > correctly. Isn' what you > describe as "’" t

identifying multi-byte characters / coverting

oks like it did. are there any situations where this may cause a problem? and is there any way to filter it or convert it to a single-byte char? i'm assuiming it's multibyte, coz i didn't see it in th

check privileges on a db as normal user

x27;s mysql password, how do i actually use it? google searches only explain the situation, not how it's done. coz i know those 3-4 ppl can see my encrypted passwd. (yes, 'mysql' db is viewable to them). ty abs

mysql_escape_string ... when?

# etc. in the url). and if magic_quotes_gpc is on, any and all escape characters are backslashed right? how does when check what the accepted mysql escape characters are? (like -- for a comment) thanks abs Yahoo! Mess

Re: Help with Update statement

wasn't run with an "order by" clause, there could be some in between that haven't been reformatted. those two solutions are pretty much foolproof. since some values have already been converted, i think u've made it a varchar(19) or something, i.e. it's length i

Re: left join-ing for two values

join colours a on a.id = choices.new left join colours b on b.id = choices.old if i put choices.id as just id, i get id is ambiguous (after making all changes to real table and column names) ;-). if 'from' is 

left join-ing for two values

id = new or do i put another left join? either ways, how do i specify which join / equality is which alias or whateva? i don't wanna use two queries...as far as possible. ty abs ps: i wouldn't be going through all this just for colours ;-) also (unrelated to mysql) ;-) i didn't kn

Re: update shouldn't update

--- Abs <[EMAIL PROTECTED]> wrote: > hi > in the php manual, regarding 'mysql_affected_rows()' > it says: > When using UPDATE, MySQL will not update columns > where > the new value is the same as the old value. This > creates the possiblity that mysql_affec

update shouldn't update

. but if i paste any of the queries into phpmyadmin to run, it gives 'Affected rows: 0'. so how come the difference? abs Yahoo! Messenger - Communicate instantly..."Ping" your fri

Re: num rows / pages

ays be scanned entirely so my big set is the number of rows of the table (there's no where clause). so the SHOW TABLE STATUS FROM db LIKE tbl will do. 'Rows' has what i need. just in case anyone else was in a similar situation. abs ___

num rows / pages

were and the 2nd just for a particular bunch with limit. wouldn't that load the mysql db? and what if i've got 10,000 rows or so? the query will take time. any solutions? thanks abs Yahoo! Messenger - Communicate

RE: sending array data using php mail

--- Mike Johnson <[EMAIL PROTECTED]> wrote: > > For the record, there's a syntax error in there -- > the closing curly brace is missing. > > echo "{$row["Password"]}\n"; >^ > > Also, I've never tried this syntax with > double-quotes. Do the curly braces keep the PHP > par

Re: sending array data using php mail

y the html code. and while u're at it, put a \n in $newline so that ur email looks nicer. abs BT Yahoo! Broadband - Save £80 when you order online today. Hurry! Offer ends 21st December 2003. The way the internet was

setting values to default w/ null

LL"; break; (etc.) and replace the null with "DEFAULT" so that when mysql sees the keyword, it sets that column's value to the column's default (and not the column type's default) ty abs

Re: escaping slashes not present in table?

--- Daniel Kasak <[EMAIL PROTECTED]> wrote: > Abs wrote: > > >mysql and php question: > >the magic_quotes_gpc is set to 1. when i echo it to > >the browser, it shows the added slashes. i inserted > >these same values into a database. when i read the > >

escaping slashes not present in table?

en i tried to do a dump/export of the table, the output showed a backslash before the quote. so how come? the slashes should be showing when i say SELECT * FROM MYTABLE. abs Want to chat instantly with your online friends? Ge

binary data fields

dumping back into a table. would this be related to the win32 version? abs Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk -- MySQL General Mailing List For list

splitting tables based on row length

eing considered different from return time. hence, putting t2 and t3 as one table. also, not using the mysql query cache. and would that change how the tables are designed? abs Want to chat instantly with your online friends?

enum for bool in the future

arity (as opposed to empty strings). but i was looking for a better option. checking for isnull, etc. is almost the same problem as the first case, which is easier to read if we had to. thanks abs Want to chat instantly with y