[PHP-DB] Problem with php/mysql and ISS on windows XP profeesional

hi i use php and mysql on IIS server on windows xp professional when i select anything from the database i get this : Notice: Use of undefined constant name - assumed 'name' in d:\inetpub\wwwroot\EGYCDS\index.php on line 158 Spy Hunter while evrything is going fine when i upload it on the web

Re: [PHP-DB] Problem with php/mysql and ISS on windows XP profeesional

Sounds like you left off a $ when using a variable. I would take a look at line 158, find the variable name and make sure it's $name. Disabling the error will cause the message to go away but not fix the problem. humbly, =C= * Cal Evans * http://www.christianperformer.com * Stay plugged into

Re: [PHP-DB] Problem with php/mysql and ISS on windows XPprofeesional

If your missing the dollar sign then add it, if your not, then set error_reporting in your php.ini to E_ALL ~E_NOTICE. On Mon, 2003-06-02 at 10:52, Cal Evans wrote: Sounds like you left off a $ when using a variable. I would take a look at line 158, find the variable name and make sure it's

Re: [PHP-DB] Problem with php/mysql and ISS on windows XPprofeesional

Again, changing the error reporting level will not fix the problem. Since he is getting a warning AND his code is acting unexpectedly, he probably needs to concentrate on fixing the problem. (At least I assume that there is a problem. It sounds like there is from his description.) humbly, =C= *

Re: [PHP-DB] Problem with php/mysql and ISS on windowsXPprofeesional

Ok, like I said, if it is an error (like a missing dollar sign) then put the dollar sign in, therefore fixing the problem. However, if there is not an error and he is simply using a variable and PHP is complaining it's not defined, that's not a big deal, thats why it doesn't make the code fail. It

Re: [PHP-DB] Problem with php/mysql and ISS on windows XP profeesional

here is the code i wrote i didn't miss the $ sign and it works fine on web but returns the error message when i use it on localhost ? @ $db = mysql_connect(localhost); mysql_select_db(cds); $test_tr = mysql_query(select name from newpcgames order by gameid desc LIMIT 0, 10); $test_tr1 =

Re: [PHP-DB] Problem with php/mysql and ISS on windows XPprofeesional

Put single quote's around name in your record array, example: Use: $record['name'] Instead Of: $record[name] On Mon, 2003-06-02 at 11:04, Ahmed Abdelaliem wrote: here is the code i wrote i didn't miss the $ sign and it works fine on web but returns the error message when i use it on

[PHP-DB] Total Values with MySQL

Hi, Is it possible to get MySQL to total the values of a select statement, say 'SELECT ColumnName FROM Table WHERE ColumnName = '1'' Say I have three values in ColumnName all of '1' then can I get MySQL to return 3? Thanks for your help -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] Total Values with MySQL

SELECT SUM(ColumnName) AS total FROM table WHERE ColunName = '1'; On Mon, 2003-06-02 at 11:18, shaun wrote: Hi, Is it possible to get MySQL to total the values of a select statement, say 'SELECT ColumnName FROM Table WHERE ColumnName = '1'' Say I have three values in ColumnName all of

Re: [PHP-DB] Total Values with MySQL

Hi Shaun Comments inline... On 02 Jun,2003 at 16:18 shaun shaun wrote: Hi, Is it possible to get MySQL to total the values of a select statement, say 'SELECT ColumnName FROM Table WHERE ColumnName = '1'' Say I have three values in ColumnName all of '1' then can I get MySQL to return 3?

Re: [PHP-DB] query string

Awsome! Thanks, That is exactly what I was looking for. Work great now! Leif K-Brooks [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] To answer your question, you should urlencode() the team name. However, I would store the user in a cookie or session, and fetch the team name on

Re: [PHP-DB] another redirecting question

Hi Grant.. I've tested it and it doesn't resubmit this information a second time. I have a page called submit.php where users can upload pictures. Once they submit, it goes to submitpics.php for processing and creates a session. Then it's redirected to submit.php which reads the session and

[PHP-DB] Array Question

Hello everyone. If I wanted to pass a item ID along with a quantity to an associative array called CartArray how would I pass it to the PHP script? I'll get this shopping cart working yet !! Cheers, Graeme :) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

RE: [PHP-DB] Array Question

CartArray['itemid'] = $itemid; note where $qty = CartArray['qty']; /note Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Boa Constructor [mailto:[EMAIL PROTECTED] Sent:

Re: [PHP-DB] Array Question

RE: [PHP-DB] Array QuestionCheers Gary, and in the html would I put something like: a href=myscript.php?itemid=1qty=2buy this item/a Simple question I know! Jay, yup thats all I want to do, just assign two values into an array. Thank you, Graeme :) - Original Message - From:

[PHP-DB] Stuck on table design

I have a system I'm building. There are several applications. For each application there are one OR two reviewers. For each reviewer, there is a team leader, and for each team leader there is an administrator. Applications primary key is ApplicationID. Two reviewers can edit their own

Re: [PHP-DB] Array Question

Hello everyone. If I wanted to pass a item ID along with a quantity to an associative array called CartArray how would I pass it to the PHP script? I'll get this shopping cart working yet !! If the question is how do you pass an array to another PHP page, you serialize() and urlencode() it,

[PHP-DB] Adding elements to array question

Hey again all, right I've tried using an associative array for my shopping cart and I've encountered two problems - so far. The first problem is that I can't only add one item to the cart and the second problem is that when viewing the cart it shows two items in it. I think this is because there

[PHP-DB] Re : File Input From Form Not Detected

Hi everyone. Thanks for helping Turned out the problem was my upload_tmp_dir. So there you go.. heh Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail! http://login.mail.lycos.com/r/referral?aid=27005 -- PHP

[PHP-DB] Reserve Username while Confirming Signup

Hi All, I have a sign up page and when the user submit, it goes to a confirmation page, before the person actually submits. The confirmation page stores the username and password in the Session variable and the submit page stores it into the database by getting it from the session. The rest of

RE: [PHP-DB] Reserve Username while Confirming Signup

I'm inexperienced with db's, but here are my thoughts: Maybe add a TIMESTAMP(14) field in your temp table, then run a script periodically to delete any rows stored that are more than, say, 20 mins old? Gav -Original Message- From: Dewi Wahyuni [mailto:[EMAIL PROTECTED] Sent: Tuesday, 3

Re: [PHP-DB] Reserve Username while Confirming Signup

You don't need PostgreSQL for transactions. InnoDB tables in MySQL will work just fine. I do agree that this begs for a transaction setup. The transactions will confirm the transfer of everything from the temp to regular table. Then use a timestamp in conjunction with a sweeper script to

Re: [PHP-DB] Dealing with ENUM fields

This is for another menu project that I'm working on. The restaurant has a large list of daily specials, all of which fit into one of four categories (lunch, dinner, pizza, dessert). Because the data will never mix (no need for joins or unions), I wanted to keep the specials categories separate

[PHP-DB] MS Access DSN for PEAR DB::connect

Hi!Does anyone know what DSN I must use to get connected to my MS Access database? BUSINESS is my OBDC connection on Windows 2000 to my database. As PHP database type I use 'odbc'. Please find the enclosed code snipet: getMessage());} ? When running it, I receive an DB Error: connect failed.

[PHP-DB] MS Access DSN for PEAR DB::connect

Sorry, the first email was unreadable, Here again! pDoes anyone know what DSN I must use to get connected to my MS Access database?/p p BUSINESS is my OBDC connection on Windows 2000 to my database. As PHP database type I use 'odbc'. /p p ?php require_once('DB.php'); $dsn =

[PHP-DB] authentication problems

Hi to all, I upgrade from Red Hat 7.2 to 7.3, but now I'm facing a problem. Most of my pages use user authentication popup window. For some reason I can't get access to my pages even though I type in the right user name and password. The code for the pages remains the same, I haven't changed

RE: [PHP-DB] Reserve Username while Confirming Signup

I like that idea the best... Just insert into your DB with their requested login name and password. Have a timestamp field AND a registration completed field or a status field. I used to do this for people who had registered but had not come back to the site to verify that they recieved their

Re: [PHP-DB] Dealing with ENUM fields

Will there ever be 5 specials categories? 6? I like enums for strings, but for more complex sites I go with a separate table for even 4 categories. I don't actually know what happens if you change lunch to pre-dinner on the enum column -- does everything remain as enum selection #1 and change

[PHP-DB] Access denied for user: '@localhost'

Hi, this problem seems to have appeared after a system upgrade ... command line works fine mysql -uschool -pbonfire school BUT ?php /* Connecting, selecting database */ $link = mysql_connect(localhost, school, bonfire) or die(Could not connect : . mysql_error()); print