Re: [PHP-DB] keyword search a mysql database.

on 18/12/02 5:47 pm, Adam Voigt at [EMAIL PROTECTED] wrote: $searchstring = $_POST[searchfor]; $searchstring = str_replace( ,%,$searchstring); mssql_query(SELECT id FROM table WHERE field LIKE '$searchstring';); I've modified my query to $result = mysql_query(SELECT coursecode, title FROM

[PHP-DB] Passing selection to next page

I have a drop down list created using the following code and am having trouble passing my selection to the next page. Can anyone help? ? $query = select distinct department from courses order by department; $result = mysql_query($query); echo SELECT ID='Category Combo Box' NAME='department';

RE: [PHP-DB] Passing selection to next page

I guess this all is in a form so on the next page it should be in: echo $_POST[department]; or in echo $department depending on the php version -Original Message- From: Alex Francis [mailto:[EMAIL PROTECTED]] Sent: donderdag 19 december 2002 12:05 To: [EMAIL PROTECTED] Subject:

Re: [PHP-DB] Passing selection to next page

Hi, you have to put this list in a form... form name=select_name action=eval.php method=post select option /select /form in eval.php you may write like: $variable1=$_POST['select_name']; //and variable1 is now the option_value selected echo $variable1; where option_value is the value

Re: [PHP-DB] picture into mysql (file address)

One comment is to be sure the destination folder has write privileges for world. My typical usage is: 2) // datafile is field name for image/file upload browser $img_dir = ../photos; // must be 777 access if($datafile_name != ) { if ($datafile_name != none) {

[PHP-DB] Inserting URL into table

Hi, I'm trying to insert a URL into a char field. MySQLFront punts out this error with my compiled query: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '','Yahoo mail','httpNULL/www.yahoo.co.uk/')' Well

RE: [PHP-DB] Inserting URL into table

Try addslashes($varname). Check PHP.NET for addslashes. -Original Message- From: George Pitcher [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 11:24 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Inserting URL into table Hi, I'm trying to insert a URL into a char

Re: [PHP-DB] Inserting URL into table

I'm trying to insert a URL into a char field. MySQLFront punts out this error with my compiled query: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '','Yahoo mail','httpNULL/www.yahoo.co.uk/')' Well

[PHP-DB] trees in MySQL

hello im implementing a portal and im choosing between the 'Nested Set' and 'Adjacency Lists tree' models. http://users.starpower.net/rjhalljr/Serve/MySQL/traer.html im perfectly aware of the 'Adjacency Lists tree' model how-to and I am studying the 'Nested Set', example follows : CREATE TABLE

RE: [PHP-DB] Inserting URL into table - SOLVED

Well, all I can say is Doh! as Homer would put it! Somehow when I created my table, the link_url field was set is INT with a length of 3! Changing it to a much longer char field sorted it. Cheers George -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

RE: [PHP-DB] trees in MySQL

Jose, In addition to any advice you may receive from your post today, check out the PHP archives. I distinctly remember a discussion related to these models maybe a month back that may be of interest to you. Don't remember if it dealt with your specific concerns, but I'm pretty sure it dealt with

[PHP-DB] PHP/MySQL Problem....

Hello, I seem to have a problem getting my PHP to work with MySQL. I have installed Redhat 7.3 on my system and I installed apache, php, and mysql from the redhat install cd via the RPMS. Now I know the PHP works just fine normally, but when I start trying to use the MySQL commands

Re: [PHP-DB] trees in MySQL

If you don't know how many nodes you're going to have and the amount of branches under each node, then that's the only way to do it. However, if you can define those numbers, you can use something like the following. A manager would have 50 numbers, for example. So, rather than counting through

[PHP-DB] More linking problems but slightly OT

Hi, Now that I can store - and rebuild my link (URL), I'm having a problem displaying them. The links are being displayed into a frame and the link is being prefixed with the default url for the frameset. Does anyone know how I can get rid of the prefix? Cheers George === George Pitcher

Re: [PHP-DB] trees in MySQL

The difficulty you are being confronting could be alleviated by using an XML data model (meaning non relational). Of course, I don't know about your requirements, but it could be a direction worth investigating. I use the php_xslt.dll (sablotron) extension, which I find works quite pleasantly.

RE: [PHP-DB] More linking problems but slightly OT

Be sure to add http:// to the beginning of your URL, or the browser thinks it is a local URL Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: George Pitcher [mailto:[EMAIL

RE: [PHP-DB] More linking problems but slightly OT

I think you're going to have to post some code for this one. If your database holds the exact data you're expecting, show the code that is building the link on your page after it is retrieved from the database. If the link in the database is wrong, show the query that inserts it into the database

RE: [PHP-DB] More linking problems but slightly OT

RE: [PHP-DB] More linking problems but slightly OTgary, Thanks, I'd just found that worked. Cheers George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 December 2002 5:32 pm To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] More

Re: [PHP-DB] PHP/MySQL Problem....

On Friday 20 December 2002 00:56, Grant P. Kohler wrote: Hello, I seem to have a problem getting my PHP to work with MySQL. I have installed Redhat 7.3 on my system and I installed apache, php, and mysql from the redhat install cd via the RPMS. Now I know the PHP works just fine

[PHP-DB] extracting data

I posted this to the php general list also so forgive me if you are seeing this twice. Can I use php to extract data from an access db? The php script and access db will be local. I will then upload the file to my server. Thanks, Eddie -- PHP Database Mailing List (http://www.php.net/) To

RE: [PHP-DB] trees in MySQL

thank you for your help, the portal will (problably) use sort of a directory index where a node can be a folder to go 'inside' or a portlet like moduled application like a forum, or a partial download list ( depending on current node ). knowing that the 'Adjacency Lists tree' and a bunch of

RE: [PHP-DB] extracting data

If you are on a windows machine, you can create a DSN to the access file and use odbc from php to connect to it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 12:59 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] extracting data I

RE: [PHP-DB] trees in MySQL

http://froogle.google.com/froogle?q=%22SQL+for+Smarties%22btnG=Froogle+Sear ch Chaps 28 29. (ok, I had to read both but it sounds like you already understand the concepts.) The end of chap 29 he gives a simple example for maintaining what you are talking about. I used it to write a dynamic menu

Re: [PHP-DB] Help with connecting PHP/MySQL to MS Outlook

Chris, Does anyone know of a way to retrieve MS Outlook data via PHP? I am creating an intrant for my company and want to grab data from the MS Oulook contact list on the server to using in my PHP/MySQL intranet project. Any help would be most appreciated. Rather than using PHP to go

Re: [PHP-DB] picture into mysql (file address)

since this is a local folder (testing on local server) I have complete access everywhere. I judge from your sample that register_globals are ON and mine are turned off (for several reasons. Do I have a typo somewhere? where does my full path start etc. the actual folder is in:

RE: [PHP-DB] extracting data

You can actually do this from any machine, although you will need an ODBC driver on the Linux/Mac OS X/Unix side. Another alternative is to dump the .mdb to mysql format and move it over. But ODBC is the way to go. Beginning PHP Databases from Wrox cover this a lot, but you can get started

RE: [PHP-DB] Catalog

Don't be offended: SQL For Dummies One of the best SQL primers I've ever read. I STILL keep my copy handy. Once you get through that and a few thousand queries under your belt, Joe Celko's SQL for Smarties is a great reference. (I recommended it earlier today to someone, dig that out and it's

[PHP-DB] Theory help needed

Hi there everyone, I have a messageboard which works, but what I need is some kind of threading for it. Right now I have EXTREMELY basic threading, where you can reply to a message, reply to replies etc . and they'll appear in the correct part of the messageboard. What I need though is

[PHP-DB] Set Logout Time for No Activity

Hello, Is there a variable in php.ini that will allow you to log someone out if there is no activity of 30 minutes or greater from the logged in user? Thanks in advance. :) :) Gale L. Allen Jr Macintosh Support Specialist 865/947-5740 Remember, Love wins over all (:

Re: [PHP-DB] Set Logout Time for No Activity

Log out, meaning what? Using sessions? Cookies? Allens wrote: Hello, Is there a variable in php.ini that will allow you to log someone out if there is no activity of 30 minutes or greater from the logged in user? Thanks in advance. :) :) Gale L. Allen Jr Macintosh Support Specialist