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
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
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
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
.
--
-
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
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
', '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
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
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
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
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
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
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
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
--
-
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
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
+= (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
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
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]
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
. 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
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
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
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
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:
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
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
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
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
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
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
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
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
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
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
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
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
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-
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
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...
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
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';
--
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
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
44 matches
Mail list logo