Re: [PHP-DB] String manipulation

2009-09-11 Thread boclair
Ron Piggott wrote: How would I put a space after each letter: echo str_shuffle(stripslashes(mysql_result($word_result,0,word)); Ron CSS best handles styling E.G. div style=letterspacing:0.5em;php echo $word_result;?/div OR ?php print div

[PHP-DB] Could not run query

2008-09-27 Thread boclair
I need help to track down the cause of the error,Could not run query A typical query is $laterrecords = mysql_query(SELECT * FROM messages WHERE `logged` $timebegin ORDER BY `logged` DESC ) or die (Cannot select:br$querybrError: . mysql_error()); Louise -- PHP Database Mailing List

[PHP-DB] Highlighting data selected from one table that appear in another

2005-09-01 Thread boclair
Content-Type: multipart/alternative; boundary=070700030402040702060708 X-Authentication-Info: Submitted using SMTP AUTH PLAIN at omta05ps.mx.bigpond.com from [138.130.220.111] using ID boclair at Thu, 1 Sep 2005 11:49:59 + This is a multi-part message in MIME format

Re: [PHP-DB] Highlighting data selected from one table that appear in another

2005-09-01 Thread boclair
Miles Thompson wrote: At 08:50 AM 9/1/2005, boclair wrote: Content-Type: multipart/alternative; boundary=070700030402040702060708 X-Authentication-Info: Submitted using SMTP AUTH PLAIN at omta05ps.mx.bigpond.com from [138.130.220.111] using ID boclair at Thu, 1 Sep

[PHP-DB] Re: Highlighting data selected from one table that appear in another

2005-09-01 Thread boclair
Frank Flynn wrote: But if you could be more specific - send the schema and precisely what you were looking to do I could give you an example of how to make it work. I am still having difficulties with my workup and more help would be appreciated . I have two tables CREATE TABLE

[PHP-DB] Parsing PHP sourced from blob

2005-04-18 Thread boclair
When a php statement is part of a markup snippet in a mysql database table field, what must be done to have the php parse in the html A simple demo demonstrating my problem is at http://www.boclair.com/test/blobvars.php Louise -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

[PHP-DB] Displaying the time of the Latest Update to an ISAM table

2005-02-20 Thread boclair
PHP 4.3.10 MySql 4.0.20 How do I find and then display on a web page the time that additional data added to, or, existing data amended in an ISAM table? My latest futile attempt , with connection made and the database already selected, ?PHP $logged = mysql_query(SHOW TABLE TABLE UPDATE_TIME

Re: [PHP-DB] Displaying the time of the Latest Update to an ISAM table

2005-02-20 Thread boclair
Typo. Sorry. Should read of course SHOW TABLE STATUS UPDATE_TIME Louise boclair wrote: PHP 4.3.10 MySql 4.0.20 How do I find and then display on a web page the time that additional data added to, or, existing data amended in an ISAM table? My latest futile attempt , with connection made

Re: [PHP-DB] putting strings together with a linefeed

2004-04-16 Thread boclair
- Original Message - From: Hull, Douglas D [EMAIL PROTECTED] For example, say I have a variable $mytext = 'what up doc'. Now I want to add the text 'not much' to the end of this variable. But I want to place a return or linefeed after the original text so when I echo $mytext it looks

Re: [PHP-DB] Changing colors in table?

2002-09-30 Thread boclair
- Original Message - From: Blue Tiger [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 10:13 AM Subject: RE: [PHP-DB] Changing colors in table? : The blank table column comes from a blank MySQL database field...(I was : initially going to blob images from there

Re: [PHP-DB] Indepth Tutorial... need help.

2002-09-03 Thread boclair
http://www.mysql.com/doc/en/Tutorial.html is a good place to start with the mysql functions in the php manual. http://www.devshed.com/Server_Side/ has a number of on line tutes amongst others. phpbuilder also is useful. The normalisation article is a good first step; it is at

Re: [PHP-DB] Nothing returned

2001-11-03 Thread boclair
- Original Message - From: Martin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, November 04, 2001 8:29 AM Subject: [PHP-DB] Nothing returned : Why am I not getting anything returned from this function? : I have code doing a if user exists and b if user doesn't exist. I'm not

Re: [PHP-DB] Date_Format Question

2001-08-29 Thread boclair
- Original Message - From: Jeff Oien [EMAIL PROTECTED] To: PHP-DB [EMAIL PROTECTED] Sent: Thursday, August 30, 2001 11:07 AM Subject: [PHP-DB] Date_Format Question 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

Re: [PHP-DB] Date_Format Question

2001-08-29 Thread boclair
- Original Message - From: boclair [EMAIL PROTECTED] To: [EMAIL PROTECTED]; PHP-DB [EMAIL PROTECTED] Sent: Thursday, August 30, 2001 1:09 PM Subject: Re: [PHP-DB] Date_Format Question - Original Message - From: Jeff Oien [EMAIL PROTECTED] To: PHP-DB [EMAIL PROTECTED] Sent

Re: [PHP-DB] MySQL Connect Problem

2001-05-16 Thread boclair
Here is sample code: ? $connection = @mysql_connect(localhost, jeff, *) or die(Couldn't connect.); if ($connection) { $msg = success!; } ? This is on my machine only used by me. I also tried connecting to IP address and 127.0.0.1 and it still won't work. Thanks. Jeff Oien Are

Re: [PHP-DB] Forms : Validating user input is integer

2001-04-08 Thread Boclair
Manuel, Manuel Lemos [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... | Hello boclair, | | On 05-Apr-01 01:58:24, you wrote: | | I have a problem with a user input in a form required to be an | integer, creating a variable for a mysql query. | | I have i

[PHP-DB] RE : [PHP-DB] Forms : Validating user input as integer

2001-04-07 Thread boclair
Manuel, Manuel Lemos [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... | Hello boclair, | | On 05-Apr-01 01:58:24, you wrote: | | I have a problem with a user input in a form required to be an | integer, creating a variable for a mysql query. | | I have i

Re: [PHP-DB] Forms : Validating user input is integer

2001-04-05 Thread boclair
r validation was being with a javascript and the creation of the variable was OK. Further advise appreciated. Tim - Original Message - From: Steve Farmer [EMAIL PROTECTED] To: boclair [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, April 05, 2001 3:23 PM Subject: Re: [PHP-DB] Forms

Re: [PHP-DB] Forms : Validating user input is integer

2001-04-05 Thread boclair
- Original Message - From: Matt Williams [EMAIL PROTECTED] To: boclair [EMAIL PROTECTED] Sent: Thursday, April 05, 2001 9:03 PM Subject: RE: [PHP-DB] Forms : Validating user input is integer To gain the full benefit of your suggestion I find that I can validate for a wrong entry

Re: [PHP-DB] Forms : Validating user input is integer

2001-04-05 Thread Boclair
"boclair" [EMAIL PROTECTED] wrote in message 004801c0bdc7$13afbe00$[EMAIL PROTECTED]">news:004801c0bdc7$13afbe00$[EMAIL PROTECTED]... | | - Original Message - | From: Matt Williams [EMAIL PROTECTED] | To: boclair [EMAIL PROTECTED] | Sent: Thursday, April 05, 2001 9:0

Re: [PHP-DB] Forms : Validating user input is integer

2001-04-05 Thread Boclair
"Matt Williams" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... | | or even just | elseif (!eregi("[^a-zA-Z]"),$num)) { } | | But that would not stop other characters. | | M@ Whoops! Careless of me. The line should read, and as I tested it, elseif

Re: [PHP-DB] Forms : Validating user input is integer

2001-04-05 Thread boclair
- Original Message - From: Matt Williams [EMAIL PROTECTED] To: Boclair [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, April 05, 2001 11:28 PM Subject: RE: [PHP-DB] Forms : Validating user input is integer The line should read, and as I tested it, elseif (eregi("[a-zA-Z]&

Re: [PHP-DB] Forms : Validating user input is integer

2001-04-05 Thread Boclair
"boclair" [EMAIL PROTECTED] wrote in message 002101c0bd8e$30742e60$[EMAIL PROTECTED]">news:002101c0bd8e$30742e60$[EMAIL PROTECTED]... | I have a problem with a user input in a form required to be an | integer, creating a variable for a mysql query. | | I have instances where in

Re: [PHP-DB] Forms : Validating user input is integer

2001-04-05 Thread Boclair
Ben Udall [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... | boclair wrote: | I have a problem with a user input in a form required to be an | integer, creating a variable for a mysql query. | | I have instances where integer, 0, is being typed as

Re: [PHP-DB] CSS versus Includes

2001-04-01 Thread Boclair
"Matt Braynard" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... | When I asked the question, what I meant was should I use the includes to | hold page style details or a CSS file. And someone who understood that this | was not an apples and oranges situation but

Re: [PHP-DB] uploading files.

2001-04-01 Thread Boclair
"olinux" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... | here is the working script on my local windows machine. note that you will | need to change $the_path | Everything is pretty self explanatory. You can read the article that I took | this from at

[PHP-DB] date_format yet again

2001-03-26 Thread boclair
I realise that CC Zona answered this question earlier but I haven't understood. I have attempted to use the date_format in generating the query variable and applying the result with a while loop to display the date data in an html table as dd-mmm- Generating the query variable include

Re: [PHP-DB] date_format yet again

2001-03-26 Thread Boclair
"boclair" [EMAIL PROTECTED] wrote in message 000e01c0b5d0$720921c0$[EMAIL PROTECTED]">news:000e01c0b5d0$720921c0$[EMAIL PROTECTED]... | I realise that CC Zona answered this question earlier but I haven't | understood. | | I have attempted to use the date_format in generating th

Re: [PHP-DB] date_format yet again

2001-03-26 Thread Boclair
It has been pointed out to me that there is an error. I had failed to include the two date fields in the select. The actual scripting is. The query include ("inputs/connect.php"); |$plantavail = mysql_query("SELECT * date_format(online,'%d-%b-%Y') AS logon, date_format(offline,'%d-%b-%Y') )

Re: [PHP-DB] uploading files.

2001-03-24 Thread boclair
Yes please Tim Morris - Original Message - From: olinux [EMAIL PROTECTED] To: PHP-DB [EMAIL PROTECTED] Sent: Sunday, March 25, 2001 11:21 AM Subject: Re: [PHP-DB] uploading files. mmmK, i have figured it out, anyone want it? lemme know olinux - Original Message -

Re: [PHP-DB] Select where date is in period

2001-03-22 Thread Boclair
"boclair" [EMAIL PROTECTED] wrote in message 005101c0b2d2$4e6b3920$[EMAIL PROTECTED]">news:005101c0b2d2$4e6b3920$[EMAIL PROTECTED]... | | - Original Message ----- | From: boclair [EMAIL PROTECTED] | To: [EMAIL PROTECTED] | Sent: Thursday, March 22, 2001 10:45 PM | Su

[PHP-DB] Select where date is in period

2001-03-21 Thread boclair
The database has a table of equipments with date fields for date_online and date_offline. The requirement is to find which equipments were available on a date specified by the user, this being a variable created by the user. My attempts at scripting for the condition where the date_online =

Re: [PHP-DB] Select where

2001-03-20 Thread boclair
- Original Message - From: boclair [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 21, 2001 12:02 AM Subject: [PHP-DB] Select where This is simple but I cannot see where I am going wrong I have a table members with one of the fields status, varchar(10) The values

[PHP-DB] Using include() to specify mysql_connection??

2001-02-16 Thread Boclair
Is it possible to place the mysql_connect and mysql_select_db functions in an include file and to open the connection and use the database in a PHP file using include(); ? All that happens when I attempt it is that the text of the include file is dumped, the connection to the mysql server is

Re: [PHP-DB] Using include() to specify mysql_connection??

2001-02-16 Thread boclair
- Original Message - From: CC Zona [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 17, 2001 12:30 PM Subject: Re: [PHP-DB] Using include() to specify mysql_connection?? To be parsed as PHP code, the contents of the included file also need to be in PHP mode ?php ...