[PHP-DB] Re: [PHP] reading a URL...

2001-03-27 Thread Renze Munnik
Here's the mail I sent yesterday right after your question. I sent it to the general PHP list (you posted it there). But obviously your never read that list. Don't post any questions there then. There are people putting time in answering your questions, so you have to make sure they don't do this

Re: [PHP-DB] Indexing help

2001-03-27 Thread Steve Brett
replies below: ""M. Verheijen"" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Dear reader, A newbie mysql/php-question here! I've filled a mysql-database with about 1600 records. All these records contain items which are on sale on a website. Every row contains

[PHP-DB] get_browser()

2001-03-27 Thread Simon R Jones
hi all how does everyone feel about the get_browser function?? Is the general impression it's overkill, and also flawed since it depends on the browser.ini file being up to date, or it is widely used? I'm about to need to use browser detection I'm wondering if a simple

RE: [PHP-DB] get_browser()

2001-03-27 Thread Steve Brett
i use get_env("HTTP_USER_AGENT") to log browser types and it works fine. to be hones i didn't know about the get_browser function ... user agent suplies loads of info though about browser, platform etc. Steve Brett Internal Development EMIS Ltd. "Privileged and /or Confidential information

RE: [PHP-DB] table 1 to table 2

2001-03-27 Thread Michael Rudel
I was thinking that MySQL doesn't support subselects ?! Or is there a new MySQL-Version which does support them ? Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - ___ Suchtreffer AG Bleicherstrae 20 D-78467

[PHP-DB] Re: How to print last row in an array using WHILE?

2001-03-27 Thread Jon Valvatne
What you are missing is the first row, not the last row. To explain: mysql_fetch_row() operates with an internal pointer which moves one step down the result set with each call to the function. The first time it is called, it returns the first row, and moves its pointer to the second row. The

[PHP-DB] Re: Betr.: [PHP-DB] Structure Question

2001-03-27 Thread Jordan Elver
I thought that it was good db design to have no repeating data in your db but to use a relationship instead? Jord On Tuesday 27 March 2001 14:42, you wrote: Jord, I don't see quite why you should want to use two tables, you can easily put all the information in one table and have one

Re: [PHP-DB] Structure Question

2001-03-27 Thread [EMAIL PROTECTED]
Why don't you just store the file names in a db? iets much easyer Hi, I want to keep filenames of different kinds of media(real sudio, qt, mp3) for articles in a db table. Would it be best to store each kind of media in a different table like one table for real audio, one for quicktime,

Re: [PHP-DB] Structure Question

2001-03-27 Thread Jordan Elver
I am. Jord On Tuesday 27 March 2001 14:06, you wrote: Why don't you just store the file names in a db? iets much easyer Hi, I want to keep filenames of different kinds of media(real sudio, qt, mp3) for articles in a db table. Would it be best to store each kind of media in a

Re: [PHP-DB] SQL Select?

2001-03-27 Thread Jason Stechschulte
On Sat, Mar 24, 2001 at 08:55:13PM -, Grant wrote: Is there any way of using a string in an SQL query instead of using the table name. Something along the lines of $result=mysql_query("SELECT * FROM $tablename",$db); this doesnt work it come up with a parse error Your problem is

[PHP-DB] MySQL manager

2001-03-27 Thread Rosen
Hi, can anybody tell me for some cool MySQL database manager ? Thanks, Rosen Marinov -- 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 manager

2001-03-27 Thread Rubanowicz, Lisa
www.mysqlfront.de I have used it and found it to be great. However I am a beginner and if there is a better product please let me know. All the best Lisa -Original Message- From: Rosen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 3:26 PM To: [EMAIL PROTECTED] Subject:

AW: [PHP-DB] Structure Question

2001-03-27 Thread Stefan Siefert
I think you should store all files in a table with an extra table with the filetypes (like you suggest in the end of your mail)!! In my opinion this is a well designed database modell, 'cause you have only one table (instead of 10 or twelve depending on the count of your datatypes), but you are

[PHP-DB] Why mysql function in php don't support prepare statement?

2001-03-27 Thread Carfield Yim
As title, I can't have some query like "insert into table (a, b, c) where (?, ?, ?) and then fill the value in the loop. This kind of statement often have better performance, why php don't support this? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

RE: [PHP-DB] Editing DB entries via form

2001-03-27 Thread Steve Brett
use isset($checkbox) where $checkbox is the name of the check box on the page that processes the form. Steve Brett Internal Development EMIS Ltd. "Privileged and /or Confidential information may be contained in this message. If you are not the original addressee indicated in this message (or

[PHP-DB] Connecting and Viewing a Database

2001-03-27 Thread Anyangwe, Tanwani
Does anyone know how to connect and display table rows from an ODBC source MS Access MySQL databases? -- 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:

AW: [PHP-DB] Connecting and Viewing a Database

2001-03-27 Thread Stefan Siefert
Maybe you tell us, which system you are running, like linux, or windows. If you use linux you should try to use unixODBC (Tutorial for uinxODBC and PHP: www.unixODBC.org).. If you use windows, it should be done by uncommenting the odbc-library in php.ini like: extension=php_odbc.dll Greetings,

[PHP-DB] How do you define table row indexes?

2001-03-27 Thread Anyangwe, Tanwani
The following code: $result = mysql_query("SELECT * FROM motor_vehicle",$db); $strSep = 'nbsp;|nbsp;'; while ($myrow = mysql_fetch_array($result)) { echo $myrow['id'].$strSep; } Gives me the following error: Warning: Undefined index: id in C:\PHP\Test_Scripts\testdb2.php on line 16 -- PHP

Re: [PHP-DB] Hold that insert!

2001-03-27 Thread Darryl Friesen
I have the insertRecord function which is supposed to be called only when you hit submit. For some reason I'm blanking out on how to do this. The function and function call ARE on the same page. I think I just need some logic to indicate "stop" and "go". Every form has a submit button right?

Re: [PHP-DB] Indexing help

2001-03-27 Thread Joe Brown
Columns used in the WHERE clause is the good identifier for which columns to index. You don't want to index every column you select. Typically adding indexes decreases insert performance. The more indexes the slower inserts operate, because the indexes also must be updated. Adding an index to

RE: [PHP-DB] Hold that insert!

2001-03-27 Thread Boget, Chris
Click Here! "), so in that case I display the form. If it does not have an empty value, the user has clicked the submit button, so I can go ahead processing the form data. Like this: if ( empty($submit) ) { ### Display the form } else { ### Do some checks to make the the data

Re: [PHP-DB] get_browser()

2001-03-27 Thread Joe Brown
Is it easier to update every web page you code with get_env("HTTP_USER_AGENT") ; or easier to grab a new browser.ini file? ""Simon R Jones"" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... hi all how does everyone feel about the get_browser function?? Is the

[PHP-DB] Multiple rows for one column in a MySQL table?

2001-03-27 Thread Kevin Connolly
Hi, Is it possible to have multiple rows for one column of a MySQL databes? and if so how would I insert another row into the column in question? eg: idNamePhone Number 1Kev 123123 2John 234234 345345 3 Paul

Re: [PHP-DB] Hold that insert!

2001-03-27 Thread Terry Romine
I like your simplicity and straightforwardness. My code tends toward: switch($submit) { case: "Accept": .. insert record break; case: "Delete": .. delete record break; case "Cancel": ..

Re: [PHP-DB] How do you define table row indexes?

2001-03-27 Thread CC Zona
In article [EMAIL PROTECTED], [EMAIL PROTECTED] ("Anyangwe, Tanwani") wrote: $result = mysql_query("SELECT * FROM motor_vehicle",$db); $strSep = 'nbsp;|nbsp;'; while ($myrow = mysql_fetch_array($result)) { echo $myrow['id'].$strSep; } Gives me the following error: Warning: Undefined

RE: [PHP-DB] MySQL manager

2001-03-27 Thread Michael Rudel
what about kmysql and kmysqladmin ?? Greetinx, Mike -Original Message- From: Rubanowicz, Lisa [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 4:34 PM To: 'Rosen'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] MySQL manager www.mysqlfront.de I have used it and found it to

RE: [PHP-DB] Hold that insert!

2001-03-27 Thread Boget, Chris
I like your simplicity and straightforwardness. Thanks. ;p My code tends toward: switch($submit) { case: "Accept": .. insert record break; case: "Delete": .. delete record break; case "Cancel":

[PHP-DB] error code = -504 Cursor unknow

2001-03-27 Thread Mauricio Junqueira
Hello, this is my first attempt to query and print a result coming from a database, in this case interbase6. I got the following error: InterBase: Dynamic SQL Error SQL error code = -504 Cursor unknown in maingeral.htm on line 8 Here's the code: ? include("php/header.php");

RE: [PHP-DB] Multiple rows for one column in a MySQL table?

2001-03-27 Thread Cal Evans
No. You need to look at normalizing your database if you have this situation. Cal http://www.calevans.com -Original Message- From: Kevin Connolly [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 10:48 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Multiple rows for one column in a

Re: [PHP-DB] Multiple rows for one column in a MySQL table?

2001-03-27 Thread Peter J. Krawetzky
Even if you normalize your database design, you must still tell it who owns the row. For example, you have a table containing the following columns: id name You have another table that contains the phone numbers: idnamephone number In order to connect the rows via a foreign

[PHP-DB] Reading OLE objects form MSAcces97

2001-03-27 Thread cosas
Hello, I would like to know if it's possible to read a videoclip from Access97 with PHP? I have inserted the clip as an OLE object but i don't know exactly how to retrieve the format to visualize, i've also check the type of the column an PHP says it's LONGBINARY. Does anyone knows how to

Re: [PHP-DB] error code = -504 Cursor unknow

2001-03-27 Thread Mauricio Junqueira
Mauricio Junqueira wrote: Hello, this is my first attempt to query and print a result coming from a database, in this case interbase6. I got the following error: InterBase: Dynamic SQL Error SQL error code = -504 Cursor unknown in maingeral.htm on line 8 Here's the code: ?

Re: [PHP-DB] error code = -504 Cursor unknow

2001-03-27 Thread Mauricio Junqueira
If just comment the following lines, everything works Please help... I'm getting nut !! ? include("php/header.php"); ibase_pconnect(BANCO,DBUSER,DBPASSWD) or die ("script language='javaScript' alert('" . ibase_errmsg() . "'); /script"); $stmt = "select count(*) from

[PHP-DB] A question - ($file_exists)

2001-03-27 Thread Matthew Cothier
I am setting up an episode guide for one of my favourite shows and with this I need to include three screenshots: episodeID_a.jpg episodeID_b.jpg episodeID_c.jpg In some cases though the files will not exist and therefore I need too check if they exist and if they don't then it will display a

Re: [PHP-DB] A question - ($file_exists)

2001-03-27 Thread Darryl Friesen
Whats wrong with this code? $img1 = "episodeID_a.jpg"; $img2 = "episodeID_b.jpg"; $img3 = "episodeID_c.jpg"; $img$x="blank.jpg"; That doesn't what you expect. I think the syntax is the same as Perl: $var = "$img$x"; # $var hold the _name_ of the variable

[PHP-DB] Interbase 6.01 (dialect 3), PHP4 and DATE

2001-03-27 Thread Francisco Puentes
How can I manage DATE fieldtype in PHP4 with Interbase? The problem is that i manage DATEs in format DDMM (spain) but Interbase manage it in MMDD format; so queries expected data in that format while i need it in other format. % if(isset($action)) {

RE: [PHP-DB] A question - ($file_exists)

2001-03-27 Thread Larry Rivera
or you can put yuou r values into an array then for(loop) thru the thing checking as you go. Example $img[] = "episodeID_a.jpg"; $img[] = "episodeID_b.jpg"; $img[] = "episodeID_c.jpg"; for ($x=1; $x count($img); $x++) { if (!$file_exists(.//$img[$x])) { //Change the

Re: [PHP-DB] A question - ($file_exists)

2001-03-27 Thread Matthew Cothier
Why isn't this working? ?php $img[] = "$episodeID_a.jpg"; $img[] = "$episodeID_b.jpg"; $img[] = "$episodeID_c.jpg"; for ($x=0; $xcount($img); $x++) { if(!file_exists($img[$x])) { print("td align=centerimg src=\"blank.gif\" width=160 height=120 border=\"1\"/td"); } else {

Re: [PHP-DB] Checking for empty string - long

2001-03-27 Thread CC Zona
In article 99qq47$jvn$[EMAIL PROTECTED], [EMAIL PROTECTED] (Martin Skjoldebrand) wrote: How do I check for an empty string in PHP/MySQL. http://www.php.net/empty/ http://www.php.net/is_null/ -- CC -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED]

[PHP-DB] PrintF

2001-03-27 Thread Mike Baerwolf
Hello, I'm new to PHP and mySQL. I'm trying to find more info on printf. Specifically setting table properties, like height,width,background. Hoping someone can point me in the right direction. Thanks for the Help, Mike

Re: [PHP-DB] Refresh

2001-03-27 Thread JJeffman
I don't know Postgresql, but all databases I've dealt with increments auto-increment fields only on committing insert commands. I think you can catch the last id number (MySQL do it) and show the number + 1 on the user screen. HTH Jayme. -Mensagem Original- De: Julio Cuz, Jr. [EMAIL

[PHP-DB] Help Export Excel to MySQL database

2001-03-27 Thread John
how to export the text files to Msql database ? My database now in Excel format. what type of file should I saved I will insert the file in MySQL -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[PHP-DB] simple sql question

2001-03-27 Thread Paulson, Joseph V. \Jay\
Hello- I'm running MySQL and php and when I run the query below I don't get any return rows. As you can see I search for events that are happening between a certain date. The "startDate" field is type DATE in MySQL and the date in the database that should be returned in "2001-03-27" but I'm not

RE: [PHP-DB] simple sql question

2001-03-27 Thread Ted Rolle
Is DATE CCYY-MM-DD? -- 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] simple sql question

2001-03-27 Thread Doug Semig
There is no date that was before Jan 4th and on or after March 1st simultaneously--not even March 27th. Today might be a special day to individuals for varying reasons (birthdays, anniversaries, new jobs, promotions, whatever) but it's not THAT special that it simultaneously exists in two

Re: [PHP-DB] Help Export Excel to MySQL database

2001-03-27 Thread olinux
save the file as a .csv [comma delimited] file and you will be able to import that into mysql. sorry, that's as much as i know. olinux - Original Message - From: "John" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 27, 2001 4:14 PM Subject: [PHP-DB] Help Export Excel to

AW: [PHP-DB] MySQL manager

2001-03-27 Thread ji
http://phpwizard.net/projects/phpMyAdmin/ Mit freundliche Gruessen / Regards Juergen Immel MultiServicesNetworks / Anwendungsentwicklung |N |O |C | --|--|--|--|- | GROVE Network Operation Center http://www.grove.de http://www.iag-net.de Kooperationspartner des

Re: [PHP-DB] MySQL manager

2001-03-27 Thread Rosen
Yes Thanks, Rosen Marinov ""Michael Rudel"" [EMAIL PROTECTED] wrote in message 005e01c0b6e1$f70dd6b0$[EMAIL PROTECTED]">news:005e01c0b6e1$f70dd6b0$[EMAIL PROTECTED]... what about kmysql and kmysqladmin ?? Greetinx, Mike -Original Message- From: Rubanowicz, Lisa

[PHP-DB] checkbox data

2001-03-27 Thread olinux
I have a number of apartment features that are entered via checkboxes. In my revision script, I am not sure of the best way to revise these. With the system I am using now I set the field to "1" if the box is checked on the initial form, otherwise, it becomes zero indicating, "NO" [ "1" is

[PHP-DB] Update query problem (Oracle)

2001-03-27 Thread Francesco D'Inzeo
Hi everyone. The scenario: Table1 Table2 Field_01, - Same as - Field_01, Field_02, - Same as - Field_02, Field_03, - Same as - Field_03, Field_04, - Same as - Field_04, Field_05, Field_05, Field_06, Field_06, Field_07,

[PHP-DB] fetch array problems.

2001-03-27 Thread John Starkey
Hello all. Can someone tell me what I'm doing wrong here? $sql = "SELECT * FROM user_prefs WHERE u_id='$UserID'"; $result = mysql_db_query($sql); $color = mysql_fetch_array($result); echo ' table bgcolor="'.$color[color_1].'" class="nav" .. '; I can't get $color[color_1] to return a