[PHP-DB] Re: Help: Two dimensional array from table

2006-04-09 Thread El Bekko
Mark Fellowes wrote: I created an array to pull data out of one column in database. //Code for registered $usrregid = array(); do { $usrregid[] = $row_rs_usr_usr["usr_id"]; } while($row_rs_usr_usr = mysql_fetch_assoc($rs_usr_usr)); //end of registered ?> However I now need a second colu

[PHP-DB] Re: stripslashes etc.

2006-03-02 Thread El Bekko
Andrew Darby wrote: Hello, all. I'm getting a bit confused figuring out the best way to insert data into a db via web forms and then pull it out again safely. I know there's lots of information out there, but I was hoping someone could suggest a current, [easy!] best practice. Specifically, I

[PHP-DB] Re: Help Needed with malfunctioning query

2006-02-26 Thread El Bekko
Chris Payne wrote: Hi there everyone, This line of code USED TO WORK but now it gives me a Coudln't Execute Query error: $query2 = "SELECT word,def,photo MATCH(word,def) AGAINST ('$txtsearchword' IN BOOLEAN MODE) AS m FROM dictionary WHERE MATCH(word,def) AGAINST ('$txtsearchword' IN BOOLEA

[PHP-DB] Re: cannot connect to mysql on windows

2006-02-25 Thread El Bekko
raj wrote: Hello, I have apache 2 and mysql 4.1 and php5 and am unable to connect to mysql database server, and keep getting the following error: Fatal error: Call to undefined function mysql_connect() in D:\backup\test.php on line 10 I have removed the semicolon before the line: extensio

[PHP-DB] Re: Help need please?

2006-01-22 Thread El Bekko
JeRRy wrote: Hi, I know this is not PHP/MySQl related but every other board I have posted on I have not got a response, so I'll try here also. I'm missing something basic, surely here so that is another reason I am posting here.. Here goes... I have two lots of code here, one i

Re: [PHP-DB] Formatting a form box

2006-01-12 Thread El Bekko
ies. No part of this message or attachments may be used or reproduced in any manner whatsoever. The nl2br() function is way better because you don't change email adressess. And for the colours and stuff... just put a small note on the bottom of your post page what HTML tags they are allo

[PHP-DB] Re: Bit(1) datatype from mySQL

2006-01-08 Thread El Bekko
Larry Bradley wrote: Greetings: I'm new to PHP, although I've been a programmer all my life. I had been doing a bit of web database work with VB Script and ASP and mySQL, and then decided to try PHP. I've run into a couple of things that bother me. I have boolean fields (i.e. bit(1)) in the

[PHP-DB] Re: retaining and displaying line returns in a text field

2006-01-08 Thread El Bekko
Frank Flynn wrote: This is an HTML issue (not PHP or MySQL) that is HTML ignores carriage returns (and most other white spaces). There are two simple solutions: use tags: echo " $rmks"; Or replace the \n with "" $newRmks = str_replace ( "\n", "", $rmks ); echo $newRmks; You can do

Re: [PHP-DB] isset or ! isset what is my problem?

2006-01-03 Thread El Bekko
On Monday 02 January 2006 7:54 pm, Ralph wrote: I'm building a URL based on data extracted from mySQL and I want the text space.gif used as my default value should the variable $picture by NULL. The results of the code below kick back a value for $picture when it is set in the database, but ign

[PHP-DB] Re: Inserting a php file into a mysql database

2005-12-26 Thread El Bekko
Thomas Bonham wrote: Hello, I am trying to insert a php page into a database. I need to know if there is something that I need to do when setting up the table, also is there something to do with the code. Thank You for your help Thomas Use file_get_contents() I'd say... but you'll have th

Re: [PHP-DB] Scrolling News

2005-12-24 Thread El Bekko
PHP Superman wrote: Hi, just to tell you scrolling text boxes are javascript, PHP is server side not client side, PHP can only get the data from the table and javascript will display it On 12/22/05, Alex Major <[EMAIL PROTECTED]> wrote: Hi there. I'm trying to make a scrolling news box for m

[PHP-DB] Re: CLOSE button or link

2005-12-22 Thread El Bekko
Ron Piggott (PHP) wrote: I am building a Christian ministry web site. One of the things we are establishing is an online offering basket to receive donations. One of our disbursements is a benevolent fund to help others. I have a 'how we operate our benevolent fund' web page online at http://w

[PHP-DB] Re: RSS/XML

2005-12-18 Thread El Bekko
m/RSS/Tutorial/RSS%20Tutorial.html Have fun with it :) El Bekko -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: RSS/XML

2005-12-16 Thread El Bekko
Henry Ortega wrote: I want to put a website's RSS feed on my website. For example, http://beccary.com/feed/ I want to put all the titles of that blog page on my website. Is there an easy way to do this? Because they're all in a DB, yes, very easy :) Just build your RSS feed through PHP. -- P

[PHP-DB] Re: Date Formatting Question

2005-12-14 Thread El Bekko
"07","Jul",$date); $newdate = str_replace("08","Aug",$date); $newdate = str_replace("09","Sep",$date); $newdate = str_replace("10","Oct",$date); $newdate = str_replace("11","Nov",$date); $newdate = str_replace("12","Dec",$date); return $newdate; } And then use this: echo ""; echo "$newdate"; Hope it helps, El Bekko -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Character encoding issues: Pound- sign "£" becomes a "ú" - why?

2005-12-14 Thread El Bekko
Alex Gemmell wrote: Hello, I'm experiencing some odd character encoding issues. My PHP webpage is displaying test from a MySQL database. What happens is that I export data from an SQL Server database to a MySQL (4.0) database. Somewhere along the line the British currency pound-sign "£" be

[PHP-DB] Re: formatting a date from mysql

2005-12-12 Thread El Bekko
Eternity Records Webmaster wrote: I need to figure out how to format the date format: year-month-day (2005-12-06). It is a date(8) field in a mysql table that i pulled out of the table with php 5.0.5. I need it in the format: Tue December 6, 2005 (or in mysql's formatting: 6-12-2005). I am using

[PHP-DB] Re: ftp_put

2005-12-08 Thread El Bekko
Chris Payne wrote: Hi there everyone, I'm using FTP to upload a file from a form, the information is stored in a MySQL DB and then FTP'd to the server. Is it possible - without altering the php.ini file as I don't have access to this on my clients server - to be able to upload large files r

[PHP-DB] Re: SQL Insert INTO question

2005-12-08 Thread El Bekko
geekgirl1 wrote: First time poster. This is the problem. I want to add the value of $_POST[review] to the reviews table where the unique id from the reviews table equals the review id on my form. The statement below does not work. Should I use UPDATE instead? "INSERT INTO reviews (review

[PHP-DB] Re: SELECT & html

2005-12-05 Thread El Bekko
Ron Piggott (PHP) wrote: I would like to display the contents of my table with the first row being grey in background and the next row being white and the third row being grey, fourth being white, etc. I am not sure how to do this. Well, that's pretty easy to do actually :P You have your while

[PHP-DB] Re: problem of transmitting variable from page to another page.

2005-12-03 Thread El Bekko
Mohamed Yusuf wrote: I am transmitting variable from one of my pages and I would like to match that variable into mysql data. it won't return data. my code is this. $j |"; if ($j == Z) { break; } } ?> this code in my index page prints alphabetical letters from A-Z. and I woul like to t

[PHP-DB] Re: IS_NUMERIC ?

2005-11-29 Thread El Bekko
http://php.belnet.be/manual/en/function.is-numeric.php Apparently there is :) Dwight Altman wrote: Hello List, Is there an IS_NUMERIC(aCandidateString) function in MySQL that I can run in a query, similar to the various PHP "is_*" functions? I can't seem to find it in the docs (other than a C