Re: [PHP-DB] mysql EXPLAIN

2001-12-14 Thread Chris Hobbs
http://www.mysql.com/doc/E/X/EXPLAIN.html Sharmad Naik wrote: > How do i get all the info for mysql just the EXPLAIN statement in postgres -- ___ ____ _____ Chris Hobbs / \ \/ / | | |/ ___\| __ \ Head G

Re: [PHP-DB] Mail() Not working

2001-12-12 Thread Chris Hobbs
= "Reply-to: [EMAIL PROTECTED]"; > mail ($email, $to, $subj, $body, $hdr); In response to Kevin's question: >>> I have been unable to get the mail() function to work. >>> >>> my php.ini file has the following line in it: >>> SMTP = mail.attbi.c

Re: [PHP-DB] Multiple paragraphs; The trick?

2001-11-13 Thread Chris Hobbs
uctures. Unfortunately: SQL queries fail miserably in >my brain.. Probably need a mental upgrade here.. > > Hope you can help! > > Thanks, > > Jelle. > > > -- ___ ___

Re: [PHP-DB] Weird Problem In mysql_connect();

2001-08-31 Thread Chris Hobbs
$link = mysql_connect($host,$user,$pass); > } And Jonathan Hilgeman correctly recommended: > function dbConnect () > { > global $host; > global $user; > global $pass; > $link = mysql_connect($host,$user,$pass); > } -- ___

Re: [PHP-DB] Random

2001-08-31 Thread Chris Hobbs
your code looks right. John Hurleston wrote: > $result = mysql_db_query ("$DBName","select * from Contacts order by rand() > LIMIT 5 "); > Doesn't work at all. :( -- Chris Hobbs Silver Valley Unified School District Head geek:

Re: [PHP-DB] Opt-In Request Re: Php-db@lists.php.net

2001-08-31 Thread Chris Hobbs
rued as a commercial message. Bollocks. Spammers are such a waste of skin... -- Chris Hobbs Silver Valley Unified School District Head geek: Technology Services Coordinator webmaster: http://www.silvervalley.k12.ca.us/~chobbs/ postmaster: [EMAIL PROTECTED]

Re: [PHP-DB] CSV TO MYSQL

2001-08-27 Thread Chris Hobbs
; . $ln[29] . '"'; } > $sqlquery .= ');'; > $sqlquery .= "\n"; // new line > > /* debug info (output) */ > if ($debug_output == 'yes') { > echo $sqlquery; > } > >

Re: [PHP-DB] CSV TO MYSQL

2001-08-27 Thread Chris Hobbs
o this point: > INSERT INTO news VALUES (,"[EMAIL PROTECTED]"," [EMAIL PROTECTED]"," > [EMAIL PROTECTED]","[EMAIL PROTECTED]","etc.."); > But that is not what I want. I can attach the script for analysis or if > anyone has a better idea. I

Re: [PHP-DB] listing

2001-08-23 Thread Chris Hobbs
ation from table "companies" (name, telephone...) > > > > > > > > THanks. > > > -- > Su pagarba, > > Andrius Jakutis > InternetMedia > http://www.internetmedia.lt > GSM: 370 82 31332 > > > > > -- Chris Hobbs Silver Valley

Re: [PHP-DB] can you help to beginner?

2001-08-23 Thread Chris Hobbs
ionship. See my e-mail response to > him. > > - Jonathan > > "Chris Hobbs" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > >>I won't add to the code suggestions already given, but I will share one >

Re: [PHP-DB] can you help to beginner?

2001-08-23 Thread Chris Hobbs
data effectively is in two tables. Andrius Jakutis wrote: > Can you help me? I know that for this example its better to use one table, > not two, but I am just learning.. -- Chris Hobbs Silver Valley Unified School District Head geek: Technology Services Coordinato

Re: [PHP-DB] Getting key of row just inserted into mySQL

2001-08-22 Thread Chris Hobbs
mysql_insert_id() Grant Boggs wrote: > What's the best way to get the primary key of a row just inserted into a > mySQL database? -- Chris Hobbs Silver Valley Unified School District Head geek: Technology Services Coordinator webmaster: http://www.silve

Re: [PHP-DB] exit query

2001-08-16 Thread Chris Hobbs
Chris Hobbs wrote: > exit; Except, you'll want to remove that - doh! -- Chris Hobbs Silver Valley Unified School District Head geek: Technology Services Coordinator webmaster: http://www.silvervalley.k12.ca.us/~chobbs/ postmaster: [EMAIL P

Re: [PHP-DB] exit query

2001-08-16 Thread Chris Hobbs
nt it to, > > how can i make it skip the rest of the php within the document (so > displaying no results from the database) > > Cheers in advance > > Marky > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For addi

Re: [PHP-DB] Querying active directory from PHP

2001-08-14 Thread Chris Hobbs
'd be a way for your postmaster to make it a little less brain-dead by not attaching it to mail sent to certain addresses, namely _any_ public mailing list. I feel better Chris Hobbs Silver Valley Unified School District --- The views expressed herein do not necessarily reflect the view

Re: [PHP-DB] Transforming doc files into html

2001-08-04 Thread Chris Hobbs
ly uploaded. I then redirect to that file with: header ("Location: http://www.silvervalley.k12.ca.us/$file.html";); Hope this helps! Cami wrote: > Does anybody know if is any way in which when you upload a word document > file you can parse it and transform > it into an html fi

Re: [PHP-DB] Re: Making a new row in HTML tables

2001-07-25 Thread Chris Hobbs
> $rows = $cols + ceil(($numdata-($cols*$cols))/$cols); Seb suggested a much easier way: $rows = ceil($numdate/$cols); -- Chris Hobbs Silver Valley Unified School District Head geek: Technology Services Coordinator webmaster: http://www.silvervalley.k12.ca.us/~cho

Re: [PHP-DB] Re: Making a new row in HTML tables

2001-07-25 Thread Chris Hobbs
; > > Can anyone help me with this - I have a database of people, that I want > to > > > print into an HTML table - how can I make the table wrap into an equal > > > number of rows. > > > i.e. if there are 4 entries, a 2x2 table, 6 a 2x3, 8 a 2x4, 9 a 3x3, >

Re: [PHP-DB] Dynamic Links

2001-07-24 Thread Chris Hobbs
p?machine_name=$a_row->machine_name\>$a_row->machine_name > \n"; -- Chris Hobbs Silver Valley Unified School District Head geek: Technology Services Coordinator webmaster: http://www.silvervalley.k12.ca.us/~chobbs/ postmaster: [EMAIL PROTECTED] --

Re: [PHP-DB] search form

2001-07-24 Thread Chris Hobbs
t it to search the entire site. what will i do if not >all the information in my site came from the database ... -- Chris Hobbs Silver Valley Unified School District Head geek: Technology Services Coordinator webmaster: http://www.silvervalley.k12.ca.u