Re: [PHP] Help with msql_fetch_array() FIXED ! Now cookie problems :(
Hello again,
I got the fetch_array problems fixed. I was using the actual server name,
when I switched back to localhost everything worked!!
Now I have a question about how to make cookies work on a Windows machine.
This is what I have these parameters set to but it's not working. Do I
have slashes/backslashes wrong, or is there something else I have to do in
Apache??:
session.save_path = C:/Program Files/Apache
Group/Apache/web/php/dir/files/temp
; Whether to use cookies.
session.use_cookies = 1
; Name of the session (used as cookie name).
session.name = PHPSESSID
; Initialize session on request startup.
session.auto_start = 0
; Lifetime in seconds of cookie or, if 0, until browser is restarted.
session.cookie_lifetime = 0
; The path for which the cookie is valid.
session.cookie_path = c:/Program Files/Apache
Group/Apache/web/php/dir/files/temp
; The domain for which the cookie is valid.
session.cookie_domain = www.mydomain.com
As always, thanks for your help.
PHPCoder [EMAIL PROTECTED]
07/24/02 01:50 PM
To: Matthew Bielecki [EMAIL PROTECTED]
cc: php-general [EMAIL PROTECTED]
Subject:Re: [PHP] Help with msql_fetch_array()
I can almost guarantee that it's not the second line that is failing,
the problem here is that $result is not containing naything, and that is
normally due to the fact that you are not connecting to the db, or the
table tablename is not there.
I use the following format as my standard MySQL connect and query
snippet:
$link = @mysql_connect(localhost,$username,$password) or die ('Could
not connect!'); //@ suppresses the default error message generated by
this function and the or die() bit kills the script right then and
there should it not be able to connect.
mysql_select_db(YOUR_DB_NAME,$link);
$sql = select * from your_table_name;
if ( $result = mysql_query($sql)) { // checks to see if $result
contains anything before it even tries to fetch an associative array
from it.
$row = mysql_fetch_assoc($result);
} else {
echo Empty result set!;
Note also that I use mysql_fetch_assoc and NOT mysql_fecth_array, as 9
out of 10 times, you don't need the array element id's that is returned
by mysql_fetch_array.
Matthew Bielecki wrote:
I have a couple of scripts that fail with the error of:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
result
resource in...
I'm new to both SQL and PHP and I'm wondering if I have some setting
turned off or what.
Here's the piece of code that is failing (the second line fails):
$result = mysql_db_query($dbname, SELECT * FROM tablename ORDER BY id);
$row = mysql_fetch_array($result);
Thanks for your help in advance!!
Re: Re[2]: [PHP] Help with msql_fetch_array() FIXED ! Now cookie problems:(
OH MY GOSH...I ACTUALLY GOT A REAL PROGRAM TO RUN! Thanks a ton x 1,000,000 Alexander Thanks, Matthew J. Bielecki, MCP, A+ Certified Technician Hobart Corporation Field Engineer - Weighing Network Systems Phone (937) 332-7163Fax (937) 332-3222 Email [EMAIL PROTECTED] Alexander Kuznetsov [EMAIL PROTECTED] 07/25/02 10:15 AM Please respond to Alexander Kuznetsov To: Matthew Bielecki [EMAIL PROTECTED] cc: php-general [EMAIL PROTECTED] Subject:Re[2]: [PHP] Help with msql_fetch_array() FIXED ! Now cookie problems :( Hello Matthew, Thursday, July 25, 2002, 5:06:09 PM, you wrote: MB Hello again, MB I got the fetch_array problems fixed. I was using the actual server name, MB when I switched back to localhost everything worked!! MB Now I have a question about how to make cookies work on a Windows machine. MB This is what I have these parameters set to but it's not working. Do I MB have slashes/backslashes wrong, or is there something else I have to do in MB Apache??: MB session.save_path = C:/Program Files/Apache MB Group/Apache/web/php/dir/files/temp MB ; Whether to use cookies. MB session.use_cookies = 1 MB ; Name of the session (used as cookie name). MB session.name = PHPSESSID MB ; Initialize session on request startup. MB session.auto_start = 0 MB ; Lifetime in seconds of cookie or, if 0, until browser is restarted. MB session.cookie_lifetime = 0 MB ; The path for which the cookie is valid. MB session.cookie_path = c:/Program Files/Apache MB Group/Apache/web/php/dir/files/temp MB ; The domain for which the cookie is valid. MB session.cookie_domain = www.mydomain.com try something like this session.save_path = c:/Program Files/Apache Group/Apache/web/php/dir/files/temp i mean without ... i had that problem - deleted and all is working now -- Best regards, Alexander Kuznetsov
[PHP] Help with msql_fetch_array()
I have a couple of scripts that fail with the error of: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in... I'm new to both SQL and PHP and I'm wondering if I have some setting turned off or what. Here's the piece of code that is failing (the second line fails): $result = mysql_db_query($dbname, SELECT * FROM tablename ORDER BY id); $row = mysql_fetch_array($result); Thanks for your help in advance!!
Re: [PHP] Help with msql_fetch_array()
Well I think you were correct about not connecting to the db, but I don't
understand why. I wrote another little script just to test the
connection.
?php
$link = mysql_connect(servername,username,password)
or die(Couldn't make connection.);
$diditwork = mysql_select_db(news, $link);
if ($diditwork FALSE)
{
echo got the db..yea!;
echo $link;
}
else
{
echo didnt get db...bo;
echo $link;
}
?
This returns didnt get db...booResource id #1
I don't understand how I can get a resource ID but then not be able to use
the news database. Like I described earlier, this happens with my other
db as well. I can connect to the db through the console or any other
client I have on the physical server and do whatever I want with the db's,
I'm just having problems with php.
Thanks again for your help!!
PHPCoder [EMAIL PROTECTED]
07/24/02 01:50 PM
To: Matthew Bielecki [EMAIL PROTECTED]
cc: php-general [EMAIL PROTECTED]
Subject:Re: [PHP] Help with msql_fetch_array()
I can almost guarantee that it's not the second line that is failing,
the problem here is that $result is not containing naything, and that is
normally due to the fact that you are not connecting to the db, or the
table tablename is not there.
I use the following format as my standard MySQL connect and query
snippet:
$link = @mysql_connect(localhost,$username,$password) or die ('Could
not connect!'); //@ suppresses the default error message generated by
this function and the or die() bit kills the script right then and
there should it not be able to connect.
mysql_select_db(YOUR_DB_NAME,$link);
$sql = select * from your_table_name;
if ( $result = mysql_query($sql)) { // checks to see if $result
contains anything before it even tries to fetch an associative array
from it.
$row = mysql_fetch_assoc($result);
} else {
echo Empty result set!;
Note also that I use mysql_fetch_assoc and NOT mysql_fecth_array, as 9
out of 10 times, you don't need the array element id's that is returned
by mysql_fetch_array.
Matthew Bielecki wrote:
I have a couple of scripts that fail with the error of:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
result
resource in...
I'm new to both SQL and PHP and I'm wondering if I have some setting
turned off or what.
Here's the piece of code that is failing (the second line fails):
$result = mysql_db_query($dbname, SELECT * FROM tablename ORDER BY id);
$row = mysql_fetch_array($result);
Thanks for your help in advance!!
