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
('include_path',$new_include_path);
Hope that helps.
Sincerely,
Paul Burney
http://paulburney.com/
?php
while ($self != asleep) {
$sheep_count++;
}
?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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://paulburney.com/
?php
while ($self != asleep
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
// the statement formerly known as prince
if ($the_elevator == 'tries to bring you down') {
go_crazy('punch a higher floor
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
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,
Paul Burney
--
I'm inhaling Caesar's last gasp
.
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
while ($self != asleep) {
$sheep_count++;
}
?
--
PHP Database Mailing List (http://www.php.net
object.
Hope that helps.
Sincerely,
Paul Burney
http://paulburney.com/
?php
while ($self != asleep) {
$sheep_count++;
}
?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
.
Sincerely,
Paul Burney
http://paulburney.com/
?php
// the statement formerly known as prince
if ($the_elevator == 'tries to bring you down') {
go_crazy('punch a higher floor');
}
?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
://searchdatabase.techtarget.com/tip/1,289483,sid13_gci537290,00.html
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
that shows up in things like this:
ERROR 1030: Got error 127 from table handler
You could also add indexes for that table to speed up queries and setup a
script to automatically migrate from one table to the other, etc.
Hope that helps. YMMV. TMTOWTDI.
Sincerely,
Paul Burney
http://paulburney.com
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://paulburney.com/
?php
while
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.com/
?php
while ($self != asleep) {
$sheep_count++;
}
?
--
PHP Database Mailing List (http
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 Burney
http://paulburney.com/
?php
if ($your_php_version 4.1.2) {
upgrade_now(); // to avoid major
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 few times.
END OF ASIDE
Hope some of that ramble helps. Please try to see if it is dieing on a
particular URL so we can be of further assistance.
Sincerely,
Paul Burney
)
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
while ($self != asleep) {
$sheep_count++;
}
?
--
PHP Database Mailing
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:
http://www.php.net/manual/en/function.strtok.php
Sincerely,
Paul Burney
http
);
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
. 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
while ($self != asleep) {
$sheep_count++;
}
?
--
PHP Database Mailing
().
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...
http://paul.burney.ws/thoughts/caesars_breath.html
--
PHP
?w=615h=420
- 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
while ($self != asleep) {
$sheep_count++;
}
?
--
PHP Database Mailing List
, username FROM photos LEFT JOIN users ON
photos.userid=users.id GROUP BY userid
You could add the file field in there as well, but it would only be
returning one of the files (the first or last one for that user, but I don't
know of a way for you to be specific).
Hope that helps.
Sincerely,
Paul
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 available.
http://mystri.sourceforge.net
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 helps.
Sincerely,
Paul Burney
http://paulburney.com/
?php
while ($self != asleep
, 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/function.setcookie.php
HTH.
Sincerely,
Paul Burney
http://paulburney.com/
?php
while ($self != asleep) {
$sheep_count
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.
Sincerely,
Paul Burney
http://paulburney.com/
?php
if ($your_php_version
) = 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 applications?
A: Use MySTRI instead. http://www.burney.ws/software/mystri/
--
PHP
. 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.
Sincerely,
Paul Burney
http
value=http://www.etc.com;
thank you and best, addison
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
/1,289483,sid13_gci537290,00.html
http://www.dbmsmag.com/9605d06.html
http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm
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
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/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
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
while ($self != asleep) {
$sheep_count++;
}
?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit
= str_replace(\n,\r\n,$text); // all to windows
HTH.
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
.
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/manual/en/function.sybase-select-db.php
HTH.
Sincerely,
Paul Burney
http
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.
Sincerely,
Paul Burney
http://paulburney.com
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 get flooded
with automated requests?
Sincerely,
Paul Burney
--
I'm inhaling Caesar's last gasp...
http://paul.burney.ws/thoughts
';
while (result = something) {
if ($first_record == 'yes') {
do_something();
$first_record == 'no';
} else {
do_something_else();
}
}
HTH.
Sincerely,
Paul Burney
http://paulburney.com/
?php
while ($self != asleep) {
$sheep_count
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
while ($self != asleep) {
$sheep_count++;
}
?
--
PHP Database Mailing List
based calendar in PHP.
DevShed is good place for other PHP tutorials as well.
HTH.
Paul Burney
http://paulburney.com/
?php
while ($self != asleep) {
$sheep_count++;
}
?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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
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
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
/manual/en/function.ini-set.php
HTH.
Sincerely,
Paul Burney
http://paulburney.com/
?php
while ($self != asleep) {
$sheep_count++;
}
?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
, 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.
Sincerely,
Paul Burney
http
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
while ($self != asleep) {
$sheep_count
:
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
while ($self != asleep) {
$sheep_count++;
}
?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit
should quote your key
names.
while ($myrow = mysql_fetch_array($result)) {
echo 'trtd',$myrow['Name'],'/td';
echo 'td',$myrow['txtSWDesc1'],'/td/tr';
}
HTH.
Sincerely,
Paul Burney
http://paulburney.com/
?php
while ($self != asleep) {
$sheep_count++;
}
?
--
PHP Database
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 Burney
http://paulburney.com/
?php
while ($self
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
while ($self != asleep) {
$sheep_count++;
}
?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
,
Paul Burney
http://paulburney.com/
?php
// the statement formerly known as prince
if ($the_elevator == 'tries to bring you down') {
go_crazy('punch a higher floor');
}
?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
that
mentions MySQL as well.
HTH.
Sincerely,
Paul Burney
http://paulburney.com/
?php
// the statement formerly known as prince
if ($the_elevator == 'tries to bring you down') {
go_crazy('punch a higher floor');
}
?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit
the above
code, it would succeed.
Just a word of warning.
Sincerely,
Paul Burney
http://paulburney.com/
?php
// the statement formerly known as prince
if ($the_elevator == 'tries to bring you down') {
go_crazy('punch a higher floor');
}
?
--
PHP Database Mailing List (http
.
Sincerely,
Paul Burney
http://paulburney.com/
?php
while ($self != asleep) {
$sheep_count++;
}
?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
id if statement
/* More code after this point */
} // end while if statement.
===
Hope that helps.
Sincerely,
Paul Burney
http://paulburney.com/
?php
while ($self != asleep) {
$sheep_count++;
}
?
--
PHP
.
Sincerely,
Paul Burney
http://paulburney.com/
?php
while ($self != asleep) {
$sheep_count++;
}
?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
produce something like:
DELETE FROM table WHERE id IN ('3','4','123');
Hope that helps.
Sincerely,
Paul Burney
http://paulburney.com/
?php
while ($self != asleep) {
$sheep_count++;
}
?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net
=text value=?php echo htmlspecialchars($name); ?
HTH,
Paul Burney
http://burney.ws/
?php
while ($self != asleep) {
$sheep_count++;
}
?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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 shared
startup script for MySQL on OS X.
http://www.entropy.ch/software/macosx/mysql/
HTH.
Sincerely,
Paul Burney
http://paulburney.com/
?php
If ($your_php_version 4.1.2) {
upgrade_now(); // to avoid major security problems
/* Please see http://security.e-matters.de/advisories/012002.html
,
Paul Burney
http://paulburney.com/
?php
If ($your_php_version 4.1.2) {
upgrade_now(); // to avoid major security problems
/* Please see http://security.e-matters.de/advisories/012002.html */
?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
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/
?php
If ($your_php_version 4.1.2) {
upgrade_now
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.com/
?php
If ($your_php_version 4.1.2) {
upgrade_now(); // to avoid major
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 my
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 PHP
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?
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
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
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 PHP General
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:
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_id =
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 Communigate
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
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 construction
databases regularly and hope you never really need
to use them.
Hope that helps.
Sincerely,
Paul Burney
++
Paul Burney
Webmaster Open Source Developer
UCLA - GSEIS - ETU
(310) 825-8365
[EMAIL PROTECTED]
http://www.gseis.ucla.edu
, the value you're looking for is mydate, i.e.,
echo $myrow['mydate'];
HTH.
Sincerely,
Paul Burney
++
Paul Burney
Webmaster Open Source Developer
UCLA - GSEIS - ETU
(310) 825-8365
[EMAIL PROTECTED]
http://www.gseis.ucla.edu
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 klunky, but you could probably get it to
work.
Sincerely,
Paul Burney
.
Sincerely,
Paul Burney
++
Paul Burney
Webmaster Open Source Developer
UCLA - GSEIS - ETU
(310) 825-8365
[EMAIL PROTECTED]
http://www.gseis.ucla.edu/
++
--
PHP Database Mailing List (http
() , ': ' , mysql_error() , 'BR';
HTH.
Sincerely,
Paul Burney
++
Paul Burney
Webmaster Open Source Developer
UCLA - GSEIS - ETU
(310) 825-8365
[EMAIL PROTECTED]
http://www.gseis.ucla.edu
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] |
| UCLA - GSEIS - ETU
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 |
| Webmaster Programmer | E: [EMAIL PROTECTED
variable will be set to yes.
Sincerely,
Paul Burney
++
Paul Burney
Webmaster Open Source Developer
UCLA - GSEIS - ETU
(310) 825-8365
[EMAIL PROTECTED]
http://www.gseis.ucla.edu
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 diagnosis.
Sincerely,
Paul Burney
instance_name, host_name FROM v\$instance;
HTH.
Sincerely,
Paul Burney
++
Paul Burney
Webmaster Open Source Developer
UCLA - GSEIS - ETU
(310) 825-8365
[EMAIL PROTECTED]
http://www.gseis.ucla.edu
='$ContactID';
echo 'SQL query is: ' , $sql, 'br';
$result = mysql_query($sql,$db);
printf(%s\n, mysql_result($result,FirstName));
printf(%sbr\n, mysql_result($result,LastName));
?
Hope that helps.
Sincerely,
Paul Burney
+-+-+
| Paul Burney
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 Open Source Developer
UCLA
the database and return the publisherID and a count of
the number of books.
You can do a group by to get them all at once:
SELECT COUNT(*) AS book_count, publisherID FROM bookDB GROUP BY publisherID;
Then use your favorite mysql_fetch_*** and access them.
Hope that helps.
Sincerely,
Paul Burney
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
Webmaster Open Source Developer
UCLA - GSEIS - ETU
(310
,
Paul Burney
+-+-+
| Paul Burney | P: 310.825.8365 |
| Webmaster Programmer | E: [EMAIL PROTECTED] |
| UCLA - GSEIS - ETU | W: http://www.gseis.ucla.edu
suggestions???
It looks like you set your key column as a TINYINT type rather than say, an
INT. Try ALTER'ing that column type to INT and see if it works.
Sincerely,
Paul Burney
++
Paul Burney
Webmaster Open Source Developer
UCLA - GSEIS
++;
}
// make sure you don't have a malformed table
while ($c % $n != 0) {
echo 'tdnbsp;/td';
$c++;
}
echo '/tr';
// end table code (omitted)
?
Hope that helps.
Sincerely,
Paul Burney
++
Paul Burney
Webmaster Open Source Developer
UCLA
with MySQL support.
You still need to download and install MySQL on the machine. You can find
packages and more information at:
http://www.mysql.com/
Hope that helps.
Sincerely,
Paul Burney
++
Paul Burney
Webmaster Open Source Developer
UCLA
use of the function mysql_num_rows?
What are the error messages you get? The @ symbol suppresses warning
messages being sent to the browser so it isn't fixing whatever the real
problem is.
Sincerely,
Paul Burney
++
Paul Burney
Webmaster
['ordertotal'];
Hope that helps.
Sincerely,
Paul Burney
++
Paul Burney
Webmaster Open Source Developer
UCLA - GSEIS - ETU
(310) 825-8365
[EMAIL PROTECTED]
http://www.gseis.ucla.edu
of checking for $submit, do something like:
... if (isset($submit_x)) { ...
Sincerely,
Paul Burney
++
Paul Burney
Webmaster Open Source Developer
UCLA - GSEIS - ETU
(310) 825-8365
[EMAIL PROTECTED]
http://www.gseis.ucla.edu
on 5/16/01 10:44 PM, andrie at [EMAIL PROTECTED] wrote:
we know that every password in mysql was encryption using PASSWORD
function. i have case that make me to send user password bymail.
how can i get this user password ?
You can't. It's a one way encryption. You'll need to log into MySQL
of what it sees. Try changing the file name to nav.php.
HTH,
Paul
++
Paul Burney
Webmaster and Open Source Developer
Educational Technology Unit
Graduate School of Education and Information Studies
University of California, Los Angeles
]
etc.
Since phpBB is open source, you could probably look through the source code
and find it. I would guess some kind of preg_replace loop.
http://www.phpbb.com/
Paul
++
Paul Burney
Webmaster and Open Source Developer
Educational
a while loop to drop the values into a select field, i.e.,
echo 'option value=' , $row['fieldname'] , '' , $row['fieldname'] ,
'/option';
You may want to check out a small script I wrote:
http://webdevel.burney.ws/code/id?14
Hope that helps,
Paul Burney
1 - 100 of 104 matches
Mail list logo