[PHP-DB] Link for next db record

Hi all, Wondering if you could help or point me to a tut where I can use a link to get the next record in the db? Like a href='php.php'Previous record/aa href='php.php'Next record/a How do I go about doing this. Thanks Jennifer -- The sleeper has awaken --- Outgoing mail is certified

[PHP-DB] Re: How to force a new browser page?

I don't know if this is what you are looking for but it will open a new browser window. You may have to play with it to get it the way you want. a href=\#\ onClick=\MyWindow=window.open('yourscript.php?id=$id','MyWindow','toolbar=n

[PHP-DB] Re: Simple search engine gone bad

Thanks all for your help. I knew it was somathing stupid and I knew it was because it was Monday. Now that it is Tues I have found the problem and it was somethin very stupid. I forgot echo /FORM; Now it work as it should. Again thanks Jennifer. Jennifer Downey [EMAIL PROTECTED] wrote

[PHP-DB] Not getting results if 0

Hi all, I am wondering how to keep something from beind displayed if a price is set to 0? I have a store where the user looks up items, but it shows all items even if the price is 0. Is there a way to prevent the items set at 0 from being displayed? Thanks Jennifer -- The sleeper has awaken

Re: [PHP-DB] Not getting results if 0

024AC071@SSIMSEXCHNG... Are you looking it up in a database? If so you'd want to do something like where price 0. Then it wouldn't return those results. -Natalie -Original Message- From: Jennifer Downey [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 2:01 PM To: [EMAIL PROTECTED]

[PHP-DB] Simple search engine gone bad

Hi all, It's Monday, it's probably something stupid, but I have poured over this all day and cannot find the problem. This is a simple search engine based on one table. It is suppose to return the results of the search word. Instead it returns ALL records in the mysql table. If I type the letter

[PHP-DB] Re: Can't Load Data into Mysql Using PHP

include 'phpstudy/constant.inc'; $link=mysql_pconnect(HOST,USER,PASSWD); mysql_select_db(DBNAME,$link) or die(mysql_error()); This will give you the errors if any. HTH Jennifer Jack [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Dear all I had a problem to

Re: [PHP-DB] Search Script

'; HTH Maureen Jennifer Downey [EMAIL PROTECTED] said: Hi all, I have been trying to build a search script for my site that deals with only one table in my db. As Julie Meloni pointed out look in the MySQL manual for LIKE clauses I can't seem to locate that clause in ether manua

[PHP-DB] Re: Search Script

; echo /TD/TR/TABLE; } }else{ echo FORM METHOD=post ACTION='$PHP_SELF'; echo Search ShopsBRinput type=text name=\searchword\ value=\\; echo BRINPUT TYPE='submit' NAME='search' VALUE='Search'; } Thanks Jennifer Jennifer Downey [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">new

Re: [PHP-DB] Re: Search Script

g. HTH Maureen Jennifer Downey [EMAIL PROTECTED] said: Thanks all, You people are awesome. I have it working but I still have 2 bugs First it is only showing the first record it finds with the search term, not all records associated with it. Second it has to be spelled exactly ri

[PHP-DB] Re: Search Script

it to. What I needed to do is have it where it isn't == to anything in otherwords a null value. So if $searchword = $iname then it will work as it is suppose to. Thanks everyone for your time, effort and help. Jennifer Jennifer Downey [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]"

[PHP-DB] Re: FORM not inserting data

As many people have told me and I have just now got it through my thick head try either echoing the query or use $result = mysql_query($sql) or die(mysql_error()); You will find out what is being passed (or not passed) through your variables or find out what error you are getting. HTH

Re: [PHP-DB] Re: Search Script

is works, then it looks like the situation above. I think previously, you were searching using all lower case for a word that was in the database with an upper case letter in it. HTH Maureen Jennifer Downey [EMAIL PROTECTED] said: Ok I am looking at the code an I'm thinking it has to be in the code

[PHP-DB] Search tutroial

Hi all, Would someone kindly point me to a tutorial on designing a search script for mysql db. I have tried to build one but can't get anywhere with it. Thanks Jennifer -- The sleeper has awaken --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system

Re: [PHP-DB] Search tutroial

This is basically what I am trying to do if($search) { $query = SELECT uid, id, image, iname, quantity, type FROM {$config[prefix]}_shop WHERE iname = $shopsearch; $ret = mysql_query($query); while(list($quantity)=mysql_fetch_row($ret)) $name = $row['user']; echo $name; }else{

Re: [PHP-DB] Search tutroial

By the way SELECT uid, id, image, iname, quantity, type, user where it shows below that user isn't in the query- it is there in my editor. I just forgot to put it in before sending. Jennifer Jennifer Downey [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL P

[PHP-DB] Delete from mysql table is there a way to....

Hi all, Is there a way to delete a record from a mysql table without fragmenting the db? Here is the query I am using and it does a horrible job. Fragment city. if ($quantity == 0) { $gone =

[PHP-DB] Delete from mysql table is there a way to....

Hi all, I'm not sure if my first post showed up so I am going to post it again and I apologize if it shows up twice. Is there a way to delete a record from a mysql table without fragmenting the db? Here is the query I am using and it does a horrible job. Fragment city. if ($quantity == 0) {

Re: [PHP-DB] Closing curly brackets?

11:15 PM, Jennifer Downey at [EMAIL PROTECTED] appended the following bits to my mbox: I believe it has something to do with the first while statement's closing curly bracket placement but I can't seem to get it in the right place. Hi Jennifer, The first thing you should do is properly ind

[PHP-DB] Closing curly brackets?

Hi everyone, I originally posted this in general by mistake. I have a question about this code. The way it sits now it always shows the last record in the database table. In other words if the user has 6 items, like: item id 1 item id 2 item id 5 item id 6 item id 7 item id 8 it will only show

[PHP-DB] Re: Closing curly brackets?

ar while loops.. Wouldn't the data still get retrieved in array form with that? If I'm wrong, feel free to publicly ridicule me.. Later, Bob Weaver Jennifer Downey [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi everyone, I originally posted

[PHP-DB] Multiple selects?

Hi all, You are probably getting tired of me asking questions but I have another and will try to keep them down from now on. If I have let's say five items with different id's, image's and so forth how do I display all items on one page. Do I have to use multiple selects or is there another

[PHP-DB] Re: Multiple selects?

the cart that is hosted on that page and can post some code from it if you would like.. Thanks, Bob Weaver Jennifer Downey [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi all, You are probably getting tired of me asking questions but I have another

[PHP-DB] Forms and mysql

Hi all, I know I've asked this before and wouldn't be asking again if I had the email that you people replied back with. Windows took a you know what on me and I had to format the hard drive. Anyway here is what I have. This is items.php: form action='buyitem.php' method='post' ? $query =

Re: [PHP-DB] Forms and mysql

PROTECTED]... On Friday 05 April 2002 07:55, Jennifer Downey wrote: Hi all, I know I've asked this before and wouldn't be asking again if I had the email that you people replied back with. Windows took a you know what on me and I had to format the hard drive. If this has been answered

Re: [PHP-DB] Forms and mysql

In any case the email or replies are not in the archives. I have searched them and came up empty. Marius Ursache [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Jennifer Downey a écrit : If you had read more carefully you'd see that I don't have T

[PHP-DB] int or tinyint

Hi all, Just a simple question (I think). When should I use tinyint over int. and what is the difference between the two? Thanks Jennifer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Table structure and displaying certain thing

Hi all, I have a table called items here is a dump: CREATE TABLE items ( id int(10) NOT NULL auto_increment, name varchar(50) NOT NULL default '', item_type int(4) NOT NULL default '0', image varchar(100) NOT NULL default '', price int(10) NOT NULL default '0', quantity int(5) NOT

[PHP-DB] MySQL, PHPand cron

Hi all, Wondering if anyone might know how to empty a table with a php script and cron job? Would someone point me to a tutorial or help with this? TIA Jennifer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Unknown column 'Test' in 'field list'

Hi All! Hope I'm not bothering you nice people too much. I have a account called Test, when I click the submit button I get this error Unknown column 'Test' in 'field list' My table only has two fields id and user_name I am not trying to insert the data into the field Test but into

[PHP-DB] Unknown column 'Test' in 'field list'

Never mind I forgot to put ' ' around $u_name in my insert. Jen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] If else Question

Hi all, I have a table called pets, here is a partial dump: At this time this is all I am working with. uid int(10) NOT NULL default '0', num_pet tinyint(1) NOT NULL default '1', There are three steps to adding the pet into the db Step 1 create the record, this is in create.php. And yes

[PHP-DB] WHERE clause

Wondering do I have to have the WHERE clause in a select query? $b=mysql_query( SELECT * FROM my_table) -can I use something like this or do I have to put WHERE in the statement? Thanks Jennifer -- PHP Database Mailing List (http://wwwphpnet/) To unsubscribe, visit:

[PHP-DB] Tutorial?

Hi all, Can anyone point me to a good tutorial on how to disable a submit button once clicked? preferably in php Thanks Jennifer Downey -- PHP Database Mailing List (http://wwwphpnet/) To unsubscribe, visit: http://wwwphpnet/unsubphp

[PHP-DB] Rounding numbers

=$bank_points * $interest; print(BRYour yearly interest is : $yearly_interest); $daily_interest=$yearly_interest / $days; $round_daily_interest = round($daily_interest); print(BRYour daily interest is : $daily_interest); Thanks Jennifer Downey -- PHP Database Mailing List (http://wwwphpnet

[PHP-DB] Rounding numbers again.

set bank_points = bank_points + $round_daily; $ret = mysql_query($query); If I use the users session id then it works fine. With the query all I'm doing is updating ALL users bank_points right? I want to use cron to update all users at midnight. Thanks again Jennifer Downey

[PHP-DB] Join tables

for your help Regards Jennifer Downey P.S. I have looked at the mysql manual and a few tutorials. None of them helped or worked.

Re: [PHP-DB] Join tables

Ok thanks for that info, but I guess I am ignorant to what MS Access is. Please enlighten me. Thanks Jennifer Downey Marius Ursache [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]; the best tool for building join queries is MS Access . make a db same as that you use in mysql

[PHP-DB] I'm really stuck!

= select bin_data,filetype from image_data where id=$id; $result = mysql_query($query); $data = mysql_query($result,0,bin_data); $type = mysql_query($result,0,filetype); Header( Content-type: $type); echo $data; }; echo img src=\petdata.php?id=$id\; Thanks Jennifer Downey

[PHP-DB] Storing image path to database

(50) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; Thanks in advance Jennifer Downey -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: using sendmail w/ windows

arguments as well (default: 'sendmail -t -i'). ;sendmail_path=this is the path to sendmail --leave this commented out. HTH Jennifer Downey Crosswalkcentral [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... any one know how to use send mail with windows

[PHP-DB] Still bangin my head

been made!; Thanks again in advance Jennifer Downey -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] If else trouble

!; }else{ echo Your withdraw has been made!; } Thanks in advance Jennifer Downey -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Instest of add, subtract.

]} ); $result=mysql_query($query); if set like this it will update the points in the bank_points but not the points table. $db[bank_points]=(UPDATE wt_users set bank_points = bank_points + $user_deposit WHERE uid={$session[uid]} ); $result=mysql_query($db[bank_points]); Thanks in advance Jennifer

[PHP-DB] Add and Subtract

Hi All, Would someone please help me with the following code? I am trying to make this work like if I have 15 gold pieces and I deposit 5 it will subtract 5 from the gold pieces I have and deposit the 5 into my account showing that I now have 10 gold pieces I can deposit and 5 in the bank. I

Re: [PHP-DB] Join

heck out the manual of your RDBMS (ie. http://www.mysql.com/doc/J/O/JOIN.html for MySQL) good luck :) Beau // -Original Message- // From: Jennifer Downey [mailto:[EMAIL PROTECTED]] // Sent: Thursday, 21 February 2002 10:47 AM // To: [EMAIL PROTECTED] // Subject: [PHP-

[PHP-DB] Parse error

Can someone tell me why I am getting a parse error in this little snip? ? $origVar = 100; echo POriginal value is $origVar/p; $origVar += 25; echo PAdded a value, now it's $origVar/p; $origVar -= 12; echo PSubtracted a value, now it's $origVar/p; $origVar .= chickens; echo PFinal answer:

[PHP-DB] Re: Parse error

all your time. I'll try to think better in the future. Thanks Jen Jennifer Downey [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Can someone tell me why I am getting a parse error in this little snip? ? $origVar = 100; echo POriginal value is $o

[PHP-DB] Re: A good tutorial

odbc_do($connectionToDBid, $sqlr); ? end of image to db process ## Hope this helps you out :) Cheers Joe :) Jennifer Downey [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED

[PHP-DB] Join

Could someone point me in the right direction for joining tables? I have searched the php manual for it but only found info on joining arrays. If someone could point me to a code snip or a tutorial I would much appreciate it. Thanks in advance Jen Downey -- PHP Database Mailing List

[PHP-DB] A good tutorial

If anyone knows of one, would someone please point me towards a good tutorial on storing images in a database then fetching them out again. I would really appreciate it and thanks in advance! Jen Downey -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] cron job

Ok I have the cron job figured out. The only thing I would like help with is how to update all users in a table. This just updates a spacific user: $db[points]=(UPDATE wt_users set points = points + 1000 WHERE uid={$session[uid]}); $result=mysql_query($db[points]); How would I use this to

[PHP-DB] Updating Database at a specified time

)= mysql_fetch_row($ret)) print(SP: $points); ? Thanks in advance! Jennifer Downey -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] PHP MySQL and updating

Hi again, I am having trouble with updating. How do I tell php to update the database at mid night instead of every time the browser is refreshed? I have looked for it but can't find the info. Also I thought session ID's were different between users. Is this true? Thanks Jennifer Downey

[PHP-DB] Ok another update

be appreciated! Thanks Jennifer Downey -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Username

please tell me what I have done wrong? Thanks for all your time. Jennifer Downey -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Username

ve found the articles at devshed to be helpful in the past. This particular one has a pretty good explaination of setting up a user authentication system: http://www.devshed.com/Server_Side/PHP/TimeIsMoney/TimeIsMoney1/page1.html Robert On 2/5/02 9:50 AM, Jennifer Downey [EMAIL PROTECTED] wrote:

[PHP-DB] Update

Hi, I am having problems with this code. I want to update a members number of days they have been a member can anyone help? $query[days]=(UPDATE users set days_member VALUES = ('days_member' + '1')); $result=mysql_query($query[days]); Thanks in advance JD -- PHP Database Mailing List

Re: [PHP-DB] Update

they explain in technical terms in which 98% of us don't understand. So we have to do things by trial and error and learn by our mistakes and pray that someone who does know can explain in a way that we can understand. Regards Jennifer Downey Miles Thompson [EMAIL PROTECTED] wrote in message [EMAIL