[PHP-DB] Re: chat

2005-05-02 Thread JeRRy
From:Patrick Dunegan [EMAIL PROTECTED]To:[EMAIL PROTECTED]:Sun, 1 May 2005 08:22:58 -0500Subject:chat Does anyone know where there is a good chat room with PHP developers? -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.0 -

RE: [PHP-DB] String manipulation

2005-05-02 Thread Bastien Koert
Are you trying to achieve this in the db or for the application? It sounds like the application, in which case I would get the string from the db and then use substr to pull out the various elements. $first_name = substr($rows['name'],0,1); $last_name = substr($rows['name'],1); Bastien From:

[PHP-DB] Sorting multidimensional arrays from mysql

2005-05-02 Thread J. Connolly
Morning all, I am having problems understanding what I need to do. Usually for most of my work, all i need to do is pull the information and place it like this: function office_list(){ global $link; echo tabletr; $sql = SELECT town FROM offices; $result = mysql_query($sql,

RE: [PHP-DB] Sorting multidimensional arrays from mysql

2005-05-02 Thread Juffermans, Jos
mysql_fetch_array will always only return 1 row. $array['town'] won't be an array but just a text and is therefor interpreted differently. If you can give us more information (ie data model, output sample) we might be able to help you a bit better. Jos -Original Message- From: J.

[PHP-DB] Aggregate MySQL functions in html table via php - having problems

2005-05-02 Thread Finner, Doug
I want to build a table that is populated from a MySQL query and have the table include some aggregate data (mean, sd, and cv). If I select 'avg(RawData) as Mn' - and then stuff Mn into the table - life is good. If I try and select just RawData and computed the mean and sd at the time the table

RE: [PHP-DB] Aggregate MySQL functions in html table via php - ha ving problems

2005-05-02 Thread Juffermans, Jos
Hi, Since you're telling mysql Avg(RawData) as Mn the index in $myrow won't be Avg(RawData), it'll just be Mn. Try printing the entire $myrow to find out what you're receiving from mysql: print pre; print_r($myrow); print /pre; That will show you the keys that you should use. Jos

Re: [PHP-DB] URL question. .

2005-05-02 Thread Martin Norland
Mark Cain wrote: a 404 script is the way I would handle it. [snip] - Original Message - From: Chris Payne [EMAIL PROTECTED] To: php-db@lists.php.net Sent: Friday, April 29, 2005 11:00 PM Subject: [PHP-DB] URL question Hi there everyone, My client needs to be able to have their url

RE: [PHP-DB] Sorting multidimensional arrays from mysql

2005-05-02 Thread Juffermans, Jos
In that case the best way is to read all the data at once. Something like this: // first read all the data $sql = SELECT street, town, state, zip, phone FROM offices; $result = mysql_query($sql, $link); $all_data = array(); while ($this_row =

Re: [PHP-DB] Sorting multidimensional arrays from mysql

2005-05-02 Thread J. Connolly
Thank you, That was the conceptual problem I was having. jozef Juffermans, Jos wrote: In that case the best way is to read all the data at once. Something like this: // first read all the data $sql = SELECT street, town, state, zip, phone FROM offices; $result =

RE: [PHP-DB] Sorting multidimensional arrays from mysql

2005-05-02 Thread John R. Sims, Jr.
I need your help. I have a script that allows me to select a specific user from a mysql database and then allow me to show the data on a specific client. I would like to put this information into a for that I have created instead of just displaying them on the screen. Any Suggestions. Keeping

[PHP-DB] Problems with a script

2005-05-02 Thread John R. Sims, Jr.
?php if (($_POST[op] != add) || ($_GET[master_id] != )) { //haven't seen the form, so show it $display_block = h1Add an Entry/h1 form method=\post\ action=\$_SERVER[PHP_SELF]\; if ($_GET[master_id] != ) { //connect to database $conn = mysql_connect(localhost,

RE: [PHP-DB] Problems with a script

2005-05-02 Thread Bastien Koert
Since I definitely don't have time to copy your script and duplicate your environment, perhaps you would be so kind as to tell what the hell is wrong with itthen we can try to help you bastien From: John R. Sims, Jr. [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Problems with

Re: [PHP-DB] Problems with a script. .

2005-05-02 Thread Martin Norland
John R. Sims, Jr. wrote: ?php [snip * - not even gunna bother] /HTML Okay, quick/proper fixes 1 - 4: 1) you never open a FORM element, you only close it - you'll be wanting one, probably with a method=POST. 2) you should quote your array indices... just because php will evaluate them as

[PHP-DB] MySQLi group

2005-05-02 Thread john
Caio, I have started a new Google group for those of us here that may run into issues specifically with MySQLi in PHP5. http://groups-beta.google.com/group/MySQLi Regards, John -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Where are my form variables?

2005-05-02 Thread MIGUEL ANTONIO GUIRAO AGUILAR
Hi!! I created a form with five text boxes, method=post and action=myscript.php; but I can't see the variables at the target script, why? Do I need a special sintaxis for accesing the POST array? Regards, -- MIGUEL GUIRAO AGUILERA -- PHP Database Mailing List