RE: [PHP-DB] database abstraction for php3

I use the CDBAbstract but don´t know if it is possible to use it with PHP3 ... Just give it a try Go to http://www.zend.com/codex.php?id=105&single=1 Although I have changed it a bit to fit my needs the version you get there is quite good ... Cheers, Marcel > -Original Message- > From:

Re: [PHP-DB] Problem with my first script

on 6/24/01 7:23 PM, Fernando Gonzalez at [EMAIL PROTECTED] wrote: > I have eliminate the space but still the same message. > $myrow=mysql_fetch_array ($result); > Fatal error: Call to undefined function: array() in > /home/fergonza/mod_php4/index.php on line 18 I wonder if somehow you have an

Re: [PHP-DB] Problem with my first script

1. safe to assume that there is a column named "nombre"? 2. try using index numbers instead, i.e;, instead of $myrow("nombre"), try $myrow(1)... Fernando Gonzalez wrote: > > Thanks, but it wont work. > I have eliminate the space but still the same message. > I have realized that the problem i

RE: [PHP-DB] Problem with my first script

Thanks, but it wont work. I have eliminate the space but still the same message. I have realized that the problem is below that line: the problem is pointing to the line where i fetch the first variable: $nombre=$myrow("nombre"); Any other Ideas thanks "; $link = mysql_connect ("localhos

RE: [PHP-DB] Problem with my first script

Thanks, but it wont work. I have eliminate the space but still the same message. I have realized that the problem is below that line: the problem is pointing to the line where i fetch the first variable: $nombre=$myrow("nombre"); Any other Ideas thanks "; $link = mysql_connect ("localhos

Re: [PHP-DB] search form

ot reply: use a text-indexing database, pass it a stored procedure against the index. not php, but it'll work. also, xml compliant pages will allow you to search them via xpath. cheers, jaxon On Tuesday, July 24, 2001, at 07:43 PM, olinux wrote: > Build the keywords for the static pages into

Re: [PHP-DB] HELP!! - Search

UMMM... can you be a little bit more specific? what section aint working? error messages??? Matthew Cothier wrote: > > Whats wrong with this?? Its not working... > {snippage}... -- Leo G. Divinagracia III [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsub

RE: [PHP-DB] Problem with my first script

$myrow=mysql_fetch_array ($result); Remove the space in the function call and it should work fine for you ie. $myrow=mysql_fetch_array($result); Sincerely, Craig Vincent -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e

RE: [PHP-DB] search form

Build the keywords for the static pages into the existing db table. a lot of work so you will have to remember to delete changed/delete url's olinux -Original Message- From: J- E- N [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 2:48 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] s

Re: [PHP-DB] Question regarding php and mysql with binary data...

the web page that is generated, does the HREF tag supply a name? and at least for my netscrape 4.7x, whenever i right click on an image, it uses that name on the dialog box that pops up, prompting me where and how to save it as... btw, why save images on a table? wouldnt saving the URL better?

Re: [PHP-DB] log out

if you are tracking the sessions by a unique value, say their username, then check if the session is still alive each they log in... otherwise, start a new one. but the trick is the unique value... deco wrote: > >Well, i'm having some trouble in here and i hope someone can help me... > >

Re: [PHP-DB] Problem with my first script

i havent tested it yet... but... Fernando Gonzalez wrote: > > $num=mysql_num_rows($result); > $cur=1; > while($num>=$cur){ > $myrow=mysql_fetch_array ($result); ^^ you got a space after the function and the open paren. NO SPACES (as i found before

[PHP-DB] Problem with my first script

I'm trying to retrieve data from a MySql Database I have the following php script: "; $link = mysql_connect ("localhost:3306", "root", "") or die ("Could not connect"); print ("Connected successfully"); mysql_select_db ("seguros"); $sql="select * from mae_companias"; $result=mys

[PHP-DB] Re: php script showing up on web page!!!!

Well unless you set up your webserver to parse .htm pages then your code will not be parsed and is displayed as plain text. -- phill "Tony" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Here is the link to the problem page, > http://www.youngsmall.com

[PHP-DB] another php/mysql problem

hello again. i seem to be absolutely stumped on this one, it's even hard for me to explain, i'll do my best though. ok, so what i need to do essentially is have the bands.php?band=thebandsname thing which the isset at the top of the code does. then i need $band_spaces to equal $artist and $artis

[PHP-DB] php script showing up on web page!!!!

Here is the link to the problem page, http://www.youngsmall.com/cgi-local/shop.pl/page=index222.htm This PHP script shows up below "buy now" button. Can anybody tell me what I am doing wrong? This is script that I am using on each buy buttons, Unable to locate the inventory " . "databas

RE: [PHP-DB] mysql and oracle outer join syntax

In Oracle, the syntax for a theta-style join (the one you're describing) is: SELECT ... FROM ... WHERE item1 (+) = item2 However, MySQL doesn't support this syntax. The only way to do left (outer) joins in mysql is the way you described: SELECT ... FROM ... LEFT JOIN ... ON ... = ... -O

[PHP-DB] Quick mysqld question...

I recently installed PHP4, Apache, and MySQL on my computer for various reasons. Everything was working smoothly for a while, but today when I tried to start mysqld I got this error message: Can't initialize InnoDB as "innodb_data_file_path" is not set. Any idea what this means, and how I can f

[PHP-DB] Oracle 9i Support

Hello, I am trying to use php 4.0.6 with an Oracle 9i database. Using the --with-oci8 compile option does not seem to work as it gives me the following message: checking Oracle version... configure: error: Oracle-OCI8 needed libraries not found Is there any way I can "trick" php (or oracle) i

[PHP-DB] mysql and oracle outer join syntax

hello all. i have a question - but first some background... the standard LEFT JOIN syntax is something like this: SELECT t1.a, t1.b, t1.c, t2.d, t2.e FROM table1 t1 LEFT JOIN table2 t2 ON t1.x = t2.x WHERE t1.a = 'some condition or another'; i much prefer to do LEFT JOINs like this however: S

RE: [PHP-DB] 'htaccess" method : how to modify passwords from PHP scripts ?

There is a fantastic class that takes care of writing .ht* files... look here: http://phpclasses.upperdesign.com/ -Original Message- From: Samuel Torton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 6:40 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] 'htaccess" method : how to modi

Re: [PHP-DB] Dynamic Links

In view.php, you'd do something like this: $qry = "SELECT * FROM inv_table WHERE machine_name='$machine_name'"; Execute the query, display the results. $machine_name will contain the value of the string passed in through your link (eg. href='view.php?machine_name=lab01' - $machine_name in view.p

[PHP-DB] Re: forming a multi-dimensional from a MYSQL DB QUERY

You've got to call it by $tbl[0]["hardware"] greetings Thomas -- -- 4Ws Netdesign GbR www.webinside.de... ..wir machen Homepages -- "Cody Caughlan" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED]... > Hello, > > I am implementing an "excel" like webpage, that is multiple box

[PHP-DB] log out

Well, i'm having some trouble in here and i hope someone can help me... I'm using sessions to keep track of users on my website... Using this, i'm able to display the name of the users that are currently online... Here's the thing... When users get on the site a new session is opened an

[PHP-DB] Dynamic Links

I think this topic was discussed before. But I couldn't find it in the archive. I have this table mysql> desc inv_table; +--+--+--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-+--

[PHP-DB] test

pls ignore ) (( |""|-. | :|/' -`--'- -- 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] database abstraction for php3

Hi, Can anyone suggest a good (and simple) database abstraction class for php3? I have been using ADODB, but it doesn't like php3. Thanks - Geoffrey Makstutis <[EMAIL PROTECTED]> 51% Studios Architecture + Design 1-5 Clerkenwell Road London EC1M 5PA

Re: [PHP-DB] search form

You'll need to write two search engines - one for the db, one for the static pages. Then combine the results on your results page. I'm looking at having to do the same thing, and can't think of a different way of doing it offhand. J- E- N wrote: > i have a search form and i want it to search the

RE: [PHP-DB] Counting Number of Instances in a One2Many Relationships

> I'd like a simple query to determine how MANY books in a > database are released by A publisher. [...] > The relevant table's here: > Suggestions are appreciated! SELECT publisherID,count(*) FROM WLPbib GROUP BY publisherID; That query is only acceptable if you want a list of all the pu

[PHP-DB] MS SQL datetime format problem

Hi, I am having trouble setting a datetime in a ms sql database. I can put in a date, but when I add the time i always get an error. this is likely something simple, any thoughts? thanks --Brian -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED]

RE: [PHP-DB] Counting Number of Instances in a One2Many Relationships

On Monday, July 23, 2001 at 9:54 PM (ahem, set your clock!), Mike Gifford said: > I'd like a simple query to determine how MANY books in a > database are released by A publisher. [...] > The relevant table's here: > > CREATE TABLE WLPbib ( > bibID mediumint(9) NOT NULL, > languageID

[PHP-DB] Question regarding php and mysql with binary data...

Hello Again everyone... My question is simple... I have images submited IN my mysql Database. What i want is when i display them and i right click on them and choose save picture as i can get the name of the picture from the DB and not have to insert it my self. Does anyone now how can i do tha

[PHP-DB] 'htaccess" method : how to modify passwords from PHP scripts ?

Hi all, I use a Linux platform, Apache, and PHP4. I use "htaccess" method in order to have restricted accesses, and I handle my users via a PHP interface. - when I want to create a new user, I generate a string such as "username:cryptedpassword", and I insert it at the end of my ".htpasswd" fi

[PHP-DB] HELP!! - Search

Whats wrong with this?? Its not working... >>Search.php Could not get record."; } if(mysql_num_rows($result)) { $uid = 1; while($row = mysql_fetch_row($result)) { print("$row[1]$row[2]"); $uid++; } } ?> >>Search Boolean file I was told to use ## I don't even get these i

Re: [PHP-DB] phpmyadmin troubles - creating tables

On Tue, Jul 24, 2001 at 01:07:51AM -0500, olinux wrote: > OK, I have no idea why but i have spent the past hour trying to create this > stupid table. I am using the latest version of phpmyadmin. I created the > query several times thru the interface and then played with the query in the > textbox.

RE: [PHP-DB] phpmyadmin troubles - creating tables

you need INT(16) or something, as in in phpmyadmin, enter an integer for the size of the field as well when defining it :) // -Original Message- // From: olinux [mailto:[EMAIL PROTECTED]] // Sent: Tuesday, 24 July 2001 2:08 PM // To: php-db // Subject: [PHP-DB] phpmyadmin troubles - creat

[PHP-DB] phpmyadmin troubles - creating tables

OK, I have no idea why but i have spent the past hour trying to create this stupid table. I am using the latest version of phpmyadmin. I created the query several times thru the interface and then played with the query in the textbox. I need help badly. CREATE TABLE users (id INT (9) not null ,

Re: [PHP-DB] line breaks in mySQL text fields

Hi, You could put "\n" where you want the new line. Than if you want to output the text field in HTML you could use nl2br() to replace the new line characters with For example take a look at this INSERT query: $sql= "INSERT INTO table_name (text_field,...other_fields) VALUES ('first row\nsecond

[PHP-DB] search form

hello everyone, i have a search form and i want it to search the entire site. what will i do if not all the information in my site came from the database ... thanks