this question be any different if I were using
PostgreSQL, MSSQL or DB2?
Thank you in advance for any advice you can offer.
Sincerely,
Paul Burney
<http://paulburney.com/>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
h =
$file_system_location . '/includes:' .
$current_includes_path;
ini_set('include_path',$new_include_path);
Hope that helps.
Sincerely,
Paul Burney
<http://paulburney.com/>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
on 05/30/2003 9:16 AM, Dewi Wahyuni at [EMAIL PROTECTED] appended the following
bits to my mbox:
> if($userfile) it fails. BUT $userfile_name is able to display the filename .
I just tried the script on your site...
It looks like you are trying to fopen the actual file name. You need to
fopen
4.1 or above, you should probably be looking at the
$_FILES array.
- You must add an encoding type to the form -> enctype="multipart/form-data"
HTH.
Sincerely,
Paul Burney
<http://paulburney.com/>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
CT * FROM Firmennamen INNER JOIN Master ON
Firmennamen.ID=Master.FN INNER JOIN Personen ON Master.NN=Personen.ID WHERE
Personen.NAME LIKE '%$name%'";
Also make sure that you are indexing the fields that you are performing the
joins on.
HTH.
Sincerely,
Paul Burney
<http://paulbu
vels in the hierarchy, each include call needs to be different.
If your web host allows you to use .htaccess files and gives you override
permissions, you can put this in the .htaccess file at the top level of your
server.
php_value include_path '/whatever/path/you/need/here:.'
Sincerely,
ld also do:
$_SESSION = array();
Before the calls to unset and destroy.
See the comments on this page for a bunch more information:
<http://www.php.net/manual/en/function.session-destroy.php>
HTH.
Sincerely,
Paul Burney
<http://paulburney.com/>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
$query for the query, and $line for the
returned record array.
A lot of database classes use $db as the new object.
Hope that helps.
Sincerely,
Paul Burney
<http://paulburney.com/>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
aying with JPGraph to produce some nice charts).
Cool. We'd love to see some of your results when they are usable.
Sincerely,
Paul Burney
<http://paulburney.com/>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ould
be welcome. :-)
This gives the top servers in order of hits:
select count(*) as hits,server_name from access_log_archive group by
server_name order by hits desc;
Note: If your server is busy, you should query from another "mirrored" table
that isn't being accessed all the t
;http://www.dbmsmag.com/9605d06.html>
<http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm>
Hope that helps.
Sincerely,
Paul Burney
<http://paulburney.com/>
Q: Tired of creating admin interfaces to your MySQL web applications?
A: Use MySTRI instead. Version 3.1 now
on 3/22/03 8:26 PM, Mike Delorme at [EMAIL PROTECTED] appended the
following bits to my mbox:
> $select = "mysql_select_db ($database)";
Remove the quotes around this. Actually, there is no reason to do the
variable assignment either.
Sincerely,
Paul Burney
<http:
he name element, but it works very well.
Another idea is to use "id" elements for JavaScript / DOM interaction and
reserve the "name" elements for php. That should work on any modern browser
(sorry, no Netscape 4.x).
HTH.
Sincerely,
Paul Burney
<http://paulburney.
applicable. Unless you're running out of
memory? Or maybe the server can't handle all the connections? If so, you
could try sleeping for a second every 10 times through the loop, etc, to
slow down the process and maybe keep it from dying.
Hope that helps.
Sincerely,
Paul Bur
mples/examples/examples/examples/e
xamples/examples/somefile.html
As far as apache is concerned, it is fulfilling the request with the
examples.php file and php just sees a really long query_string starting with
/examples.
I'm sure that isn't your problem, but I've been bit by it a f
ge that data in criteria doesn't match. (free
> translation)
> The field Datumsfeld is a date field with the syntax DD.MM. (German way)
Maybe you should try the date in the syntax the database uses, i.e.,
12.12.2002?
Sincerely,
Paul Burney
<http://paulburney.com/>
--
PHP Dat
("\r\n", $_POST);
If that doesn't help, send an example of what you want the data to look
like.
Sincerely,
Paul Burney
--
I'm inhaling Caesar's last gasp...
http://paul.burney.ws/thoughts/caesars_breath.html
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
"Willy-Brandt-Platz-5"
>
> I want to have an array that looks like this:
> $variable_array[0] should be "Willy"
> $variable_array[1] should be "Brandt-Platz"
Wrong list since doesn't involve databases. Should be on PHP-General. That
said, use strtok:
ewrite the query with a JOIN, something like:
SELECT table1.id FROM table1 LEFT JOIN table2 ON table1.id=table2.table1_id
WHERE table1.sold=1 AND table2.table1_id IS NULL; (not tested)
More info can be found here:
<http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html>
Hope that helps.
S
MS? That is, perhaps session_id() or $customer_id is not giving a
valid value.
3) Using the results of (2) above, have you input the query into another
RDBMS client (i.e., command line version) to see what kind of errors are
given.
HTH.
Sincerely,
Paul Burney
<http://paulburney.com/>
--
o use mysql_connect().
>
> "Call to undefined function: mysql_pconnect()"
You need to install the php-MySQL RPM file from the Red Hat CD. The default
install doesn't give you MySQL support.
HTH.
Sincerely,
Paul Burney
--
I'm inhaling Caesar's last gasp...
that
generate HTML pages. PHPMyAdmin is just a collection of PHP pages that talk
to MySQL. It doesn't require any special "installation."
See: <http://phpmyadmin.sf.net> for more information.
Sincerely,
Paul Burney
<http://paulburney.com/>
--
PHP Database Mailing Lis
#x27;t
know of a way for you to be specific).
Hope that helps.
Sincerely,
Paul Burney
<http://paulburney.com/>
Q: Tired of creating admin interfaces to your MySQL web applications?
A: Use MySTRI instead. Version 3.1 now available.
<http://mystri.sourceforge.net/
:
- Have your php script output the correct Content-type header for the image
and pass it through while logging the info you want.
HTH.
Sincerely,
Paul Burney
<http://paulburney.com/>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
on 2/26/03 6:23 PM, Jonathan Villa at [EMAIL PROTECTED] appended the
following bits to my mbox:
> but what I'm missing is
>
> CREATE table blah, blah, blah
Here you go:
SHOW CREATE TABLE $tablename;
HTH.
Sincerely,
Paul Burney
<http://paulburney.com/>
Q: Tired of creat
w a live demo
and download the source at:
<http://www.burney.ws/software/library.php?id=20>
Hope that helps.
Sincerely,
Paul Burney
<http://paulburney.com/>
Q: Tired of creating admin interfaces to your MySQL web applications?
A: Use MySTRI instead. Version 3.1 now av
"file")
If you don't want to recompile with CURL support, nor want to upgrade to PHP
4.3.x, you may be able to call a command line utility directly. For
example, I've used this in the past:
passthru('curl https://secure.example.com/some-file.html');
Hope that
wGraph(); call inside your while
loop.
If not, let us know what format it needs the data in and we'll help you
figure out how to get it from the database into that format.
If you can't figure out what format of data the class needs, you should let
us see the graph class source.
HTH.
S
#x27;t be seen until the next time you view the page. If your
setcookie command and echo $cookie commands are in the same file, you won't
see the echo unless you reload.
You may also wish to look at the documentation for the setcookie (not
sendcookie) function:
<http://www.php.net/manual/en/func
No, it will not work. PHP is server side, JavaScript (onClick, etc.) is
client side. Have the form submit to a PHP page that has the session
functions at the top.
HTH.
Sincerely,
Paul Burney
<http://paulburney.com/>
Q: Tired of creating admin interfaces to your MySQL web applications?
A: Us
es on the list. Check the archives:
<http://marc.theaimsgroup.com/?l=php-db>
Also, a google search:
<http://www.google.com/search?q=mysql+php+image+blob>
Turns up a good tutorial as the first result:
<http://www.phpbuilder.com/columns/florian19991014.php3>
Hope that helps
connection
$q = 'SELECT COUNT(*) FROM tablename';
list($my_count) = MySQL_fetch_row(MySQL_query($q,$dbh));
The $my_count variable now has your number of rows.
Hope that helps.
Sincerely,
Paul Burney
<http://paulburney.com/>
Q: Tired of creating admin interfaces to your MySQL web appl
"
one that MySQL_fetch_array returns. Try using MySQL_fetch_assoc instead.
Hope that helps.
Sincerely,
Paul Burney
<http://paulburney.com/>
Q: Tired of creating admin interfaces to your MySQL web applications?
A: Use MySTRI instead. <http://www.burney.ws/software/mystri/>
-
ree. See this site for
details:
<http://philip.greenspun.com/sql/trees.html>
If you aren't tied to that database structure, you could investigate the
must faster denormalized alternative nested set model that is often
mentioned on this list:
<http://searchdatabase.techtarget.com/
t;\r\n","\n",$text); // windows to unix
$text = str_replace("\r","\n",$text); // mac to unix
$text = str_replace("\n","\r\n",$text); // all to windows
HTH.
Sincerely,
Paul Burney
--
I'm inhaling Caesar's last gasp...
ht
n use PHP to parse the results to tell
you which fields are time types, then use that result to build a query like
that above. (You could also use one of the php mysql_field_* functions.)
HTH.
Sincerely,
Paul Burney
<http://paulburney.com/>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
f not. Adding the select database command
in the script solved it, of course.
Check phpinfo() to see if sybase persistent connections are allowed, and if
you aren't using the default database, make sure you are calling the
sybase_select_db() command before the queries.
http://www.php.net
tabase
c) transfer the data
If the databases are on the same server, I think you can do (c) as the
following:
INSERT INTO $new_database.$tablename SELECT * FROM $old_database.$tablename;
If it's a remote server, I think it would require you to do it in PHP
(ouch).
Hope that helps.
Since
ng request page while waiting
for the processing finished page to show up, which will take at least 10
seconds because of the sleep(10) command.
Why do you want to sleep instead of giving the results to the user as soon
as they are ready? Is it a security issue so the server doesn't
rd = 'yes';
while (result = something) {
if ($first_record == 'yes') {
do_something();
$first_record == 'no';
} else {
do_something_else();
}
}
HTH.
Sincerely,
Paul Burney
<http://paulburney.com/>
--
PHP D
ange to DESC as suggested by someone else, but instead of directly
outputting the result, store it into another array. Then reverse that array
in php and display it.
HTH.
Sincerely,
Paul Burney
<http://paulburney.com/>
--
PHP Database Mailing List (http://www.php.net/)
To uns
t's a simple MySQL based calendar in PHP.
DevShed is good place for other PHP tutorials as well.
HTH.
Paul Burney
<http://paulburney.com/>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
on 10/15/02 4:11 PM, BAROILLER at [EMAIL PROTECTED] appended the
following bits to my mbox:
> No one have an idea ?
Maybe it's because this isn't really database related and you posted to the
PHP-DB list instead of PHP-GENERAL?
> I don't want to use this because it's too long for users when you
on 10/15/02 12:29 AM, CK Raju at [EMAIL PROTECTED] appended the following
bits to my mbox:
> Reports of US annexing Iraq appears to be highly disturbing. The oil
If (!preg_match('/php/',$message_body)) {
redirect_message('/dev/null');
}
--
PHP Database Mailing List (http://www.php.net/
her MySQL commands, type a question mark or \h at the MySQL command
prompt.
mysql> ?
Hope that helps.
Sincerely,
Paul Burney
--
I'm inhaling Caesar's last gasp...
http://paul.burney.ws/thoughts/caesars_breath.html
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
r further information:
<http://www.php.net/manual/en/function.ini-set.php>
HTH.
Sincerely,
Paul Burney
<http://paulburney.com/>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
orrectly, that option is related to quoting for certain
database queries. Specifically, it adds a ' to every ' character.
If you are able to use .htaccess files to override settings on the server,
you could try something like this:
php_value magic_quotes_gpc 0
Hope that helps.
Since
o run a version the FileMaker unlimited
client connected to the FileMaker server. You can then use the native XML
output from the Web Companion or one of the previously mentioned php
scripts.
Hope that helps.
Sincerely,
Paul Burney
<http://paulburney.com/>
--
PHP Database Mailing List
ly outputting strings, printf isn't really necessary
so you can use the echo command instead.
Also, though this probably isn't the reason, you should quote your key
names.
while ($myrow = mysql_fetch_array($result)) {
echo '',$myrow['Name'],'';
to use the CURL functions:
<http://php.us.themoes.org/manual/en/ref.curl.php>
I'd suggest looking for an RPM that has them included.
Sincerely,
Paul Burney
<http://paulburney.com/>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
on php-general.
FWIW, I believe that the location needs to include the scheme and FQDN,
i.e., http://example.com/file.php
Some browsers (notably Lynx) complain or don't work with relative Location
headers. It's also possible that the "." is causing a problem.
Sincerely,
Paul
and it must be set to handle the FDF type. This may be the
default case in Windows, but I know from experience that it is a PITA on old
Macs.
Hope that helps.
Sincerely,
Paul Burney
<http://paulburney.com/>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
al/en/function.preg-match.php>
HTH.
Sincerely,
Paul Burney
<http://paulburney.com/>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ot;3";
Hope that helps.
Sincerely,
Paul Burney
<http://paulburney.com/>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
or an RPM for PHP that
mentions MySQL as well.
HTH.
Sincerely,
Paul Burney
<http://paulburney.com/>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
to delete your table's entire contents.
Usually, with PHP and MySQL such a query would fail. If you use the above
code, it would succeed.
Just a word of warning.
Sincerely,
Paul Burney
<http://paulburney.com/>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
the options into an array and then create the list by looping
through the array, each time checking the value to see if it is the selected
one using the code above.
HTH.
Sincerely,
Paul Burney
<http://paulburney.com/>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
nt then set a blank
$thisoption="";}
} // end option "if" statement
} // end id "if" statement
/* More code after this point */
} // end "while" if statement.
===
Hope that helps.
Sincerely,
Paul Burney
<http://paulburney.com/>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
; , urlencode($username);
HTH.
Sincerely,
Paul Burney
<http://paulburney.com/>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ot;DELETE FROM $tablename WHERE id IN ('" .
implode("','", addslashes($_POST['del'])) . "')";
That would produce something like:
DELETE FROM table WHERE id IN ('3','4','123');
Hope that helps.
Sincerely,
Paul Burney
<http://paulburney.com/>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
to display the name CASTRO TRUCKING, the text field
> only display the first word CASTRO.
> >
Just following up on what someone else said. If the Name field has a quote
in it, such as <> that could also cause
problems.
To remedy, do this:
HTH,
Paul Burney
http://burney.ws/
on 3/27/02 11:45 PM, mailing list at [EMAIL PROTECTED] appended the
following bits to my mbox:
> I am attempting to POST to a https://whatever.url.com server and return
> the result from the server into the script without the user knowing using
> a php script. I can not use CURL becuase the shar
out Marc Liyange's startup script for MySQL on OS X.
<http://www.entropy.ch/software/macosx/mysql/>
HTH.
Sincerely,
Paul Burney
http://paulburney.com/
http://security.e-matters.de/advisories/012002.html> */
?>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
so take my advice with a grain
of salt.
Hope it helps.
Sincerely,
Paul Burney
http://paulburney.com/
http://security.e-matters.de/advisories/012002.html> */
?>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
#x27;s better to place it on a public web server somewhere
and then use a link to it in your post, like this:
<http://example.com/somefolder/my_image.jpg>
Or
<http://example.com/somefolder/my_php_file.phps>
Sincerely,
Paul Burney
http://paulburney.com/
http://security.e-matte
op-down menus. You can see the theory
and tutorial here:
<http://webreference.com/dev/menus/>
And they even have a script that'll generate the code for you here:
<http://webreference.com/js/tools/menus/>
Hope that helps.
Sincerely,
Paul Burney
http://paulburney.co
on 3/4/02 11:34 PM, jas at [EMAIL PROTECTED] appended the following bits
to my mbox:
> how can you find out what the php.ini is looking like? is there a way to
> use php to get that info. i have used phpinfo() but i cannot see whether or
> not file_uploads is disabled
It will only show up in P
on 3/5/02 5:35 AM, Andy at [EMAIL PROTECTED] appended the following bits
to my mbox:
> No I was reading in a mysql book, that chars like ' are bad for db
> PHP provides the function addslashes. Is this the way to check for bad
> entries a user provides? What happens
> if a hacker tryes to delete
on 3/3/02 7:39 PM, Ric Mañalac at [EMAIL PROTECTED] appended
the following bits to my mbox:
> i personally think that the developer still has
> the control in making his php code secure. but how do you
> think will this news affect php as one of the most popular
> choice for web developers?
Prob
on 2/28/02 2:21 AM, Monty at [EMAIL PROTECTED] appended the following bits
to my mbox:
> I have an Image table in a MySQL database that will be used to store the
> location of all images used on my site. Some images will relate to an
> Article table (article.id) and some images may relate to a Me
on 2/27/02 2:51 AM, Marco Coletta at [EMAIL PROTECTED] appended the
following bits to my mbox:
> I would like to upgrade to newer version of php, ho can supply detailed
> instructions.
You can start here:
http://www.php.net/manual/en/installation.php
And if you have difficulty, post your probl
on 2/25/02 11:32 AM, ªüYam at [EMAIL PROTECTED] appended the following
bits to my mbox:
> I don't know why??That comes out a Err Msg about "Unsupported type:
> text/html" .
I've never done any WML scripting, but the error message offers a big clue.
PHP by default sends a Content-type
on 2/8/02 9:05 PM, Desikan at [EMAIL PROTECTED] appended the following
bits to my mbox:
> Actually I want to replace "is" alone from the string and not all the
> words that contains is...
>
> I have tried with "^".$is."$" ---> but yields nothing
This kind of question really belongs on the P
on 2/4/02 12:54 PM, J Leonard at [EMAIL PROTECTED] appended the following
bits to my mbox:
> mysql_connect($db["host"],$db["user"],$db["password"],$db["database"]) or
The above function call only has three parameters. The database isn't
specified in the connect call but selected later. Try:
m
on 2/3/02 3:36 PM, Lutz Brückner at [EMAIL PROTECTED] appended the following
bits to my mbox:
>> Question is how to properly form a LEFT JOIN using
>> UPDATE... I tried:
>>
>> UPDATE product_price LEFT JOIN temp
>> SET product_price.product_price_vdate = 1 (del flag)
>> ON product_price.product_
on 1/26/02 1:21 AM, jas at [EMAIL PROTECTED] appended the following bits
to my mbox:
> Ok, I am having a hard time coming up with a mysql connection class that
> simply allows me to setup a require(db_connection.inc) at the top of my php
> pages that allows a consistent connection to the mysql db
on 1/15/02 4:08 PM, Wee Chua at [EMAIL PROTECTED] appended the
following bits to my mbox:
> Is it possible that I would get the wrong ID (Not the ID I just inserted in
> Auto_Increment field) by using mysql_insert_id function if someone is also
> inserting record at the same time? How does mysql_
on 1/15/02 7:38 AM, Adam Royle at [EMAIL PROTECTED] appended the
following bits to my mbox:
> I have been trying for months now (on and off) to get mail() working in
> OS X. I
> - I am using PHP v4.0.6 on Mac OS X 10.1 (pre-compiled with cool options
> from entropy.ch)
> - I installed Communiga
on 1/14/02 2:12 PM, Daniel Barton at [EMAIL PROTECTED] appended the following
bits to my mbox:
> Well maybe I should just go out and join that perl list.
I was going to respond to you but I didn't have a good answer. :)
I don't know of any built in PHP functions that do what you are looking to
on 1/12/02 7:36 AM, Malcolm White at [EMAIL PROTECTED] appended the
following bits to my mbox:
> 4. No error messages. An email constructed as above sends perfectly - but
> the return path defaults to the apache user (in my case www) not the
> supplied return path. I tested the header constructio
es (what goes in the [" "]?)
Using the above code, the value you're looking for is mydate, i.e.,
echo $myrow['mydate'];
HTH.
Sincerely,
Paul Burney
++
Paul Burney
Webmaster && Open Source Deve
on shared servers.
5) Backup everything from databases regularly and hope you never really need
to use them.
Hope that helps.
Sincerely,
Paul Burney
++++++
Paul Burney
Webmaster && Open Source Developer
UCLA -> GSE&IS -> E
specialchars() function.
<http://php.net/manual/en/function.htmlspecialchars.php>
Sincerely,
Paul Burney
++++++
Paul Burney
Webmaster && Open Source Developer
UCLA -> GSE&IS -> ETU
(310) 825-8365
<[EMAIL
ion of MySQL are you using? I remember something about ordering by
rand() only working in 3.23.xx. If you're using 3.22.xx, it won't work.
You could do something with mysql_data_seek() and the php mt_rand() function
if that's the case. It would be k
'" WHERE GID=' . $gid;
HTH.
Sincerely,
Paul Burney
++++++
Paul Burney
Webmaster && Open Source Developer
UCLA -> GSE&IS -> ETU
(310) 825-8365
<[EMAIL PROTECTED]>
<http://www.gseis.ucla.edu/>
+
riptive than those from PHP.
Another thing to try is instead of dying with "Problem!", try exiting with
mysql_error and/or mysql_errno, that is:
echo mysql_errno() , ': ' , mysql_error() , '';
HTH.
Sincerely,
Paul Burney
ction exactly? If so, where is $dbuser set? If
it's set outside the function, you need to make it a global
global $user_tablename,$dbuser;
> Does this have anything to do with updated MySQL parser? I am now using
> MySQL version 3.23.36.
Possibly if the version of P
. $file_extension;
You should also look at using the GetImageSize function to determine whether
or not the file is really an image.
Good luck.
Sincerely,
Paul Burney
+-----+-+
| Paul Burney | P: 310.825.8365 |
| We
ist since this is a PHP / Database discussion list.
See mysql.com for more information.
Sincerely,
Paul Burney
+-+-+
| Paul Burney | P: 310.825.8365 |
| Webmaster && Programmer | E: <[EMAIL PROTECTED]&g
($query, $connection_id)
Just make sure that you select the db before each query otherwise a query
will use the last selected database.
Sincerely,
Paul Burney
+-+---------+
| Paul Burney | P: 310.825.8365 |
| Webmas
cking isset($submit).
Some browsers (Netscape on the Mac, for example) won't submit the name-value
pair associated with the button.
One solution is to do this instead:
No matter how the form is submitted, the submit variable will
mysql_fetch_array before this in your code, perhaps to see
if there is a result? If so, that's the problem. Each call to
mysql_fetch_array (mysql_fetch_row) increments the array pointer.
If that isn't your problem, please post more of the code so that we can make
a better diagnos
x27;;
Or escape the $:
$query = "SELECT instance_name, host_name FROM v\$instance";
HTH.
Sincerely,
Paul Burney
++++++
Paul Burney
Webmaster && Open Source Developer
UCLA -> GSE&IS -&
on 7/26/01 6:25 PM, Ariunbold Gerelt-Od at [EMAIL PROTECTED] wrote:
> Somebody give me a advice???
You probably should try your question on the PHP General list:
<http://php.net/support.php>
This list should be reserved for messages related to using databases with
PHP.
Sincerely,
Pa
D='$ContactID'";
echo 'SQL query is: ' , $sql, '';
$result = mysql_query($sql,$db);
printf("%s\n", mysql_result($result,"FirstName"));
printf("%s\n", mysql_result($result,"LastName"));
?>
Hope that helps.
Sincer
ay, you can do it as
follows:
1. Create a new table with the columns in the right order.
2. Execute `INSERT INTO new_table SELECT fields-in-new_table-order
FROM old_table'.
3. Drop or rename `old_table'
4. `ALTER TABLE new_table RENAME old_table'
Hope it helps.
Si
you have an invisible control character between the
mysql_fetch_ and the array part. Try deleting the line and retyping:
$myrow = mysql_fetch_array($result);
Hope that helps.
Sincerely,
Paul Burney
++++++
Paul Burney
Webmaster && O
e mysql_fetch_*** and access them.
Hope that helps.
Sincerely,
Paul Burney
++
Paul Burney
Webmaster && Open Source Developer
UCLA -> GSE&IS -> ETU
(310) 825-8365
<[EMAIL PROTECTED]>
<http://www.gseis.ucla.edu/&g
add an "ORDER BY" clause to your query. That is, if you want to sort
by reg_id, append "ORDER BY reg_id". You can also add a DESC keyword to put
them in reverse order.
HTH.
Sincerely,
Paul Burney
++++++
Paul Burney
Webma
ig etc. respond to this.
Sincerely,
Paul Burney
+-+-----+
| Paul Burney | P: 310.825.8365 |
| Webmaster && Programmer | E: <[EMAIL PROTECTED]> |
| UCLA -
1 - 100 of 123 matches
Mail list logo
