3 questions!

Anon

Hi, I am new to PHP and mysql.
I have 3 questions which i've been asking
on many irc linuxhelp room but got no anwser.

I hope someone can help me

1) How do i delete a row where there's a char NULL. I am assumed the command would be 'delete from guestbook where name=NULL;' but it didn't work.

2) Is it possible to convert a current microsoft access database, or table to mysql?

3) Can I declare an array varible to be use globally? I want to retrieve the list of files on my hard drive, but do not want php to search for it each time a user redo a file search.

thanks for your time!! you help will greatly
be appreicated...

toma42

where name is null

yea, but a pain in the butt. Best to export to a text file and import into mysql.

you may want to serialize the array into shared memory and pull it out from there.

Anon

3) how do i serialize the array?

define it as global ($arrayname)?

OH, i got one more question as I scripting my homepage. Why can't i use apache function within my *.php3 file?

exe would be.....

those functions no longer work when placed in a *.php3 file...

any idea?

Anon

Hi Toan,

PHP provides functions to serialize and unserialize data. You may want to check the PHP website on the usage. Also, it looks like you're trying to mix server side includes and php. I assume you can do this, only if the SSI scripts are outside the <? ?>. I really can't vouch for this cause I've never tried it.

[deleted]

1) DELETE FROM table WHERE field IS NULL;

2) Dump to CSV and use MySQL's LOAD DATA INFILE function.

3) Write the list to a textfile and load it into an array using file('filename');
BTW: the filesystem will cache all thedata, so searching should not take that long .