[PHP-DB] TIMESTAMP - Y-m-d

Please help me how to print a timestamp string retrived from the database, and print it as -MM-DD Nabil -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] query, INTERVAL problem

usually the mysql convert it to 2003-01-01 type without using this function... especially if it came from a form submission, am i right ? Nabil [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] ok make it as $sql = SELECT doc_id, exam_date FROM exams WHERE doc_id='$doc_id

[PHP-DB] MySQL CONNECTION PROblem

machine IP address.. do i have to put a domain name instead of an IP if i want to connect to a remote server on the internert? Regards nabil -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] MySQL CONNECTION PROBlem2

Sorry , when i put the IP instead of localhost i got the error... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: MySQL CONNECTION PROBlem2

. -- - Cristian MARIN InterAKT Online (www.interakt.ro) +4021 411 2610 [EMAIL PROTECTED] Nabil [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Sorry , when i put the IP instead of localhost i got the error... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

Re: [PHP-DB] MySQL CONNECTION PROblem

but when i used mysql_error() i got : sorry database not found as my dbconnect.php file includes ? mysql_connect(192.168.0.111 , root , password) or die(SORRY CANNOT CONNECT) ; mysql_select_db(kt) or die(sorry database not found); ? and the user table of mysql database : # # Dumping data for

Re: [PHP-DB] MySQL CONNECTION PROblem

', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'); George Patterson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Tue, 10 Jun 2003 16:47:26 +0300 nabil [EMAIL PROTECTED] wrote: but when i used mysql_error() i got : sorry database not found as my dbconnect.php file includes

[PHP-DB] Re: Now, how about Roman Numerals?

That's is wonderfull Hugh.. Nabil Hugh Bothwell [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] David Shugarts [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Second poser today: How to use either a MySQL select statement or PHP to produce a roman numeral, starting

[PHP-DB] HELP, Still not be able to connect to MySQL

machine on my local network (from 192.168.0.2) i still not be able too... Please help me, am i missing to point to a port number ??? *** all the above is to test how to connect to a remote Mysql server online... Nabil -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

[PHP-DB] HELP, MSSQL STORED PROCEDURES

PLEASE HELP ME PHP PEOPLE, I have a stored procedure on a remote Microsoft (stupid) SQL server.. and I have to connect to it remotely and I have only permission to execute those specific procedure , and I only got the returned value... My server that I will connect from is Linux, apache with

Re: [PHP-DB] HELP, MSSQL STORED PROCEDURES

could you help for that .?? Martin [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] You are entirely wrong about ODBC. Linux has several implementations available. On Sat, 14 Jun 2003 14:30:42 +0300 nabil [EMAIL PROTECTED] wrote: PLEASE HELP ME PHP PEOPLE, I have

[PHP-DB] Re: php_mssql.dll

go and download a new version ... then change the extention dir in php.ini , restart ur IIS and then BINGO Louai [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I got the following error when I tried to connect to MS SQL server: Unknown () mssql: unable to initialize module Please

[PHP-DB] Re: Displaying 10 records per page

check this out :)) http://www.phpfreaks.com/print.php?cmd=tutorialtut_id=43 Nabil David [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Dear All I am writing a support pages for my company at present. I would like to display 10 records per page, e.g. like google does

[PHP-DB] PLS Advise, Highlighted Text from a Query

Dear all, 1- I have a form with an input text : keyword 2- the field address is in my MySQL as TEXT field. 3- I select * from db where address like '%keyword%' 4- I want when echo the return $row[address] to highlight the entered keyword (that the user has entered in the search form) in the

[PHP-DB] Re: PLS Advise, Highlighted Text from a Query

-- - Cristian MARIN - Developer InterAKT Online (www.interakt.ro) Tel: +4021 312.53.12 Tel/Fax: +4021 312.51.91 [EMAIL PROTECTED] Nabil [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Dear all, 1- I have a form with an input text

Re: [PHP-DB] Re: PLS Advise, Highlighted Text from a Query

to your level of experience. As they say, if you need to ask... Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: nabil [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, 18 June, 2003 10:11 Subject: [PHP-DB] Re: PLS Advise, Highlighted Text

Re: [PHP-DB] Re: PLS Advise, Highlighted Text from a Query

+= (length of $word) * (1 + strength($n)); } $score = ($count + $count) / (length of $query + length of $text ); $score = curve($score); Nabil Mikon Dosogne [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] [...] what about the percentage how much accurate the result returned?? I'm

[PHP-DB] Header, Directory, and SESSIONs

HOPE I WAS CLEAR, and thanks for your patient again... :)) (sorry because it might be shouldn't in db list) Regards Nabil -- open source world, open mind for all -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] mysql_bind question

Any one give me an idea , I have a procedure in Microsoft SQL server return : select 0 as err, @cardPrice as cardPrice, @newBalance as newBalance, @exp as expirationDate I want to print out the return vars as @cardPrice ,,, please note that I got the $row[0] as 0 but not the $row[1]

[PHP-DB] MySQL Backup, final script !!!

it didn't work with me (on windows by example). All what I am thinking to do is a script that retrieved the database names then retrieve the tables names, then fields names and dump the data in an schema like mysqldump does any suggestions?? Cheers... Nabil -- PHP Database Mailing List (http

Re: [PHP-DB] MySQL Backup, final script !!!

. First you have to connect to a database using mysql_connect() and using mysql_query and mysql_fetch_row. Armand Nabil wrote: thanks a lot for your response but i got Fatal error: Call to a member function on a non-object in c:\inetpub\wwwroot\dump.php on line 3 not that mysql

[PHP-DB] HELP PLEEASSSEE

with a space). 3- I have a problem when submit the form , if i echo $_POST['area'] in the action file .. i got only happy without day Please help me , because i m going to pull my hair off... Nabil -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

[PHP-DB] non-GPL MySQL licenses PHP5

As i read in www.MySQL.com: The software from MySQL AB that you can download from the pages listed below, is licensed under the GNU General Public License (GPL) and is provided as is and is without any warranty. You need to purchase commercial non-GPL MySQL licenses: a.. If you distribute

[PHP-DB] XML to MySQL

Dear All ; I have an XML files like the following and i want to make an PHP code to insert it into my MySQL how can i read the nodes ot tages??? by the way i can export like this file from PhpMyAdmin but i cann't dump it back... Thanks in advance Nabil ?xml version=1.0 encoding=windows-1252

[PHP-DB] Re: Testing code

run the mysqld on shell Hugh Dickinson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Is it possible to test PHP and MySQL scripts and databases without being registered on a web server? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Any one can help me dump XML into MySQL??

Dear All ; I have an XML files like the following and i want to make an PHP code to insert it into my MySQL how can i read the nodes ot tages??? by the way i can export like this file from PhpMyAdmin but i cann't dump it back... Thanks in advance Nabil ?xml version=1.0 encoding=windows-1252

[PHP-DB] Re: XML to MySQL

any one ?? Nabil [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Dear All ; I have an XML files like the following and i want to make an PHP code to insert it into my MySQL how can i read the nodes ot tages??? by the way i can export like this file from PhpMyAdmin but i cann't

[PHP-DB] Re: ./configure stupidity

please please would you help me to get mysql - gd - iodbc (odbc) - mssql - apache I need to upgrade because i need the new one with iodbc support not unixODBC. and i need it with ofcourse ( mysql - gd - iodbc (odbc) - mssql - apache ) I have read so many articles all over the web, and

[PHP-DB] ANYONE KNOWS, can help me to link Linux to MS SQLserver 7 by ODBC

Hiya all; I have been trying so hard to get that done.. and i posted many here. but with no hope.. here is a summury of what i did: - I tried FreeTDS as a driver with unixODBC ... - Tried to remove mysql- apache - php and recomplied them with : iodbc - Tried to try openlink driver. - tried to

Re: [PHP-DB] ANYONE KNOWS, can help me to link Linux to MS SQLserver 7 by ODBC

is the .so file that works with MS SQL7 that i should point to. Nabil Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Monday 28 July 2003 16:38, Nabil wrote: I have been trying so hard to get that done.. and i posted many here. but with no hope.. here is a summury

Re: [PHP-DB] ANYONE KNOWS, can help me to link Linux to MS SQLserver 7 by ODBC

these are not working because i need to connect ro Micro$oft SQL server 7 NOT to mysql nor postgresql Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Monday 28 July 2003 18:13, Nabil wrote: Please Jason help me to do this The sql server is on 192.168.0.101 IP

[PHP-DB] [unixODBC]Client unable to establish connection

tested the connection : bash tsql DSNname -S 192.168.0.1 -U user -P pass and i got connected... and i tried telnet 192.168.0.1 1433 and i managed too SO what do u think the prblem is? -- Nabil Attar Advanced Web Solutions /*** Everyone is a beginner once, and no one is an expert at everything

[PHP-DB] Re: mySQL Binaries for Linux

You just untar it and copy it to a directory like /ur/local/mysql then copy php.ini to /etc you read the read me that is in the same directory shell groupadd mysql shell useradd -g mysql mysql shell cd /usr/local shell gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - shell

[PHP-DB] Re: PHP connection to remote Access database on NT

Yes , and I done myself to mssql on windows from linux/apache you have to use odbc .. use FreeTDS , it is free and open soured... and work like a charm Nabil John Almberg [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Here's a question I hoped I'd never have to ask

[PHP-DB] Re: backing up MySQL

use the following script ## #!/bin/sh # Create the temporary copy directory mkdir /tmp/mysql # Get the list of MySQL Databases copy them for var in `find /var/lib/mysql/ -type d | \ sed -e s/\/var\/lib\/mysql\///`; do mysqlhotcopy -q $var /tmp/mysql done # Tar/gzip data

[PHP-DB] Re: Compiling 4.2.3 with MySQL ... what does it look for?

Nabil -{ Rene Brehmer }- [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] X-posted to PHP General, PHP DB, and MySQL Hi gang Attempting to get my Linux test-server working, but ran into a problem when making PHP... System is RedHat 8, Apache 1.3.27 (compiled myself, tested OK

[PHP-DB] mySQL vs pgSQL | php vs others

that but what do you all think ? nabil -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] case to comment, please

I have the following example case: 1- More than 1000 record in my MySQL database. 2- I have to submit those record via HTTP GET or POST method. 3- I have to read the confirmation message that will be printed on the remote page showing me that the vars have been inserted in the remote database. 4-

[PHP-DB] connect nativly with Oracle9i

I have php 4.3.4 on windows as a development environments, i could not connect to oracle using the native functions, should i connect using ODBC ?? What will be happen when i will deploy on Linux ? still same ? Nabil -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

[PHP-DB] Multi search function (help)

hi all Is there a way to condition your search: -I have a form for four text boxes for search my Mysql... -I don't want to write 4 conditions and for SQL statements incase he decided not to search with all keywords (fields) - I have by example : name, lastname , nickname and phone form...

[PHP-DB] Re: Multi search function (help)

thanks .. but my question is not for isset... i m thinking consider that i have 10 search fields... if i have to do a combination then i need a day to right the various SQL statements David Robley [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Nabil wrote: hi all

[PHP-DB] Drawing table by while

Hiya, How can i draw a new tr AFTER FIVE td in the following loop (i want to echo the records in 5 columns width tables whatever the number of records will be fetched) .. echo 'table'; while ($myrow = mysql_fetch_array($sql)) { echo $myrow[0]; } echo '/table'; --

Re: [PHP-DB] Re: Multi search function (help)

a caution, you will need to take some care in figuring when and where to place your 'and' statements linking the various parts of the query. At 08:01 AM 27/05/2004, you wrote: Nabil wrote: David Robley [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Nabil wrote: hi

[PHP-DB] MSSQL Procedures

Jeson Hi , this is Nabil from PHP list, i wonder if u could help with the following: I have a stored procedure on a remote Microsoft (stupid) SQL server.. and I have to connect to it remotely and I have only permission to execute those specific procedure , and I only got the returned value... My