Re: [PHP-DB] sql: LIKE

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] wrote: > "SELECT bar FROM foo WHERE bar LIKE '%foo%'" should return something like > the order > > bar > --- > 'foo' (exact match) > 'the foo is a foo is a foo' (3 matches) > 'have you seen the foo?' (1 match) What DBMS?

Re: [PHP-DB] Listbox Data Entery

In article <95erfd$neg$[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("iGuru") wrote: > I have a little problem. I have a listbox (multiline combo box) on my web > page. When I sellect multiple items from the list box and submit the for to > enter the values of the listbox items in the database, then on

Re: [PHP-DB] logs

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Marc Bragg) wrote: > Does php log its activity anywere? especially for debugging purposes? > Some of my scripts don't show any browser window areas, but also don't > show any results int he browser, i.e., a blank screen, and yet aren't > workin

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

In article <96klap$c8p$[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("Boclair") wrote: > 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

Re: [PHP-DB] Hide Files

In article <000c01c09ac2$7ed27ab0$0100a8c0@fusion>, [EMAIL PROTECTED] ("Fusion") wrote: > while ($file name = readdir($dir)) { > > if (($file name != ".") > && ($file name != "..") > && ($file name !="*.php") > && ($file name !="main.gif") > > ) > { > > how come that still displays all

Re: [PHP-DB] apostrophe

In article <01cd01c09b0d$7f247630$0101a8c0@server>, [EMAIL PROTECTED] ("Pankaj Ahuja") wrote: > Is it possible to insert apostrophe into a Mysql database ?? I have a > varchar type column and want to insert " manufacturer's" into it. How can I > do this ?? Escape it with a slash: " manufacturer

Re: [PHP-DB] assoc arrays

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("Free Beachler") wrote: > the form variables from an http post are stored in: > > http_post_vars[] - associative array containing form variables.. > > what about url parameters, such as:: > http://www.mysite.com?param1=12 > > is there a corre

Re: [PHP-DB] Data input

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("Matthew Cothier") wrote: > How can they input the data into the database as they typ eit in without > them having to add html <.br.> tags? nl2br() -- CC -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PRO

Re: [PHP-DB] array awry

In article <061201c0a063$08eab5a0$[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("Keith Spiller") wrote: > This associative array embedded within a function and declared as a global at > the start of the function, is meant to be a multidimensional array, but with > every loop of the while ($myrow = my

Re: [PHP-DB] Search engines & database driven sites

(re-ordered to bottom-posting, for clarity) In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("Scott Bernard") wrote: > I recently converted my sites from hardwired HTML to a PHP/MySQL > combination - with dynamic 'newsy' info held in a database, tailored for > each visitor. Unfortunately the

Re: [PHP-DB] php-mySQL and an SQL query

And even without the subquery, the "like" keyword expects a wildcard character or two, for example: LIKE '$month%' " > mysql doesn't support sub-queries unfortunately =( > > > > > At 10:22 PM 3/8/01 -0500, Michael Gerholdt wrote: > >Hi, folks, > > > >Can someone insight me regarding this? >

Re: [PHP-DB] upperCase

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Hoo Kok Mun) wrote: > This is what I did and it did not work. > $userfield = upper('$userfield'); > echo "User Field - $userfield"; > > Errors (tried both ucase and upper) > Call to undefined function: upper() > Call to undefined function: ucas

Re: [PHP-DB] Storing character returns

In article <98jdeu$46r$[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("Dan Eskildsen") wrote: > I store newspaper articles into a MySQL database. The text that I insert > (via phpwizard.net) contains a little formatting: line returns to separate > paragraph, but when I suck the data out again to displ

Re: [PHP-DB] If expressions in selects....

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("Trond E. Hundal") wrote: > Is it possible to run sql expressions in an if expression??? > Eks: IF(table1.id > 12, table1.id, 'Not') Do you mean something like "select if(table1.id > 12, table1.id, 'Not') from foo where somefield='bar'"? Yes,

Re: [PHP-DB] If`s in MySQL.... Having some trouble here...

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("Trond Erling Hundal") wrote: > I want to query two tables in my db. One containing a list of numbers > ranging from 1 - 10200, the other table is storing information that is > relative to some of the numbers: > > Eks: > Table1.record1: nu

Re: [PHP-DB] Strings

In article <003801c0afa2$2d5853e0$890083ca@oemcomputer>, [EMAIL PROTECTED] ("Mick Lloyd") wrote: > Can anyone advise on how to surround a string variable in a query. I select > a string code from a column using: > > $result = mysql_query("SELECT * FROM $TA WHERE Profileid = '$profileid'"); > $r

Re: [PHP-DB] if () and () - newbie Q

In article <000f01c0af50$e5092480$6609ee8d@pmg>, [EMAIL PROTECTED] ("Michael Gerholdt") wrote: > what about something like 'isNull' ? I don't see any documentation in the > PHP online manual nor is 'null' even mentioned in the index of my Core PHP > book. You must not have looked very hard. Ne

Re: [PHP-DB] MYSQL Trouble with the IN operator

In article <9937to$794$[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("Jen") wrote: > SELECT CONCAT(c.l_name, ", ", c.f_name) name > FROM contractor c > WHERE c.contractor_id NOT IN > (select c.contractor_id > FROM contractor c, task_assign t > WHERE c.contractor_id = t.contractor_id > A

Re: [PHP-DB] Re: [PHP] how do i get a variable type? - not that simple

You could use ereg/preg to determine whether it: a) consists of nothing but digits from beginning to end, example: ^[0-9]+$ b) consists of nothing but digits separated by a single decimal, example: ^[0-9]+[.][0-9]+$ c) doesn't match the first two conditions, and therefore assume it is a string.

Re: [PHP-DB] More on strings

In article <007901c0b153$ae861a80$660083ca@oemcomputer>, [EMAIL PROTECTED] ("Mick Lloyd") wrote: > Thanks for the reply. I tried the variable route but again failed. I think > from your suggested line of code you may have misunderstood the problem. The > LIKE option works fine without having to

Re: [PHP-DB] Procedure to Include

In article <011201c0b29b$7b6d9cb0$0101a8c0@server>, [EMAIL PROTECTED] ("Pankaj Ahuja") wrote: > Can anybody tell me the procedure and/or code necessary to include another > document into a .php document http://www.php.net/include http://www.php.net/manual -- CC -- PHP Database Mailing List

Re: [PHP-DB] read fils

In article <004101c0b44b$b8e90640$[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("[EMAIL PROTECTED]") wrote: > I just want to read a txt file and let the output in php file. > > Can someone help me? For more sophisticated alternatives, see . -- CC --

Re: [PHP-DB] SQL Select?

In article <99jh2n$gr1$[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("Grant") wrote: > Is there any way of using a string in an SQL query instead of using the > table name. Something along the lines of > > $result=mysql_query("SELECT * FROM $tablename",$db); > > this doesnt work it come up with a par

Re: [PHP-DB] Date

In article <002f01c0b52b$d4778e00$[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("[EMAIL PROTECTED]") wrote: > I save the date in my MySQL db as 2001-03-25. > > But in my PHP script i want do see it like 25-03-2001. Do it in the MySQL select. Assuming date_field is of field type 'date': select date_

Re: [PHP-DB] newbie help

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Matt Coyne) wrote: > I have been trying to detect if the variable holds any value and then > building a query by concatenating like this: if(!empty($foo)) { ... } > $result=@mysql_query($concatsql, $connection) or die ("bugger...!");

Re: [PHP-DB] Error Control

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("Jason Bell") wrote: > Hello! I'm writing a script that validates a form It creates users in a > mysql table, where there are 2 unique columns 'username' and 'email'. > > I'm putting mysql_error() into a variable, but I don't want the end u

Re: [PHP-DB] What's wrong with this code?

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Emir Musabasic) wrote: > I have user/password/host variables inside a config > file but for some reason when I include this into a > php page when I test it, I get: > > Fatal error: Cannot redeclare db_connect() in > /www/affiliate/include/func

Re: [PHP-DB] error and general problems

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Liz Bander) wrote: > I am getting a parse error for the return line every time I try and view > the page. Can anyone tell me why? The code is below. > > $results = "select req, source, number from orders where req=" . > $GLOBALS["req"] . "

Re: [PHP-DB] reading a URL...

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] wrote: > Is it Possible, in PHP to read a URL? > > What I am trying to do is this... > I have many news stories in a database, and a single static news page, that > calls the story, and the corresponding headline. > I have looked about on-line,

Re: [PHP-DB] database search

In article <99mtsa$85b$[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("Mark Collins") wrote: > Hope you can help, I have put a basic database together which add, deletes, > updates and edits records but I am not sure where to start with searching > the data base. I have already got it working a bit usin

Re: [PHP-DB] newbie help

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Matt Coyne) wrote: > now does anyone know about getting ages from dates of birth (previous post > of mine) and also searching by age group when you only have dates of birth > in the table!! See the MySQL manual's chapter on date/time functions

Re: [PHP-DB] Getting info from remote host

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] wrote: > My idea was to make the http request and load it into an array, to be > output in a PHP page. -- CC -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL P

Re: [PHP-DB] How do you define table row indexes?

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("Anyangwe, Tanwani") wrote: > $result = mysql_query("SELECT * FROM motor_vehicle",$db); > $strSep = ' | '; > while ($myrow = mysql_fetch_array($result)) > { > echo $myrow['id'].$strSep; > } > > Gives me the following error: > > Warning: Undefi

Re: [PHP-DB] Checking for empty string - long

In article <99qq47$jvn$[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Martin Skjoldebrand) wrote: > How do I check for an empty string in PHP/MySQL. http://www.php.net/empty/ http://www.php.net/is_null/ -- CC -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTE

Re: [PHP-DB] Copy data from one mysql table to another?

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Bob Stone) wrote: > I cannot find any documentation on how to copy the > data from one mysql table to another, i.e. table1, > columnx to table2, columnx. See the mysql documentation of the "insert into" syntax for how to use a trailing "select

Re: [PHP-DB] MySQL max_connections

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Lee Stretton) wrote: > Got a bit of a problem with the number of users accessing a website > driven by a MySQL database. I want to increase the number of allowed > connections to the database, I have found the variable to change > (max_connecti

Re: [PHP-DB] Search results

In article <001301c0bafa$34d15be0$[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("David Drummond") wrote: > Can anyone tell me what is the best way to implement displaying multiple > search results using next and previous buttons to cycle through all the > results. I see this method done on a lot of

Re: [PHP-DB] Delete all Data and keep the Table

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Naga Sean) wrote: > How to delete all the data in database, without delete the table. Do you want to delete every *table* in the *database*, or delete every *row* in the *table*? Assuming the latter, "delete from database_name". -- CC -- P

Re: [PHP-DB] Convertion Types

In article <9aj490$s1p$[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("Fernando Buitrago") wrote: > Where is the functions referece of convertion types like: isinteger. http://php.net/manual/en/function.is-integer.php http://php.net/manual/en/ref.var.php -- CC -- PHP Database Mailing List (http://w

Re: [PHP-DB] Really Dumb Question...

In article <00c701c0c2af$be478f40$[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("Darryl Friesen") wrote: > > How do I create a table within my PHP? Heres what I currently have, but I > > keep getting parse error on the "create" line... > > Because create is not a valid PHP command. You have to assign

Re: [PHP-DB] Forms and PHP

In article <005201c0c61d$bd2bf620$97fe013d@piii500>, [EMAIL PROTECTED] ("CK Raju") wrote: > I am unsuccessful in attempting to have the FORM work with POST method, while > there is a with alongwith other variables that I am > accepting directly from text fields. > > Its something like this

Re: [PHP-DB] php with mysql - multiple tables

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("Shahmat Dahlan") wrote: > $result=mysql_query($sqlstmt); > > I know the $sqlstmt query does work. But if I do a mysql_fetch_array and > assign it to a variable called $myrow, > > while ($myrow=mysql_fetch_array($result)) { >... > } > > h

Re: [PHP-DB] PHP Forms

In article <001201c0c77c$a0262360$[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("Hector M Banda") wrote: > I want to know how can I store all the forms in a place where users can run > them but are not available to the owner of the domain. See the following for pages for info on using an include_path

Re: [PHP-DB] Error Msg: Wrong data type when performing "extract()"

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("Shahmat Dahlan") wrote: > $result=mysql_query($sqlstmt); > # print $result; > $row=mysql_fetch_array($result) > > extract($row); > > If I do the above, I get the results below: > > Warning: Wrong datatype in call to extract() in > E:\winnt\t

Re: [PHP-DB] database synchronizing

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("Benny K. Putera") wrote: > I have 2 systems, local and internet. > I want my Internet database is updated from local database. > How can I make this through php script? See the manual for your DBMS for info on terms like "replication", "backu

Re: [PHP-DB] Newbie question

In article <034101c0d3f3$0dd747e0$41041dd8@winbox>, [EMAIL PROTECTED] ("~BD~") wrote: > at the end of my script, I run a set of closing and clean-up procedures.. > what I would like to be able to do is that when a user bails out of the > script by closing the browser or leaving the site/page, de

Re: [PHP-DB] Mystery variable query?

In article <9crr9l$4c4$[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("martin helie") wrote: > assuming: > > $var="1234";(type does not seem to matter) > > this query returns no error, but no result either: > > mysql("database","SELECT * FROM table WHERE id='$var'"); When you call mysql_query is

Re: [PHP-DB] Mystery variable query?

In article <9cs791$mn3$[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("martin helie") wrote: > The problem, evidently, is that echoing the variable didn't show the html > formatting (it was something like "" in an obvious way! Look at it via source view next time. Echoing the content wrapped in a ta

Re: [PHP-DB] Autoincrement Question

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("Angie Tollerson") wrote: > I will be 3 Jeff :) > > > >>> "Jeff Oien" <[EMAIL PROTECTED]> 05/10/01 01:13PM >>> > If I have a database that has three records and I delete the entire > third record, when another record is then added will the aut

Re: [PHP-DB] Autoincrement Question

[quotes restored to bottom-posting order, for clarity] > > > > If I have a database that has three records and I delete the entire > > > > third record, when another record is then added will the auto increment > > > > number be 3 or 4? Thanks. > > > I will be 3 Jeff :) > > Only if the auto inc

Re: [PHP-DB] 'the missing character'

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Jimmy Brake) wrote: > Does anyone know of a function in php that will take a chunk of text and > seperate it into 'chunks' preferably returning it in an array? > > The reason being is that I have some columns(oracle) that are set to > varchar

Re: [PHP-DB] do table alias's work in PHP?

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (cameron walker) wrote: > Now I am using a shareware version which, perhaps, is buggy: > 3.22.24-shareware-debug Given that MySQL is currently well into the 3.23.* series, getting an upgrade would certainly be a good place to sart. As for the

Re: [PHP-DB] do table alias's work in PHP?

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (cameron walker) wrote: > It's hard to comprehend how this is a MySQL problem as my SQL commands work > perfectly when entered at the command line. This fact is a pretty strong > pointer to PHP being the culprit. Why empirical test would suggest

Re: [PHP-DB] MySQL Error???

In article , [EMAIL PROTECTED] (Brian Grayless) wrote: > Is anyone familiar with this MySQL error? > > "1062: Duplicate entry '127' for key 1" You have a unique key (likely the primary key field). There is already a record with value "127" in t

Re: [PHP-DB] mysql errors .... or php errors ????

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Steve Brett) wrote: > 'invalid index test assumed 'test' in test.php at line 13' can't > remember the exact syntax but that's the general idea. > > if i quote the var when i reference it the error goes away. like > $arow['test'] as opposed

Re: [PHP-DB] cites/states data

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Jaskirat) wrote: > I am creating a database driven php page for which I need to have a database > of > US and Canadian states and cities in the back end. > Is there some place on the web where I can get such data in the reusable > form and Yo

[PHP-DB] Re: problem with regular expression

In article <001601c10dc9$e4513780$[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Jennifer Arcino Demeterio) wrote: > i have a script to identify if the input is a combination of letters and > numbers > > if (eregi("[a-zA-Z0-9][0-9]+[a-zA-Z][0-9a-zA-Z]",$fieldvalue)) > print "alphanumeric" > } else

[PHP-DB] Re: the body of the response

In article <008101c10e0f$379207e0$c844500c@zeospantera>, [EMAIL PROTECTED] (Ken Sommers) wrote: > PHP manual says: > fopen > fopen -- Opens file or URL > Description > int fopen (string filename, string mode [, int use_include_path]) > > If filename begins with "http://"; (not case sensitive),

Re: [PHP-DB] Re: the body of the response

In article <00c801c10e3f$758ba8a0$b943500c@zeospantera>, [EMAIL PROTECTED] (Ken Sommers) wrote: > Suppose I had a MUSIC database that you wanted your site visitors to be able > to query,and it was OK with me because you had a MOVIE database that i > wanted MY site visitors to be able to query, >

Re: [PHP-DB] Re: the body of the response

In article <00c801c10e3f$758ba8a0$b943500c@zeospantera>, [EMAIL PROTECTED] (Ken Sommers) wrote: > are you saying that i can grab the output of your echo() statements in YOUR > PHP script by Fopen()ing your URL Yes, you can use it that way. > IF so,, is this done much? It's done. I can't qua

[PHP-DB] Re: remote database exchange

In article <00d201c10e41$9fa2e340$b943500c@zeospantera>, [EMAIL PROTECTED] (Ken Sommers) wrote: > Is it possible to exchange data on remote databases in PHP mysql? PHP is a scripting language. MySQL is a database management system (DBMS). Two different things. > Suppose I had a MUSIC databas

Re: [PHP-DB] remote database exchange

In article <012601c10e4a$6c7a2ec0$b943500c@zeospantera>, [EMAIL PROTECTED] (Ken Sommers) wrote: > Suppose I Need to get Vendor prices from a very large remote (Oracle) price > list . > They probably don't have PHP installed. If... -you have PHP installed, -AND you have Oracle support compiled

Re: [PHP-DB] remote database exchange

In article <001b01c10e52$0c08e060$3c41500c@zeospantera>, [EMAIL PROTECTED] (Ken Sommers) wrote: > I ran > mysql> show variables; > to see if my host server has Oracle support,, MySQL is a DBMS. Oracle is a DBMS. Different products from different vendors. MySQL doesn't tell you if you have O

[PHP-DB] Re: (preg_match ?

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] wrote: > $search = "TheName" > $data = "TheName,TheAddress,ThePhone" > > if (preg_match('"/\b'.$search.'\b/i"', $data)) > { > echo "True"; > } > else > { > echo "False"; > } > I am trying to see if the search name matches exactly a name in the

[PHP-DB] Re: function ??

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] wrote: > are INSERT INTO statements forbiden inside a function?? Assuming that you're referring to a PHP function and not a function of the RDBMS, no it's not forbidden. Show the relevant snip of code and any error messages being reported. M

[PHP-DB] Re: ranking database searches

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Michael Hall) wrote: > This may be more trouble than I'm interested in, but I'm working on search > functionality for a number of our MySQL database projects. > > I'm looking for ways (or just ideas about ways) to set up a ranking system > such

[PHP-DB] Re: Off the point here!

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Scott Fletcher) wrote: > P.S. the php.general & php.version4 newsgroup is now closed! No they're not. I just accessed both lists (via news server) without difficulty. Maybe something's funky with your newsreader config? -- CC -- PHP Dat

[PHP-DB] Re: query returned "Resource id #2"

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Default) wrote: > I'm using PHP 4 and mysql. I'm trying to do just a simple query from a > database table, but every time it returns the value, it returns > "Resource id #2" and results like that. Any ideas? Thanks. This is correct. See the

[PHP-DB] Re: General PHP problem

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Ali Nayeri) wrote: > >> File php1.php > print("Hi $name"); > > >>File test.htm > > > Name: Check phpinfo(): is the option "register_globals" turned on? See for more info... You may always want t