Re: [PHP-DB] Global query
At 04:05 04/04/2001 +0200, [EMAIL PROTECTED] wrote:
To do that, I expect to build the following database :
---
Date of the document|chapter| text
---
1999-02-25 |editorial | blablablabla...
| |...
| |blbalbal
---
1999-02-25 |policy | blablablabla...
| |...
| |blbalbal
I don't kow if you're giving us the total definition of your db here but in
that case, there are some points that are wrong. First, You should have an
id field in this table so that each texts has its own id. And by the way, I
would do several tables, not only one. For example, one table would contain
the definition of all the documents (id, title, creation_date, author,etc),
and another one would contain the chapters which would be linked to the
documents table by the text_id field (id, text_id, chapter_type,
chapter_title, chapter_text). For the chapter_type field, there are two
schools of thought about that. Either you put directly the type
("Editorial", "policy") in the field by defining it's a char field, or you
put an id field linked to another table containing the types of chapters
(id, chapter_type_str). Some people say that is useless, although it allows
you to change the name of a chapter only by changing one field value
instead of updating as much lines in your main db as there is of that
chapter type. I'm used to do that latter way.
Anyway, to sum it up, i'd have three tables to do your thing. But Maybe
some other people can think of better architecture. I just woke up and
didn't have my shower yet. And no, I'm not a nerd because I'm already
surfing right after waking up, I just happened to come on my computer to
check an important work mail before going to shower, and that's when I saw
this mail and decided to be a good samaritan today :)
What are my concerns :
Is a database done for this kind of thing ?
Yes, most definitely. Database are the way to go for such things. The
important keyword is good indexing thou :)
What is it better :
- to have the text of each chapter in the database (as above)
- to have one file for each chapter and only the adress of the file in the db
If you wanna be able to make a search in a particular type of chapters,
it'll be more efficient to split the texts in the database otherwise
you'll have to split it within your code which can be tricky and will
drastically alter the performance of your code.
To display correctly the text, line breakdown should be kept. Is it
possible to
keep them in the database ?
Yes, check out the strings functions in php, they should help you do that.
(nl2br() eg). You'll just have to put some \n in the database whenever
there needs a line feed.
Later dude
--
Chand
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] FREE LEADS FOR OUR GROUP!!
ATTENTION: ANY SERIOUS NETWORK MARKETER TAKE A LOOK AT THE FOLLOWING OPPORTUNITY I CAME ACROSS!! IF YOU PLUG INTO THEIR PROVEN SYSTEM, THEY GUARANTEE YOU SUCCESS, AND PROVIDE YOU WITH FREE LEADS TO BUILD YOUR GROUP!! DO NOT LET THIS SLIP AWAY!! CLICK BELOW AND FIND OUT AS I DID, WHY THESE GUYS ARE THE LEADERS IN THE INDUSTRY!! http://www.geocities.com/wealthclub8989 * THIS EMAIL COMPLIES WITH ALL REGULATIONS. TO BE REMOVED WITHIN 24 Hours, SIMPLYEMAIL [EMAIL PROTECTED] FOR IMMEDIATE REMOVAL FROM ANY FUTURE EMAILS FROM OUR COMPANY. * -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Is Sybase supported on Windows?
Hello, I'm trying to connect via PHP to Sybase from Win'98 Having Personal Web Server and I get the following error: Fatal error: Call to unsupported or undefined function sybase_connect() I haven't found any dll named *sybase* for Windows. Is there any way of supporting Sybase? Please help me. Many thanks, Javier
[PHP-DB] Fatal error: Call to unsupported or undefined function mysql_connect()
Can anybody help me with this problem
Fatal error: Call to unsupported or undefined function mysql_connect() in
dbopen.php on line 7
$server = "localhost";
$user = "dbuser";
$password = "pass";
$db = mysql_connect($server, $user, $password); -- This is line 7 of my
script
$select = mysql_select_db("intranet", $db);
Thanks,
Patrick
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Fatal error: Call to unsupported or undefined function mysql_connect()
Hello...
Either the Username or Password or Database does not exist...
Do this
$db = mysql_connect(server, $user, $password)
or die ("Sorry something is wrong");
$select = mysql_select_db("intranet", $db);
or die ("Sorry something is wrong");
That way you can see if it connects and or if the Database does
exist.
You can also delete $select as well so it would read.
mysql_select_db("intranet", $db);
or die ("Sorry something is wrong");
That what I use
That really might be the problem..
Learn how to put in debug stuff. It's easier to see your
mistakesI know I had a bunch...
Dan
--
From: Patrick Schfer
Sent: Wednesday, April 4, 2001 7:41 AM
To: PHP
Subject: [PHP-DB] Fatal error: Call to unsupported or undefined
function mysql_connect()
Can anybody help me with this problem
Fatal error: Call to unsupported or undefined function mysql_connect()
in
dbopen.php on line 7
$server = "localhost";
$user = "dbuser";
$password = "pass";
$db = mysql_connect($server, $user, $password); -- This is line 7 of
my
script
$select = mysql_select_db("intranet", $db);
Thanks,
Patrick
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail:
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Prob with Ingres II (apache DSO) (on SuSe 7.1)
Actually, I don't know if this is a PHP problem, or an Apache problem. I'm trying to create a 'libphp4.so', including Ingres support (-with-ingres= ), and everything on the PHP side seemedto go ok - no errors in the make. But an ./apahectl configtest gives this: Syntax error on line 205 of .. httpd.conf Cannot load ... libphp4.so into server: undefined symbol: CM_CaseTab Any ideas anyone? thanks a lot gordon gallacher inverness, scotland (Environment: SuSe Linux 7.1; Apache 3.1.19, PHP 4.0.4pl1; Ingres II) PS without Ingres, the dso for php4 works fine ... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] [BUG?] pg_fetch_array
I have a database running on PostgreSQL. My script runs an SQL query and then retrieves the data with calls to pg_fetch_array. It then stores each record for later use, looking it up in memory. What I have found is that pg_fetch_array is not reliable in terms of the key name in the associative array. To test this I retrieved data using a call to pg_fetch_array and then used the following code shown in the PHP help file to print out the fields and their data: while (list ($key, $val) = each ($row)) echo "$key = $valbr"; This will return each field twice: once with a numeric key, and once with a named key. However in some cases the named key does not return any data. Here is an example: 0 = 27 scheduleid = 27 1 = M10V PMT displaytext = M10V PMT 2 = Mitre 10 Visa Payment Due descriptext = 3 = https://sec.westpactrust.co.nz/servlet/Banking?xtr=Logon url = 4 = t current = t 5 = f reminder = f 6 = hideinsummary = 7 = 35 occurrid = 35 8 = 27 9 = 26/12/2000 occurdate = 26/12/2000 10 = 00:00:00 starttime = 00:00:00 11 = 00:00:00 endtime = 00:00:00 12 = t allday = t 13 = 3 importance = 3 14 = repeats = 15 = 16 = There are 17 fields in the result set (correct). You can see the problem occurring in field 2 and 3. The numeric key returns values but the named key doesn't. This doesn't occur on every single record, only on some records. The other problem is that there is no named key for when the same field name is returned a second time. Postgres names these fields the same except it adds "_1" on the end of the name. But this is evidently left unresolved by PHP. Fields 8, 15 and 16 are examples. The only reliable way I can see of being able to retrieve the data is to use numbered rather than fieldname references. It only seems to apply to a few fields and is without logic, since in some cases it does dereference correctly. -- === Patrick Dunford, Christchurch, NZ - http://pdunford.godzone.net.nz/ Rejoice in the Lord always. I will say it again: Rejoice! -- Philippians 4:4 http://www.heartlight.org/cgi-shl/todaysverse.cgi?day=20010404 === Created by Mail2Sig - http://pdunford.godzone.net.nz/software/mail2sig/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] mysql_result()
-Original Message- From: Jordan Elver [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 10:46 AM To: PHP Database Mailing List; PHP General Mailing List Subject: [PHP-DB] mysql_result() If I knnow that a query will only retrun one row, can I do this (below) rather than using a while loop for one record? $id = @mysql_result($result, 0, 'id'); $name = @mysql_result($result, 0, 'name'); $email = @mysql_result($result, 0, 'email'); $address1 = @mysql_result($result, 0, 'address1'); $address2 = @mysql_result($result, 0, 'address2'); $town_city = @mysql_result($result, 0, 'town_city'); $postcode = @mysql_result($result, 0, 'postcode'); Looks reasonable to me...what happens when you try it? --- Mark Roedel ([EMAIL PROTECTED]) || "There cannot be a crisis next week. Systems Programmer / WebMaster || My schedule is already full." LeTourneau University ||-- Henry Kissinger -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Method POST not allowed
Someone can tell me how can i resolve the problem in the subject i ve a form with a peace of code in php calling a mysql db, when i press submit the apache server returns me that error: 450 Method not allowed The requested method is not allowed to this URL Ill appreciate any kind of help, Thanks in advance, Gabriel. *** END FORWARDED MESSAGE *** -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] SELECT statement
Hi--
Every time I run the following code, I get this error if I use a NUMBER for
the 'Email' case:
"Warning: Unable to jump to row 0 on PostgreSQL result index 2 in
/html/rccd/remodel/display2.php on line 35"
or, if I use a string (i.e. [EMAIL PROTECTED]), I get this error message:
"Warning: PostgreSQL query failed: ERROR: Attribute 'jcuz' not found in
/html/rccd/remodel/display2.php on line 33"
Please help!
switch ($Search) {
case "WO":
settype ($find,integer);
$sql = "SELECT * FROM \"Remodel\" WHERE \"WO\" LIKE $find";
break;
case "Email":
$sql = "SELECT * FROM \"Remodel\" WHERE \"Email\" LIKE $find";
break;
}
--
Julio Cuz, Jr.
Riverside Community College
[EMAIL PROTECTED]
Re: [PHP-DB] SELECT statement
Ron, Thanks for your help, but my problem still there even when I made the following changes: $sql = "SELECT * FROM \"Remodel\" WHERE Email=\"".$find."\""; By the way, you're correct when saying that "WO" and "Email" are column names and '"$find" is what the user entered when searching for a record. At 03:39 PM 4/4/2001 -0700, you wrote: At 03:24 PM 4/4/2001 -0700, Julio Cuz, Jr. wrote: Every time I run the following code, I get this error if I use a NUMBER for the 'Email' case: "Warning: Unable to jump to row 0 on PostgreSQL result index 2 in /html/rccd/remodel/display2.php on line 35" The problem is that your query is equivalent to going: SELECT * FROM "Remodel" WHERE "WO" LIKE 1; // or some other numerical value The "WO" is a string because it is in quotes so you are saying: WHERE string = integer Ain't gonna happen so the result is always empty. What you want probably is (assuming WO is a column name): $sql = "SELECT * FROM \"Remodel\" WHERE WO=\"".$find."\""; It is equals since you are using an integer instead of a string (like is for strings). or, if I use a string (i.e. [EMAIL PROTECTED]), I get this error message: "Warning: PostgreSQL query failed: ERROR: Attribute 'jcuz' not found in /html/rccd/remodel/display2.php on line 33" Same problem. "EMAIL" means the string "EMAIL" not the column called "EMAIL". Cheers, Ron - Island Net AMT Solutions Group Inc. Telephone: 250 383-0096 1412 Quadra Toll Free:1 800 331-3055 Victoria, B.C. Fax:250 383-6698 V8W 2L1 E-Mail:[EMAIL PROTECTED] Canada WWW: http://www.islandnet.com/ - Julio Cuz, Jr. Riverside Community College [EMAIL PROTECTED]
RE: [PHP-DB] Fatal error: Call to unsupported or undefined functi on mysql_connect()
On 4 Apr 2001 06:54:45 -0700 AD in php.db, Brunner, Daniel said:
Hello...
Either the Username or Password or Database does not exist...
NO!.
"Call to undefined function" means it doesn't know the name of the function
you are calling.
if the function name is correct you either need to load a mySQL library for
PHP using the dl statement or you need to compile PHP with mySQL support
enabled.
Check with your server administrator.
Do this
$db =3D mysql_connect(server, $user, $password)=20
or die ("Sorry something is wrong");
$select =3D mysql_select_db("intranet", $db);
or die ("Sorry something is wrong");
That way you can see if it connects and or if the Database does
exist.
You can also delete $select as well so it would read.
mysql_select_db("intranet", $db);
or die ("Sorry something is wrong");
That what I use
That really might be the problem..
Learn how to put in debug stuff. It's easier to see your
mistakesI know I had a bunch...
Dan=20
--
From:Patrick Sch=E4fer
Sent:Wednesday, April 4, 2001 7:41 AM
To: PHP
Subject: [PHP-DB] Fatal error: Call to unsupported or undefined
function mysql_connect()=20
=20
Can anybody help me with this problem
=20
Fatal error: Call to unsupported or undefined function =
mysql_connect()
in
dbopen.php on line 7
=20
$server =3D "localhost";
$user =3D "dbuser";
$password =3D "pass";
$db =3D mysql_connect($server, $user, $password); -- This is line 7 =
of
my
script
$select =3D mysql_select_db("intranet", $db);
=20
Thanks,
Patrick
=20
=20
--=20
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail:
[EMAIL PROTECTED]
=20
=20
--
===
Patrick Dunford, Christchurch, NZ - http://pdunford.godzone.net.nz/
Rejoice in the Lord always. I will say it again: Rejoice!
-- Philippians 4:4
http://www.heartlight.org/cgi-shl/todaysverse.cgi?day=20010404
===
Created by Mail2Sig - http://pdunford.godzone.net.nz/software/mail2sig/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Is Sybase supported on Windows?
On 4 Apr 2001 04:12:37 -0700 AD in php.db, Javier Boluda said: Hello, I'm trying to connect via PHP to Sybase from Win'98 Having Personal Web Server and I get the following error: Fatal error: Call to unsupported or undefined function sybase_connect() I haven't found any dll named *sybase* for Windows. Is there any way of supporting Sybase? There is a DLL in extensions calls php_sybase_ct.dll You either need to compile in support for sybase with PHP or dl a dynamic library. -- === Patrick Dunford, Christchurch, NZ - http://pdunford.godzone.net.nz/ Rejoice in the Lord always. I will say it again: Rejoice! -- Philippians 4:4 http://www.heartlight.org/cgi-shl/todaysverse.cgi?day=20010404 === Created by Mail2Sig - http://pdunford.godzone.net.nz/software/mail2sig/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Oracle vs MS SQL vs MySQL
Hey, Has anyone tried out all three of these DBMS packages and evaluated them? I was wondering what everyone is having the best luck with when writing PHP scripts. I'm using Oracle8i and if you don't mind, it's a pain in the tail. :-P While I'm asking, let's not limit it to just those three, if anyone is overwhelmingly pleased with something else, name it please! :-) Thanks, Brian -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Passing parameters
if ($btnChoice = 'Save'){
Do something
}elseif ($btnChoice = 'Delete') {
header("Location: MemberAdmin.shtml");
exit;
}
use == instead of =
--
++
| Julie Meloni ([EMAIL PROTECTED]) |
||
| "PHP Essentials" and "PHP Fast Easy" |
| http://www.thickbook.com |
++
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Global query
Thanks to Brian, Chand and Andi for their comments. Yes Andi, it is exactely what I am looking for ! I would be more than happy to receive this code. Thanks. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Saving email address with @ in it
Jim Ray wrote: Can anyone tell me if this is correct? Or can someone tell me how to save a field with an @ in it? You certainly can safe a field with a @ in it, just use the addslashes() function on the string before you do the insert. eg: $string = addslashes($string); this will basically escape any command characters with a backslash, or you could do it manually. Cheers Tim -- | Disclaimer:| Timothy Aslat [EMAIL PROTECTED] | | The sender of this email is a figment | http://www.goodiesruleok.com | | of a deranged imagination and leaves it| Spyderweb Consulting | | to your own devices to decide whose... | P: 82270800M: 0401088479 | -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Varible insert
Hi People, It seems like all I am doing lately is going into areas of php that I haven't done before and get stuck. Anyway, here is another small request that I have. I have a series of pages that must insert into a mysql database the results of the entries. I know how to insert these details into a database, however there are over 200 entries across 20 or so pages. What I am in need of doing is the following: Is there a way of creating one insert statement that can be used by all pages to insert the data from the fields into the appropriate fields in the database? ie the sql insert statement is dynamic and will adapt. I have an idea that maybe the "get" method on the form will be of some help, but not sure. Any ideas etc would be helpful. - Shannon -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Oracle vs MS SQL vs MySQL
Hi Brian, At 7:24 PM -0500 4/4/01, Brian.J.Mauter wrote: Hey, Has anyone tried out all three of these DBMS packages and evaluated them? well not all of them :) I was wondering what everyone is having the best luck with when writing PHP scripts. On that level it doesn't make much difference to me I'm using Oracle8i and if you don't mind, it's a pain in the tail. :-P Kinda wondering what in particular is a PIA about it, apart from the knowledge level required to install, configure and tune Oracle !! While I'm asking, let's not limit it to just those three, if anyone is overwhelmingly pleased with something else, name it please! :-) MySQL - best price :) , very fast when doing reads, not very good when a lot of writes are happening, lacking in some fundamental features eg foreign keys etc. Integrates well with PHP. PostGres - no experience , but V7 seem to be getting very good reviews, I am going to try it out very soon now. Oracle - the "18 wheeler" of the RDBMS world. Expensive but highly scaleable, full featured , excellent security etc. It needs a fair amount of knowledge to really get it happening though. PHP integrates well, including with stored procedures. So IMHO it's a matter of "horses for courses" i.e. choosing the right tool for the job. Thanks, Brian HTH Steve Farmer -- --- "Minds are like parachutes, they work best when open" Support free speech; visit http://www.efa.org.au/ Heads Together Systems Pty Ltd http://www.hts.com.au Email: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Microsoft Access DB PHP
Hello List, I have a query in regards to using PHP to only retrieve records from a Microsoft Access Database. I would like to know whether it is possible to do so with PHP and not have to change completely and use ASP. Cheers, James -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Good PHP MySQL Host in India
Hello, Are there any Indian Developers here who can suggest a good hosting company in India which gives MySQL and PHP. I have been hosting with Delhinet for two years .. now they have suddenly changed their hosting plans a lot which are now are very restrictive and costlier. Jaskirat. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Oracle vs MS SQL vs MySQL
Brian, To echo your other replies, there is always a trade-off between cost, ease of mainenance, usability, and functionality. PHP seems to go quite hand-in-hand with MySQL, despite some limitations. I'd take a look at the MySQL site and see first if you can live with those limitations. Ive been living in an ASP/Access world for the past year, for mostly "light" internet and intranet applications. Due to the mainfame side of our IS dept. and the fact that we have a Data Adminstration dept. that is dedicated to IBM's DB2, we are required to use the DB2 UDB database (a DB2 server on PC, if you will) for future development. Best I can say here to anyone is "stay away"! My vote is with MySql, unless you'vegot to do triggers, sub-selects, or views, or simply have to create work for a pre-existing DBA Phil J. "Brian.J.Mauter" wrote: Hey, Has anyone tried out all three of these DBMS packages and evaluated them? I was wondering what everyone is having the best luck with when writing PHP scripts. I'm using Oracle8i and if you don't mind, it's a pain in the tail. :-P While I'm asking, let's not limit it to just those three, if anyone is overwhelmingly pleased with something else, name it please! :-) Thanks, Brian -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Varible insert
Hmmm...given that the form fields all had the same names - i.e. you were performing the same sql, you could use and include or "required" file that did all the DB work. Or - you could have a generic includr file function that you passed a connectstring and sqlstring to as variables Phil J. Shannon Doyle wrote: Hi People, It seems like all I am doing lately is going into areas of php that I haven't done before and get stuck. Anyway, here is another small request that I have. I have a series of pages that must insert into a mysql database the results of the entries. I know how to insert these details into a database, however there are over 200 entries across 20 or so pages. What I am in need of doing is the following: Is there a way of creating one insert statement that can be used by all pages to insert the data from the fields into the appropriate fields in the database? ie the sql insert statement is dynamic and will adapt. I have an idea that maybe the "get" method on the form will be of some help, but not sure. Any ideas etc would be helpful. - Shannon -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] OT - Domain Registrars
I'd have to definately agree. Avoid NS at all costs. If you want to be able to change your records in about ten minutes go with register.com or I use urlbuyers.com (and register.com but am in the process of moving everything of mine over to consolidate. A client registered with NS spent a week trying to move their domain. I was on the phone for atleast an hour trying to get things straight for him. Not much luck. The process is just too involved for what it's worth. Once you've done it though, I think it's a one day affair waiting for the confirmations and reconfirming. "B. van Ouwerkerk" wrote: I am about to need to re register some domains and i note that there seem to be some other registrars, such as domainzoo.com and godaddy.com offer much better pricing than network solutions, anybody have any experience with other registrars, good or bad? I'm currently working with register.com .. they are pretty good I think.. seems that dotster.com (or is it dotstar.com isn't bad.. not had a change to try them.. One of my friends had to fight network solutions to transfer his domain to another ISP.. with register.com it's easy.. They are more working to gain marketshare than the big old networksolutions. Bye, B. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] mysql_result()
Jordan, If you know your result is going to product one row, try using: $row=mysql_fetch_array($result, MSQL_ASSOC); // returns an assoc array where the field names are keys, field value is value $id=row[id]; $name=row[name]; etc. Best regards, Andrew -- Andrew Hill - OpenLink Software Director Technology Evangelism eBusiness Infrastructure Technology http://www.openlinksw.com -Original Message- From: Jordan Elver [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 11:46 AM To: PHP Database Mailing List; PHP General Mailing List Subject: [PHP-DB] mysql_result() Hi, If I knnow that a query will only retrun one row, can I do thiss (below) rather than using a while loop for one record? $id = @mysql_result($result, 0, 'id'); $name = @mysql_result($result, 0, 'name'); $email = @mysql_result($result, 0, 'email'); $address1 = @mysql_result($result, 0, 'address1'); $address2 = @mysql_result($result, 0, 'address2'); $town_city = @mysql_result($result, 0, 'town_city'); $postcode = @mysql_result($result, 0, 'postcode'); Cheers, Jord -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] mysql_result()
Hi, If I knnow that a query will only retrun one row, can I do thiss (below) rather than using a while loop for one record? $id = @mysql_result($result, 0, 'id'); $name = @mysql_result($result, 0, 'name'); $email = @mysql_result($result, 0, 'email'); $address1 = @mysql_result($result, 0, 'address1'); $address2 = @mysql_result($result, 0, 'address2'); $town_city = @mysql_result($result, 0, 'town_city'); $postcode = @mysql_result($result, 0, 'postcode'); Cheers, Jord -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
