[PHP-DB] [php-objects] RE: [PHP] Re: [PHP-DEV] [CROSS POST] PHP Meetup Texas PHP Users

2002-08-01 Thread Martin Clifford
I'm definately interested, even though I'll most likely be in MN at the time. I've never even MET another PHP developer, so I don't know what to expect, but I'd sure love to be updated :o) Martin [EMAIL PROTECTED] 08/01/02 03:21PM Well, the predictions have come true. In San Antonio only

Re: [PHP-DB] Re: Storing Variable Function Info

2002-07-24 Thread Martin Clifford
literally, so you could store it in your database as such. HTH Martin Clifford Homepage: http://www.completesource.net Developer's Forums: http://www.completesource.net/forums/ Raquel Rice [EMAIL PROTECTED] 07/24/02 04:49PM On Wed, 24 Jul 2002 13:23:54 +1200 David Robley David Robley [EMAIL

Re: [PHP-DB] How to use Full text search?

2002-07-18 Thread Martin Clifford
The query you would need would be something along the lines of: SELECT show_name FROM table_of_shows WHERE show_name LIKE '%$keyword%' Learning the LIKE syntax is going to be the best help to you in this situation, I believe ;o) Martin Clifford Homepage: http://www.completesource.net

Re: [PHP-DB] or statement in url

2002-07-18 Thread Martin Clifford
Pass different variables and use them both in your query. http://www.xyz.com/foo.php?FooID=1 http://www.xyz.com/foo.php?Foo2ID=2 $query = SELECT * FROM table WHERE id=$FooID OR id=$Foo2ID; HTH Martin Clifford Homepage: http://www.completesource.net Developer's Forums: http

Re: [PHP-DB] TEXTAREA ...

2002-07-17 Thread Martin Clifford
$content = nl2br($content); That will convert all newline characters into br tags. HTH Martin Clifford Homepage: http://www.completesource.net Developer's Forums: http://www.completesource.net/forums/ José Moreira [EMAIL PROTECTED] 07/17/02 09:15AM hello ... im sorry to bother with a non

[PHP-DB] RE: PHP meetup [CROSS-POST] Meet other PHP Developersin Your Area

2002-07-15 Thread Martin Clifford
Yes, everyone please join up! I would love to find more developers in the Maryland area, and I'm sure others would in their areas as well! Let's do the great american get togeth... err... the great php get together! Martin Clifford Homepage: http://www.completesource.net Developer's Forums

RE: [PHP-DB] ID numbers not sorting Properly

2002-07-12 Thread Martin Clifford
MySQL has no obligations when it comes to sorting result sets. If you want it sorted a certain way, it'd be in your best interest to declare it with ORDER BY item_id ASC, if that's your flavor. Martin Clifford Homepage: http://www.completesource.net Developer's Forums: http

Re: [PHP-DB] Mysql syntax error - phpMyAdmin ??

2002-07-10 Thread Martin Clifford
DESC is a reserved word in SQL, standing for Descending Order. That is why you can't use it as a table column name. HTH Martin Michael Zornek [EMAIL PROTECTED] 07/10/02 12:49PM I was using phpMyAdmin to do an export from one machine to another and on import I got an error: Error

[PHP-DB] Re: bouncing an idea...

2002-07-10 Thread Martin Clifford
I would think the better way to set the entire system up is to have the barcodes scanned directly into a database (your choice), then just have PHP read the database and display editing, deleting, etc. I don't see any reason why the barcode has to go through PHP at all to make this a viable

Re: [PHP-DB] Checking for a successful login and setting aglobal flag.

2002-07-08 Thread Martin Clifford
I have my page set up to use sessions to track the users on my page. The best way I have found is to give each user a user level to identify what areas they should or should not be in. For example, if you have a page that edits the news content on your site, you might set it up like this:

Re: [PHP-DB] passing variables from one page to another

2002-07-08 Thread Martin Clifford
If that is your exact code, then you need to have an ending quote after the query is written. Like this: $query = Select * from course, disc, instit, prof where course.CourseID = $CourseID and course.DiscID = disc.DiscID and course.InstitID = instit.InstitID and course.ProfID = prof.ProfID;

Re: [PHP-DB] Strange MySQL Query Problem

2002-07-03 Thread Martin Clifford
From your query, it looks as if you are letting the user select the table that they can query with $pop-up1. Is that correct? If so, do all the available choices of tables have the same column names? Other than that I can't see why this query would fail. Martin eat pasta type fasta [EMAIL

Re: [PHP-DB] multiple queries in a rov

2002-07-02 Thread Martin Clifford
Load the query into a variable, usually $query. $query = SELECT * FROM table; SELECT * FROM othertable;; $result = mysql_query($query, $link_id) or die(error msg); Mattia [EMAIL PROTECTED] 06/27/02 02:19PM I would like to make multiple queries in a single mysql_query(...) statement!! Like

Re: [PHP-DB] mail function

2002-07-01 Thread Martin Clifford
Nice, mature response, Jason. Really smooth! :o) :chortle: Martin [EMAIL PROTECTED] 06/30/02 09:44AM On Sunday 30 June 2002 09:06, CrossWalkCentral wrote: As this has nothing to do with DBs it should be posted to the php-general list. When using this fucntion listed bellow with the HTML

Re: [PHP-DB] what the heck? (elementary question)

2002-06-25 Thread Martin Clifford
POST will allow larger form submits as well, like file uploads. GET are for smaller and faster data sets. -Mike Not only that, but POST results cannot be properly bookmarked by the user, whereas GET results contain the full URI string, therefore can be bookmarked. Good for searches, etc.

Re: [PHP-DB] Time difference question...

2002-06-25 Thread Martin Clifford
Versions above just before 4.0 of MySQL can handle direct date math. Try SELECT date_returned - date_paged FROM pagetable; It'll work if you have values date_returned and date_paged in the table pagetable of course :o) HTH Martin NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED] 06/25/02 04:40PM

Re: [PHP-DB] force no results

2002-06-24 Thread Martin Clifford
Could you give us some examples of entries in the table? You might need to set it up as a relational database, but we can't know that without information. Martin C Martin Adler [EMAIL PROTECTED] 06/24/02 10:47AM Hi, is it possible to force mysql in a SELECT clause depend on a condition to

Re: [PHP-DB] what the heck? (elementary question)

2002-06-24 Thread Martin Clifford
You can't have extensions to a filename from the action attribute, period. You have to either use defined input fields, or hidden fields to pass value from one page to another. And just as FYI, you don't need to use the printf() function in your situation, as it's best used when you need

[PHP-DB] Re: brand new elementary question

2002-06-24 Thread Martin Clifford
If your form is up to standards, then hitting the enter key on any field, with the exception of textarea, should submit the form. If you are using an image for your submit button via the input type=image tag, then you'd have to tab until on the image before hitting enter for it to work. HTH

Re: [PHP-DB] WebSite Submissions Question

2002-06-21 Thread Martin Clifford
Since PHP is parsed before ever reaching it's destination for viewing/profiling, there should be no penalties for putting this on your page. If you have a page like the following (in PHP): ?php ### HAHAHA I HATE GOOGLE!!! THEY SUCK!!! ### ### HAHAHA I LAUGH AT THEM, THOSE IDIOTS ### ?

RE: [PHP-DB] Populating multi-select list from mysql

2002-06-21 Thread Martin Clifford
Whenever you are having trouble with your PHP pages, always echo! By doing this, you can see whether or not the query is formatted correctly, whether or not the variables are containing the values you think they are. It's incredibly helpful, no matter what the situation. Martin Ryan

Re: [PHP-DB] BBS program

2002-06-21 Thread Martin Clifford
One of the best PHP Message Boards around is Invision Boards (http://www.invisionboard.com). It's made by the same person who made IkonBoard. For an example check out my boards, which are still in development (I'm slow, what can I say? hehe): http://www.completesource.net/forums/ Martin

[PHP-DB] MySQL Query Acting Up

2002-06-20 Thread Martin Clifford
Howdy all, If someone call tell me why this MySQL query is not working, I'd be VERY thankful. I don't see a damn thing wrong with it, but I could have been looking at it too long. Here is the query: $query = UPDATE articles2 SET title=\$title, brief=\$brief\, doclink=\$doclink\ WHERE

[PHP-DB] Re: MySQL Query Acting Up

2002-06-20 Thread Martin Clifford
Thanks everyone! Between all the replies I was able to locate the problem and fix it! It wasn't the missing backslash (that was a typo, which sucks). I wasn't properly passing the article_id field to the query, so MySQL had a problem with WHERE id=. Thanks again! :o) Martin -- PHP

Re: [PHP-DB] case

2002-06-11 Thread Martin Clifford
Use strtolower() on all entries from the form, so you can compare them (in lowercase) without worry about whether the user entered MA, ma, Ma, or mA. Martin James Kupernik [EMAIL PROTECTED] 06/11/02 10:15AM I want to test a value that was typed into a form, but I don't want the case to be a

Re: [PHP-DB] Trouble displaying info in a multiline form

2002-06-05 Thread Martin Clifford
TEXTAREA rows=x cols=y wrap=virtual Example text to be inside box on load. /TEXTAREA x = height, using monospace font for measurement. Usually 5 suffices. y = width, using monospace font for measurement. Usually 40 suffices. Martin Paulo Nunes [EMAIL PROTECTED] 06/05/02 02:00PM Thanks