[PHP-DB] Problem with mysql_num_rows

I get an invalid argument when trying to create this output of pages to limit to 20 records per pages. I removed the line and it stopped the error, but the next and previous buttons will go on and on even if there is no more records so I am thinking it is my mysql_num_rows() function I have

[PHP-DB] returning all rows

I know I have asked this silly question before, but forgive me since I have been a bit rusty with PHP lately So how do I return all rows? I have this: $sql= SELECT id, city, date FROM meetings WHERE city = \$city\ ; $result = mysql_query($sql,$connection) or die(Couldn't execute query); while

[PHP-DB] Returning all rows

I know I have asked this silly question before, but forgive me since I have been a bit rusty with PHP lately So how do I return all rows? I have this: $sql= SELECT id, city, date FROM meetings WHERE city = \$city\ ; $result = mysql_query($sql,$connection) or die(Couldn't execute query); while

[PHP-DB] Re: Returning all rows

It needs that line to sort them by city. But it only returns one row Todd Williamsen [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I know I have asked this silly question before, but forgive me since I have been a bit rusty with PHP lately So how do

Re: [PHP-DB] returning all rows

It needs that line to sort them by city. But it only returns one row Bogdan Stancescu [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Just lose the WHERE city=\$city\ in the SQL. Bogdan Todd Williamsen wrote: I know I have asked this silly questio

[PHP-DB] MS SQL Server 7

I am trying to get PHP to work with MS SQL Server 7, but its not liking something when I do a mssql_connect() it says Fatal error: Call to undefined function: mssql_connect() in c:\inetpub\wwwroot\test.php on line 7 I have added the proper extensions, have put them in the right directory.

[PHP-DB] Oracle... Beginner

I would like to try Oracle as a backend. I do have a copy of Oracle 8 server, Oracle Application Server, Oracle Internet Commerce Server. I am running Windows 2000 server, so all these will and should run on Win2k. I never used Oracle, so I would like to know: 1. What is the procedure of

Re: [PHP-DB] Drop Down Menus

here is an example from my page: ? $connection = mysql_connect($databaseserver, $databaseuser, $databasepass) or die(Can't connect to DB); $db = mysql_select_db($databasename, $connection); $sql= SELECT id, State FROM $statetable ORDER BY State ASC; $result= mysql_query($sql, $connection);

Re: [PHP-DB] Flipping through database records

how about just not do it by userid? query some other column thats in there maybe by last name? SELECT * FROM $tablename WHERE lname = $lname LIMIT [#results per page] That should eliminate gaps Olinux [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Interesting

[PHP-DB] If Statement that makes me cry

This script is confusing the hell out of me... What its suppose to do is do a search on documents, and then is it finds something say who and where it is, but it repeats the message for every hit. Same goes with the message when there is no results, it repeats it for every record. All I want it

[PHP-DB] Searching records...

What I am doing is user inputs their contact information, then copies and pastes text and also uploads a formal document, which the location is stored in the database. Now, the text that gets pasted into the text field is then stored into the database for search purposes. This is the problem...

[PHP-DB] Searching Documents

I was wondering if there is a way to search documents. Scenario: I have a application where it uploads MS Word documents to a server and holds the documents location in the database. What I want is to be able to search those Word documents via keywords. Is this possible with PHP? -- PHP

Re: [PHP-DB] addslashes()

HTH Joe :) Todd Williamsen [EMAIL PROTECTED] wrote in message 002601c1b033$382a4700$f6b2d83f@goofy1">news:002601c1b033$382a4700$f6b2d83f@goofy1... Paul, It is being inserted into a database -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Thurs

RE: [PHP-DB] Searching Documents

So that statement would actually open up the MS Word document and search it for the keywords specified? -Original Message- From: Dan Brunner [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 9:34 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Searching

RE: [PHP-DB] addslashes()

Paul.. Going into the database Coming out of the database Please read the whole post.. 8) -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 9:40 AM To: Todd Williamsen; [EMAIL PROTECTED] Subject: Re: [PHP-DB] addslashes() At 9:14 -0600

RE: [PHP-DB] addslashes()

and both queries are the same structure. I cannot figure it out If you want the URL to look at it, I will send it to you. Thanks! -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 10:00 AM To: Todd Williamsen; [EMAIL PROTECTED] Subject: RE: [PHP-DB

RE: [PHP-DB] addslashes()

Paul, No kidding I see the problem, that is why I am asking how do I solve it. I don't need the problem re-explained to me 8) -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 10:21 AM To: Todd Williamsen; [EMAIL PROTECTED] Subject: RE: [PHP

RE: [PHP-DB] addslashes()

and the other doesn't? -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 10:34 AM To: Todd Williamsen; [EMAIL PROTECTED] Subject: RE: [PHP-DB] addslashes() At 10:22 -0600 2/8/02, Todd Williamsen wrote: Paul, No kidding I see the problem

[PHP-DB] Re: Searching Documents

No one knows??? hmm... I looked around on php.net couldn't find anything regarding this.. would I need to do these searches in MS Word docs with ASP? Todd Williamsen [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I was wondering if there is a way t

RE: [PHP-DB] Re: Searching Documents

Yes, I was thinking COM/DCOM, but then does PHP able to do that? Or do I need to resort to ASP(Awful Scripting Pages)? -Original Message- From: DL Neil [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 12:40 PM To: Todd Williamsen Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Re

RE: [PHP-DB] Re: Searching Documents

Now, if I do COM with PHP, then does this need to be on a Windows server? Currently it sits on a Linux box. -Original Message- From: DL Neil [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 12:40 PM To: Todd Williamsen Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Re: Searching

Re: [PHP-DB] Re: Searching Documents

Well, This application would eventually land on either Linux or Windows box, it would be for internal use only, so it wouldn't get wacked too bad. I know IIS5 has a bunch of COM built-ins. The problem of going to like a text based documents is that this is for resume management and 99% of the

RE: [PHP-DB] Re: Searching Documents

[mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 1:33 PM To: Shrock, Court; 'Todd Williamsen' Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Re: Searching Documents Court, Todd, et al Actually, PHP does COM very wellsearch the PHP-WIN list about COM and Word and you should find some

RE: [PHP-DB] Re: Searching Documents

PROTECTED]] Sent: Friday, February 08, 2002 1:51 PM To: 'DL Neil'; Todd Williamsen Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Re: Searching Documents If running meant at the process level and not just installed, then word does not have to be running.COM creates the appropriate instances

[PHP-DB] File deletion

I created a couple of forms where one inserts new contact data with a file, in this case its a resume. Now, I want to create a form where a user can update the information by inserting their updated information and if there is a new resume then it would be uploaded. I got the upload part down,

[PHP-DB] Re: THIS IS TRUE !!!

Yes you can, i forget how though... I dropped the ODBC and MS databases a year ago... I wish I remembered! Kerem Can Karakas [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... how can you do that Francisco Aquino wrote: Can I access a Database like MsAccess

[PHP-DB] Re: Ok another update

Jennifer... $query=select name, days from wt_users where uid=$uid; change to: $query=SELECT name, days FROM wt_users WHERE uid=\$uid\ ; You also need to make sure the page that is calling this script has a valid value of $uid otherwise it won't work. Jennifer Downey [EMAIL PROTECTED]

[PHP-DB] addslashes()

I have a Notes field where users can add notes. Now, there will be times when they use quotes or maybe even HTML, what is the correct way of using this function? I have tried: addslashes($Notes); and $Notes addslashes($Notes); neither work.. I thought I would ask this great newsgroup!

Re: [PHP-DB] addslashes()

01c1b027$ec33b7b0$e4d22fc2@acealex... Try $Notes = addslashes($Notes); You where almost right :) /Alexander - Original Message - From: Todd Williamsen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 07, 2002 11:32 PM Subject: [PHP-DB] addslashes() I have a Not

RE: [PHP-DB] addslashes()

Paul, It is being inserted into a database -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 5:41 PM To: Todd Williamsen; [EMAIL PROTECTED] Subject: Re: [PHP-DB] addslashes() At 16:54 -0600 2/7/02, Todd Williamsen wrote: Ok.. i tried

[PHP-DB] Search results

I have done a search page based on a specific column name, but in some columns there is no results to be returned.. What I would like to do is display an error message stating that there is no results .. something like Sorry your search returned Zero Rows

[PHP-DB] File Uploading... Two problems...

I have been successfully able to upload the files to the server and its path stored in the database.. Now I have two small issues... 1. How would I automate the file naming otherwise errors will fly (can't copy file... blah blah) 2. The second part is the most annoying. It seems that I

[PHP-DB] FIle Uploading to database

I don't want the file to be stored in the database, but its location. What I want to do: Upload a file, it gets stored on the webserver, but its location on the server is stored in the database. Where do I look for something like this? What data type would I use to store the URL or file

[PHP-DB] Re: FIle Uploading to database

query Let me know if you need more info! Thank you! Todd Williamsen [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I don't want the file to be stored in the database, but its location. What I want to do: Upload a file, it gets stored on the webserver,

[PHP-DB] Re: FIle Uploading to database

Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 11:06 AM To: [EMAIL PROTECTED] Subject: Re: FIle Uploading to database Well... thanks to Dan Burner for the script... BUT I cannot get this friggin INSERT statement to execute.. which c

[PHP-DB] Automating Date in mySQL

I want the date to automatically be updated. So if a post was made on 2/10/2001 I would like it to put it automatically in the database. I do have a column called Date and the datatype is set to date. But when I add a record even if the sql states to insert the date it doesn't, or does the

[PHP-DB] SELECT statement does not return rows

Weird.. I want to be able to edit records, which I have done in the past, and I cannot see why it isn't working... I have tried single qoutes around the $row = and that doesn't work either. here is the code: $db = @mysql_select_db($db_name, $connection) or die(Could not select database);

[PHP-DB] 2 Questions... INSERT and searching records....

It seems that my insert statement doesn't want to cooperate.. I used the same format as in Julie Meloni's book. I know, sometimes, her code doesn't always work either. here it is: $sql = INSERT INTO Jobs (id, Industry, Other, JobTitle, Description, Location, Date) VALUES (\\, \$id\,

[PHP-DB] Re: 2 Questions... INSERT and searching records....

would I do that? Todd Williamsen [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... It seems that my insert statement doesn't want to cooperate.. I used the same format as in Julie Meloni's book. I know, sometimes, her code doesn't always work either

[PHP-DB] Select statement only returns 1 record

I am trying to get data from two columns, FirstName and Last name and displaying all the records LastName, FirstName in a drop down menu. The weird thing is that it only displays one record. I thought the table was hosed, but its not. I tried it through another database and still doesn't work.

RE: [PHP-DB] Select statement only returns 1 record

Nope, that doesn't work -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 1:01 PM To: 'Todd Williamsen'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Select statement only returns 1 record ? $db = mysql_connect($dbserver, $dbuser, $dbpass

[PHP-DB] Updating a record with math and division

Ok So to update a record lets say... I have a current value of 150 and the new value will be 250 now how would I total them to equal 400? I was thinking $sql = UPDATE $table value1 = value1 + ? is that correct? how do you update it with simple math? What about division... take the

Re: [PHP-DB] Updating a record with math and division

thanks... Miles Thompson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... Read the docs for the database in question. They will tell you what is and is not allowed. Miles Thompson On Friday 28 December 2001 06:26 pm, Todd Williamsen wrote: Ok So to update a record lets

Re: [PHP-DB] Updating a record with math and division

' syntax: http://www.mysql.com/doc/U/P/UPDATE.html -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Friday, December 28, 2001 4:06 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Updating a record with math and division That isn't the answer I was