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

RE: [PHP-DB] CREATE TABLE QUERY PHP/MySQL

Granting access makes sense. Now what is the difference between the user information I put into the mysql_connect function and "PHP user"? If there is a difference , how would I grant the access via a query and how would it affect the new users who will use the application when it is given to

[PHP-DB] Unable to load dynamic library

Hi, PHP 4.2.3 is running with IIS 5 on W2k server. Oracle client v6 is installed and working properly. The error message is the following: PHP Warning: Unable to load dynamic library 'c:\php\extensions\php_oci8.dll' - The specified module could not be found. in Unknown on line 0 Also tried with ph

Re: [PHP-DB] CREATE TABLE QUERY PHP/MySQL

Very likely you have to GRANT the CREATE permission to your PHP user account. Also investigate the CREATE TEMPORARY TABLE grant status available since version 4+. Very convenient. Ignatius - Original Message - From: "Jonathan" <[EMAIL PROTECTED

Re: [PHP-DB] CREATE TABLE QUERY PHP/MySQL

On Saturday 07 December 2002 05:00, Jonathan wrote: > This is the first time I am trying to create a table in MySQL based on > user input. > > Here is the scenario, > > The user will enter in the name of a stage, e.g. Harley Davidson. > I then look for the first space (to indicate the first word),

[PHP-DB] Here goes!

Thanks a ton! The syntax ' ' was the problem- i have been stumped for 2 weeks and quite frustrated. Much appreciated all! John --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.426 / Virus Database: 239 - Release Date: 12/2/2002

[PHP-DB] CREATE TABLE QUERY PHP/MySQL

This is the first time I am trying to create a table in MySQL based on user input. Here is the scenario, The user will enter in the name of a stage, e.g. Harley Davidson. I then look for the first space (to indicate the first word), make it into lower case and then do the following: $new_stage_

RE: [PHP-DB] Here goes!

Or that too hehe -Original Message- From: Hutchins, Richard [mailto:[EMAIL PROTECTED]] Sent: December 6, 2002 3:51 PM To: 'John'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Here goes! You're missing the mysql_query($sql) or die(mysql_error()); to actually fire the data into the

RE: [PHP-DB] Here goes!

First off, Have you tried echoing the values upon submission to ensure they are being set in the form? Secondly, I would place all "data" code in another file for script processing - processRegistration.php would work well. If all values are being set... maybe look at: $sql="INSERT INTO model

Re: [PHP-DB] Return 1 instance of each unique record?

Thanks everyone... I find my problem often time is terminology. I am a FileMaker database developer and know the terminology of that database. I love MySQL, especially it's speed, but find crossing over sometimes difficult because the terminology is different and so I will do a search at MySQL o

RE: [PHP-DB] Here goes!

You're missing the mysql_query($sql) or die(mysql_error()); to actually fire the data into the db. Hope this helps. > -Original Message- > From: John [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 06, 2002 3:50 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Here goes! > >

[PHP-DB] Here goes!

Thanks all! Brand spanking new here to PHP so I will paste all the code below. I am using MySQL as my DB and i can modify the information with the same username and password that is in this code using a proprietary GUI administrator (navicat). Unfortunately it will not enter the info via this

Re: [PHP-DB] calling function on submit instead of going to a new script

or use javascript, this really keeps you on the same page -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Data not entering DB

Yes, and yes. -Original Message- From: John [mailto:[EMAIL PROTECTED]] Sent: Friday, December 06, 2002 2:41 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Data not entering DB Questions: Is this the right email addy to post help questions, and may I post the php code within the emai

RE: [PHP-DB] Data not entering DB

Sure thing, Give it a whirl. Aaron -Original Message- From: John [mailto:[EMAIL PROTECTED]] Sent: December 6, 2002 3:41 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Data not entering DB Questions: Is this the right email addy to post help questions, and may I post the php code within th

[PHP-DB] Data not entering DB

Questions: Is this the right email addy to post help questions, and may I post the php code within the email html? Thanks, John --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.426 / Virus Database: 239 - Release Date: 12/2/200

RE: [PHP-DB] Function questions...

Duh, OK. That fixed me right up. Thanks. Now if I can just figure out the 'Select All' option. -Original Message- From: Jason Wong [mailto:[EMAIL PROTECTED]] Sent: Friday, December 06, 2002 2:28 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Function questions... On Saturday 0

Re: [PHP-DB] Return 1 instance of each unique record?

Hi Doug, > How do I get MySQL to summarize a query so that I receive only 1 instance > per similar record. I.E. if you have 10 records with name "Smith" and 5 > records with "Barney, etc, that it would return 2 records instead of 15. Try the MySQL DISTINCT feature. =dn -- PHP Database Mailin

Re: [PHP-DB] Function questions...

On Saturday 07 December 2002 04:12, NIPP, SCOTT V (SBCSI) wrote: > OK. Stumped once again. This function is now properly generating > and displaying the form as I intend it to. The only problem is that the > optional text and button at the end of the function is actually displaying > above the c

Re: [PHP-DB] Return 1 instance of each unique record?

use GROUP BY field Adam On Fri, 6 Dec 2002, Doug Coning wrote: > Hi everyone: > > How do I get MySQL to summarize a query so that I receive only 1 instance > per similar record. I.E. if you have 10 records with name "Smith" and 5 > records with "Barney, etc, that it woul

Re: [PHP-DB] Return 1 instance of each unique record?

> How do I get MySQL to summarize a query so that I receive only 1 instance > per similar record. I.E. if you have 10 records with name "Smith" and 5 > records with "Barney, etc, that it would return 2 records instead of 15. This should be on a MySQL list... SELECT * FROM tbl WHERE ... GROUP BY

[PHP-DB] Return 1 instance of each unique record?

Hi everyone: How do I get MySQL to summarize a query so that I receive only 1 instance per similar record. I.E. if you have 10 records with name "Smith" and 5 records with "Barney, etc, that it would return 2 records instead of 15. Thanks! Doug Coning -- PHP Database Mailing List (http://w

RE: [PHP-DB] Function questions...

OK. Stumped once again. This function is now properly generating and displaying the form as I intend it to. The only problem is that the optional text and button at the end of the function is actually displaying above the choices provided in the while loop from the database. Please let

RE: [PHP-DB] Function questions...

Thanks guys. I was able to work through this issue pretty much on my own. I got this portion of things working nicely except for a form button that is appearing at the top rather than the bottom of the page. -Original Message- From: Mark [mailto:[EMAIL PROTECTED]] Sent: Friday, D

Re: [PHP-DB] Function questions...

$sys is an array, so echoing $sys will cause problems. Are you trying to get a 4xN table of values and checkboxes? There's got to be an easier way... --- "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]> wrote: > I am trying to convert something that I have working in a PHP > script > to be a fun

Re: [PHP-DB] MySQL Array

Try: $query = "INSERT INTO anagrafe (codice,nome, cognome, codicefiscale) VALUES ('" .strtoupper($codicefiscale) ."','{$NOME}','" .strtoupper($cognome) ."','" .strtoupper($co dicefiscale) ."', etc" then mysql_query ( $query ) ; Ignatius - Original

Re: [PHP-DB] MySQL Array

Hi, I want to insert the upper case of the strings written in the forn, so I put on the php file called these lines $NOME=strtoupper($nome); mysql_query ("INSERT INTO anagrafe (codice,nome, cognome, codicefiscale) VALUES ('strtoupper($codicefiscale)','$NOME','strtoupper($cognome)','strtoupper($

Re: [PHP-DB] MySQL Array

Mark, That was just about it. Once I moved the $c incrementor inside the loop it worked perfectly. $c = 0; print(""); while($row = mysql_fetch_array($dbResult)) { $c++; print("{$row['server_name']}"); if(($c % 4) == 0) { print(""); } } I appreciate yo

Re: [PHP-DB] Function questions...

I would replace $query = "SELECT * FROM accounts WHERE verifyurl='$safe_verify_string'"; by $query = "SELECT * FROM accounts WHERE verifyurl='{$safe_verify_string}'"; to force interpolation of variable $safe_verify_string HTH Ignatius - Original Me

[PHP-DB] Function questions...

I am trying to convert something that I have working in a PHP script to be a function in a library type of file. The code contained in the function works fine in another script, but I am currently getting no output from the function. I have a question about the nature of functions that ma

Re: [PHP-DB] mileage calculator

> I know a lot of sites, such as car dealerships, where you can put in your > zip code and then you can search for cars within 50,100, etc miles of your > house. How is this done? I have a site that we want to implement a feature > like this. What is stored in the db? Can I simply write a funct

[PHP-DB] mileage calculator

I know a lot of sites, such as car dealerships, where you can put in your zip code and then you can search for cars within 50,100, etc miles of your house. How is this done? I have a site that we want to implement a feature like this. What is stored in the db? Can I simply write a function usin

RE: [PHP-DB] MySQL Array

It's not incrementing $c. Start out with $c=0;, then Add $c++; after the while line (not after the whole while statement). Like this: $c = 0; print(""); while($row = mysql_fetch_array($dbResult)) $c++; { print("{$row['server_name']}"); if(($c % 4) == 0)

[PHP-DB] SapDB

In this moment i need odbc for access sapdb Databases. In php the development, is plan to have a sapdb extension ? Alejandro Michelin Salomon

[PHP-DB] SQL Error

Please help. I have a basic scipt: $connection_id=odbc_connect("$DSN","$user","$pass"); $sql="select * from whatever"; $stmt=odbc_prepare($connection_id,$sql); $result=odbc_execute($connection_id,$stmt); this script used to work on RH-7.3 with php-4.1.2 the script will not work anymore when i ins

RE: [PHP-DB] MySQL Array

You are right about my query. I am only pulling down one column. As you guys can probably tell I am pretty inexperienced with this. I tried what you said and still got the same results. Here are snippets of my code and maybe this will depict what I am doing wrong: After creating the connectio

[PHP-DB] Re: [PHP-DEV] RFC: ODBC and PHP

Dan Kalowsky wrote: On Tue, 10 Sep 2002, Shane Caraveo wrote: Hmm, is there no way to make the functions work with both odbc versions? Have an odbc_set_version(int) function that can set the version of odbc to use. The default can be version 3. This way, with the addition of a single functio

[PHP-DB] Re: NewB: Return New Record ID...

Try $last=mysql_insert_id(); Jochem Doug Coning wrote: Hi all, How do I do this: I need a PHP page that simply creates a "blank" record so that I have the record's ID (which is automatically generated). That same page then needs to return the record ID back so that I know what the ID is. I w