In the second loop you do an array_shift($entry) which should be
array_shift($all).
Perhaps a foreach loop would be easier:
Jos
-Original Message-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]
Sent: 18 May 2005 22:47
To: php-db@lists.php.net
Subject: [PHP-DB] Help!!!
On 8/20/07, Asim <[EMAIL PROTECTED]> wrote:
> can anyone provide me code of basic website structure having member
> area and can use mysql database to show results of search by PAGINATION?
For pagination refer this :- http://www.phpfreaks.com/tutorials/43/5.php
Hope this will help you.
--- R * S
On 19 Feb 2001, at 12:54, Fusion wrote:
>
> Hey can somone show me how to make something to list all files in a =
> directory spedified ?
>
Check this out:
http://www.php.net/manual/en/function.readdir.php
HTH!
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
Fabrizio Ermini
Perhaps the quote marks within quote marks? PHP,as is javascript, very
particular..
Try:
echo "Name: $row['user_id'].'\n"; or some such.
or
echo "Name".$row[user_id]."\n";
It's the quote marks within that are playing havoc..
Phil J.
Chris Hall wrote:
> I keep getting this error on a little pro
On Mon, Mar 26, 2001 at 09:24:38PM -0800, Chris Hall wrote:
> Parse error: parse error, expecting `','' or `';'' in
> f:\inetpub\wwwroot\forums\index.php on line 38
> line 38 would be:
> echo "Name: "$row["user_id"]."\n";
^^ missing a '.' there.
either this way
echo "Name:
On Tuesday 04 February 2003 11:29, Tomás Liendo wrote:
> Hello I'm a beginner, I'm reading the PHP's manual but I can't test the
> examples because always receipt the following error message:
>
> Call to undefined funciont:
>
> I can't understand why! Please help... :-(
1) Please use a descriptive
Have you correctly updated you web server's .ini file to point to the PHP
installation according to the PHP installation instructions?
> -Original Message-
> From: Tomas Liendo [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 03, 2003 10:29 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB]
Why don't you post the code you are trying to work with and we could
help you from that point on.
Akmal wrote:
I'm trying to create a guestbook and... I'm having trouble getting a certain
amount of entries per page. Please help, a snippet of a code would be nice.
Thanks!
-Akmal-
---
Outgoing mai
your post is abit vague, give more details or code then we can try help. Its
kinda like you saying, help my car wont go.
-Original Message-
From: Akmal [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 06, 2003 5:43 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] HELP!
I'm trying to create a
> Help, i'm trying to connect to a remote oracle database from
> win98/apache/php4 and win2k/iis/php4 but it always gives me tns
> error. Other
> apps however, works fine with the tns configuration. the php oracle module
> was loaded successfully on both platforms.
> I've tried all sorts of possi
Hi Shelly,
It is just the old trick. You can get the time at the beginning of the page
and at the end of the page and just calculate the difference in between two.
Since the default timeout value in PHP is 30secs. it will probably be a
short timeperiod so you can probably you use time() function w
Google search for php wiki, or save that step and go to
http://sourceforge.net/projects/phpwiki/
Miles Thompson
At 05:26 AM 2/6/2002 -0700, jas wrote:
>Is there anyone out there that has developed an application using php and
>mysql that allows clients etc to update and maintain their own websi
you need a second REQUIRED parameter:
mysql_result
(PHP 3, PHP 4 )
mysql_result -- Get result data
Description
mixed mysql_result ( resource result, int
row [, mixed field])
as cop
SpiderWebb,
One posting to one list is enough...
> I dont know if this is possible in PHP (Newbie) im working on a project
> where each product has 3 diffierent prices depending on the amount sold so
> say for example 1- 100 price A 101-299 price B and above 300 Price C.
What
> I need to be able t
You might read the database to see how many have been sold previously
and put that into a PHP variable. Add the amount that you'd be
incrementing it by (I assume it's possible that it will increment by
more than one at a time), determine the price point, and then update
the row with both the new am
Hi,
You can use LEFT OUTER JOIN
Table1 : software list
Table2 : installed ones
$res=mysql_query("select table1.software_name, table2.software_name from
table1 left outer join table2 on
table1.software_name=table2.software_name");
Check if there is not a matching record on table 2
while($row=m
Check to see if your register_globals is set to off in php.ini. If so
(likely, since it defaults to that value) you'll need to access your
POST and GET variables like this:
GET vars:
$var = $_GET['var'];
POST vars:
$var = $_POST['var'];
Gary Every
Sr. UNIX Administrator
Ingram Entertainment Inc
On Thu, 23 Dec 2004 10:57:55 -0500, Bastien Koert <[EMAIL PROTECTED]> wrote:
> you have a mysql account with that particular user identification?
yes this connections works well when i query table user, in specified db.
>
> bastien
>
> >From: Nayyar Ahmed <[EMAIL PROTECTED]>
> >Reply-To: Nayyar
you have a mysql account with that particular user identification?
bastien
From: Nayyar Ahmed <[EMAIL PROTECTED]>
Reply-To: Nayyar Ahmed <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: [PHP-DB] help newbies :)
Date: Thu, 23 Dec 2004 20:54:23 +0500
Hello All,
I am developing attendence mangem
Nayyar Ahmed wrote:
Hello All,
I am developing attendence mangement system, its my first application
in PHP, I want to compaire the input text box value with table records
the follwing is the code
_index.htm___
..
User
Sorry, the data under 'Looking something like this' should be in a table
format with 3 columns and 4 rows.
-Original Message-
From: ReClMaples [mailto:[EMAIL PROTECTED]
Sent: Friday, July 29, 2005 8:46 PM
To: PHP
Subject: [PHP-DB] Help Needed
All,
I know this is the wrong distro to
ReClMaples a écrit :
Sorry, the data under 'Looking something like this' should be in a table
format with 3 columns and 4 rows.
-Original Message-
From: ReClMaples [mailto:[EMAIL PROTECTED]
Sent: Friday, July 29, 2005 8:46 PM
To: PHP
Subject: [PHP-DB] Help Needed
All,
I know this
You ROCK!!! Thanks so much, this worked perfectly!!!
Thanks
-Rich
-Original Message-
From: Alain Rivest [mailto:[EMAIL PROTECTED]
Sent: Friday, July 29, 2005 10:10 PM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Help Needed
ReClMaples a écrit :
>Sorry, the data under '
you don't have a connection to the db...either because the name.password, db
name are wrong or you lack the needed permissions to allow the query...
note that this query is a really back idea...opens the whole db up...better
to provide one connection and allow the users basic read write access
ully logged on.';
}
else {
echo "Your username and/or password have not been accepted. Please go back and try again.";
}
Thanks
Richard
-Original Message-----
From: Bastien Koert [mailto:[EMAIL PROTECTED]
Sent: 30 August 2005 00:59
To: [EMAIL PROTECTED]; php-db@lists.ph
e-
From: Richard Hart [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 30, 2005 12:06 PM
To: Bastien Koert; php-db@lists.php.net
Subject: RE: [PHP-DB] Help with. .
Thanks for your help Bastien.
I have changed the authentication procedure but have come up against
another
problem.
This time I
Martin is right...
carefully~
@ $db = new mysqli('localhost', 'root', 'password', 'database_table');
On 8/30/05, Richard Hart <[EMAIL PROTECTED]> wrote:
>
> Hi
>
> I'm new to PHP/MySQL and wondered if anyone on this list would be kind
> enough to help me solve
> this problem. I'm trying to autom
Forgive me for saying this, but you should be posting this to the Oracle
mailing list, not here.
David Skyers wrote:
> Hello,
>
> I have an input field that inserts data into an oracle table. The users
> of the system will be composing the data that goes into this input field
> in Microsoft Word.
1. yes, user a rich text editor plugin in you web page
(http://www.kevinroth.com/rte/ is one such beast)
2. sure, in a text / blob field
3. yes, but likely you'll need to do it as CDATA
hth
Bastien
From: "David Skyers" <[EMAIL PROTECTED]>
To:
Subject: [PHP-DB] Help Needed!!
Date: Wed, 8
uot;Beau Lebens" <[EMAIL PROTECTED]>
To: "Sridhar Ranganathan" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Thursday, February 01, 2001 5:46 PM
Subject: Re: [PHP-DB] Help Me!
> the way i have attacked a similar situation in the past was to create my
> own f
the way i have attacked a similar situation in the past was to create my
own formatting system - kind of a pseudo-html set-up, which made use of
conventions like;
**bold**
%%italic%%
__underline__
!!titlefont!!
etc etc
then you can save the article directly into the DB, as a text or whatever,
Hello, "Sridhar Ranganathan"!
You wrote:
> What should I do?
>
See the strip_tags() function.
--
Piloteers do it on the road
--
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 a
From the ever-valuable Richard Alsebrook, this link ...
http://www.easysoft.com/tech/php/tut_002/main.phtml
Regards - Miles Thompson
PS Check the archives , this question was addressed about a week ago.
At 03:24 PM 4/4/01 -0400, shaun wrote:
>Fiesta
>i need to make a tree list that populated
here are some links to free tree menu scripts
http://www.hotscripts.com/Detailed/8821.html - UltraTree
http://www.hotscripts.com/Detailed/9035.html - iScouter Smart Tree View
http://www.hotscripts.com/Detailed/3704.html - PHP TreeMenu
let me know how they work, please?
olinux
- Original Me
It's best if you can supply the full code. Code may not need to be attached,
you can just put in a text file and send the link so that we all can read.
Error in line 42 DOES NOT mean the error is in line 42, sometimes the error
can be in the couple of lines before line 42.
Best wishes,
Indri
--
BDY.RTF
--
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]
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
Look for extensions in the file php.ini. uncomment the line:
extension=php_dbase.so (for linux or)
extension=php_dbase.dll (for windows)
remember to set extension_dir to directory where you have the file.
Hope it helps.
Bruno Gimenes Pereti.
> I need to open a dbase file, so I use the "dbase
if you have phpMyAdmin then just use that (if you don't then you *really*
should :)
otherwise, yeah just use mysql_query()
or use the command line
of course the second 2 options assume you can construct the SQL command to
do it, using phpMyAdmin you won't really need to know.
/beau
// -Or
>
>
> Source code- CÛdigo fuente:
>
> $based="articulo.dbf";
> if (($descriptor=dbase_open ($based, 0))==0){
>printf ("Error al abrir la base de datos");
> }else{
>printf ("Base de datos abierta");
>$num_registros=dbase_numrecords($descriptor);
>$num_campos=dbase_numfields($descr
>From original msg:
>> I need to be able to do is increment an mysql database field each time an
DN> =possibly an AUTO_INCREMENT field is what is needed here
Is that what he has been trying to do? I think SpiderWebb needed to see
how many pieces of the item were sold, didnt'he?
So let's say he's
-- pada 2002-12-26, 14:36:00 [EMAIL PROTECTED] menulis: --
>
>Hi.
>I juz installed a RedHat 8.0 on my machine.
>But then I have a problem in configuring Apache 2.0.4 to use PHP 4.20..
>It's preety weird.. coz there's nothing shown up in the browser when I
>run phpinfo(); or even a simple 'hellow
Everything's perfect.. except my browser keep blank when I run my php
files...
--www.kapsul.org--
DuFronte
-Original Message-
From: adi setiawan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 26, 2002 5:00 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Help Needed
--
> Everything's perfect.. except my browser keep blank when I run my php
> files...
No, obviously it's not perfect because it's not working at all. Your page is
blank because will be evaluated as an unknown HTML tag and
come out blank.
Find another tutorial that discusses how to set up what you w
At 02:36 PM 12/26/02 +0700, dufronte wrote:
Hi.
I juz installed a RedHat 8.0 on my machine.
But then I have a problem in configuring Apache 2.0.4 to use PHP 4.20..
Apache 2 and PHP are not ready for prime time. If you must use Apache 2
with PHP, you are on the bleeding edge, and should plan o
ubject: Re: [PHP-DB] Help Needed
At 02:36 PM 12/26/02 +0700, dufronte wrote:
>
>Hi.
>I juz installed a RedHat 8.0 on my machine.
>But then I have a problem in configuring Apache 2.0.4 to use PHP 4.20..
Apache 2 and PHP are not ready for prime time. If you must use Apache 2
wi
Hello khac,
hmm what platform are you running on? what are PHP settings for
writing sessions? Check out permissions for /tmp directory, check out
free space on disk.
--
Best regards,
Martin mail [EMAIL PROTECTED]
mobile +421.907.30
Are you running on windows or Linux???
This looks like a Windows problem - you have to set your
"SESSION_SAVE_PATH" in php.ini AND make sure the folder you specify exists
and is accessible to PHP.
HTH,
Richy
==
Richard Black
Senior Developer, DataVisibil
when using start_session
the code tries to write a file to the tmp dir...
think you are working under windows
so make in c: a \tmp dir !!!
then it should work
-Original Message-
From: khac duy [mailto:[EMAIL PROTECTED]]
Sent: vrijdag 10 januari 2003 1:08
To: [EMAIL PROTECTED]
Subjec
there are a million sample php script in links...
http://www.php.net
"muhammad_wahyu"
Make sure that u had installed Oracle Client on your Machine and Recompile your php
with --with-oracle=$ORACLE_HOME then
check wether your Apache included -lpthread
-Original Message-
From: Marcial Comerón Mariño <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Date: Mon, 31 Mar 2003 07:57:38
Hadi wrote:
Hi , please help this newbie , how to make my database view from
[1] [2] [3] [4] [5] [6] [7] [8]
to
<<< 1 2 34 >>>
Thanks very much
Hadi
***removed code***
You could convert the array into a string but why would you like to do
that?
Not a good way but a possible
Return Receipt
Your Re: [PHP-DB] help newbie
document
Hi varin,
putenv("ORACLE_SID=TEST");
$uid = "scott";
$pwd = "tiger";
$inst = "test";
$conn = ocilogon($uid,$pwd,"$inst");
works for me
you could also try
OCIInternalDebug(8);
and see what happens
I just noticed you are using Ora_logon, you need to use the OCI functions !!
HTH
stev
ORA-12154: TNS:could not resolve service name
Cause: The service name specified is not defined correctly in the
TNSNAMES.ORA file.
Action: Make the following checks and correct the error:
- Verify that a TNSNAMES.ORA file exists and is in the proper place and
accessible. See the operating system
Hi
try echoing the actual query, after the variables have been converted to
values
$qtrans = "insert into $tbltrans
values('0', 'daily', '$building',
'$itemchoice',
'0', '$count', '0', '$ddate', '$cat')";
echo $qtrans ;
and see if a comma or quote mark is in
If it is cutting off at the spaces (like is apple sauce, etc... cutting off
after apple instead of the comma after sauce), try urlencode'ing the data
before passing it to the next page.
For your print option statement, try this:
print ("$itemarray
[description]\n");
HTH
Maureen
Peter Lovat
Rodrigo,
Is there a way to convert a date " 20/11/2002 " to a Float number in PHP,
since the date starts in 30/12/1899, just like the delphi treats the
dates
=Check out UNIX timestamps (but watch the valid date range),
=dn
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
> Is there a way to convert a date " 20/11/2002 " to a Float number in
PHP,
> since the date starts in 30/12/1899, just like the delphi treats the
> dates
Yeah, of course. To convert "20/11/2002" into a float, just do
echo (float)"20/11/2002";
and you get 20!!
Or you can use strtotime() to
Well...
1 day = 60*60*24 = 86400
You figure it out from there :)
Just one example.
Aaron
-Original Message-
From: Dankshit [mailto:[EMAIL PROTECTED]]
Sent: November 28, 2002 12:06 PM
To: PHP; PHP1
Subject: [PHP-DB] Help with date
How can i add days to a date??
If you use MySQL:
SELECT DATE_ADD( $my_date, INTERVAL n DAY ) AS new_date ;
Ignatius
- Original Message -
From: "Dankshit" <[EMAIL PROTECTED]>
To: "PHP" <[EMAIL PROTECTED]>; "PHP1" <[EMAIL PROTECTED]>
Sent: Thursday, November 28, 2002 6:06 PM
S
Go to http://hotscripts.com
-Original Message-
From: redhat [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 1:21 PM
To: phplist; fedoralist
Subject: [PHP-DB] help desk software
Anybody out there familiar with some helpdesk software? I found some
called "teacup" that runs as a c
Have you set up a ODBC connection ?
You must set up a ODBC connection in the ODBC Sources that is usually in you
Control Panel or Administrator Tools.
You must put it as a System DNS and set up the connection, so your local system
know where to find the database.
Kind Regards
Arné K
have you created a dsn for this connection?
Bastien
From: Petrus Ali Saputra <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Help me please
Date: Mon, 08 Nov 2004 10:55:45 +0700
Can anyone here help me how to connect to an ODBC data?
Here is my code: $odbc = odbc_connect("Ta Fara","",""
Arné klopper wrote:
Have you set up a ODBC connection ?
You must set up a ODBC connection in the ODBC Sources that is usually in you Control Panel or Administrator Tools.
You must put it as a System DNS and set up the connection, so your local system know where to find the database.
I already
Bastien Koert wrote:
have you created a dsn for this connection?
Bastien
From: Petrus Ali Saputra <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Help me please
Date: Mon, 08 Nov 2004 10:55:45 +0700
Can anyone here help me how to connect to an ODBC data?
Here is my code: $odbc = odbc_co
I apologize but I figured out my mistake.
Thanks
-Rich
-Original Message-
From: ReClMaples [mailto:[EMAIL PROTECTED]
Sent: Monday, April 25, 2005 10:05 PM
To: PHP
Subject: [PHP-DB] Help with PHP
I'm not sure if this is the correct distro to be sending this question to,
if it's not, let
Get rid of both your onload= statements and replace with...
window.onload=doboth
Then include the function below...
function doboth() {
changetext();
changead();
}
Not sure what you were getting at regarding the " thing, but I think the browser
must just over-ride the previous onload s
Hi,
Thanks for this, got a few reposnses regarding this.
This seems a more professional approach, I will try this and let you know
about it when I do it.
Thanks for your time.
Jerry
Ross Honniball <[EMAIL PROTECTED]> wrote:
Get rid of both your onload= statements and rep
1.
0?("?start=").$y:""));?>">
2. 0?("?start=").$next:""));?>"><<
turns into:
> $string = '' . $pg . '';
> ?>
> $string2 = '';
> ?>
I can squeeze the if operation into the string but I can't see good cause
for this (this is less spageti this way)
On 06/06/2008, Nasreen Laghari <[EMAIL P
You can use phpMyAdmin at www.phpwizard.net
Rosen wrote:
> Hi,
> Can someone tell me how can I manage
> MySQL database on remote server ( With what software ) ?
>
> Thanks,
> Rosen Marinov
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For
-Original Message-
From: Andy Etemadi [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, January 17, 2001 6:04 PM
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] HELP! Manage MySQL
You can use phpMyAdmin at www.phpwizard.net
Rosen wrote:
> Hi,
> Can someone tell me how can I manag
Hello Rosen,
Wednesday, January 17, 2001, 9:54:28 AM, you wrote:
R> Hi,
R> Can someone tell me how can I manage
R> MySQL database on remote server ( With what software ) ?
try dbtools .. http://dbtools.vila.bol.com.br/
--
DSig `
David Tod Sigafoos
Thanks!
But when I try to connect to server I get message "Can't connect to MySQL
server on (10060 )!
Please Help!
"David Tod Sigafoos" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hello Rosen,
>
> Wednesday, January 17, 2001, 9:54:28 AM, you wrote:
>
$res = mysql_query("SELECT * FROM ecomm where ID ='$sid'",$db))
if(!$res){echo("error preforming query: " . mysql_error());exit();}
//error trap
while( $row=mysql_fetch_array($res)){
$pno=$row["part"];
#
Mark Newnham
Application De
Thanks a million, works great now.
- Original Message -
From: "Mark Newnham" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 25, 2001 1:41 PM
Subject: RE: [PHP-DB] Help with loop
> $res = mysql_query("SELECT * FROM ecomm where ID =
On Thu, 8 Mar 2001, Rosen wrote:
> Hi,
> I'm using MySQL database and I try:
> "
> insert into roubr('id','pos','name') values ( select id,pos,name from
> requestroubr)
>
> "
Try this:
insert into roubr(id,pos,name) values select id,pos,name from requestroubr
I hope this will work !
Best rega
ok you must get your variables like row1, row2 etc from anywherelse then try
this format too insert them at your db
mysql_connect("localhost","username","password")
or die ("cant connect database");
@mysql_select_db("databasename")
or die("cant connect database");
mysql_query("INSERT INTO yourt
Thanks, but it doesn't work !
"Brinzoi Constantin Aurelian" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> On Thu, 8 Mar 2001, Rosen wrote:
>
> > Hi,
> > I'm using MySQL database and I try:
> > "
> > insert into roubr('id','pos','name') values ( select id,po
Thanks, but the idea is to transfer data between two tables with
same structure.
Rosen Marinov
""karakedi"" <[EMAIL PROTECTED]> wrote in message
987ggc$mca$[EMAIL PROTECTED]">news:987ggc$mca$[EMAIL PROTECTED]...
> ok you must get your variables like row1, row2 etc from anywherelse then
try
> th
BDY.RTF
--
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]
it's amazing.. I've been banging my head for over an hour on this, then as
soon as I send for help, I see the obvious - first of all, my error checking
was done *before* the query executed... then, to make it even more of an
effort in mindlessness, the table name capitalization was throwing it all
Try mysql_connect instead. Doesn't sound as if you are at the stage at
which you would realize any gains from a persistent connection. I've
just seen a lot of comments regarding strange happenings with pconnect
- which I have no doubt will be addressed later.
Don Briggs wrote:
While viewin
use system() to run /bin/df
depending on the OS you might need to add a flag to it like -h (linux) or
-k (solaris).
www.php.net/system
Adam
On Fri, 27 Dec 2002, Dankshit wrote:
> Is there a way to see how much space is left in a ftp server?
>
> thanks in advance!
>
--
You can do it very nicely with MySQL:
$query = "SELECT WEEKDAY( '{$mydate}' )" ;
Provided your date is correctly formatted ( -mm-dd )
Ignatius
- Original Message -
From: "Rodrigo Corrêa" <[EMAIL PROTECTED]>
To: "PHP1" <[EMAIL PROTECTED]>
Se
with mysql its:
WEEKDAY(date)
Returns the weekday index for date (0 = Monday, 1 = Tuesday, ... 6 =
Sunday):
mysql> SELECT WEEKDAY('1998-02-03 22:23:00');
-> 1
mysql> SELECT WEEKDAY('1997-11-05');
-> 2
http://www.mysql.com/doc/en/Date_and_time_functions.html
in php its:
string dat
Rodrigo Corrêa wrote:
I´m new with MySQL, i´m just wondering if there is a way to get the IP from a MySQL Server, since i acess this by localhost in the webserver
even if you could, the MYSQL admin probably set your account to access
your data with a LOCALHOST permission only... so if you
Put start_session() statement on first line of your code
- Original Message -
From: "do khac duy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 27, 2003 13:31
Subject: [PHP-DB] help about session
>i can't start session under incule row
> ex: include("file.php"
>i can't start session under incule row
> ex: include("file.php");
> start_session();
>
> it say : can't add header header already sent by...v
>
> somebody can help me?
You can't have any output before session_start(). Call it first in your
file or fix where you have output. The er
On Wednesday 01 October 2003 01:39, Balazs Nemeth wrote:
> cd /apache/apache-xxx
> ./configure --prefix=/www
> cd /php/php-xxx
> ./configure --with-mysql --with-apache=/apache/apache-xxx
> --enable-track-vars
> make
> make install
> cd /apache/apache-xxx
> ./configure --activate-module=src/modules
Jason Wong wrote:
>On Wednesday 01 October 2003 01:39, Balazs Nemeth wrote:
>
>
>
>>cd /apache/apache-xxx
>>./configure --prefix=/www
>>cd /php/php-xxx
>>./configure --with-mysql --with-apache=/apache/apache-xxx
>>--enable-track-vars
>>make
>>make install
>>cd /apache/apache-xxx
>>./configure
But do you have php compiled --with-curl?
check phpinfo();
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forward"
mailto:[EMAIL PROTECTED]
http://accessingram.com
> -Original Message-
> From: Joseph Allard [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, Oc
Could you be a little more explicit? I don't understand "check phpinfo()?"
"Gary Every" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
But do you have php compiled --with-curl?
check phpinfo();
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forwar
You seem to be doing it fine as far as I can see, except for "song_id" which should be
"songs_id" in the query...
Bogdan
Barry Rumsey wrote:
> Hi
> I have three tables set out below:
>
> xp_artist: artist_id , artist _name
> xp_sings: artist_id , songs_id
> xp_songs: songs_id , song_name , lyr
t; <[EMAIL PROTECTED]>
To: "Barry Rumsey" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, January 07, 2002 1:51 PM
Subject: Re: [PHP-DB] help on mulit query
> You seem to be doing it fine as far as I can see, except for "song_id"
which should be &qu
Your query looks fine, except that it should be xp_sings.songs_id. What you
are trying to resolve is a many to many relationship where many artists can
sing the same song, hence you have created the table xp_sings. This is also
known as a pivot table.
What problem are you having?
Have you ec
To: "Barry Rumsey" <[EMAIL PROTECTED]>
>Cc: <[EMAIL PROTECTED]>
>Sent: Monday, January 07, 2002 1:51 PM
>Subject: Re: [PHP-DB] help on mulit query
>
>
> > You seem to be doing it fine as far as I can see, except for "song_id"
>which should
Just echo a link of the form Click for
lyrics and use the incoming song_id in lyrics.php to get it from the
database.
Bogdan
Barry Rumsey wrote:
> I did not see that ( I must be blind hehe ). One other question , I have the
> lyrics also stored in the database, how can I create a link so that w
Hi Djordie,
You need to have the connection to the DB in your php script
leksikon_in.php .
Gurhan
-Original Message-
From: Djordje Gacesa [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 07, 2002 9:44 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] help with insert needed
Hello, everybody!
for mssql(for Unix and linux) you need to install the sybase
libraries(freetds) and configure --with-sybase=/path/to/sybase so i the
MAC you must have to do something similar, but i have no idea what.
Hope this helps.
Jd
1 - 100 of 387 matches
Mail list logo