Posted by J.O. Aho on 05/30/06 17:17

Frankly wrote:
> "J.O. Aho" <user@example.net> wrote in message
> news:4e0mcpF1cj02jU1@individual.net...
>>
>>> i could also be mistaken about the -1 thing. I have read so much lately
>>> it will be much better now that I am only going to focus on php and
>>> mysql. I will see you soon with my best ( for now ) shot at database
>>> design. I hope for your monitors sake you were not drinking coffee :).
>> Not sure we are talking about the same thing, but in if-statments you get
>> the following results
>>
>> if(0) = false
>> if(1) = true
>> if(2) = true
>> if(-1) = true
>
> I guess someplace they used the -1 in the example. I cant wait to start
> doing statments.
>
>
>
>> Perl is another language, which been quite popular before PHP and still
>> quite widely used, the dbd-mysql is a module that allows Perl to
>> communicate with mysql in the same way as php can communicate with mysql.
>> This isn't needed for php and the version has nothing to do with the
>> version of mysql.
>>
>> On my server the 3.0002 is installed and on my workstation I have 2.9007,
>> as they use different CPUs (server is powerpc and workstation is x86) they
>> will have different versions of programs installed as one may be marked as
>> stable on powerpc and be unstable on x86 or the other way around.
>>
>> A good web hotel who offers mysql should run 4.1.x, and php 5.x, if using
>> older I think they are out of date. Soon mysql 5.0/5.1 should be stable
>> too, which gives better features. Avoid a hotel who offers mysql 3.x, they
>> are really outdated IMHO and see to that the php is at least version
>> 4.1.x.
>>
>>
>> I hope this clears some "questions", if anything else, php/mysql/linux,
>> just ask :) Okey, now it's time for me to make some pancakes.
>>
>>
>>
>> //Aho
>
>
> yes, many thoughts of questions :) are now clear. We will get back to linux
> in the near future.
> perhaps i can use my old laptop.
> I did try to find these answers but couldnt in a way that I can understand.
> I wont be inserting pictures in the database but links or statements to
> pictures.. would that data type be varchar?

Short text, up to 255 characters long can be stored in a column that uses
varchar().

There are types for big size text too, think it's text.

If you want to store images in the database, then blob is the type to use.


> I also had a hard time with hyper links - I understand there is no hyperlink
> data type so would that also be varchar?

Yes, as it's really a text, varchar is a good option here too, as long as you
know your links are less than 255 characters (usually is).


> if only PHP can be used to remove the calories from pancakes.

Yeah, just code a load of PHP scripts and you will consume all the calories :P



//Aho

[Back to original message]