[PHP] Re: PHP / mySQL Project...

2010-02-22 Thread Carlos Medina
Hi Don, i work for the company simplynetworks in germany. I have access to may programmers with the best quality to the best prices. We work quick and no dirty ;-) I am programmer too and my company offer you the best object oriented software of the market. Some references of my clients in

[PHP] Re: [php] [mysql] select and subselect

2009-11-17 Thread David Robley
Allen McCabe wrote: I have a page on my site where I can optionaly filter by certain fields (order by filesize or file category), but I am implementing a shopping cart type of idea where users can submit an order. As administrators, my coworkers and I need to be able to filter orders by

[PHP] Re: [php] [mysql] select and subselect

2009-11-17 Thread Nisse Engström
On Mon, 16 Nov 2009 14:21:41 -0800, Allen McCabe wrote: I have an order table that keeps track of the order_id, the date, the status, etc. I also have an order_lineitem table that is the contents of the order. This has a one-to-many structure (without foreign keys because it is mysql).

[PHP] RE: PHP/MySQL Superstars

2009-10-02 Thread Jerome Botbol
Thanks Manuel your input is greatly appreciated. Jerome -Original Message- From: Manuel Lemos [mailto:mle...@acm.org] Sent: 01 October 2009 20:46 To: Jerome Botbol Cc: php-general@lists.php.net Subject: Re: PHP/MySQL Superstars Hello, on 10/01/2009 10:09 AM Jerome Botbol said the

[PHP] Re: PHP/MySQL Superstars

2009-10-01 Thread Manuel Lemos
Hello, on 10/01/2009 10:09 AM Jerome Botbol said the following: Hi All, We require a PHP / MySQL superstar to work in-house at our offices near Edgware, London for 3 months on a ground breaking new web 2.0 project which involves a variety of exciting new technologies. You will need at

[PHP] Re: php/mysql Query Question.

2009-09-16 Thread Peter Ford
ad...@buskirkgraphics.com wrote: Before most of you go on a rampage of how to please read below... As most of you already know when using MySQL from the shell you can write your queries in html format in an out file. Example: shellmysql -uyourmom -plovesme --html This now will return

[PHP] Re: PHP/mySQL question using ORDER BY with logic

2008-10-26 Thread Carlos Medina
Rob Gould schrieb: Question about mySQL and PHP, when using the mySQL ORDER BY method... Basically I've got data coming from the database where a wine producer-name is a word like: Château Bahans Haut-Brion or La Chapelle de La Mission Haut-Brion or Le Clarence

[PHP] Re: PHP/mySQL question using ORDER BY with logic

2008-10-24 Thread Colin Guthrie
Robert Cummings wrote: On Fri, 2008-10-24 at 00:18 -0400, Rob Gould wrote: Question about mySQL and PHP, when using the mySQL ORDER BY method... Basically I've got data coming from the database where a wine producer-name is a word like: Château Bahans Haut-Brion or

[PHP] Re: PHP-MYSQL Error: Can't connect to MySQL socket. Can someone helpme out please?

2008-05-10 Thread Rahul
By the way it installed MySQL 6 and PHP 5.0.4 and from the console this command does not work: mysql -u root -p but only this works: mysql -h hostname -u root -p I tried doing the same while connecting to the database via php but it does not work. Rahul wrote: I am using Fedora Core 4. As

[PHP] Re: PHP/MySQL CMS for Articles/Studies/Research Papers?

2007-10-19 Thread Colin Guthrie
Jason Paschal wrote: just wanted to know if any of you have seen anything geared for this sort of content, something professional-looking that doesn't come with a huge learning curve. it wouldn't have to be TOO fancy, i could probably make something, but didn't want to re-invent the

[PHP] Re: php/mysql - getting ID of query

2007-08-21 Thread M. Sokolewicz
John Pillion wrote: This is as much a mysql question as it is php. What is the most reliable way to retrieve an auto_increment key/id for a query you just inserted? In other words, I compile all my data, insert it into a new row, and now I want to retrieve the ID it created for it in

[PHP] RE: php/mysql - getting ID of query

2007-08-21 Thread John Pillion
Thanks guys, that's exactly what I was looking for J -Original Message- From: M. Sokolewicz [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 21, 2007 4:51 PM To: John Pillion Cc: php-general@lists.php.net Subject: Re: php/mysql - getting ID of query John Pillion wrote: This is as much

[PHP] Re: php-mysql problem

2007-04-03 Thread itoctopus
$sql = SELECT count(Email) as numEmails, Email FROM mena_guests WHERE Voted='yes' GROUP BY Email ORDER BY numEmails DESC LIMIT $startingID, $items_numbers_list; -- itoctopus - http://www.itoctopus.com Me2resh Lists [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] hi i need help

[PHP] Re: php-mysql problem

2007-04-03 Thread itoctopus
$sql = SELECT count(Email) as numEmails, Email FROM mena_guests WHERE Voted='yes' GROUP BY Email ORDER BY numEmails DESC LIMIT $startingID, $items_numbers_list; I answered this morning, I don't know why it got deleted -- itoctopus - http://www.itoctopus.com Me2resh Lists [EMAIL PROTECTED] wrote

[PHP] Re: PHP+MySQL website cache ? Yes/No

2007-02-25 Thread Colin Guthrie
Martin Zvarík wrote: I did a benchmark with and without caching to HTML file and it's like: 0.0031 sec (with) and 0.0160 sec (with database) I know these miliseconds don't matter, but it will have significant contribution in high-traffic website, won't it? I would say yes. A good caching

Re: [PHP] Re: php mysql problem

2006-05-03 Thread Richard Lynch
On Tue, May 2, 2006 7:05 am, Ross wrote: This is my database now...I will use the item_id for the order but what if I want to change item_id 3 to item id 1? How can I push all the items down one place? How can I delete any gaps when items are deleted. Change item_id 3 to 1. ... select id

Re: [PHP] Re: php mysql problem

2006-05-03 Thread Richard Lynch
On Tue, May 2, 2006 7:22 am, chris smith wrote: On 5/2/06, Ross [EMAIL PROTECTED] wrote: This is my database now...I will use the item_id for the order but what if I want to change item_id 3 to item id 1? How can I push all the items down one place? How can I delete any gaps when items are

Re: [PHP] Re: php mysql problem

2006-05-03 Thread chris smith
On 5/3/06, Richard Lynch [EMAIL PROTECTED] wrote: On Tue, May 2, 2006 7:22 am, chris smith wrote: On 5/2/06, Ross [EMAIL PROTECTED] wrote: This is my database now...I will use the item_id for the order but what if I want to change item_id 3 to item id 1? How can I push all the items down

[PHP] Re: php mysql problem

2006-05-02 Thread Barry
Ross schrieb: Just say I have a db CREATE TABLE `mytable` ( `id` int(4) NOT NULL auto_increment, `fileName` varchar(50) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ; when I add items they go id 1,2,3 etc. Whn I delete them gaps appear.

[PHP] Re: php mysql problem

2006-05-02 Thread Ross
This is my database now...I will use the item_id for the order but what if I want to change item_id 3 to item id 1? How can I push all the items down one place? How can I delete any gaps when items are deleted. CREATE TABLE `board_papers` ( `id` int(4) NOT NULL auto_increment, `doc_date`

Re: [PHP] Re: php mysql problem

2006-05-02 Thread chris smith
On 5/2/06, Ross [EMAIL PROTECTED] wrote: This is my database now...I will use the item_id for the order but what if I want to change item_id 3 to item id 1? How can I push all the items down one place? How can I delete any gaps when items are deleted. Why do you want to do that? There's no

Re: [PHP] Re: php mysql problem

2006-05-02 Thread T.Lensselink
This is my database now...I will use the item_id for the order but what if I want to change item_id 3 to item id 1? How can I push all the items down one place? How can I delete any gaps when items are deleted. CREATE TABLE `board_papers` ( `id` int(4) NOT NULL auto_increment,

Re: [PHP] Re: php mysql problem

2006-05-02 Thread Dave Goodchild
Exactly - I don't think you really understand how a relational database works. The ids are retained as they may relate to records in another table. Internal sorting order is of no relevance at the application level. I think you need to rethink your design a little. On 02/05/06, T.Lensselink

[PHP] Re: php / mysql / js search result question

2006-01-04 Thread Michelle Konzack
Am 2005-12-27 08:03:42, schrieb Dave Carrera: Hi List, User input is a so the list moves to first instance of a. User continues to input ap so the list moves to 2 Apple Customer and so on. This can only be done from a JavaScript. Thank you in advance Dave c Greetings Michelle --

[PHP] Re: PHP MySQL

2006-01-03 Thread toylet
Here's one thought . ascii (97) is the letter a is it possible that the ascii (65) A was interpreted as lowercase thus creating a duplicate primary key? Or your DBMS doesn't make a distinction between upper or lower case. You are correct. I compiled mysql and php from source tar-ball.

[PHP] Re: PHP MySQL

2006-01-02 Thread Jerry Kita
Man-wai Chang wrote: A table with a column big5 char(2) not null primary key. $target-query(delete from canton); for ($ii=0; $ii256; $ii++) { for ($jj=0; $jj256; $jj++) { echo $ii ... $jj . \n; $query=insert into canton ( big5 ) values ( ' .

[PHP] Re: PHP/MySql noob falls at first hurdle

2005-12-09 Thread Brice
On 12/9/05, Paul Jinks [EMAIL PROTECTED] wrote: Hi all I've been asked to put simple database interactivity on an academic site. They want users to enter a few details of their projects so other researchers can search and compare funding etc. How difficult can that be, I thought I've

[PHP] Re: PHP/MySql noob falls at first hurdle

2005-12-09 Thread Brice
Are short tags disabled? Change this line... ?=$output_row[projTitle]?br / To... ?php echo ( $output_row[projTitle] ) ?br / This line seems to work : pResult of b?=$SQLquery ?/b/p -- Brice Favre http://pelmel.org/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP] Re: PHP/MySql noob falls at first hurdle

2005-12-09 Thread Paul Jinks
Brice wrote: Try to check the key of your result row with a print_r or a var_dump command. Brice Favre http://pelmel.org/ Like this? ?php while($ouput_row = mysql_fetch_array($result)) print_r($output_row); ? Apologies if this is pathetically wrong. Like I

RE: [PHP] Re: PHP/MySql noob falls at first hurdle

2005-12-09 Thread Dan Parry
PROTECTED] Sent: 09 December 2005 15:05 To: php-general@lists.php.net Subject: Re: [PHP] Re: PHP/MySql noob falls at first hurdle Brice wrote: Try to check the key of your result row with a print_r or a var_dump command. Brice Favre http://pelmel.org/ Like this? ?php

[PHP] Re: PHP/MySql noob falls at first hurdle

2005-12-09 Thread Brice
On 12/9/05, Paul Jinks [EMAIL PROTECTED] wrote: Brice wrote: Try to check the key of your result row with a print_r or a var_dump command. Brice Favre http://pelmel.org/ Like this? ?php while($ouput_row = mysql_fetch_array($result)) print_r($output_row);

[PHP] Re: PHP MYSQL Dynamic Select Boxes: Please Help

2005-11-03 Thread James Benson
Try asking in a newsgroup or forum specific to javascript, that has nothing to do with PHP Adele Botes wrote: I have 2 tables: products table product_id (INT 11 AUTOINCRE PRI) product_name (VARCHAR 255) product_desc (VARCHAR 255) color table color_id (INT 11 AUTOINCRE PRI) color (VARCHAR

Re: [PHP] Re: PHP/MySQL offline

2005-09-06 Thread Joe Wollard
... an automated script that creates a static site that will allow me to do that? If all you're really looking for is a static version of your site then you could simply use wget. This will crawl all of the links on your site and generate the static version you wanted. On Sep 5, 2005, at

Re: [PHP] Re: PHP/MySQL offline

2005-09-05 Thread viraj
On 9/4/05, John Taylor-Johnston [EMAIL PROTECTED] wrote: This is maybe what you want: http://www.indigostar.com/ http://www.indigostar.com/microweb.htm another good method is a Live Linux CD. you can find a light weight live linux distro and remaster it to include your live web site. so your

[PHP] Re: PHP/MySQL offline

2005-09-04 Thread John Taylor-Johnston
This is maybe what you want: http://www.indigostar.com/ http://www.indigostar.com/microweb.htm Runs an apache server, php all, from a CD. (windows app.) John Mario netMines wrote: Hi all I have a project where I'm using PHP/Mysql. The client wants to run that project to a cd. Does anyone

Re: [PHP] Re: PHP MySQL insert

2005-08-20 Thread areguera
On 8/19/05, Richard Lynch [EMAIL PROTECTED] wrote: On Fri, August 19, 2005 12:56 pm, areguera wrote: could you suggest something about Latin characters and portability?. As I understand it, or not, more likely, you want to configure your MySQL server to use UTF-8, and your MySQL client to

Re: [PHP] Re: PHP MySQL insert

2005-08-19 Thread Ben Ramsey
Please always reply to the list so that others can benefit from the exchange. As it happens, I'm not exactly very knowledgeable about character sets, so someone on the list may be able to offer more help with regard to the problem you're experiencing. -Ben areguera wrote: On 8/19/05, Ben

Re: [PHP] Re: PHP MySQL insert

2005-08-19 Thread areguera
sorry...here is the message On 8/19/05, areguera [EMAIL PROTECTED] wrote: On 8/19/05, Ben Ramsey [EMAIL PROTECTED] wrote: Alain Reguera Delgado wrote: you could try: 1. get all form variables into an array fine 2. validate values Good, but do this step as you put the

Re: [PHP] Re: PHP MySQL insert

2005-08-19 Thread Richard Lynch
On Fri, August 19, 2005 12:56 pm, areguera wrote: could you suggest something about Latin characters and portability?. As I understand it, or not, more likely, you want to configure your MySQL server to use UTF-8, and your MySQL client to use UTF-8 and pretty much everything to use UTF-8, and

[PHP] Re: PHP MySQL insert

2005-08-18 Thread Satyam
Commas are no problem within strings. You might have an apostrophe, which SQL assumes is the end of the string literal. That was answered by Chris already, I just wanted to clarify the problem. You don't need to insert NULL in indx. If indx allows NULL and has no other default value nor is

[PHP] Re: PHP MySQL insert

2005-08-18 Thread Dan Baker
Jon [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Please help with an insert problem. Sometimes $data1 could have a comma and that messes up the insert. how do I get around that? $query = insert into testtable6 (indx, col1, col2) values (NULL, '$data1', '$data2');

[PHP] Re: PHP MySQL insert

2005-08-18 Thread Ben Ramsey
Dan Baker wrote: You are looking for the addslashes function. It prepares data for database querys: Better yet, don't use addslashes(). Use the escaping function that is specific to the database you're using. In this case, it's mysql_real_escape_string(). This is much better than using

Re: [PHP] Re: PHP MySQL insert

2005-08-18 Thread Alain Reguera Delgado
you could try: 1. get all form variables into an array 2. validate values 3. convert all values into entities using htmlentities() 4. build sql query (do some tests 'til get it right) 5. execute the built query (with proper db function) by now, commas aren't a problem, they are limited between

Re: [PHP] Re: PHP MySQL insert

2005-08-18 Thread Ben Ramsey
Alain Reguera Delgado wrote: you could try: 1. get all form variables into an array fine 2. validate values Good, but do this step as you put the values into a separate array, don't put all the values into the array first and then validate them later... make sure the input received is

Re: [PHP] Re: PHP MySQL insert

2005-08-18 Thread Jasper Bryant-Greene
Ben Ramsey wrote: You don't need to convert the values to HTML entities when saving to a database. That's not going to prevent this problem. Furthermore, you don't need to use htmlentities() if you specify your character set properly and all the characters you are outputting are in your

[PHP] Re: php mySql question

2005-07-27 Thread axel
Sure that your php.ini is located correctly? I have installed php 5.0.4 on my windows 2000, IIS 6.0 server. PHP works but when I try to connect to MySQL I get the Fatal error: Call to undefined function mysql_connect(). I have uncommented the line in the php.ini file that says

[PHP] Re: php + mysql: binary arrays

2005-03-29 Thread Robert S
Hope I was helpful Yaron Khazai Thanks - will try that out soon. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Re: php/mysql url validation methods...

2005-02-14 Thread Jason Barnett
Darren Kirby wrote: Hello all, On the main page of my website I have written a very simple comments feature that allows people to leave a message under my posts, much like a blog. I have purposely kept this very simple... On the main page I have simple text links that someone can click on if they

Re: [PHP] Re: php/mysql url validation methods...

2005-02-14 Thread darren kirby
quoth the Jason Barnett: Darren Kirby wrote: The problem is that after playing around with this a bit, it is clear that someone can craft a url with an arbitrary $postid that is not in the database yet. Now naively, it would seem that the worst someone could do is just create arbitrary

[PHP] Re: php mysql codes insertion error.

2004-12-14 Thread Jonathan
Found the problem. I set ( default_charset = iso-8859-1 ) in php.ini and it solve the problem. Just in case anyone want to know. Jonathan [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi, I have encounter something rather weird. In my development server, when I insert a

[PHP] Re. [PHP] mysql networking ?

2004-11-08 Thread Manoj Kumar
Hi its a php mailing list ? Okey . -- Manoj Kr. Sheoran Aalee [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi guys, I have a small home network working with just 4 computers (PC's on WinXP Pro) connected through a switch just using the local ip's 192.168.0.1 and so on. And

[PHP] Re: php/MYSQL remove duplicate records

2004-09-15 Thread Sam Hobbs
I do that a lot using Microsoft Access. I just finished on a project where I had to eliminate duplicates from each of three or more queries, a couple of which have three keys. However I am not much more experienced han you are; Microsoft Access generates SQL for us so I am not sure what the SQL

[PHP] Re: PHP MySQL DATE comparison

2004-06-16 Thread Torsten Roehr
Ryan Schefke [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hello, I'm pulling a date in the datetime format via a MySQL query. Using PHP I would like to check if that date is prior to today's date. Can someone please help with this quick question. You could convert it to a

[PHP] Re: PHP/MySQL difficulties on WindowsXP

2004-04-12 Thread Gabe
I don't know if this is the root of your problem or not, but I tried running PHP 4.3.5 on my Win2K box and it crashed a lot. I found out that if you have PHP configured to run as a SAPI module there are stability issues with that version (this bug has been reported). I think the CGI install

[PHP] Re: php/mysql email

2004-03-20 Thread David Robley
[EMAIL PROTECTED] (Bigmark) wrote in news:[EMAIL PROTECTED]: I have a sports tipping script and instead of using the admin to close a round off or input results ,would it be possible to do it via an email. Mark This can be done on a Unix style system by creating a mail alias which pipes

[PHP] Re: php/mysql run on Microsoft Personal Web Server 4.0 ?

2004-03-05 Thread Five
Five [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I've been learning php/mysql by uploading my scripts to a php/mysql enabled website. It's getting to be a drag uploading each script change to check if it works. I think this can be done but wanted to double check before starting

RE: [PHP] Re: php/mysql run on Microsoft Personal Web Server 4.0 ?

2004-03-05 Thread Jay Blanchard
[snip] I can tell you if you install the server, install php using the windows installer, and then try to run a php script, nothing happens [/snip] You cannot do it with the Personal Web Server. Might I recommend that you download Apache for Windows? Then you can use PHP all day long. -- PHP

[PHP] Re: PHP || MySql Directory Tree Problem......

2004-03-05 Thread CF High
Hey all. I've developed a site builder application that allows my clients to build/maintain their sites without my having to deal with tedious web design tasks. The current version has some problems, however. To resolve these issues I've switched over to an MVC (Model-View-Controller)

[PHP] Re: php/mysql run on Microsoft Personal Web Server 4.0 ?

2004-03-05 Thread Five
Five [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I've been learning php/mysql by uploading my scripts to a php/mysql enabled website. It's getting to be a drag uploading each script change to check if it works. I think this can be done but wanted to double check before starting

[PHP] Re: PHP/ MySQL Login Module

2004-02-16 Thread zerof
If you can use Dreamweaver, you must use one extension to make this. Is very simple. http://www.macromedia.com/cfusion/exchange/index.cfm - zerof - Pushpinder Singh [EMAIL PROTECTED] escreveu na mensagem news:[EMAIL PROTECTED] hello everyone. I am using PHP and MySQL on my website.

[PHP] Re: PHP, MySQL problem

2004-01-14 Thread Jan Grafström
Hi Add records with this code. ?php $name=isset($_POST['name']) ? $_POST['name'] :''; $address=isset($_POST['address']) ? $_POST['address'] :''; if (!empty($name)) { mysql_connect($server,$user,$pass) or die (Error conecting); mysql_select_db($dbnamn,$conection) or die (no db .$dbnamn); $query =

[PHP] Re: PHP/MySQL with Microsoft Word

2004-01-06 Thread Gary C. New
Use MySQLODBC... I use it to manage my databases through MS Access. I haven't integrated it yet with Word, but it is my intention in the near future. Hope this helps. Respectfully, Gary Satch wrote: Is there any way to have a web page (PHP) that draws data from a database (MySQL) then

RE: [PHP] Re: PHP/MySQL with Microsoft Word

2004-01-06 Thread Vail, Warren
To: [EMAIL PROTECTED] Subject: [PHP] Re: PHP/MySQL with Microsoft Word Use MySQLODBC... I use it to manage my databases through MS Access. I haven't integrated it yet with Word, but it is my intention in the near future. Hope this helps. Respectfully, Gary Satch wrote: Is there any way

[PHP] Re: php/mysql data display

2003-12-18 Thread rush
Jlake [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I have a small database that I want to display data from. in such a way that it shows shows in a table with the table header being the department category and the table cells being the categories for each department. I have no

[PHP] Re: PHP, MySQL and datetime

2003-12-04 Thread John
Guess it matters on which one you want to do the date handling...php or MySQL. If it's PHP, I like epoch time, makes manipulating time and dates very simple (basic math). MySQL has its own timestamp format (the guy above me mentions it). Whichever you feel more comfortable with. John Jough

[PHP] Re: PHP/MySQL/Server not working

2003-10-18 Thread conbud
Hey, Also the webhost only allows us database direct database connection using phpMyadmin, I did notice that on the table that stores the info, it keep getting an error after someone is posting the form. The error says something about Overhead: 275 bytes, Is this just an MySQL limitation that is

[PHP] Re: php mysql array question

2003-07-11 Thread Pete Morganic
I use the PEAR db http://pear.php.net/manual/en/package.database.php This returns arrays - examples here http://pear.php.net/manual/en/package.database.db.intro-fetch.php look at the Quick data retreaval down the page pete Larry Brown wrote: Is there any php function to pull a query into an

[PHP] Re: php mysql array question

2003-07-11 Thread Rob Adams
It shouldn't take a lot of code to put results into an array: $query = select * from table; $r = mysql_result($query); while ($row = mysql_fetch_object($r)) $hold[] = $row; (OR, to index by some id field in the database:) $hold[$row-id] = $row; mysql_free_result($r); Total of 5 lines. --

[PHP] RE: PHP Mysql Error Code 1062 - Duplicates found

2003-06-26 Thread Ow Mun Heng
Hi All, I found out how to do it already. Thanks for the help. mysql_error() was the key.. Cheers, Mun Heng, Ow H/M Engineering Western Digital M'sia DID : 03-7870 5168 -Original Message- From: Ow Mun Heng Sent: Wednesday, June 25, 2003 10:03 AM To: [EMAIL PROTECTED]

[PHP] Re: PHP Mysql Hit Counter

2003-06-25 Thread Nadim Attari
http://www.hotscripts.com/PHP/Scripts_and_Programs/index.html

RE: [PHP] Re: PHP Mysql Hit Counter

2003-06-25 Thread mwestern
To: [EMAIL PROTECTED] Subject: [PHP] Re: PHP Mysql Hit Counter http://www.hotscripts.com/PHP/Scripts_and_Programs/index.html -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Re: PHP MySQL Move

2003-03-03 Thread John Taylor-Johnston
Found this for anyone interested. http://www.mysql.com/doc/en/INSERT_SELECT.html John Taylor-Johnston wrote: I was wondering about this, but decided to ask first first: INSERT INTO ccl.ccl_main VALUES (select * from greid.ccl where id=28); delete * from greid.ccl where id=28; Both tables

[PHP] Re: PHP MySQL Move

2003-02-28 Thread John Taylor-Johnston
I was wondering about this, but decided to ask first first: INSERT INTO ccl.ccl_main VALUES (select * from greid.ccl where id=28); delete * from greid.ccl where id=28; Both tables would have to have the same structure ? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP] Re: php/mysql report builder

2002-11-27 Thread UberGoober
http://www.phplens.com/ might be something you could use. Michael P. Carel [EMAIL PROTECTED] wrote in message 002d01c295b8$f0301800$[EMAIL PROTECTED]">news:002d01c295b8$f0301800$[EMAIL PROTECTED]... hi to all; sorry for posting this mysql question again. im searching for a report builder for

[PHP] Re: php/mysql not mutually connected

2002-11-13 Thread David Robley
In article 003001c28a86$cab1dce0$[EMAIL PROTECTED], [EMAIL PROTECTED] says... I have php (as an apache module) and mysql up and running on Windows in the same computer, but they seem to be unconnected. How do I configure php.ini, my.ini, etc for a php script to find and query a database in

[PHP] RE: PHP + MySQL, how to get total rows matched when using LIMIT 0, 10?

2002-11-05 Thread Jeroen Geusebroek
I'm trying to get the total matched rows when I'm using LIMIT 0, 10, but I only get the number 10, when the total should be around 100. So, can I get total matched rows without doing a separate query using count()? You first have to get the whole result set without the limit OR make use of

[PHP] Re: PHP/MYSQL query error

2002-08-26 Thread Chris Crane
I did some more testing and I found that I forgot the first field in the columns section of the Statement. So now it looks like this: I also copy and pasted the statement into PHPMYADMIN and it worked fine. It just doesn't work here function AddSignupRequest($Signup_FName, $Signup_LName,

[PHP] Re: PHP/MySQL Search Engine Query Question

2002-07-29 Thread Richard Lynch
I am currently working on a website that is implemented using PHP and MySQL. The site currently has a simple search engine that allows a shopper to type in a search string that is stored in $search. For example, if a shopper types in 1972 Ford Mustang $string =1972 Ford Mustang Using the

[PHP] Re: PHP-MySQL connection problem

2002-07-29 Thread Richard Lynch
My server is running on shared server which has support for PHP 4.1.2. I installed mySQL for our shared server. I also installed phpMyAdmin. Both are running properly. But I am facing following problems 1) If there is any error in the script - It is not getting displayed - screen is becoming

[PHP] Re: php/mysql simple math

2002-07-18 Thread Richard Lynch
I have created a table which has a column called cost. How do I add up all the numerical data in the cost column and display that on a webpage? ?php $query = select sum(cost) from whatever where blah, blah, blah; $cost = mysql_query($query) or error_log(mysql_error()); $cost =

[PHP] Re: PHP/MySQL and parameterized queries

2002-07-09 Thread Richard Lynch
Does MySQL support parameterized queries (e.g., INSERT INTO table (Col1,Col2) VALUES (?,?)), and if so, is there a PHP function that allows you to create and attach parameters to MySQL queries? I don't believe MySQL supports that, so there's no PHP mechanism for it. However, you *can* insert a

[PHP] Re: PHP-MySQL AND Case Sentivity

2002-06-07 Thread fincom
That's Ok See : http://www.zend.com/tips/tips.php?id=199single=1 Fincom [EMAIL PROTECTED] a écrit dans le message de news: [EMAIL PROTECTED] Hi, how to make sql Result case sensitive with php. thanks -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:

RE: [PHP] Re: PHP-MySQL AND Case Sentivity

2002-06-07 Thread John Holmes
: fincom [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 5:43 AM To: [EMAIL PROTECTED] Subject: [PHP] Re: PHP-MySQL AND Case Sentivity That's Ok See : http://www.zend.com/tips/tips.php?id=199single=1 Fincom [EMAIL PROTECTED] a écrit dans le message de news: [EMAIL PROTECTED] Hi

[PHP] Re: PHP+MySQL - Excel ?

2002-05-17 Thread Evan
Thanks to all :-) Bye, Evan Evan [EMAIL PROTECTED] ha scritto nel messaggio [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Is it possible to create an excel file with some data from mySQL, using PHP ? Thanks, Evan -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP] Re: PHP+MySQL - Excel ?

2002-05-17 Thread Manuel Lemos
Hello, On 05/17/2002 01:18 PM, Evan wrote: Is it possible to create an excel file with some data from mySQL, using PHP ? Sure, you can use this class to generate Excel files on fly on even in non-Windows platforms. http://www.phpclasses.org/biffwriter -- Regards, Manuel Lemos -- PHP

Re: [PHP] Re: PHP+MySQL - Excel ?

2002-05-17 Thread Glenn Sieb
At 02:13 PM 5/17/2002 -0300, Manuel Lemos posted the following... Hello, On 05/17/2002 01:18 PM, Evan wrote: Is it possible to create an excel file with some data from mySQL, using PHP ? Sure, you can use this class to generate Excel files on fly on even in non-Windows platforms. Heck,

[PHP] Re: PHP MySQL Hosting services

2002-04-15 Thread The_RadiX
PROTECTED] ABN: 64 235 749 494 Mobile: 0407 122 268 QUT Student #: 04475739 ::: - Original Message - From: Vins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 15, 2002 7:12 AM Subject: [PHP] Re: PHP MySQL Hosting services

Re: [PHP] Re: PHP MySQL Hosting services

2002-04-15 Thread Vins
04475739 ::: - Original Message - From: Vins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 15, 2002 7:12 AM Subject: [PHP] Re: PHP MySQL Hosting services Hey. I have the best hosting you can get. for only $46 p/m

Re: [PHP] Re: PHP MySQL Hosting services

2002-04-15 Thread Michael Kimsal
Vins wrote: you get unlimited traffic. here it is very cheep. so they can offer a great service. www.wthosting.cjb.net and they also don't pay for a domain. so that means even more cheeper prices. LOL they crazy. I know they guy, his way of thinking is free is better for the

[PHP] Re: PHP/MySQL Query Prob

2002-04-15 Thread David Robley
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... Hey... new to the list, but didn't have time to lurk and watch the traffic, kind of in a bind here. I apologize in advance if I do something wrong... Using this code: ?php $link = mysql_connect()

[PHP] Re: PHP MySQL Hosting services

2002-04-14 Thread phplists
http://webpipe.net They seem to be doing good with uptime.. In the last couple months I've been having a monitoring service check them frequently and so far we're at 100%.. Standard Virtual Package ($24.95/mo - $14.95 setup): Linux RedHat 7.1 300mb Disk Space 25 POP3 Accounts 10GB/mo transfer

Re: [PHP] Re: PHP MySQL Hosting services

2002-04-14 Thread eat pasta type fasta
Check out linux web host comes with PHP and MySql Their PHP compile is pretty nice, including GD support. Their DB is run via phpMyAdmin. http://www.linuxwebhost.com http://webpipe.net They seem to be doing good with uptime.. In the last couple months I've been having a monitoring service

Re: [PHP] Re: PHP MySQL Hosting services

2002-04-14 Thread phplists
Yeah, I actually used to have a couple accounts with linuxwebhost.com... They are nice and fast.. I just like the ability to be able to compile and install my own software on the server.. Later, Bob Eat Pasta Type Fasta [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL

[PHP] Re: PHP MySQL Hosting services

2002-04-14 Thread Steve
Jennifer Check out Hub.Org Networking services http://www.hub.org They have Virtual Machine that can be configured to your NEEDS without affecting other clients and vice versa. and MANY other features including ssh, ftp, cgi/perl and I believe they have also added MySQL 3.23 to the list.

[PHP] Re: PHP MySQL Hosting services

2002-04-14 Thread Vins
Hey. I have the best hosting you can get. for only $46 p/m ALL THIS... a.. 400 MB web space a.. Execution of Custom CGI scripts a.. Support for PERL a.. Support for C and C++ a.. Support for SSI a.. Support for GCC a.. Support for GD a.. Support for 5 independent MySQL Databases Own URL

[PHP] Re: PHP MySQL Hosting services

2002-04-14 Thread Vins
Hey. I have the best hosting you can get. for only $46 p/m ALL THIS... 400 MB web space Execution of Custom CGI scripts Support for PERL Support for C and C++ Support for SSI Support for GCC Support for GD Support for 5 independent MySQL Databases Own URL in the format Extensive Support Forum

[PHP] Re: Php/Mysql

2002-04-13 Thread David Robley
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... Just a noob php/mysql question... (I suppose) When I try just putting php code in my insert queries, it goes like this: insert into mytable values('?php echo some string; ?') select * from mytable, returns: ?php echo some string;

[PHP] Re: PHP MySQL Hosting services

2002-04-13 Thread phplists
http://webpipe.net They seem to be doing good with uptime.. In the last couple months I've been having a monitoring service check them frequently and so far we're at 100%.. Standard Virtual Package ($24.95/mo - $14.95 setup): Linux RedHat 7.1 300mb Disk Space 25 POP3 Accounts 10GB/mo transfer

[PHP] Re: Php + Mysql Hosting problem

2002-04-12 Thread Michael Andersson
To use php+mysql on spaceports you have to sign up for a cgi-bin account and store your files on that server.. /Micke Simonk [EMAIL PROTECTED] skrev i meddelandet [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I have made a web site containing Php and Mysql script And I have applied for a free

[PHP] Re: Php/Mysql

2002-04-12 Thread Michael Andersson
Myabe you should assign some string to a variable: $string = some string; insert into mytable values ($string) /Just a noob trying to help out Torkil Johnsen [EMAIL PROTECTED] skrev i meddelandet [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Just a noob php/mysql question... (I suppose)

  1   2   >