Re: [PHP] how to read a specific "cell"

2005-04-26 Thread Joseph Connolly
seb, it would help to post the actual table structure jozef Sebastien Pahud wrote: Hello, I cannot figure out how to read a specific "cell" in a result i got from a SQL request. I have a SQL request on a database: SELECT nameAttribute, fr, de, en FROM traduction WHERE nameTable = 'whatever' A

Re: [PHP] Re: PHP Designer 2005

2005-04-26 Thread Joseph Connolly
resources. If he likes the program, knowing other people use it fine in many settings may lead him to look for other root causes John Nichel wrote: Joseph Connolly wrote: Sorry, but i have had NO problems with PHP Designer 2005 I have it running on 3 machines...never a problem with memory usagei

Re: [PHP] Re: PHP Designer 2005

2005-04-26 Thread Joseph Connolly
Sorry, but i have had NO problems with PHP Designer 2005 I have it running on 3 machines...never a problem with memory usagei think it is the greatest thing since sliced bread. Jason Barnett wrote: The Disguised Jedi wrote: Some might consider this OT, but I need to figure this out somehow,

Re: [PHP] step by step learning

2005-04-26 Thread Joseph Connolly
hey paul, php is not like html. HTML is a markup language and PHP is a scripting languange. Once you get through installing PHP, it is not like HTML where you start with the basic tags and learn them one by one. PHP has functions and you need to know which funcitons you need for the right job

Re: [PHP] uploading file

2005-04-13 Thread Joseph Connolly
Thanks for the info. That makes sense. John Nichel wrote: Joseph Connolly wrote: I though you could limit it in the php.ini file. OR, you can determine it's length through php and then discard it. I remember reading something about limiting file size and overidding that limit in the scrip

Re: [PHP] uploading file

2005-04-13 Thread Joseph Connolly
I though you could limit it in the php.ini file. OR, you can determine it's length through php and then discard it. I remember reading something about limiting file size and overidding that limit in the script. If i find it i will post it here. Richard Davey wrote: Hello Marc, Wednesday, April

Re: [PHP] phpmyadmin blank screen.

2005-04-13 Thread Joseph Connolly
1- are you loading the mssql extensions or the mysql extensionsyou keep interchanging the two and they ARE NOT the same 2- in addition you may have to load the mysqli extension if you want to run phpMyAdmin. 3- re read the php manual and the phpMyAdmin If the screen is blank trying to read t

Re: [PHP] Simple Problem

2005-04-12 Thread Joseph Connolly
I think what you mean/need is: $sql="SELECT products.productID, products.title, products.number_per_box, products.stock_level, products.image, users.username, users.email, users.userID FROM users, products WHERE products.userID = users.userID AND userID = $userID"; John Nichel wrote: PartyPo

Re: [PHP] another non php Q

2005-04-07 Thread Joseph Connolly
www.w3.org http://www.w3.org/MarkUp/html3/textarea.html wrong list though William Stokes wrote: Is there a way to limit a size with som sort of a maxlength value I know it's not php but thanks anyway -Will -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php

Re: [PHP] Re: php rich text editors

2005-04-07 Thread Joseph Connolly
1- i like php designer. It is free cross platform and does everything i need. They also make a html editor calle 'html gate' mpsoftware.dk 2- you could use google 3-go to http://www.php-editors.com/ which has many tools and forums DuSTiN KRySaK wrote: Problem with that one - does not work in safa

Re: [PHP] sql question

2005-04-07 Thread Joseph Connolly
if i understand you question... SELECT columns FROM table WHERE (condition #1) AND (condition #2); You can add many conditions. There are many ways to do this. This one is probably the most simple for only two conditions. Depending on your needs you also may need to create a subquery. SELECT col

Re: [PHP] Help with SQL Query String

2005-03-31 Thread Joseph Connolly
well...i would have told him to go pound sand...the php manual is great and so is the MySQL manual. People are just lazy. [/snip] Ya'll bitch when I make them RTFM, ya'll bitch when I do codewhat's a guy to do? j/k Actually http://dev.mysql.com/doc/mysql/en/string-functions.html shows that My

Re: [PHP] Help with SQL Query String

2005-03-31 Thread Joseph Connolly
You should not just give him the code but rather tell him why. 1. trim() is a php function. MySQL does not know what to do with it. You need to place it 'outside' of the sql. You can also do something like this: $userid = trim($row['USERID']); Then use $userid in your sql. 2. Items in arrays must

Re: [PHP] Insertion of integer in a database

2005-03-23 Thread Joseph Connolly
I don't think the integer is the problem, but if it is you can turn time() into a variable and then, $time = time(); david joffrin wrote: Hi folks, Problem is fairly simple, but how can I insert integer in an SQL statement? So, I only had strings, but now I have introduced a timestamp column