Greetings,
On 01/26/2016 08:18 AM, Karl DeSaulniers wrote:
> On Jan 26, 2016, at 7:10 AM, Alko Kotalko wrote:
>
>> Hi,
>>
>> I have a working connection from PHP to SAP HANA through PDO and regular
>> ODBC commands.
>>
[...snipped...]
>>
>> For example:
>> "SELECT * FROM dummy WHERE col1=$1 AND
wasn't that helpful for this case.
Can I setcookie('user_group', '3') and use that somehow???
Am I in the ballpark with this solution?
Thanks.
Jeff
the two color shades) and then displayed the 13
correct rows.
Perhaps this was the proper placement of nl2br but there is something
in the other code that screwed up the presentation???
Thanks.
Jeff
- Original Message -
From: "Jeff Broomall" <[EMAIL PROTECTED]>
To:
S
umbled together.
I checked within the MySQL database and noticed the Hard Returns show in the
database (at
least while using phpMyAdmin).
Must have something to do with PHP? Where did I go wrong???
Thanks.
--Jeff
tatement.
Then I guess I would have to figure out the code for the echo.
Am I at least in the ballpark???
Thank you and good night.
Jeff
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Good evening.
I'm sure this is something easy so I'm hoping you can simply steer me to a
good source.
I simply need to create a Checkbox list using data from my "groups" table.
I have a table with two fields:
1) groups_id
2) groups_name
The data contained is simple:
groups_id groups_name
>
> echo "...";
>
> }
>
> Its essentially the same thing, just neater and lets you concentrate on the
> code for the table without the worry about the way the row looks
>
> Bastien
>
Thanks again for the information.
Jeff
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
>
>
> bastien
>
>
> ps: a class css definition would be better here
Thanks for the help. After reading a couple of the responses, I
couldn't believe that I did not think of this. I don't know a lot about
CSS yet (just purchased a book). But, could you shar
t;blue";
>} else {
>$color = "red";
>}
>?>
>..
>
> }
>
> -Micah
Great, thanks for the help and information. May I ask, how does PHP
know to change the color? What do the "?&q
I have a table, where each line is the output of a query from a MySQL
database. I do not use borders, so the page is a little difficult to
read sometimes. Is it possible, or how do I, alternate the background
color of each row when I output it?
My code is like this:
while (query) {
What sort of tools are available for creating database CRUD
forms(create,retreive,update,delete)? I am familiar with patForms and
cake.
What are the other leading contenders?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
thats no good. man if its something simple, i'm not seeing it.
well it was something simple...and now i see it. old_passwords.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Jason Wong wrote:
On Sunday 06 February 2005 07:59, Jeff wrote:
OK, but my understanding was that your mysql server is on *nix, and your
problem was accessing it from a windows client. So you should not be
using localhost?
I just did that for a test to remove the remote connection from the
Jason Wong wrote:
On Sunday 06 February 2005 04:58, Jeff wrote:
Hi. I need to access mysql from windows to *nix on both the default
port of 3306 and a secondary port of 3307. php.ini states that win32
will only pay attention to MYSQL_PORT.
Just specify the port you want to use in mysql_connect
s. Part of our
application needs to reside on windows and communicate with *nix.
If this doesn't work, i guess i could use IPTables to NAT when requests come in
on certian IPs?
THanks for any assistance/advice you may have.
Jeff
--
PHP Database Mailing List (http://www.php.net/)
To unsu
g and the mode modifiers "l", "d", "-" and "t" were added
in PHP 4.3.0. In PHP versions before PHP 4.3.0 you must use semaphores
to guard against simultaneous database access for any database handler
with the exception of GDBM. See System V semaphore suppor
ces are the socket closed also, right?
-Jeff
Brian Foddy wrote:
I've been using PHP4/5 and Sybase for several years, using standard
sybase_connect. Today I tried playing around with pconnect to get
aquainted.
I expected one simple condition of a "use database" from one web pag
once it has done this, I need to get the id it has generated in
> the DB and then update that record with the id it generate, so how
> can I get the id from the above insert?
>
> Any help would be greatly appreciated :-)
>
> Regards
>
> Chris
---
Listserv only address.
Jeff Shapiro
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
as a work type associated with it, currently the Work Type
> column of the Project table holds the work type name, however i have now
> added a Work_Type_ID column to the Work_Type table and i would like Projects
> to hold the Work_Type_ID as opposed to the Work Type Name.
>
> Thanks for
to update Projects with one query?
>
> Thanks for your help
---
Listserv only address.
Jeff Shapiro
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ow 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 help
---
Listserv only address.
Jeff Shapiro
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
p by grade having cnt>1
>> and then
>> select * from studs where sno in ('result of previous query')
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
---
Listserv only address.
Jeff Shapiro
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
> table | type | possible_keys | key| key_len | ref| rows |
> Extra |
>
+++---++-++++
>> Response| ALL| [NULL]| [NULL] | [NULL] | [NULL] | 126732 |
> Using temporary|
>
e any experience with this?
Jeff
7;$type',
'$vhd', '$file', '$kb', '$grd', '$open', '$sour', '$tube', '$landed',
'$casing', '$landed2', '$shut_date', '$shut_time', '$pres', '$tag')";
- if you hit ok again, it just loops.
This might be solved as soon as I get that one field to auto populate. :P
"Richard Hutchins" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Jeff,
>
> No problem. Happens to everyone, trust me.
>
> Anyway, I see you
x27;d suggest you first output your SQL statement to the browser to see
> exactly what it's sending to the database. Might give you the answer right
> there.
>
> > -Original Message-
> > From: Jeff [mailto:[EMAIL PROTECTED]
> > Sent: Friday, September 05, 2003
" formation = '$formation' ";
> $field_str .= " perfs = '$perfs' ";
> $field_str .= " event = '$event' ";
> $field_str .= " fluid = '$fluid' ";
>
> hth
> Jeff
>
>
>
>
Hell!
I'm having a small problem with modifying the data in a MySQL DB.
And here's the error:
(After I click the "Submit Changes" button) Error: 1064: You have an error
in your SQL syntax near '(10-10-10-10)' kwo='1235', lsd='10-10-10-10',
date='2003-05-05', well' at line 1
Here's the code:
ted was to use an ODBC driver to interface
> between PHP and MySQL but indicated that this may be slower.
>
> My question, therefore, is - is there a way to upgrade the MySQL
> client in PHP 4.3.3? If not, what are the alternatives (apart from
> reverting back to MySQL 4.0.x
r_id'] in your WHERE
> clause.
>
> I'm sure there are other ways to handle this. This is how I have handled
it
> in the past though.
>
> > -Original Message-
> > From: Jeff [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, August 05, 2003 3:52 PM
> >
Oops, my mistake, it's not a blank entry - it re enters the last entry.
I can hit F5 or click refresh 1000 times and it will enter the last entry
1000 times.
"Jeff" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I tried putting that in a few diffrent
I tried putting that in a few diffrent places, same result - is there
somewhere special I need to put that?
"Matt Schroebel" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> -Original Message-
> From: Jeff [mailto:[EMAIL PROTECTED]
> Sent: Tuesday
gosto de 2003 08:51:04 a.m.
To: 'Jeff'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Sorting issue
Seeing code might help us.
Aaron
> -Original Message-
> From: Jeff [mailto:[EMAIL PROTECTED]
> Sent: August 8,
Yes duh...
I didn't realize numbers weren't considered characters.
What's the sql entry for numeric characters?
I'm new at this, and figure I'm not doing to bad so far. .
"John W. Holmes" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
Seems like changing the mixed fields back to VARCHAR worked!
Thanks again guys!
"David T-G" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
kwo isn't sorting properly... actually, I need to retest the lsd column too.
"John W. Holmes" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Jeff wrote:
>
> >$query = "SELECT kwo, lsd, date, event FROM $gradient_tablename
> >
forces it to look at the entire record before sorting it?
Thanks
Jeff
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
dashes.
If I set it back to varchar, will it sort it right because the numbers are
separated by an alfa character, or will I have the same problem as before?
"Jeff" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Thank you EVERYONE.. AGIAN! *grin*
>
>
>
echo "";
if($page_num > 1) {
$prev_page = $cur_page - 1;
echo "[Top]";
echo "[Prev]";
}
if($page_num < $total_num_page) {
$next_page = $cur_page + 1;
$last_page = $total_num_page - 1;
echo "[Next]";
echo
Thank you EVERYONE.. AGIAN! *grin*
"John W. Holmes" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Jeff wrote:
>
> > Yes duh...
> >
> > I didn't realize numbers weren't considered characters.
> > What's the sql entr
Well I did what you said, and now I get "Parse error: parse error,
unexpected T_ECHO in C:\FoxServ\www\encana_db.php on line 44"
And magic_quotes_gpc was already ON.
"Matt Schroebel" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> -Origi
wrote in message
news:[EMAIL PROTECTED]
> -Original Message-
> From: Jeff [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 05, 2003 12:59 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] MySQL Returns Error
>
> Been working on this code all weekend, and I did take
ARCHAR(6) NOT NULL,
shut_date VARCHAR(10) NOT NULL,
shut_time DATE DEFAULT '-00-00' NOT NULL,
pres VARCHAR(15) NOT NULL,
tag VARCHAR(15) NOT NULL,
PRIMARY KEY (lsd),
UNIQUE gradient (gradient)
);
"Jason Wong" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECT
Hi... again. :P
Been working on this code all weekend, and I did take everyone's advice, but
I'm still getting the same error. "Error retrieving records. From line
"$result = mysql_query($query, $link_id) OR DIE("Error retrieving
records."); " of my code. When I first put the insert query in, i
GAH! I don't userstand why this woudl work onyl once, then return a
Error retrieving records.I've even recreated the sql DB, same result.
"Jeff" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Well, it worked for ONE submission I was so excited. :)
t; <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Myfault.. you should be using link_id instead of dbHandletry this:
>
> $result = mysql_query($strSQL, $link_id) OR DIE("Error retrieving
records.");
>
>
>
>
>
>
> Quoting Jeff <[EMAIL P
Oh, and another thing, in this book I have, they say to give the forum
action .
Yet it dosn't give a value to $PHP_SELF.
IS this correct?
"Jeff" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> K, that got my a bit further, now it shows half the page
gt; ('$kwo', '$lsd', '$date', '$well', '$field', '$uni', '$license',
'$formation')";
> $result = mysql_query($strSQL, $dbHandle) OR DIE("Error retrieving
records.");
>
>
>
>
>
> Quoting J
ror.
>It's SQL. Put it in quotes, assign it to a variable, and call it
>through a mysql_query() function.
Error: Parse error: parse error, unexpected T_STRING in
C:\FoxServ\www\encana_db.php on line 36
My new code:
> --- Jeff <[EMAIL PROTECTED]> wrote:
> > Sorry, I j
> On Saturday 02 August 2003 01:46, Jeff wrote:
>
> > I tried doing this through the news server, but something messed up.
> >
> > I just need to know how to make an HTML form write to a MySQL DB.
> > This is what I have so far.
>
> [snip]
>
> And does it wor
sd, date, well, field, uni, license,
formation) VALUES ('$kwo', '$lsd', '$date', '$well', '$field', '$uni',
'$license', '$formation')
-Original Message-
From: Jason Wong [mailto:[EMAIL PROTECTED]
Sent: Augus
Hi!
I tried doing this through the news server, but something messed up.
I just need to know how to make an HTML form write to a MySQL DB.
This is what I have so far.
DB
Home | Display All
| Search
Total Entries:
http://dataguy/logo_small.jpg>
Title for page
ty in packages
debian sure seems to beat the pants off of RedHat.
But, sorry, that doesn't help your immediate problem.
- Jeff
On Thu, 2003-07-24 at 11:33, Nabil wrote:
> please please would you help me to get
>
> mysql - gd - iodbc (odbc) - mssql - apache
>
> I need
I figured out the field seperation on my own.
Thanks anyway,
jeff
Jeff Langley wrote:
> Hi,
>
> I am reading an already created gdbm file with dba_fetch into an array.
>
> I am able to print out the array but not the individual
> elements. The elements are separated with a
gdbm file do I have to stick with dba_*
calls or are there other function I can use to process the data?
Thanks,
Jeff
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
connection and insert. If that can happen, then do you get
the right insert_id value back when person_page_1 resumes? Or do you get the
most recent, which would be the insert from person_page_2?
Thanks,
Jeff Veit
http://www.tanasity.com/ - Tanasity develops software and net applications -
radical
bpthread.so.0...done.
Loaded symbols for /lib/libpthread.so.0
#0 0x407a5582 in sskgmstat () from
/opt/oracle/OraHome1/lib/libclntsh.so.9.0
-Original Message-
From: Harris, Jeff
Sent: Tuesday, July 08, 2003 5:52 PM
To: '[EMAIL PROTECTED]'
Subject: Weird Segfaults with Oracle, P
-Original Message-
From: Thies C. Arntzen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 5:33 AM
To: Harris, Jeff
Cc: '[EMAIL PROTECTED]'
Subject: Re: [PHP-DB] Weird Segfaults with Oracle, PHP, Apache2
On Tue, Jul 08, 2003 at 05:51:47PM -0500, Harris, Jeff wrote:
atement($stmt);
OCILogoff($conn);
echo 'here7';
?>
The server segfaults right after it gets to "here3". If you comment out
everything after here3, the page works fine. Running the $stmt select works
fine if you use sqlplus. I'm not sure why it's dying.
Has an
he padding that
was used?
Thank you,
Jeff Wiegley
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
gt; To unsubscribe, visit: http://www.php.net/unsub.php
---
Listserv only address.
Jeff Shapiro
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
gt;
> @ $db = mysql_connect("localhost");
> mysql_select_db("me2resh00");
> $query = "insert into recipients (recipient_name, recipient_email) values
> ('"friend"', '".$mails[$i]."')";
> $result = mysql_query($query);
> if ($result)
("INSERT INTO agents (agent_name)
>VALUES ('$agentname')
>
> but I need to find out the ID value it created, how can I do this easily?
>
> Thanks
>
> Chris
---
Listserv only address.
Jeff Shapiro
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
try :
if (strlen($products) == 0) {
echo "nothing entered in field";
}
http://www.php.net/manual/en/function.strlen.php
Jeff
- Original Message -
From: "Aaron Wolski" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 0
hi, david, thanks for responding..
David Russell wrote:
Hi Jeff,
Just a question - why are you using ODBC instead of PHP's native
Interbase connectivity? ODBC is definitely slower.
good question.. i think it pretty much boils down to the following reasons:
1) my IP dept has voice
thanks for the correction, miles and martin.. just an email typo.
i still have the problem though. :(
--
Jeff Stern 949-824-2326 [EMAIL PROTECTED]
Social Sciences Computing Services
University of California, Irvine
3151 Social Science Plz
Irvine CA 92697-5100
On Tue, 19 Nov 2002
hi, i am having the devil of a time with this. have been researching it
for 3 weeks. have posted to php.faqts.com (no answer), looked a million
times on php.net, and www.borland.com/interbase, written people email
(no response!) and even tried to get the people at easysoft to answer
(they are w
variation of it could be used throughout dbx?
Thank you,
Jeff Van Campen
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
have been due to
mysql_pconnect or something holding open previous connections to the db and
the script just connecting to the last connected db. Anyway...
Sorry for the trouble!
Jeff
> -Original Message-
> From: hugh danaher [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 0
e with only some name changes (for security,
ya know):
And then the code in my include where I keep all the db connection stuff:
Any help is appreciated!! Thanks!
Jeff
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ce
I don't really care about the development db's being in synch on the master,
why bother. Does this make sense?
Anyway, I hope I've made this clear enough for someone to jump with answers
and comments.
Jeff
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ter
handled by PHP after pulling the data out of mysql?
Any help I can get on this would be greatly appreciated.
Thanks.
-Jeff
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
How can I do a query for a distinct field plus get the info from
other fields? I tried this:
select DISTINCT email, name_first, name_last, id from applicants;
and it gave me everything. Thanks.
Jeff Oien
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
shows these breaks? I can't find any \n in the data. Then
when it's sent via email of course there are no line breaks displayed.
Jeff Oien
> Hiya,
>
> If I remember correctly, you much send both \r and \n to terminate a line
> on an e-mail, regardless of the platform. Thi
I tried wrap=hard already. I should have mentioned that. Sorry if this is
off topic.
Jeff Oien
> You need a wrap= within your textarea.. You may need a couple if the
> browsers haven't come together on it yet.. But you can check it out here:
>
> http://www.blooberry.com/indexdo
This isn't what I'm looking for because the output is to email not HTML.
What I would like is the natural line breaks in the form input to be
preserved and then result in line breaks in the email without having
to add any \n, which didn't work anyway.
Jeff Oien
> check ou
d those \n show up in the database data. I must be missing
something. Thanks for any help.
Jeff Oien
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
$row['username'];
$title1 = $row['album_title'];
$title = stripslashes($title1);
$date1 = $row['date1'];
$cnt = $row['cnt'];
$display_block .= "
$title
$cnt$date1";
}
> Hi Jeff,
>
> the most important rule you should follow: don'
make this more efficient?
http://www.webdesigns1.com/temp/code.txt
Jeff
--
$table_name = "Chart_Users";
$sql = "SELECT * FROM $table_name order by album_title";
$result = @mysql_query($sql,$connection) or die(" Couldn't execute que
Could anyone give me an example of how to use GREATEST
and LEAST in a MySQL query. I want to look through the
last 15 records in a certain field and find the highest and/or
lowest number. Thanks.
Jeff Oien
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
Hello
How do you Normal put you mysql data in to a php table.
Jef
--
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]
Hello
I am trying make a script fatch my data form my mysql database. I use
this script but when execute it is says
Warning: printf(): too few arguments in
/home/httpd/html/larken/database.php on line 47
any hints
Thanks Jeff
\n";
echo "Name of contactName of company
Add
W() where id = '$id'";
However, time1 is being updated to be the same as time2 after
the exit and I don't want it to be. Am I missing something?
Jeff Oien
--
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]
I can't seem to locate the php.ini file on my server. Phpinfo() shows it to
be in /usr/local/lib but I can't seem to see it (logged as root). I'm on OSX
Server 10.0.3 using PHP 4.0.6. Does anybody have have any clues where to
locate this file?
Thanks,
Jeff Panis
[EMAIL PROTECTED
I'm attempting to setup the PHP module to allow the mail() function to work.
As I understand, I need to edit the php.ini file? I can't locate the file to
edit. Can someone point me in the right direction? I'm using OSX Server.
Thanks,
Jeff Panis
[EMAIL PROTECTED]
--
PHP Databa
stored in
$store to automatically fill in on the drop down list. But, for some
reason it is defaulting to the first option, and not using the value
that is in the database.
Can I use a drop down menu, or should I just go to radio buttons?
Thanks,
Jeff
--
Jeff Grossman ([EMAIL PROTECT
{
$store=$row["store"];
$jobdesc=$row["jobdesc"];
$rowid=$row["rowid"];
echo "
$store
$jobdesc
Modify/
Delete
\n;
}
echo "";
mysql_free_result($result);
?>
Return To Main Menu
Add An I
ut them into an array? Thanks for the help.
Jeff Oien
> I don't know of a way to do the insert in a single query (anyone?!?) with
> this... but
>
> assuming the fields in pic are
> id int PRI
> location varchar(30)
> picnumber int
> user varchar(20)
>
> $query = &
sword stuff but this I'm just clueless.
Jeff Oien
> I would add the field "picnumber int" or something to your DB.
> This is where the pic falls in the order of pics in the album.
>
> The the previous and next should be as simple as doing
> select picnumber,picloc
I like the new password idea. How do I make sure it's them who's creating
a new password so that someone else doesn't maliciously change their
password? If someone knew someone's username and e-mail address
I would think they could change it. Thanks.
Jeff
> This doesn'
sword they use for other
things I think it would be best for it to be encrypted.
Jeff Oien
--
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]
s the second etc. and know which the current
one is if the id field has gaps in it. Not sure if that made any sense.
Jeff Oien
--
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 administrato
;) from Chart_Users;
or
select date_format(creation_date, '%M %D, %Y') as creation from Chart_Users;
Jeff Oien
> Jeff,
>
> mysql> select now();
> +-+
> | now() |
> +-+
> | 2001-08-29 21:21:50 |
> +
Isn't that what I tried?
Jeff Oien
> Although it might be better to format the date in php, don't forget you can
> also do date formating in the select string. The date format functions for
> mySQL can me found here:
>
> http://www.mysql.com/doc/D/a/Date_and_time_func
I have a date like this in date format in MySQL
2001-08-29
and I want it to say
August 29, 2001
I tried this and it didn't work.
select date_format('creation_date', '%b %D, %Y') from Chart_Users;
Could you tell me what I'm doing wrong or how I should do th
I should have said photo_filename. That was what I intended to do.
Would you suggest one directory for all photos or separate directories
for each user?
Jeff Oien
> Rick: I don't see any .php tags there... plus just because someone
> else has done it doesn't mean he can
Thanks for the suggestion but this is a personal project to be used
for learning and as a place for friends to post photos with only the features
that we all want.
Jeff Oien
> This has been done. see http://www.photopoint.com
>
> This is a free service available to the public.
I want to make a photo album that will have users who sign up
to create an album and then have the albums open to the public.
I was thinking of doing it like this but I've never done a relational
database before so if anyone thinks of anything I should change
please let me know. Thanks.
Jeff
> "Jeff Oien" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > I want to retrieve the last 15 days of data from a certain time but
> > not today's. I have this but it's still giving me today's data:
1 - 100 of 143 matches
Mail list logo
