how come some peoples dont close ther mysql connection after each page?
is mysql_close not necessary?

Read the rest of this entry »

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
i keep gettign that and i checked the data fields 19,000 times and its correct, anything else it can be?

Read the rest of this entry »

how would i insert the password into the db using md5?

portal, you convert it to md5 hash then insert into db :-
upon initial registration

ah
www.php.net/md5
yeah i was reading that
Read the rest of this entry »

Shouldn't strtotime() be able to return an accurate timestamp with a date with a format of MM-DD-YYYY ?

Read the rest of this entry »

How many characters can i fit into MySQL tinytext, text, mediumtext bigtext or wtf theire called, i dont understand the cha
rt in the mysql manual.

tinytext 255
text = ~64 000
and bigtext is about 4 trillion
Read the rest of this entry »

can anyone teel me if this is correct
$news = @mysql_query('SELECT Noticia FROM noticias WHERE id = 1');
{
echo ($news);
}

it was ment to be one line only
so is it corectr or not?
blackdeat: well if you intend to echo the result handle, then it's correct.
but it does not work as i want it to
blackdeat: That's because you're not doing what you want to do.
lol
help
blackdeat: php.net/mysql_fetch_assoc
im reading one already
but ill look
blackdeat: or mysql.tregt.net/showdata.php
blackdeat: You see, mysql_query returns what we call a result handle. You need to extract the rows you want from it. You
do this with mysql_fetch_array or mysql_fetch_assoc.
i had array before
but it still give me the wrong one
so ill try the assoc one
brrr now nothing comes up
blackdeat: $result=mysql_query("SELELCT Noticia from noticias WHERE id = 1") or die(mysql_error()); $row=mysql_fetch_ass
oc($result); var_dump($row);
SELELCT ?
it's sql 2.0
now it comes up
but with some extre things
lol
rza: Yes, it's the "new and improved"(tm) way of doing things.

rza: also known as "the enterprise way"(tm) or "managements good idea"(tm)
enterprise frameworks bundled with enterprise web 2.0 support
"Ofcourse we tested it… "

E:\www\mysql\bin>mysql
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
that's the mysql client
not the server
christin http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html
thanks nick
let me try to read it
you are lazy
or clueless
or both
or illiterate
here you guys can deal with him/her
pfft
thanks