Re: [PHP-DB] PHP and MYSQL Update problem

Manu Gupta wrote: try .. $q = addslashes("UPDATE episodes SET episode_title = '$_POST[episode_title]' , episode_scheduleddate = ".strtotime($_POST['episode_scheduleddate'])." , episode_description = '$_POST[episode_description]' WHERE episode_id = $_POST[episode_id]"); or try $q = "UPDATE episo

Re: [PHP-DB] PHP and MYSQL Update problem

try .. $q = addslashes("UPDATE episodes SET episode_title = '$_POST[episode_title]' , episode_scheduleddate = ".strtotime($_POST['episode_scheduleddate'])." , episode_description = '$_POST[episode_description]' WHERE episode_id = $_POST[episode_id]"); or try $q = "UPDATE episodes SET episode_titl

[PHP-DB] PHP and MYSQL Update problem

Hello, I have a little problem with a sql command string $q = "UPDATE episodes SET episode_title = '$_POST[episode_title]' , episode_scheduleddate = ".strtotime($_POST['episode_scheduleddate'])." , episode_description = '$_POST[episode_description]' WHERE episode_id = $_POST[episode_id]"; I keep

Re: [PHP-DB] php and mysql image script

Look at www.phpclasses.org ;) Wilson Osemeilu napsal(a): I need a simple php mysql image upload script with display script too and to make this easier the mysql database table to use -- S pozdravem Daniel Tlach Freelance webdeveloper Email: m...@danaketh.com ICQ: 160914875 M

Re: [PHP-DB] php and mysql image script

On Thu, May 28, 2009 at 4:19 PM, Wilson Osemeilu wrote: > I need a simple php mysql image upload script with display script too and > to make this easier the mysql database table to use > > > > STFW -- Bastien Cat, the other other white meat

[PHP-DB] php and mysql image script

I need a simple php mysql image upload script with display script too and to make this easier the mysql database table to use  

Re: [PHP-DB] PHP and MySQL design question

Chris wrote: >> My point here was the if you index on (a, b), you don't need to index on >> (b, a) if both a and b are present in your where clause. The index is >> read from left to right -- not the where clause. > > Sure you do. Look at the OP's problem and you'll see you still do. > > To quote

Re: [PHP-DB] PHP and MySQL design question

robertom wrote: Chris wrote: Roberto Mansfield wrote: It shouldn't matter what order the columns are referenced. Mysql is smart enough to optimize the query based on the available indexes. In some cases yes but as with anything there are exceptions :) mysql (and every other db) gets it wrong

Re: [PHP-DB] PHP and MySQL design question

> Chris wrote: >> Mysql will actually only use one index per table. I was surprised to >> find this out but it's mentioned in >> http://www.amazon.com/High-Performance-MySQL-Jeremy-Zawodny/dp/0596003064/ >> - page 64 (just looked it up to include a page ref). >> >> No idea if this is mentioned anyw

Re: [PHP-DB] PHP and MySQL design question

Chris wrote: > Roberto Mansfield wrote: >> It shouldn't matter what order the columns are referenced. Mysql is >> smart enough to optimize the query based on the available indexes. > > In some cases yes but as with anything there are exceptions :) > > mysql (and every other db) gets it wrong some

Re: [PHP-DB] PHP and MySQL design question

Roberto Mansfield wrote: It shouldn't matter what order the columns are referenced. Mysql is smart enough to optimize the query based on the available indexes. In some cases yes but as with anything there are exceptions :) mysql (and every other db) gets it wrong sometimes. In fact, it shoul

Re: [PHP-DB] PHP and MySQL design question

It shouldn't matter what order the columns are referenced. Mysql is smart enough to optimize the query based on the available indexes. In fact, it should be good enough just to create an index on each column that will be searched -- not on combinations of columns. Do you have any performance number

Re: [PHP-DB] PHP and MySQL design question

Hello I did look into the info from EXPLAIN. I can create the indexes also but then I have to create indexes with all permutation of column order if I want to get good performance from all search query regardless of what order user enters the column. On 10/23/07, Theodoros Goltsios <[EMAIL PROTEC

Re: [PHP-DB] PHP and MySQL design question

I guess EXPLAIN will do the job for you. First of all in order to ensure what is the index used by your queries and then how to improve performance by making the right indexes. Theodoros Goltsios Kinetix Tele.com Support Center email: [EMAIL PROTECTED], [EMAIL PROTECTED] Tel. & Fax: +30 2310556

[PHP-DB] PHP and MySQL design question

Hello all I have a table like: CREATE TABLE `benchmarks` ( `name` varchar(50) NOT NULL default '', `logic` varchar(50) NOT NULL default '', `status` varchar(50) NOT NULL default '', `difficulty` int(11) NOT NULL default '0', `xmldata` longblob, PRIMARY KEY (`name`), KEY `logic` (`l

Re: [PHP-DB] PHP and MYSQL

Na Derro Cartwright wrote: I am trying to simply display all the values from a simple query but I am recieveing an error that I have to upgrade my client. I am not sure what that means. Put the full message in to your preferred search engine - I know the message you mean and I'm sure one of

Re: [PHP-DB] PHP and MYSQL

I am trying to simply display all the values from a simple query but I am recieveing an error that I have to upgrade my client. I am not sure what that means. Chris wrote: Na Derro Cartwright wrote: I am currently running php4 with mysql 5. when I try to run a query using the mysql command

Re: [PHP-DB] PHP and MYSQL

Chris wrote: Na Derro Cartwright wrote: I am currently running php4 with mysql 5. when I try to run a query using the mysql command I recieve and error that reads the resource id and a number. What does that mean? Firstly always cc the list - others will be able to provide their input and

Re: [PHP-DB] PHP and MYSQL

Chris wrote: Na Derro Cartwright wrote: I am currently running php4 with mysql 5. when I try to run a query using the mysql command I recieve and error that reads the resource id and a number. What does that mean? Firstly always cc the list - others will be able to provide their input and

Re: [PHP-DB] PHP and MYSQL

Na Derro Cartwright wrote: I am currently running php4 with mysql 5. when I try to run a query using the mysql command I recieve and error that reads the resource id and a number. What does that mean? Firstly always cc the list - others will be able to provide their input and others will al

Re: [PHP-DB] PHP and MYSQL

Na Derro Cartwright wrote: Can PHP 4 work with MYSQL 5? Yep. -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] PHP and MYSQL

Can PHP 4 work with MYSQL 5?

Re: [PHP-DB] PHP and MySQL on Windows causing severe slowdown

Diane wrote: I just switched a customer from one Windows host to another. The new host is a Windows only shop, and not overly familiar with MySQL and PHP. My customer has two PHP applications, both important to the site. Everything else is ASP or ASP.NET. When the new host installed PHP and

[PHP-DB] PHP and MySQL on Windows causing severe slowdown

I just switched a customer from one Windows host to another. The new host is a Windows only shop, and not overly familiar with MySQL and PHP. My customer has two PHP applications, both important to the site. Everything else is ASP or ASP.NET. When the new host installed PHP and MySQL, the web

Re: [PHP-DB] PHP and Mysql help

ReClMaples wrote: $zipcode = mysql_query( "SELECT * FROM zip_code where ZG_LATITUDE >= $Lat1 and ZG_LATITUDE <= $Lat2 and ZG_LONGITUDE >= $Lon1 and ZG_LONGITUDE <= $Lon2"); Try putting single quotes around the variables in your query string; mysql sees them as strings, not variables: ... ZG_LATIT

Re: [PHP-DB] PHP and Mysql help

Hey, That is a lot of code, so I only skimmed it, but right off the bat i noticed that you are missing a space in between WHERE and zg_zipcode, as shown below: $res = mysql_query("SELECT ZG_LATITUDE, ZG_LONGITUDE FROM zip_code wherezg_zipcode = '$zip'"); should be: $res = mysql_query("SELECT Z

[PHP-DB] PHP and Mysql help

Can someone help me out with an issue I'm having? Here is my code: $res = mysql_query("SELECT ZG_LATITUDE, ZG_LONGITUDE FROM zip_code wherezg_zipcode = '$zip'"); List($Lat,$Lon) = mysql_fetch_row($res); $Lat1 = ($Lat-2); $Lat2= ($Lat+2); $Lon1= ($Lon-2); $Lon2= ($Lon+2); //echo ($Lat1);

RE: [PHP-DB] PHP and MySql question

); echo("Longitude: " . $row["ZG_LONGITUDE"]. ""); } I get no results with this still, it acutally doesn't even go to the this page. When I uncomment out: //echo ($Lat1); //echo ($Lat2); //echo ($Lon1); //echo ($Lon2); and comment out everything below this,

SV: [PHP-DB] PHP and MySql question

n) = mysql_fetch_row($res); $Lat1=Lat-2; $Lat2=Lat+2; $Lon1=Lon-2; $Lon2=Lat+2; Now you can use the values in your final query. Hth Henrik Hornemann -Oprindelig meddelelse- Fra: ReClMaples [mailto:[EMAIL PROTECTED] Sendt: 16. april 2005 22:38 Til: php-db@lists.php.net Emne: [PHP-DB] PH

[PHP-DB] PHP and MySql question

Hello, I'm kinda new at PHP programming with MySQL. I am having an issue and am not sure if this is the corret way to do this: Here is my code, I'll start there: Error performing query: " . mysql_error() . ""); exit(); } $Lat2 = mysql_query( "SELECT (ZG_LATITUDE+2) FR

Re: [PHP-DB] PHP and MySQL 5.0 stored procedures

plese don't ask qustion i am now start to do php and my sql don't sent any mail please On Thu, 10 Mar 2005 20:37:02 +1100, Guy Harrison <[EMAIL PROTECTED]> wrote: > Hi all, > > I'm new to PHP, but have been doing a lot of work with the MySQL 5.0 alphas > looking at the stored procedure implem

[PHP-DB] PHP and MySQL 5.0 stored procedures

Hi all, I'm new to PHP, but have been doing a lot of work with the MySQL 5.0 alphas looking at the stored procedure implementation. I wanted to work with stored procedures in the PHP mysqli interface, but it doesn't seem to be ready for them yet. The things I want to do with stored procedures th

Re: [PHP-DB] PHP and mysql script error in webhosting

"Robby Russell" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Mon, 2004-08-09 at 20:45, Sukanto Kho wrote: > > Hi all, > > > > My php files run well in my local PC > > but some of PHP and mysql script just getting error when running in webhosting server. > > > > I found out that

Re: [PHP-DB] PHP and mysql script error in webhosting

On Mon, 2004-08-09 at 20:45, Sukanto Kho wrote: > Hi all, > > My php files run well in my local PC > but some of PHP and mysql script just getting error when running in webhosting > server. > > I found out that the problem is in the way webhosting server handling global > variable. > for exam

[PHP-DB] PHP and mysql script error in webhosting

Hi all, My php files run well in my local PC but some of PHP and mysql script just getting error when running in webhosting server. I found out that the problem is in the way webhosting server handling global variable. for example : In my local PC : $_GET['var'] is different with $var

Re: [PHP-DB] php and MySQL and PostgresSQL at the same time

El Jue 02 Oct 2003 08:22, Morten Gulbrandsen escribió: > Is it possible to use PHP under one Apache WEB application in order to > access > > MySQL and at the same time PostgreSQL? > > > > different databases ? Depends on how the question was made. Yes you can access diferent database engines from

Re: [PHP-DB] php and MySQL and PostgresSQL at the same time

EMAIL PROTECTED] <[EMAIL PROTECTED]cc: e> Subject: [PHP-DB] php and MySQL and Postgre

[PHP-DB] php and MySQL and PostgresSQL at the same time

Is it possible to use PHP under one Apache WEB application in order to access MySQL and at the same time PostgreSQL? different databases ? Yours Sincerely Morten Gulbrandsen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] ?? php and mysql database question ??

> I already have installed a PHP program that I can > run/test PHP scripts and thought I'd ask here if > anyone knew of a mysql one. (I thought since a PHP > program is available on Windows OS maybe a mysql one > was too?) There is... http://www.mysql.com/ for more info .: Allowee -- PHP Dat

[PHP-DB] ?? php and mysql database question ??

Hello, I have a question, not sure if what I am looking for is available at all or a smaller program of the full sized program I am looking for but thought I'd ask to see if anyone knows of a program or a program they may of created. On my personal Computer I run a Windows OS and on my server (lo

RE: [PHP-DB] PHP and MySQL 4

Sure does - sure is. -Original Message- From: Benjamin Higgins [mailto:[EMAIL PROTECTED] Sent: Monday, 31 March 2003 6:47 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP and MySQL 4 Does PHP have support for MySQL 4? If I install MySQL 4, and rebuild PHP with --with-mysql, is that

Re: [PHP-DB] PHP and MySQL 4

On Monday 31 March 2003 04:46, Benjamin Higgins wrote: > Does PHP have support for MySQL 4? If I install MySQL 4, and rebuild PHP > with --with-mysql, is that sufficient to get MySQL 4 support? Yes. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrator

[PHP-DB] PHP and MySQL 4

Does PHP have support for MySQL 4? If I install MySQL 4, and rebuild PHP with --with-mysql, is that sufficient to get MySQL 4 support? Ben -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Php and mysql, a rookie problem.

Make a script to dump phpinfo() I don't think mysql support was part of your PHP binary. Just get the Apache source and PHP source and re-build it, then you KNOW what is in there and what is not. -Brad > Hi, I had already install mysql and php, the apache was in my linux > distribution (Man

[PHP-DB] Php and mysql, a rookie problem.

Hi, I had already install mysql and php, the apache was in my linux distribution (Mandrake) and also one php, but i have install the last version in rpm. I have stop and start the apache, and the php works without any problem. But when i call to a mysql function in the php code its give to me

RE: [PHP-DB] PHP and mySQL help!

zung Nguyen [mailto:[EMAIL PROTECTED]] > Sent: Friday, January 10, 2003 1:33 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] PHP and mySQL help! > > Thanks for the quick reply! Perhaps I should describe my problem more > specifically so that u co

RE: [PHP-DB] PHP and mySQL help!

Cc: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] PHP and mySQL help! > > > Thanks for the quick reply! Perhaps I should describe my > problem more > specifically so that u could have a better idea: > > The code on PHP page to create forms for users to input field names: >

Re: [PHP-DB] PHP and mySQL help!

Thanks for the quick reply! Perhaps I should describe my problem more specifically so that u could have a better idea: The code on PHP page to create forms for users to input field names: $tempdate = $date ; $tempselect = $select ; echo "Choose date

RE: [PHP-DB] PHP and mySQL help!

h.com/ > -Original Message- > From: Dzung Nguyen [mailto:[EMAIL PROTECTED]] > Sent: Friday, January 10, 2003 12:45 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] PHP and mySQL help! > > Hi! I have a PHP page with a few text areas where users can enter > different com

[PHP-DB] PHP and mySQL help!

Hi! I have a PHP page with a few text areas where users can enter different combination of fields to query a mySQL database. An example of a query would be like this: $query = "SELECT build_ids.build_id, build_ids.username, build_ids.host, build_ids.configuration, build_ids

Re: [PHP-DB] php and mysql on RH8.0

1. Is mysqld running? I don't remember if the default configuration for RH8.0 sets it to start on system boot. The easy way to check is: ps aux | grep mysql or mysqladmin -u root ping will return "MySQL is alive" if the server is running. 2. See chapter 2.4 of the MySQL Man

AW: [PHP-DB] php and mysql on RH8.0

Hi Franco, did you install MySql? Check http://www.mysql.com/ to get the newest release. Best regards Claudia -Ursprüngliche Nachricht- Von: franco stridella [mailto:[EMAIL PROTECTED]] Gesendet: Sonntag, 29. Dezember 2002 16:47 An: [EMAIL PROTECTED] Betreff: [PHP-DB] php and mysql on

[PHP-DB] php and mysql on RH8.0

Hi, i apologize in advance for my stupid question. I installed RedHat8.0 with built in apache 2 and php 4.2.2 By looking at phpinfo() i see that php has been compiled with --with-mysql,shared and php works but it seems that mysql is not enabled. Why? how can i use mysql with php? what have i

Re: [PHP-DB] PHP and MySQL

The simplest solution is to edit php.ini on your Linux box and set the parameter register_globals to ON. As of PHP4.2.0 the default setting is OFF and new "super globals" are available. A better solution is to update your windows box to the same version of PHP so that you are programming to the im

[PHP-DB] PHP and MySQL

Hello, I have created a website (www.mirax.cz) with a database mysql 3.23.33 and used PHP 4.0.4pl1. Everything functions perfect ONLY at my W98. As soon as I want to use the same database exported to linux(PHP 4.2.2) or w2000(PHP 4.2.3) both with mysql 3.23.54, it has problems like this: Notic

Re: [PHP-DB] php and mysql

Three words: php dot net --Dave On Fri, 2002-12-06 at 23:19, Jason Wong wrote: > On Saturday 07 December 2002 11:54, Dallas wrote: > > hey, i'm just new to using php and mysql > > > > i would like to know how to do the following for a assignment of mine > > (shopping site):- > > > > and if I cou

Re: [PHP-DB] php and mysql

On Saturday 07 December 2002 11:54, Dallas wrote: > hey, i'm just new to using php and mysql > > i would like to know how to do the following for a assignment of mine > (shopping site):- > > and if I could ask for full codes, and only relevant coding, no extra stuff > plz Should you be asking for

[PHP-DB] php and mysql

hey, i'm just new to using php and mysql i would like to know how to do the following for a assignment of mine (shopping site):- and if I could ask for full codes, and only relevant coding, no extra stuff plz *connect to the mysql database and display results in random areas of the page (the pri

[PHP-DB] PHP and MySQL form problem - Undifined variables

First time playing with PHP, Apache, and MySQL. I have a simple form error and I don't know how to solve it. I was doing the Webmonkey PHP/MySQL tutorial and when I started using forms with $PHP_SELF I started getting errors with variables not defined. PHP 4.2.3 MySQL 4.0 Windows 2000 Apache 1.3

RE: [PHP-DB] php and mysql security problem

Developer Sandler and Travis Trade Advisory Services, Inc. 248.474.7200 x 183 http://www.strtrade.com -Original Message- From: Jack [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:37 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP-DB] php and mysql security

[PHP-DB] php and mysql security problem

Dear all I had a security problem with my homepage. I'm using the IIS 4 to host my webpage, and i got the php to run as the script of the webpage and the database i'm using for the database is mysql. Here is my question : There is a table in mysql which will let user to input some records to, the

[PHP-DB] RE: [PHP-DEV] RE: [PHP-DB] PHP and MySQL queries...

> From: Chris Newbill [mailto:[EMAIL PROTECTED]] > >snip... (been doing VBScript on ASP for several years, tho). > > I feel sorry for you. :) ;) Never fear. It works, does what it needs to do (so long as it's properly patched ;) and I make a fist-full of money for moon-lighting. Can't complain

[PHP-DB] RE: [PHP-DEV] RE: [PHP-DB] PHP and MySQL queries...

-Original Message- From: Tim Foster [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 8:19 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP-DEV] RE: [PHP-DB] PHP and MySQL queries... >snip... (been doing VBScript on ASP for several years, >tho). I feel sorry f

[PHP-DB] RE: [PHP-DEV] RE: [PHP-DB] PHP and MySQL queries...

RE: [PHP-DEV] RE: [PHP-DB] PHP and MySQL queries...Agreed. Personally, I refuse to keep date values in fields that are not DATE fields of some kind. Too much trouble. TIM -How do "Do Not Walk On Grass" signs get there? -Original Message- From: Robinson, Mike [mailto:[EMAIL

[PHP-DB] RE: [PHP-DEV] RE: [PHP-DB] PHP and MySQL queries...

Title: RE: [PHP-DEV] RE: [PHP-DB] PHP and MySQL queries... http://mysql.com/documentation/mysql/bychapter/manual_Reference.html#Date_and_time_types Mysql permits all manner of formats for date/time storage, and a whole slew of functions for retrieving date/time info in useful, meaningful

Re: [PHP-DB] PHP and MySQL queries...

y the overhead. >> >> FWIW, M$ likes to store their dates as two integers: one to hold the >> date portion, the >> other to hold the hours:minutes:seconds portion. >> >> If there's something about PHP/MySQL that makes this point moot, >> please let me

Re: [PHP-DB] PHP and MySQL queries...

seconds portion. > > If there's something about PHP/MySQL that makes this point moot, please > let me know. > > TIM > -He who always plows a straight furrow is in a rut. > > >> -Original Message- >> From: Mike Frazer [mailto:[EMAIL PROTECTED]] >> Sent: Wednesday

RE: [PHP-DB] PHP and MySQL queries...

kes this point moot, please let me know. TIM -He who always plows a straight furrow is in a rut. > -Original Message- > From: Mike Frazer [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 24, 2001 7:54 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: [PHP-DB]

[PHP-DB] RE: [PHP-DEV] Re: [PHP-DB] PHP and MySQL queries...

Title: RE: [PHP-DEV] Re: [PHP-DB] PHP and MySQL queries... In these days and times, conservation of a meg of disk space is really not a consideration. Not the primary one anyway. The data should be stored in a format such that the storage itself and then retrieval can be executed with a

Re: [PHP-DB] PHP and MySQL queries...

Agreed. This is especially useful when you need to conserve every byte you can; a timestamp of "10/24/2001" or something similar is going to take 10 bytes as a string and an indeterminate number of bytes for an actual timestamp because of system variations, whereas an integer value of 10242001 wi

Re: [PHP-DB] PHP and MySQL queries...

Why don't you let them enter it however they want in the form mm-dd- mm/dd/yy then in the php script that processes it, convert it with regulat expressions to a timstamp and enter it in your database as an int. That's how I do it. I don't understand the point in using the mysql timedate fiel

Re: [PHP-DB] PHP and MySQL queries...

How about using 3 select menus: * One for the day called 'dayselect' * One for the month called 'monthselect; * One for the year called 'yearselect' When you get the values from the selects to perform query's upon, re-arrange the order the dates come in: In your form they'll be in the order:

[PHP-DB] PHP and MySQL queries...

I am having a hard time setting up a form for users to enter a date in the format of 00/00/ (of course they would use an actual date). My form is as follows... *I.E. - Format is 04/01/2001* Search for Ads by date:

[PHP-DB] Php and Mysql: Aborted connection to mySQL with PHP4

I'm using Php 4.0.1 pl2-9 and Mysql 3.23.22 and gets the following error in Mysqls logfile: 010711 10:58:52 Aborted connection 381 to db: 'improvement' user: 'webusr' host: `web.local' (Got an error reading communication packets) After a while mysql doesn't accept more connection because it has

[PHP-DB] PHP and MYSQL

Hi all, I have a form where I collect some information and then that information is saved on a local db (mysql). The problem that I'm having is that when the server is up an running for few hours and when a user clicks the send button, my page take a long time to communicate with my database and

Re: [PHP-DB] PHP and MySQL

try the tutorial at www.thickbook.com or at www.devshed.com for setting everything up. olinux - Original Message - From: "Mike Corredea" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 19, 2001 10:02 AM Subject: [PHP-DB] PHP and MySQL >

Re: [PHP-DB] PHP and MySQL

Well, where did you install it? If the header files are under /usr/local/mysql/include and the library files are under /usr/local/mysql/lib (for example) then you would need to tell PHP to use --with-mysql=/usr/local/mysql since PHP needs to be able to find both the header and library files somew

[PHP-DB] PHP and MySQL

I just downloaded MySQL-3.23.36.tar (Which is the Source tar) from their site and I have php-4.0.4pl1. I have installed MySQL and it is ready to go. I know this for I can connect via the MySQL Monitor. When I try to configure php with the line "./configure --with-apache=/usr/local/apache_1.3.19 --

Re: [PHP-DB] PHP and MySQL

hi, you could do it in a easier way, first put real names for the fields in your form: login : group : password : , second you could do this: INSERT INTO $tabl

Re: [PHP-DB] PHP and MySQL

Hi, my exact problem is the following. Here is my form : login : group : password : when I put the data

RE: [PHP-DB] PHP and MySQL

Laurent, Show us the code/statements you are using. It is easier to help you that way. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 1:43 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP and MySQL Hi all, I have a few questions

[PHP-DB] PHP and MySQL

Hi all, I have a few questions about PHP and databases : - how do you insert a character string into a database when it is stored in an array ? For example I have the name of a person in an array called "$name" and when I insert it into the field "name" in my table, I get a field with "array

Re: [PHP-DB] PHP and MYSQL query

arço de 2001 16:57 Assunto: RE: [PHP-DB] PHP and MYSQL query > For starters, your statement is wrong... > > $result = mysql_query($strSQL, $db); > > where $db is your connection string to the database you already have opened. > > If you have problems with your sql statement, t

RE: [PHP-DB] PHP and MYSQL query

age- From: Jim Ray [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 8:03 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP and MYSQL query I have a simpe query that I can not seem to get to work. Here is the HTML side: Here is the PHP side: The fields are being past, but I get

Re: [PHP-DB] PHP and MYSQL query

First, try just calling the form action like: Turning the & into & chars (maybe my mail prog formatted it like this? ...nevertheless..) Also, try doing: $result=mysql_query("select * from $TA where $SortField='%".$search."%' order by $SortField"); --- David Balatero www.icegaming.com

[PHP-DB] PHP and MYSQL query

I have a simpe query that I can not seem to get to work. Here is the HTML side: Here is the PHP side: The fields are being past, but I get 0 in the results? $result=mysql_query("select * from $TA where $SortField='$search%' order by $SortField"); Am I missing something here? Thanks fo

Re: [PHP-DB] php and mysql file insertion!

ot; <[EMAIL PROTECTED]> Cc: "'Kevin Connolly'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, March 06, 2001 8:03 PM Subject: Re: [PHP-DB] php and mysql file insertion! > Couldn't you also just store the image on the server, then put the path t

RE: [PHP-DB] php and mysql file insertion!

;; '[EMAIL PROTECTED]' Subject: Re: [PHP-DB] php and mysql file insertion! Couldn't you also just store the image on the server, then put the path to the image (http://www.mysite.com/images/thatimg.jpg) in the database? -- David Balatero Rick Emery wrote: > Yes. There's a

Re: [PHP-DB] php and mysql file insertion!

-Original Message- > From: Kevin Connolly [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 06, 2001 1:39 PM > To: Rick Emery > Subject: Re: [PHP-DB] php and mysql file insertion! > > great thanks! > Will I be able to save different file types do you know? > wull it wor

RE: [PHP-DB] php and mysql file insertion!

Yes. There's another tutorial on the site which addresses that question. rick -Original Message- From: Kevin Connolly [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 06, 2001 1:39 PM To: Rick Emery Subject: Re: [PHP-DB] php and mysql file insertion! great thanks! Will I be ab

Re: [PHP-DB] php and mysql file insertion!

Kevin, You generally get much better performance naming and storing your file in a directory, keeping only the link in a text field in MySQL. (Or just about any other database for that matter.) Miles Thompson At 06:27 PM 3/6/01 +, Kevin Connolly wrote: >Hi, >I have a MySQL database that i

RE: [PHP-DB] php and mysql file insertion!

rom: Rick Emery Sent: Tuesday, March 06, 2001 1:23 PM To: 'Kevin Connolly'; '[EMAIL PROTECTED]' Subject: RE: [PHP-DB] php and mysql file insertion! http://www.weberdev.com/index.php3?GoTo=get_example.php3?count=1825 -Original Message- From: Kevin Connolly [mailto:

RE: [PHP-DB] php and mysql file insertion!

http://www.weberdev.com/index.php3?GoTo=get_example.php3?count=1825 -Original Message- From: Kevin Connolly [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 06, 2001 12:28 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] php and mysql file insertion! Hi, I have a MySQL database that is

[PHP-DB] php and mysql file insertion!

Hi, I have a MySQL database that is updated using a PHP script. It stores a members details (name, address etc.) I also want it to store a file (a member photo to be exact). Is this possible? Any help is much appreciated! Thanks, Kevin.