[PHP-DB] Stange PHP bug?

Hi There, I'm developing a website for my boss, and it works PERFECTLY for me and everyone else i've shown it too, but when my boss goes to the page anything that is PHP related just doesn't show up on his machine. He is using Windows XP with Explorer 6, just like my development machine, but

Re: [PHP-DB] serving up images

Matthew Horn wrote: I have about 25 or so images that I would like to serve up on my site's home page. I would like the image to change every 3 days or so. Does anyone have a hint as to how I might go about doing this in a simple fashion? I don't want it to be random, but I do want it to cycle

[PHP-DB] i am so Lost with Php

I bought my own domain and have Php on it and Myslq..i have no idea what these are or how to use the php to set up a guestbook, etc..Is there any sites that would tell me how step by step..My host would do it for a fee and I want to do it myself thanks marion -- PHP Database Mailing List

[PHP-DB] Can anyone see why unlink isn't working?

Hi there everyone, I have image details stored in my DB, and i'm trying to remove the ones I select, but I keep getting an error saying that there is an unexpected T_Variable, can anyone see what is wrong here? It's probably obvious, but for the life of me if (count($del) = 1) { for

[PHP-DB] Forget my last post

Sorry everyone, forget my last post about the T_Variable, I was right it WAS a stupid question LOL :-) Chris

[PHP-DB] Re: about resultset internal pointer

I agree what David says. but the point is if someone else moved the pointer using mysql_data_seek($i) and he didn't tell me how much $i is, or I use mysql_data_seek so many times that I can't remember the sum of the offsets. I don't think write a tracker is a feasible way, because there are so

[PHP-DB] Re: Database backup

In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... Hi there everyone, Is there a quick way I can backup all my databases on Linux so I can download them to my HD/Burn them onto CD? I've started a very large travel project and there is going to be over 100 DB's in the end, each

[PHP-DB] Re: Can anyone see why unlink isn't working?

maybe $path$nameb is wrong $path.$nameb??? Try echoing $path$nameb and see if is is a valid file path. Jochem Chris Payne wrote: Hi there everyone, I have image details stored in my DB, and i'm trying to remove the ones I select, but I keep getting an error saying that there is an unexpected

Re: [PHP-DB] MySQL, PHP or ghost?

Hmmm... You have a point; the doc is not quite clear. Illegal YEAR values are converted to My understanding is that any illegal value will be first converted into '', then into the corresponding year inside the 1901-2155 interval, ie 2000 Well, all this is quite logical. I have no

[PHP-DB] Simple field replace...?

Hi there, I need to take a field in my database, and remove the first 32 characters from each entry... There are 100's, and I know there's gotta be an easy way... I've looked up string replace, and it only appears to work one at a time... Can anyone tell me how to make it accross the whole

RE: [PHP-DB] Simple field replace...?

I guess there is no other solution just do it one at a time... it's no problem even if there are 100's. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: donderdag 28 augustus 2003 11:35 To: [EMAIL PROTECTED] Subject: [PHP-DB] Simple field replace...? Hi

Re: [PHP-DB] Simple field replace...?

hundreds of what? rows or columns? Ignatius _ - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 28, 2003 11:35 AM Subject: [PHP-DB] Simple field replace...? Hi there, I need to take a field in my database, and remove the

RE: [PHP-DB] Simple field replace...?

Try using the substring function in your sql statement Substring('String',32); Jack -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, August 28, 2003 11:35 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Simple field replace...? Hi there, I need to

Re: [PHP-DB] Simple field replace...?

Sorry, I'll specify... I have one column, in a row of perhaps 4 fields. I want to remove the first 32 characters from onlt one field EG: My DB: namedateurl ip bob 1/2/99 http:// 1.1.1.1. sue 4/6/01 http:// 2.2.2.2 If I wanted to remove just the http bit and leave :// I'd

Re: [PHP-DB] Simple field replace...?

Then a simple substring will do: UPDATE mytable SET url = SUBSTRING( url FROM 5 ) btw your date column looks pretty awful. HTH Ignatius _ - Original Message - From: [EMAIL PROTECTED] To: Ignatius Reilly [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday,

RE: [PHP-DB] Simple field replace...?

like Jacob said, use the string functions of mysql in the actual SQL statment, not php. http://www.mysql.com/doc/en/String_functions.html UPDATE TABLE SET FIELD = SUBSTRING(FIELD,33) 33 as you will want to delete the 32'nd char -Original Message- From: [EMAIL PROTECTED]

[PHP-DB] looking for a .exe file

I need a php editor file thanks for help! ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] looking for a .exe file

From: blond al [EMAIL PROTECTED] I need a php editor file thanks for help! file:///WINNT/system32/notepad.exe You're welcome. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Simple field replace...?

Was just an examle date column ;-) Anyhoo, jsut a note to say, it's sorted..(I did the mass replace by hand :-( but at least it's done... I've also sorted anotehr prob too, so all in all, a productive morning... I jsut wish I could remember all this stuff for next time! Ignatius Reilly

[PHP-DB] Populating an array from mysql db

I have a course booking system that allows the client to add courses and then specify how long they run for. The admin system I have built allows the client to add up to 30 dates for each instance of the course and these are adding to a database row in the form date1, date2, date3, daten etc.

Re: [PHP-DB] Populating an array from mysql db

I'd worry about the empty dates after. and use something like. $qry = select date1, date2 from table; $result = mysql_query($qry) or die(mysql_error()); while ($rs = mysql_fetch_row($result)) { //this array could be built a number of ways, one is $bookdate[] = array($rs[0],$rs[1]); } if

Re: [PHP-DB] Stange PHP bug?

Hi there, This is the strange thing, it works on the other PHP sites i've done for him, and this new one uses exactly the same menu/display engine as the other sites I wrote for him, so there shouldn't be any problems in THEORY, it's just the most strange thing i've ever seen. I've told him if

Re: [PHP-DB] MySQL, PHP or ghost?

El Mié 27 Ago 2003 11:34, Ignatius Reilly escribió: Hmmm... You have a point; the doc is not quite clear. Illegal YEAR values are converted to My understanding is that any illegal value will be first converted into '', then into the corresponding year inside the 1901-2155

Re: [PHP-DB] Stange PHP bug?

Hi there, No that's the strange thing. I have written several websites for him which all work fine, this new website is in development and works fine on the 2 PC's here and 3 friends in the UK it's only on HIS machine that this doesn't work. And that's what's odd, I am using the same PHP

Re: [PHP-DB] Populating an array from mysql db

From: mike karthauser [EMAIL PROTECTED] I have a course booking system that allows the client to add courses and then specify how long they run for. The admin system I have built allows the client to add up to 30 dates for each instance of the course and these are adding to a database row in

[PHP-DB] Thanks

Hi. Thanks for all your help with the referer and the and, or || subject. I realize that neither of my questions were database related. I've looked again at the email lists offered on the PHP site and see now that there is a general user list. I had somehow missed that before and felt I had

RE: [PHP-DB] Logic Help...

Thanks for all the help. I was finally able to get this working properly by viewing the variable data as suggested. I then ran into another minor issue with session variables keeping their old values on a second pass through the application, but I resolved this by unregistering these

Re: [PHP-DB] MySQL, PHP or ghost?

Well, it IS logical provided one is aware of the rules of the game, meaning, as you rightly point out, that MySQL does not reject SQL statements for incorrect values, but attempts at converting them at any price. I have no clue whether it is or not a shortcoming of the implementation (I do not

Re: [PHP-DB] i am so Lost with Php

Marion, marionh said: I bought my own domain and have Php on it and Myslq..i have no idea what these are or how to use the php to set up a guestbook, etc..Is there any sites that would tell me how step by step..My host would do it for a fee and I want to do it myself thanks marion --

Re: [PHP-DB] Populating an array from mysql db

on 28/8/03 1:09 pm, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: I'd worry about the empty dates after. and use something like. $qry = select date1, date2 from table; $result = mysql_query($qry) or die(mysql_error()); while ($rs = mysql_fetch_row($result)) { //this array could be built

Re: [PHP-DB] Stange PHP bug?

Hi there, Well I mean a new virtual website yes, all permissions are enabled for all users with PHP/MySQL enabled (Oh and it's Apache 2.0.40). I checked and all permissions are there, it parses the PHP files and outputs the HTML for standard HTML pages for him, just not any PHP. it doesn't say

Re: [PHP-DB] Populating an array from mysql db

From: mike karthauser [EMAIL PROTECTED] Thanks for this - I ended up rehashing my query to this: ? $result = mysql_query(SELECT * FROM dates WHERE bookcode = '$bookcode' ORDER BY date1,$db); // loop to populate array $myrow = mysql_fetch_array($result); $i = 1; while ($i = '30') {

[PHP-DB] SESSION SID Question

Howdy Listers, Can someone explain to me the mechanism by which SID acquires a value? For example, $FOO = SID; echo $FOO; produces something like PHPSESSID=ade4055eef947f1a00cdb280470e859b when IE is first opened and the page is loaded, whereas reloading of the page produces an empty string

Re: [PHP-DB] Populating an array from mysql db

on 28/8/03 5:00 pm, CPT John W. Holmes at [EMAIL PROTECTED] wrote: Thanks for this - I ended up rehashing my query to this: ? $result = mysql_query(SELECT * FROM dates WHERE bookcode = '$bookcode' ORDER BY date1,$db); // loop to populate array $myrow = mysql_fetch_array($result);

RE: [PHP-DB] Populating an array from mysql db

On 28 August 2003 17:25, mike karthauser wrote: on 28/8/03 5:00 pm, CPT John W. Holmes at [EMAIL PROTECTED] wrote: Thanks for this - I ended up rehashing my query to this: ? $result = mysql_query(SELECT * FROM dates WHERE bookcode = '$bookcode' ORDER BY date1,$db);

[PHP-DB] SESSION SID Question

Howdy Listers, Can someone explain to me the mechanism by which SID acquires a value? For example, $FOO = SID; echo $FOO; produces something like PHPSESSID=ade4055eef947f1a00cdb280470e859b when IE is first opened and the page is loaded, whereas reloading of the page produces an empty string

Re: [PHP-DB] SESSION SID Question

From: [EMAIL PROTECTED] Can someone explain to me the mechanism by which SID acquires a value? For example, $FOO = SID; echo $FOO; produces something like PHPSESSID=ade4055eef947f1a00cdb280470e859b when IE is first opened and the page is loaded, whereas reloading of the page produces an

[PHP-DB] Problemas con ingreso y modificacion de datos en formularios con PHP y MySQL.

Tengo un problema con algunos programas en php, estoy usando 4 frames 3 de ellos son para ingreso de datos, el frame superior es utilizado para ingresar y verificar información que es validada contra una bases de datos (actualmente solo muestra información existente), en el frame central muestra

Re: [PHP-DB] MySQL, PHP or ghost?

El Jue 28 Ago 2003 11:25, Ignatius Reilly escribió: Well, it IS logical provided one is aware of the rules of the game, meaning, as you rightly point out, that MySQL does not reject SQL statements for incorrect values, but attempts at converting them at any price. I have no clue whether it is

Re: [PHP-DB] MySQL, PHP or ghost?

Well, you're certainly right (except I didn't get the meaning of 'FS' - anything obscene?). However: 1. The job of this ML is to help people get things done 2. For criticisms concerning the design of MySQL, you may get better results posting directly at the MySQL dev team. 3. You may decide that

[PHP-DB] Code and Review???

Hello, I'm still pretty new to MySQL, OO PHP and Javascript. Wanted a couple of you to review the multidimensional array code and let me know if this code is ok? Also, would like for a couple of you to go to my webpage http://homepage.mac.com/ateam3/ateam3/freemain.htm and slide down to the

[PHP-DB] Code and Review ???

Hello, I'm still pretty new to MySQL, OO PHP and Javascript. Wanted a couple of you to review the multidimensional array code and let me know if this code is ok? Also, would like for a couple of you to go to my webpage http://homepage.mac.com/ateam3/ateam3/freemain.htm and slide down to the

[PHP-DB] Heop someone can help with this.. involves sessions.

Hi Guys, I really hope you don't mind the OT post but I've looked everywhere and can't seem to find a solution to my problem. I am passing a var in a session (not in the URL) to my secure checkout area and it's not capturing the variable. I know there is a problem with using sessions across

Re: [PHP-DB] MySQL, PHP or ghost?

El Jue 28 Ago 2003 17:20, Ignatius Reilly escribió: Well, you're certainly right (except I didn't get the meaning of 'FS' - anything obscene?). However: File System. 1. The job of this ML is to help people get things done 2. For criticisms concerning the design of MySQL, you may get better

[PHP-DB] Test

Please disregard. :) :) Gale L. Allen Jr Macintosh Support Specialist Phone: 919/412-5039 Homepage: http://homepage.mac.com/ateam3/Menu5.html iChat = [EMAIL PROTECTED] Remember, It's only Rock 'n Roll, but I like it! (:

[PHP-DB] Code - Review ???

Hello, I'm still pretty new to MySQL, OO PHP and Javascript. Wanted a couple of you to review the multidimensional array code and let me know if this code is ok? Also, would like for a couple of you to go to my webpage http://homepage.mac.com/ateam3/ateam3/freemain.htm and slide down to the