Re: [PHP-DB] Help with If else if

2012-03-18 Thread Tamara Temple
On Tue, 13 Mar 2012 21:23:57 +0530, Gu®u sent: No Michael, your code is also not working. What you have understood is correct. let me explain it to others too. If variable twitter and facebook are empty don't echo anything, if variable twitter has a value and facebook is empty echo out only t

Re: [PHP-DB] Help with If else if

2012-03-18 Thread Tamara Temple
On Tue, 13 Mar 2012 17:33:43 +0530, Gu®u sent: Hi, Please help me with this code. I have 2 different fields in mysql table. What I want is if the field is empty don't show the image. Please look at the code below. plugin->ListViewValue()=="") { echo ''; }

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Gu®u
I tried the below code too considering may be the localhost is really dumb and we need to tell each and every condition. But still its not working :( $tweet = $search->plugin->ListViewValue(); $fb = $search->facebook->ListViewValue(); if($tweet=="" && $fb=="")

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Matijn Woudt
On Tue, Mar 13, 2012 at 4:53 PM, Gu®u wrote: > No Michael, your code is also not working. What you have understood is > correct. let me explain it to others too. > > If variable twitter and facebook are empty don't echo anything, > > if variable twitter has a value and facebook is empty echo out o

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Michael Stowe
Hmm, what happens with the code I sent you? Just tested it on my end and worked exactly as expected. Try doing a var_dump($search->plugin->ListViewValue(), $search->facebook->ListViewValue()); to make sure the data being returned is what's expected... you should be getting string(0) "" returned f

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Gu®u
No Michael, your code is also not working. What you have understood is correct. let me explain it to others too. If variable twitter and facebook are empty don't echo anything, if variable twitter has a value and facebook is empty echo out only twitter, if variable twitter has no value and faceb

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Michael Stowe
>From looking at your code, the issue is that your if statements are checking for the same criteria as your else statements, meaning that if the string is empty ("") the if statements will be triggered, and since the if statements are true, the elseif statement will not be. Or if the string isn't

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Matijn Woudt
On Tue, Mar 13, 2012 at 3:06 PM, Gu®u wrote: > The issue is both the images are echoing and no if else statement is > working. > First of all, please bottom post on this (and probably any) mailing list. You should perhaps provide what the contents of $search->plugin->ListViewValue()=="" and $sea

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Gu®u
The issue is both the images are echoing and no if else statement is working. On Tue, Mar 13, 2012 at 7:22 PM, Matijn Woudt wrote: > On Tue, Mar 13, 2012 at 1:03 PM, Gu®u wrote: > > Hi, > > > > Please help me with this code. I have 2 different fields in mysql table. > > What I want is if the fi

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Matijn Woudt
On Tue, Mar 13, 2012 at 1:03 PM, Gu®u wrote: > Hi, > > Please help me with this code. I have 2 different fields in mysql table. > What I want is if the field is empty don't show the image. Please look at > the code below. I have looked at it. Maybe you should tell what is wrong, what it outputs

[PHP-DB] Help with If else if

2012-03-13 Thread Gu®u
Hi, Please help me with this code. I have 2 different fields in mysql table. What I want is if the field is empty don't show the image. Please look at the code below. plugin->ListViewValue()=="") { echo ''; } if($search->facebook->ListViewValue()=="")

[PHP-DB] Help with AVG()

2011-06-13 Thread Ron Piggott
Hi Everyone I am trying to figure out how to write a SELECT query that will give me the average of `bible_anagrams`.`views` starting on the date specified in `bible_anagrams_rss_feed`.`rss_feed_date` and the previous 6 calendar days (for a total of 7 days). What I am trying to figure out is t

[PHP-DB] Help needed in searching a sentence in the code

2010-05-26 Thread nagendra prasad
Hi All, I have this code where user can search a song or the entire song title. It looks like when a user search a single word its searching and giving the proper results. However if the user wants to search the entire sentence its not giving the proper results. For example let say I have searched

Re: [PHP-DB] Help with mysql data sorting using php

2010-05-17 Thread kesavan trichy rengarajan
take a look at this: http://datatables.net/examples/data_sources/server_side.html On Mon, May 17, 2010 at 5:30 PM, nagendra prasad wrote: > Hi Artur, > > I am a beginner to this stuff. So, If you or anyone can give me some > example > codes or may be some links for my reference that would be a gr

Re: [PHP-DB] Help with mysql data sorting using php

2010-05-17 Thread nagendra prasad
Hi Artur, I am a beginner to this stuff. So, If you or anyone can give me some example codes or may be some links for my reference that would be a great help. Best, Guru. On Mon, May 17, 2010 at 12:57 PM, Artur Ejsmont wrote: > Hehe. Then a method: ) just make a query builder method like 'findS

Re: [PHP-DB] Help with mysql data sorting using php

2010-05-17 Thread Artur Ejsmont
Hehe. Then a method: ) just make a query builder method like 'findSongs' with all the params ( optional or mandatory ) like page, limit, sortby, filters etc. then inside build SQL based on args. Just be careful - SQL injection is your enemy here. From app pass all the args from get/ post and that'

Re: [PHP-DB] Help with mysql data sorting using php

2010-05-17 Thread nagendra prasad
DB is like more then 500MB and it will grow day by day :) On Mon, May 17, 2010 at 12:46 PM, Artur Ejsmont wrote: > If the DB is very small use tablesorter plugin of jquery. Otherwise > custumizable query method. > > On 17 May 2010 07:56, "nagendra prasad" wrote: > > Hi All, > > I have a datab

[PHP-DB] Help with mysql data sorting using php

2010-05-16 Thread nagendra prasad
Hi All, I have a database of MP3's in mysql. The database contains MP3 name, artist, date, size etc. I need to order the search results in both ascending and descending order. For example if user wants to see the size of all mp3's in ASC order he will click on size column and again if he wants to

[PHP-DB] help needed.

2010-03-17 Thread Vinay Kannan
Hello Guys, I am developing an application, which would have a front end in Flash, and the backend would be MySQL, now what I am thinking is to package this as an exe file, similar to WAMP, which installs everything, So my exe should have all my files, the MySQL data dump and should auto install P

Re: [PHP-DB] help in implementing a progress bar

2010-01-11 Thread Philip Thompson
On Jan 7, 2010, at 2:36 PM, Vinay Kannan wrote: > Hello, > > Theres this project that I am working on, and a specific module does take > few secs to process, I am thinking it would be cool to be showing a progress > bar(some kind on a .gif image) while the script runs, does any one have an > idea

[PHP-DB] help in implementing a progress bar

2010-01-07 Thread Vinay Kannan
Hello, Theres this project that I am working on, and a specific module does take few secs to process, I am thinking it would be cool to be showing a progress bar(some kind on a .gif image) while the script runs, does any one have an idea how to implement this? Thanks, Vinay K

Re: [PHP-DB] Help for a beginner

2009-12-23 Thread Niel Archer
Hi > Hi everyone, first thank you for ALL help and the understanding that I am new > to PHP and MySQL. This is a long email and for that I apologize but I am > trying to provide as much detail as possible. If this is the wrong list to > ask for help, kindly direct me to the proper authority. >

[PHP-DB] Help for a beginner

2009-12-23 Thread Adam Sonzogni
Hi everyone, first thank you for ALL help and the understanding that I am new to PHP and MySQL. This is a long email and for that I apologize but I am trying to provide as much detail as possible. If this is the wrong list to ask for help, kindly direct me to the proper authority. I am trying t

Re: [PHP-DB] HELP! PHP 4.4.4 and MySQL 4.1 - Can't find php_mysql.dll

2009-02-19 Thread Chris
John Burns wrote: I did that but the php_mysql.dll is not in any of the zips from any of the packages I tried downloading. I need to stay in PHP 4 because of some applications. No matter what zip package I downloaded, php_mysql.dll was not in the extensions directory. I tried a bunch of different

Re: [PHP-DB] HELP! PHP 4.4.4 and MySQL 4.1 - Can't find php_mysql.dll

2009-02-18 Thread Chris
John Burns wrote: I'm using Windows 2003, IIS and PHP 4.4.4 with MySQL 4.1. I had this same setup on a server that got corrupted by a virus. I can't use any of the files from the old setup so I'm trying to reinstall the same versions. However, I can't find a php_mysql.dll file that will work. All

[PHP-DB] HELP! PHP 4.4.4 and MySQL 4.1 - Can't find php_mysql.dll

2009-02-18 Thread John Burns
I'm using Windows 2003, IIS and PHP 4.4.4 with MySQL 4.1. I had this same setup on a server that got corrupted by a virus. I can't use any of the files from the old setup so I'm trying to reinstall the same versions. However, I can't find a php_mysql.dll file that will work. All of the zip packages

[PHP-DB] Help me with this someone

2009-02-09 Thread Wilson Osemeilu
i get the error: Warning: mysql_pconnect() [function.mysql-pconnect]: Lost connection to MySQL server during query in /home/www/broadwaysecure.biz.nf/Index.php on line 9 Could not connect : Lost connection to MySQL server during query     I have done everything to connect to my database but its no

Re: [PHP-DB] Help with Web services (facebook, myspace)

2009-01-23 Thread Ruprecht Helms
Abah Joseph wrote: > I just saw something on pear.net > http://pear.php.net/package/Services_Facebookmaybe it will work. hi, possible better is to have a look into the plattform http://www.phpclasses.org. Maybe you find a class that doesn't based on pear. Regards, Ruprecht -

Re: [PHP-DB] Help with Web services (facebook, myspace)

2009-01-21 Thread Abah Joseph
I just saw something on pear.net http://pear.php.net/package/Services_Facebookmaybe it will work. On Wed, Jan 21, 2009 at 10:27 PM, Chris wrote: > Abah Joseph wrote: > >> Hello PHP people, >> I`m looking for facebook and myspace API that will enable user to login on >> my site using their faceb

Re: [PHP-DB] Help with Web services (facebook, myspace)

2009-01-21 Thread Chris
Abah Joseph wrote: Hello PHP people, I`m looking for facebook and myspace API that will enable user to login on my site using their facebook and myspace id. if this is not possible, can i find something closer like, user will be able to perform some activities from my site like inviting facebook/

[PHP-DB] Help with Web services (facebook, myspace)

2009-01-21 Thread Abah Joseph
Hello PHP people, I`m looking for facebook and myspace API that will enable user to login on my site using their facebook and myspace id. if this is not possible, can i find something closer like, user will be able to perform some activities from my site like inviting facebook/myspace friends, send

Re: [PHP-DB] help me JOIN 3 tables. - fixed query

2009-01-13 Thread Yves Sucaet
l1.field3 hth, Yves - Original Message - From: "Yves Sucaet" To: Sent: Tuesday, January 13, 2009 7:49 AM Subject: Re: [PHP-DB] help me JOIN 3 tables. Hi Joseph, With the sum() aggregate function you'll need to use a GROUP BY clause and specify which field

Re: [PHP-DB] help me JOIN 3 tables.

2009-01-13 Thread Yves Sucaet
l1 on (l1.entreID = e1.entre_ID) WHERE e1.entre_active = 'Y' hth, Yves - Original Message - From: "Abah Joseph" To: Sent: Tuesday, January 13, 2009 6:46 AM Subject: [PHP-DB] help me JOIN 3 tables. I have this SQL SELECT e1.*, l1.* FROM e1 INNER JOIN l1 WHERE

[PHP-DB] help me JOIN 3 tables.

2009-01-13 Thread Abah Joseph
I have this SQL SELECT e1.*, l1.* FROM e1 INNER JOIN l1 WHERE e1.entre_active = 'Y' AND l1.entreID = e1.entre_id The above query works but i want to add the one below SELECT SUM(a1.adp_amount) as amount FROM a1 WHERE a1.adp_loanID = e1.loanID; the last part of the query is to SUM the part payme

Re: [PHP-DB] Help needed - SELECT query optimization

2008-10-26 Thread Chris
It should be a rapidshare links database (which updates with a PHP crawler I wroted last Saturday). I would like to change the snippet to title and add another column for the snippet, My main queries are INSERT's - a big insert (usually 10-100 links per insert) in each hour. My crawler is checki

[PHP-DB] Help needed - SELECT query optimization

2008-10-26 Thread Nitsan Bin-Nun
Hi, I have a mysql database with one table in it, currently it contains 36,807 records and it costs 6.8MB of space, every night another thousand~ of rows are being added to the table. The scheme (as taken from phpmyadmin) is like follows: CREATE TABLE IF NOT EXISTS `search` ( `id` int(11) NOT NU

Re: [PHP-DB] Help to improve MySQL query

2008-08-11 Thread Dee Ayy
On Sat, Aug 9, 2008 at 1:32 AM, Niel Archer <[EMAIL PROTECTED]> wrote: > Hi > > You do not say how you identify the last call (there is no date/time > field for example), so a complete answer is not really possible With the "id (auto incremented int)", the last record of either table would be the

Re: [PHP-DB] Help to improve MySQL query

2008-08-11 Thread Micah Gersten
Use an appropriate status. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Dee Ayy wrote: > On Fri, Aug 8, 2008 at 5:25 PM, Micah Gersten <[EMAIL PROTECTED]> wrote: > >> How about "select Incidents.* from Incidents inner join Calls on >> Incidents.id=Calls

Re: [PHP-DB] Help to improve MySQL query

2008-08-11 Thread Dee Ayy
On Fri, Aug 8, 2008 at 5:25 PM, Micah Gersten <[EMAIL PROTECTED]> wrote: > How about "select Incidents.* from Incidents inner join Calls on > Incidents.id=Calls.incidentid where Calls.status='Open'"? ... > > Dee Ayy wrote: ... >> The status column never has the text "Open". ... -- PHP Database Ma

Re: [PHP-DB] Help to improve MySQL query

2008-08-08 Thread Niel Archer
Hi You do not say how you identify the last call (there is no date/time field for example), so a complete answer is not really possible Do not use "NOT LIKE 'Completed'", it's an inefficient way of doing "!= 'Completed'" -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To un

Re: [PHP-DB] Help to improve MySQL query

2008-08-08 Thread Micah Gersten
How about "select Incidents.* from Incidents inner join Calls on Incidents.id=Calls.incidentid where Calls.status='Open'"? Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Dee Ayy wrote: > A database was designed with the following tables: > > Incidents >

[PHP-DB] Help to improve MySQL query

2008-08-08 Thread Dee Ayy
A database was designed with the following tables: Incidents _ id (auto incremented int) ... Calls _ id (auto incremented int) incidentId (foreign key) status (varchar 32) ... The status of the last Call is the status of the related Incident. Statuses can be "Not started" through var

Re: [PHP-DB] Help in concatenation - modular development

2008-06-07 Thread YVES SUCAET
reen Laghari" <[EMAIL PROTECTED]>Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Help in concatenation 1. 0?("?start=").$y:""));?>"> 2. 0?("?start=").$next:""));?>"><< turns into: > $string = '' . $pg .

Re: [PHP-DB] Help in concatenation

2008-06-07 Thread Nitsan Bin-Nun
1. 0?("?start=").$y:""));?>"> 2. 0?("?start=").$next:""));?>"><< turns into: > $string = '' . $pg . ''; > ?> > $string2 = ''; > ?> I can squeeze the if operation into the string but I can't see good cause for this (this is less spageti this way) On 06/06/2008, Nasreen Laghari <[EMAIL P

[PHP-DB] Help in concatenation

2008-06-06 Thread Nasreen Laghari
Hi,   I need to change PHP embeded in HTML to HTML embeded in PHP as trying to use modularity approach. I'm stuck on below these lines where concatenation is the big issue. I have researched, read but couldnt sort this out after try really hard. Could any one please help me to change this code to

[PHP-DB] Help needed PHP with Excel database

2008-05-31 Thread JDP
Hi I am a PHP beginner and using "Namo Webeditor" trial version in order to access an Excel file via ODBC...and I get no result Namo generates the following code: = Sans titre alink="red"> Feuli1$_FilterDatabase.Description, Feuli1$_FilterDatabase.Order Numb

[PHP-DB] Help needed

2008-05-11 Thread Velen
Hi, I'm testing a program and I need you assistance. Please unzip the file at http://www.biz-mu.com/PCID.zip and run the program. It will display an ID, please mail me back the ID. If you can use it on several computers, it will be even better for me, I need to have as much results as possi

[PHP-DB] help cursors odbc_connect odbc_fetch_row

2008-03-07 Thread Abhay Raghu
I am using the odbc support in PHP 5.2 to connect to a sqlserver 2005 database. The odbc driver being used is the SQLSRV32.dll provided as part of the install. In the code below I find that if I use SQL_CUR_USE_ODBC as an option to odbc_connect, the odbc_fetch_row() call below fails even though

RE: [PHP-DB] Help with JOIN query

2008-03-06 Thread Gary Wardell
TED] > Sent: Thu, March 06, 2008 6:33 PM > To: Gary Wardell; php-db@lists.php.net > Subject: Re: [PHP-DB] Help with JOIN query > > > On Thu, Mar 6, 2008 at 10:59 PM, Gary Wardell > <[EMAIL PROTECTED]> wrote: > > Ahh, to bad, I started using it with 5.0. I'm also a

Re: [PHP-DB] Help with JOIN query

2008-03-06 Thread Graham Cossey
On Thu, Mar 6, 2008 at 10:59 PM, Gary Wardell <[EMAIL PROTECTED]> wrote: > Ahh, to bad, I started using it with 5.0. I'm also a long time user of SQL > Server. > > Sorry if I caused confusion. > > Gary > You were getting my hopes up there Gary :-( -- Graham -- PHP Database Mailing List (h

RE: [PHP-DB] Help with JOIN query

2008-03-06 Thread Gary Wardell
Ahh, to bad, I started using it with 5.0. I'm also a long time user of SQL Server. Sorry if I caused confusion. Gary > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Help with JOIN query

2008-03-06 Thread Roberto Mansfield
Mysql doesn't support subselects in 4.0.x. That was added in 4.1. -Roberto J. Hill wrote: > I may be a little confused: the desire is to return all the rows from > TableA that match the record_id of a row in TableB that has the MAX > timestamp? > > If so, why not something like: > > SELECT * FR

RE: [PHP-DB] Help with JOIN query

2008-03-06 Thread Gary Wardell
> To: J. Hill; php-db@lists.php.net > Subject: Re: [PHP-DB] Help with JOIN query > > > On Thu, Mar 6, 2008 at 9:54 PM, J. Hill <[EMAIL PROTECTED]> wrote: > > I may be a little confused: the desire is to return all the > rows from > > TableA that match

Re: [PHP-DB] Help with JOIN query

2008-03-06 Thread Graham Cossey
On Thu, Mar 6, 2008 at 9:54 PM, J. Hill <[EMAIL PROTECTED]> wrote: > I may be a little confused: the desire is to return all the rows from > TableA that match the record_id of a row in TableB that has the MAX > timestamp? > > If so, why not something like: > > SELECT * FROM TableA a, TableB b W

Re: [PHP-DB] Help with JOIN query

2008-03-06 Thread J. Hill
I may be a little confused: the desire is to return all the rows from TableA that match the record_id of a row in TableB that has the MAX timestamp? If so, why not something like: SELECT * FROM TableA a, TableB b WHERE a.record_id=b.record_id && timestamp=(SELECT MAX(timestamp) FROM TableB) O

Re: [PHP-DB] Help with JOIN query

2008-03-06 Thread Krister Karlström
This will give you: ERROR : Invalid use of group function It seems like the use of an aggregate (or how is it spelled?) function is not allowed in a join statement... /Krister Jon L. wrote: You can try adding a quick test to the ON statement... SELECT * FROM TableA INNER JOIN TableB

Re: [PHP-DB] Help with JOIN query

2008-03-06 Thread Jon L.
You can try adding a quick test to the ON statement... SELECT * FROM TableA INNER JOIN TableB ON TableA.record_id = TableB.record_id AND TableB.timestamp = MAX(TableB.timestamp) Now, I haven't tested it. I can only say the theory of it is accurate. - Jon L. On Thu, Mar 6, 2008 at 12:46 P

Re: [PHP-DB] Help with JOIN query

2008-03-06 Thread Krister Karlström
Hi again! We're getting a bit of topic here, since this is pure SQL.. But anyway... I've played around with this one a bit since it seemed quite interesting... The best I can do is to get the oldest action... select TableA.record_id, product_ref, action, time_stamp from TableA join TableB on

Re: [PHP-DB] Help with JOIN query

2008-03-06 Thread Krister Karlström
Hi! Graham Cossey wrote: I was hoping to avoid joining everything as there can be many entries in TableB for each record in TableA. Also wouldn't your query only return one record? I need to return all records from TableA with the latest action from TableB as well. Yes, sorry - I realised th

Re: [PHP-DB] Help with JOIN query

2008-03-06 Thread Graham Cossey
On Thu, Mar 6, 2008 at 6:54 PM, Krister Karlström <[EMAIL PROTECTED]> wrote: > Hi! > > > Graham Cossey wrote: > > > TableA > > record_id > > product_ref > > > > TableB > > timestamp > > record_id > > action > > > > I want to create a SELECT that joins these 2 tables where the JOIN to >

Re: [PHP-DB] Help with JOIN query

2008-03-06 Thread Krister Karlström
Hi! Graham Cossey wrote: TableA record_id product_ref TableB timestamp record_id action I want to create a SELECT that joins these 2 tables where the JOIN to TableB only returns the most recent entry by timestamp. For instance, to select all columns: select * from TableA join TableB on Tab

[PHP-DB] Help with JOIN query

2008-03-06 Thread Graham Cossey
I can't see how to accomplish what I need so if anyone has any suggestions they would be gratefully received... I'm using mysql 4.0.20 by the way. I have two tables : TableA record_id product_ref TableB timestamp record_id action I want to create a SELECT that joins these 2 tables where the JO

Re: [PHP-DB] Help with MySql float

2008-02-17 Thread Chris
Daniel Brown wrote: On Feb 17, 2008 10:59 AM, Velen <[EMAIL PROTECTED]> wrote: Hi Guys, When inserting a value like 123567.8956 in my table it is rounding it to 2 decimal place. The field type is set as float. Can anyone tell me why it's not taking all the decimals? and How to insert the numb

Re: [PHP-DB] Help with MySql float

2008-02-17 Thread Daniel Brown
On Feb 17, 2008 10:59 AM, Velen <[EMAIL PROTECTED]> wrote: > Hi Guys, > > When inserting a value like 123567.8956 in my table it is rounding it to 2 > decimal place. The field type is set as float. > > Can anyone tell me why it's not taking all the decimals? and How to insert > the number with all

Re: [PHP-DB] Help with MySql float

2008-02-17 Thread Tobias Franzén
Velen wrote: Hi Guys, When inserting a value like 123567.8956 in my table it is rounding it to 2 decimal place. The field type is set as float. Can anyone tell me why it's not taking all the decimals? and How to insert the number with all the decimals? Thanks Velen Hello Velen, Your qu

[PHP-DB] Help with MySql float

2008-02-17 Thread Velen
Hi Guys, When inserting a value like 123567.8956 in my table it is rounding it to 2 decimal place. The field type is set as float. Can anyone tell me why it's not taking all the decimals? and How to insert the number with all the decimals? Thanks Velen -- PHP Database Mailing List (http://ww

[PHP-DB] help for a newb - php install erroring out on MySQL file libmysqlclient.so.15

2007-10-13 Thread Dave Cocuzzi
This is kind of db related since the error appears to be occurring when accessing a MySQL file. This install is on Fedora 6 with Apache 2 and MySQL 5.0.45. While doing the php install the config script errors out when it gets to "creating main/internal_functions_cli.c". This is part of the g

Re: [PHP-DB] help

2007-08-20 Thread subramani
On 8/20/07, Asim <[EMAIL PROTECTED]> wrote: > can anyone provide me code of basic website structure having member > area and can use mysql database to show results of search by PAGINATION? For pagination refer this :- http://www.phpfreaks.com/tutorials/43/5.php Hope this will help you. --- R * S

[PHP-DB] help

2007-08-20 Thread Asim
Hi can anyone provide me code of basic website structure having member area and can use mysql database to show results of search by PAGINATION? can anyone give me code of php webpage that gets results from database mysql and show them in pages to website content is IMAGES THAT ARE

Re: [PHP-DB] Help creating tables and fields

2007-03-29 Thread bedul
- Original Message - From: Karl James To: 'bedul' Sent: Thursday, March 29, 2007 10:40 AM Subject: RE: [PHP-DB] Help creating tables and fields bedul, wow great information and so quick. very greatfull for that. Would you mine baby stepping for me? [bedul] i don't un

[PHP-DB] Help creating tables and fields

2007-03-28 Thread Karl James
Team, I am in need of your help. I have tried over the years to do this. But, I seem not to be able to get it to the way I want. I want to start from scratch. What I want to do is build site that has team management for your roster of players, and display stats in a nut shell. As far as sta

Re: [PHP-DB] help in database design

2007-03-28 Thread bedul
NOT QUITE..ups.. my bad - Original Message - From: "Chris" <[EMAIL PROTECTED]> To: "Suprie" <[EMAIL PROTECTED]> Cc: Sent: Thursday, March 29, 2007 6:53 AM Subject: Re: [PHP-DB] help in database design > Suprie wrote: > > hi all, > > >

Re: [PHP-DB] help in database design

2007-03-28 Thread Chris
Suprie wrote: hi all, i need help in design a database, our office is hospital equipment supplier, we had a list of items, each items had it's own configuration, and each item could consist of several item. we also had contract that have a lot of site, sometimes equipmend that have been ordere

Re: [PHP-DB] help in database design

2007-03-28 Thread bedul
what is site mean in here?? - Original Message - From: "Suprie" <[EMAIL PROTECTED]> To: Sent: Wednesday, March 28, 2007 5:03 PM Subject: [PHP-DB] help in database design > hi all, > > i need help in design a database, our office is hospital equipment supplier,

[PHP-DB] help in database design

2007-03-28 Thread Suprie
hi all, i need help in design a database, our office is hospital equipment supplier, we had a list of items, each items had it's own configuration, and each item could consist of several item. we also had contract that have a lot of site, sometimes equipmend that have been ordered different from

Re: [PHP-DB] help with mysql connect error

2007-02-11 Thread Chris
Tim McGeary wrote: Chris wrote: Tim McGeary wrote: Stut wrote: Ok, so I did the recommended process of: mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') -> WHERE Host = 'some_host' AND User = 'some_user'; mysql> FLUSH PRIVILEGES; This allows the CLI script to run successf

Re: [PHP-DB] help with mysql connect error

2007-02-09 Thread Tim McGeary
Chris wrote: Tim McGeary wrote: Stut wrote: Ok, so I did the recommended process of: mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') -> WHERE Host = 'some_host' AND User = 'some_user'; mysql> FLUSH PRIVILEGES; This allows the CLI script to run successfully, but the web ph

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Chris
Tim McGeary wrote: Stut wrote: Tim McGeary wrote: But I do have a MySQL 5 client: [EMAIL PROTECTED] html]# rpm -qa MySQL* MySQL-shared-compat-5.0.27-0.rhel3 MySQL-client-standard-5.0.27-0.rhel3 MySQL-python-0.9.1-6 MySQL-server-standard-5.0.27-0.rhel3 MySQL-devel-standard-5.0.27-0.rhel3 or ar

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Tim McGeary
Stut wrote: Tim McGeary wrote: But I do have a MySQL 5 client: [EMAIL PROTECTED] html]# rpm -qa MySQL* MySQL-shared-compat-5.0.27-0.rhel3 MySQL-client-standard-5.0.27-0.rhel3 MySQL-python-0.9.1-6 MySQL-server-standard-5.0.27-0.rhel3 MySQL-devel-standard-5.0.27-0.rhel3 or are you saying that th

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Stut
Tim McGeary wrote: Thank you for the link. I think that's probably the best way to go in this case, since it's only on a dev/test server. When I build the production server, I should probably upgrade to PHP5 anyhow. I assume that should not have this problem, right? It might. PHP5 can be b

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Tim McGeary
Stut wrote: Tim McGeary wrote: But I do have a MySQL 5 client: [EMAIL PROTECTED] html]# rpm -qa MySQL* MySQL-shared-compat-5.0.27-0.rhel3 MySQL-client-standard-5.0.27-0.rhel3 MySQL-python-0.9.1-6 MySQL-server-standard-5.0.27-0.rhel3 MySQL-devel-standard-5.0.27-0.rhel3 or are you saying that th

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Stut
Tim McGeary wrote: But I do have a MySQL 5 client: [EMAIL PROTECTED] html]# rpm -qa MySQL* MySQL-shared-compat-5.0.27-0.rhel3 MySQL-client-standard-5.0.27-0.rhel3 MySQL-python-0.9.1-6 MySQL-server-standard-5.0.27-0.rhel3 MySQL-devel-standard-5.0.27-0.rhel3 or are you saying that the PHP libs ha

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Tim McGeary
Stut wrote: Tim McGeary wrote: Oh, duh! Ok. I wrote this: mysql_connect($hostname, $username, $password) or die(mysql_error()); mysql_select_db($dbname) or die(mysql_error()); $result = mysql_query("SELECT * FROM Requestor_type") or die(mysql_error());

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Stut
Tim McGeary wrote: Oh, duh! Ok. I wrote this: mysql_connect($hostname, $username, $password) or die(mysql_error()); mysql_select_db($dbname) or die(mysql_error()); $result = mysql_query("SELECT * FROM Requestor_type") or die(mysql_error()); while($row = my

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Tim McGeary
Stut wrote: Tim McGeary wrote: Tim McGeary wrote: Stut wrote: Tim McGeary wrote: I am new to this list today, so if I should be sending this to another specific PHP list, please let me know. I am getting the following error via the PHP web page I am building: Warning: mysql_connect(): Can'

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Stut
Tim McGeary wrote: Please include the list in replies. Sorry, I meant to, but hit the wrong button. Tim McGeary wrote: Stut wrote: Tim McGeary wrote: I am new to this list today, so if I should be sending this to another specific PHP list, please let me know. I am getting the following er

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Tim McGeary
Please include the list in replies. Sorry, I meant to, but hit the wrong button. Tim McGeary wrote: Stut wrote: Tim McGeary wrote: I am new to this list today, so if I should be sending this to another specific PHP list, please let me know. I am getting the following error via the PHP web

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Tim McGeary
Stut wrote: Tim McGeary wrote: I am new to this list today, so if I should be sending this to another specific PHP list, please let me know. I am getting the following error via the PHP web page I am building: Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Stut
Tim McGeary wrote: I am new to this list today, so if I should be sending this to another specific PHP list, please let me know. I am getting the following error via the PHP web page I am building: Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mys

[PHP-DB] help with mysql connect error

2007-02-08 Thread Tim McGeary
I am new to this list today, so if I should be sending this to another specific PHP list, please let me know. I am getting the following error via the PHP web page I am building: Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) in /va

[PHP-DB] Help With Inventory Listings

2007-01-20 Thread Brandon Bearden
Can anyone help me figure out how to solve my inventory listing problem? I am using php_5 and mysql_5.0 w/apache on fbsd. I need to figure out a way to make a subtitle for every category (genre) in the inventory so when I list the entire inventory on a sheet (at client's request), it is organized

RE: [PHP-DB] Help on query report...

2006-11-18 Thread Bastien Koert
goolge cross tab query ... that is what you are looking for bastien From: Suprie <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] Help on query report... Date: Wed, 15 Nov 2006 13:28:15 +0700 dear all, i have this table id | contract No | site id | handover date |

Re: [PHP-DB] Help on query report...

2006-11-16 Thread Chris
Suprie wrote: dear all, i have this table id | contract No | site id | handover date |status| finishing date | contract value|actual value 1 | T0001 | LOS01 | 12-Apr-06| Done | 11-Apr-06 | 12,000 | 12,000 2 | T0002 | LOS02 | 12-Apr-06| Done | 11

[PHP-DB] Help on query report...

2006-11-16 Thread Suprie
dear all, i have this table id | contract No | site id | handover date |status| finishing date | contract value|actual value 1 | T0001 | LOS01 | 12-Apr-06| Done | 11-Apr-06 | 12,000 | 12,000 2 | T0002 | LOS02 | 12-Apr-06| Done | 11 Apr-06 | 11

RE: [PHP-DB] Help Needed!!

2006-11-08 Thread Bastien Koert
1. yes, user a rich text editor plugin in you web page (http://www.kevinroth.com/rte/ is one such beast) 2. sure, in a text / blob field 3. yes, but likely you'll need to do it as CDATA hth Bastien From: "David Skyers" <[EMAIL PROTECTED]> To: Subject: [PHP-DB] He

Re: [PHP-DB] Help Needed!!

2006-11-08 Thread John Meyer
Forgive me for saying this, but you should be posting this to the Oracle mailing list, not here. David Skyers wrote: > Hello, > > I have an input field that inserts data into an oracle table. The users > of the system will be composing the data that goes into this input field > in Microsoft Word.

[PHP-DB] Help Needed!!

2006-11-08 Thread David Skyers
Hello, I have an input field that inserts data into an oracle table. The users of the system will be composing the data that goes into this input field in Microsoft Word. They will also be using Microsoft Word formatting features. 1. Is it possible for my input box to retain the formatting and

[PHP-DB] Help! With MySQL CASE problem

2006-10-15 Thread Andrew Darby
Hello, all. I'm having a problem with a php/mysql app which is probably in the SQL, so please don't get angry at me. Basically, I have a CASE statement that works on my localhost, but doesn't seem to get recognised on the production server (i'm running php/mysql 5.x on my localhost, 4.x of both

Re: [PHP-DB] Help displaying Column Names

2006-09-14 Thread Dimiter Ivanov
To: php-db@lists.php.net Subject: [PHP-DB] Help displaying Column Names Hello All, I am fairly new to PHP but have coded in asp and asp.net for years. I am trying to find the code that will allow me to display the name of the column's from the table I am using. Below is the code where

RE: [PHP-DB] Help displaying Column Names

2006-09-14 Thread Miguel Guirao
You haven't searched at all, go to www.php.net and look up for mysql_field_name() and related functions!! -Original Message- From: Grant Griffith [mailto:[EMAIL PROTECTED] Sent: Jueves, 14 de Septiembre de 2006 10:22 a.m. To: php-db@lists.php.net Subject: [PHP-DB] Help displaying C

  1   2   3   4   5   6   7   >