[PHP-DB] Performance in MySQL Result Question

Hi, I've got a page with lot's of visitors every day and I sure hope to get more, so I'm already thinking of performance. This is what I've got. Users select one or more things out of a couple drop down menus, no big deal. Their selection is than shown, with a limitation of 20 results on the

[PHP-DB] Listing Tables

Hi, i would like to list all of the tables and field names in my database e.g. table 1 field 1 field 2 field 3 table 2 field 1 field 2 field 3 table 3 field 1 field 2 field 3 etc is there a simple way to do this? thanks for your help -- PHP Database Mailing List

[PHP-DB] Re: Listing Tables

http://us2.php.net/manual/en/function.mysql-list-tables.php http://us2.php.net/manual/en/function.mysql-list-fields.php you should really check the manuals before posting... they are built right in... Joel Shaun [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi, i would like to

[PHP-DB] PHP / Sendmail question

Hi there everyone, When using PHP to send using sendmail, what is the option name so that failed mails bounce back to the email account of the domain SENDING it? Currently failed mails return to [EMAIL PROTECTED] and that screws the server up - bearing in mind I have multiple domains and just

RE: [PHP-DB] Performance in MySQL Result Question

[snip] Now comes my question, what is better speaking of performance: When users go on to the next page, is it better to provide the select statement again with a different integer for the limit? Or is better to do a full select without a limitation on first page. But than I don't know how

RE: [PHP-DB] Insert Date

I'm having problem inserting the date into my mysql database. What type of field should my date field be? How do I insert that into a database, the current date for example? INSERT INTO tblDate (fldDate) VALUES ( . Date() . ); You should use a DATE column, maybe?? Or a timestamp, depending

[PHP-DB] Inserting data into MySQL

Good Day All! I have been working a php/mysql and I have ran into a small problem. I have written an html form for inserting data, and it will not insert it. I am able to query the data from the data. I here is some of the code, maybe some one could point out the error.

Re: [PHP-DB] Inserting data into MySQL

yes, or you need to use the 'INSERT INTO ([field1, field2...]) values (['val1', 'val2'...]) syntax. check the mysql insert syntax. http://www.mysql.com/doc/en/INSERT.html - john On Sat, Mar 15, 2003 at 06:37:54PM -0500, Louie Henry [EMAIL PROTECTED] wrote: Good Day All! I have been working a

Re: [PHP-DB] Real Killer App!

Well, I've gotten a long way on this, and here's the results up to now: On Red Hat 8.0 appache 2.0.40, php 4.22, mysql 3.23.54a PII 366 30gig hdd, 256meg mem: Everything works flawlessly. Have spidered several HUGE sites. Goes fast, goes accurate. On windows 2000 sp3, apache 2.0.44, php 4.3.1,

[PHP-DB] use a leech filedownloader

Hi all, I'm about to make a backup php program that takes a backup with tar, read's the output, send it with som headers so it's supposed to dowload, and then it deletes the file, but it just doesent work with files that is about 50MB, i hope one of you specialist's can help me JUST SO YOU

Re: [PHP-DB] Real Killer App!

I would compare the php.ini settings on the 2 systems. phpinfo() will be able to give you the current stat of the variables PHP is using. There could be something strange on the Windows system that you'll notice as different on the Linux box's phpinfo() (hopefully). -VolVE - Original

[PHP-DB] group by get last record

Hello, Guys i try to join to tables slides: id userid file moment users id username As there few slids per user and i want to get only last one, i use following sql query, but it fetches me first slide. How can i make it fetch last one please? SELECT slides.file, slides.moment, users.id,