RE: [PHP-DB] Dynamic SQL + result resource error

Look at this snippet : $word = current($wordsarray); next($wordsarray); $sql=$sql.$word); if you have 2 words the sql would extend to word1)word2) .. this is invalid sql syntax. Change the while ($i count($wordsarray)) { $word = current($wordsarray);

RE: [PHP-DB] Dynamic SQL + result resource error

Hi Mark, ... beside of what was mentioned be4, you have also a logical error in the way you append to your $sql- query in the while loop. Look: letz say, $find is The Fields of the Nephilim, so your $wordsarray would be: 0 == The 1 == Fields 2 == of 3 == the 4 == Nephilim in your while-loop,

[PHP-DB] Re: ereg_replace

In article [EMAIL PROTECTED], Olinux O wrote: What I'm doing is using ereg_replace in this form: $LargeString = ereg_replace(tag.*/tag, replacement, $LargeString); but what I get is the string with the replacement in a way I don't actually want. It replaces the part of the string that begins

[PHP-DB] Income on the Net!

Here is an opportunity that you can take up FREE. If you join as an affiliate, we'll teach you how to build a profitable business on the Internet, using our system to create an income stream and earn income globally, 24 hours a day. Don't let this opportunity slip past you - our organization

[PHP-DB] Re: Login Help

Hi, [...] Now, if i hit enter again it will say: Please fill out all fields to proceed. Sorry, username is already taken, please choose another. There seems to be a problem with the database. So this is the problem? [...] Here is my code:

[PHP-DB] Re: ereg_replace

What I'm doing is using ereg_replace in this form: $LargeString = ereg_replace(tag.*/tag, replacement, $LargeString); but what I get is the string with the replacement in a way I don't actually want. It replaces the part of the string that begins with THE FIRST TAG tag and that ends with

[PHP-DB] image resizing

Is there a way of sizing image resolution on the fly? TIA Luis __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

AW: [PHP-DB] image resizing

There are several possibilities to do this... first PHP has the possibility to use the GD - Libs (which doesn't support Gif's because of licence problems). The second (and in my opinion better) posibility is ImageMagick which are some programs to modify pictures (you have to call them externaly

[PHP-DB] mysql_fetch_array problem

Greetings, I'm experiencing the strangest problem and I was wondering if anyone else has had the same problem. I have a fairly simple script setup that queries a mySQL database and displays the records in a HTML table. Everything works fine except it keeps omitting the first record. Running the

[PHP-DB] Use of Like

Can anyone tell me a way to simulate the command LIKE in mySQL query´s, Thanks in advance, Gabriel. -- 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:

Re: [PHP-DB] mysql_fetch_array problem

I was having the same problem for a while... although, I was using this: for($i=0;$imysql_num_rows($result);$i++) doStuffTo(mysql_result($result, $i, foo); If I remember correctly... it has to do with zero-based indexing versus 1-based indexing. Now... I think I fixed it by using =

RE: [PHP-DB] Use of Like

Can anyone tell me a way to simulate the command LIKE in mySQL query´s, Simulate it where? In a SQL database? Another kind of database? Programatically? Chris

[PHP-DB] Re: mysql_fetch_array problem

What's your code look like, something like this? $result = mysql_query(SELECT name FROM tablename); while ($row = mysql_fetch_array($result)) { print Name : . $row['name'] . br\n; } The above is the most standard way at least. Share your appropriate snippet of code, could be a few

[PHP-DB] Submiting forms to mySQL

I would like to have a three frame webpage. The data entry would be in the main frame while the edit delete and submit buttons would be in another frame. Is this possible? I thought that you could only submit things between the form/form tags. (not things in different html or php files) --

RE: [PHP-DB] Submiting forms to mySQL

You can use the TARGET attribute of the form that would be in the edit,delete,submit frame to make the main page process the form variables. ie clicking on submit in the edit frame would send the vales var1=ffefevar2=gfregr, etc etc, to the main frame. alternatively you could use the

[PHP-DB] IBM DB2 on Linux with PHP is very slow

Hi, does someone has a DB2 UDB from IBM working with PHP in a production envirement ? How is the performance? For a relaunch of our existing production system running on IBM DB2 on serveral IBM RS/6000 servers we tested the performance of connecting PHP to this database. And what can I say:

Re: [PHP-DB] Use of Like

Can anyone tell me a way to simulate the command LIKE in mySQL query¥s, Thanks in advance, Gabriel. Sir, you can use either LIKE or REGEXP. If you are coming to MySQL from an MS product, use % in place of * when using LIKE. For more information, look in the language section of the MySQL

[PHP-DB] a simple question

can somebody help me with the following code: function multi_word($title) { $array = explode ( , $input); $number = count ($array); if ($number 1) { return true; } else{ return false; } } if ($category) { $Query = SELECT * from $TableName WHERE ((category)=$category); }

Re: [PHP-DB] testing ODBC + MSSQL connection locally

Hi, I would like to begin learning ODBC. Will I be able to set this up on my single local machine? The ODBC functions are build in when you are running PHP on a Windows Box. If you are running on a (nix box you have to compile PHP with support for ODBC. Also, What about connecting to MS

[PHP-DB] Alternating Values

I'm trying to figure out the best way to do this. People will be signing up online and their info will be put into a database. They will be assigned a room and each successive person will be assigned a different room. There are different categories for each group of people also. So there will

Re: [PHP-DB] a simple question

Hi Brad, Your parameter is named $title and you are converting a variable called $input to an array. You could catch this type of errors if you change the setting for error_reportiong in php.ini. - Frank can somebody help me with the following code: function multi_word($title) {

Re: [PHP-DB] New to PHP and MySQL

assuming you have a DB setup with a table for the guestbook, just do a standard query. now the steps can be long and wordy. but essentially, you open a connection to the DB server. you make a link to the DB. you then pass an SQL query via PHP to Mysql. then it stores the result into an array

[PHP-DB] myisamchk always report table not close properly

Hi, I use php to update my MySQL database. After I run php script, I check my table using myisamchk and myisamchk always report a warning warning: 1 clients is using or hasn't closed the table properly. I check my scripts and I always use mysql_close() at the end of the script. Any idea

[PHP-DB] parsing checkbox array without [] and selecting all boxes

Hey all, The end result of all of this should be similar to an online email client like hotmal, or yahoo where you can select a number of messages to be deleted. I have a form that when generated, the html looks similar to this: === input type=checkbox

RE: [PHP-DB] parsing checkbox array without [] and selecting all boxes

don't your checkboxes act like radio buttons when you check them if they all have the same name? i would do something like form name=mail_boxes action= method= ?php // How ever many checkboxes you want $number_of_checkboxes = 5; for ( $this_check = 0; $this_check $number_of_checkboxes;