[PHP-DB] Supplied argument is not a valid File-Handle resource in

2003-09-29 Thread Ferdian
Dear All, I use this script if ( ($type == all or $type == com) and $com_include ) { $com_array = array($ddomain..com,$ddomain..net); $com_count = count($com_array); $i=0; for ($i=0;$i$com_count;$i++) { $domname = $com_array[$i]; $ns = fsockopen($com_server,43);

[PHP-DB] fopen : Supplied argument is not a valid File-Handle resource

2003-09-29 Thread Ferdian
Dear All, I use this script if ( ($type == all or $type == com) and $com_include ) { $com_array = array($ddomain..com,$ddomain..net); $com_count = count($com_array); $i=0; for ($i=0;$i$com_count;$i++) { $domname = $com_array[$i]; $ns = fsockopen($com_server,43);

[PHP-DB] [fwd] Sybase (from: stephanb@whacky.net)

2003-09-29 Thread Stephan van Beerschoten
Since I have gotten 0 (zero) response on the problem below, let me try again. Also, I kept trying to work with it, and I found out that a sybase_connect from a php shellscript does work, but it won't work from inside a php handled webpage. This is even stranger. I also found a way to up the

Re: [PHP-DB] database design question

2003-09-29 Thread olinux
i would add a second table and also store the totals in the lyrics table like you suggested then you can do things like top 10 this week / top 10 this month and make sure its not being abused LYRICS_RATINGS - id | lyric_id | rating | vote_date | remote_addr same idea for hits/impressions

Re: [PHP-DB] fopen : Supplied argument is not a valid File-Handle resource

2003-09-29 Thread Jason Wong
On Monday 29 September 2003 15:30, Ferdian wrote: Please post to the correct list, this has nothing to do with databases. Please do not post multiple times. Wait patiently for a response! I use this script [snip] $ns = fsockopen($com_server,43); fputs($ns,$domname\r\n); $result =

[PHP-DB] Email bouncer Program(s) - know any?

2003-09-29 Thread JeRRy
Hi, I run PHP and mysql on my site. I allow people to use a PHP page to send me an email that is logged in the mysql for logging reasons. If someone sends me an email to [EMAIL PROTECTED] (fake address, not real) when it is sent it does not bounce, instead it gets sent to the root email

[PHP-DB] Defining relation between tables

2003-09-29 Thread Mücella Erdem Efe
Hi ; I am a new programmer of PHP4.3.3 an MySql 3.23 . In MyPhpAdmin CREATE DATABASE phpmyadmin; GRANT SELECT,INSERT,DELETE ON phpmyadmin.* to 'local host user'; enter the databasename in $cfg['Servers'][$i]['pmadb'] (this works) But the statement below dosen't work at all. CREATE

Re: [PHP-DB] [fwd] Sybase (from: stephanb@whacky.net)

2003-09-29 Thread José Pedro Esteves
Hi list. I had the same problem when trying to use Sybase_Connect ... Insted i defined alias in ODBC and used OBDC_Connetc. JPedro - Original Message - From: Stephan van Beerschoten [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 29, 2003 8:52 AM Subject: [PHP-DB] [fwd]

[PHP-DB] odbc

2003-09-29 Thread Simpson, Doug
I am trying to connect to an AS/400 from a Linux box running RH9. I have installed unixODBC and the iSeries drivers. I can run cwbping that tell me that I am connecting to the AS400. I have made a scipt the following script - HTML HEADTITLEODBC Data Source/TITLE/HEAD BODY ?php //odbc_query.php

[PHP-DB] Help with UPDATE query

2003-09-29 Thread Shaun
Hi, I have two columns in my Bookings table of type DATETIME - Booking_Start_Date and Boking_End_Date. How can i update every row so that all of the times for Booking_Start_Date are 09.00 and all of the times for Booking_End_Date are 17.30, without affecting any of the dates? Thanks for your

[PHP-DB] Query's

2003-09-29 Thread Andrew R
Howdy List, I am a little confused in incorporating a drop down menu into my select statement. I have a very simple 1 table database that contains my DVD collection. Right now - very simply it connects to the database, and then produces the results of the search based on a ?

Re: [PHP-DB] Query's

2003-09-29 Thread dpgirago
Are you asking for help with the query, or with having the query populate a select box? If you are planning to be able to manually enter search criteria, then you do not want a select box, you want a text type input. David Andrew R [EMAIL PROTECTED] 09/29/2003 05:01 PM To: [EMAIL

[PHP-DB] Re: Help with UPDATE query

2003-09-29 Thread David Robley
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... Hi, I have two columns in my Bookings table of type DATETIME - Booking_Start_Date and Boking_End_Date. How can i update every row so that all of the times for Booking_Start_Date are 09.00 and all of the times for Booking_End_Date are

[PHP-DB] how to select rows with repeated coloumns in one query????

2003-09-29 Thread Saurabh Dhawan
I have a table called studs with coloumns as : Sno.namegrade 1 aa 1 2 bb 1 3 cc 2 4 dd 3 5 ee 4 6 ff 4 7 gg 4 8 hh 5 Now i want to see only those rows which have value of grade repeated atleast