part.");mysql_close($db);exit();}
> }
Why the single quotes around $sql. It's a string so you shouldn't have to
quote it at all.
if (!mysql_query($sql)) {echo 'Unable to add part!'; }
++
Paul Burney
Webmaster an
on 3/4/01 3:58 AM, Joris Kluivers at [EMAIL PROTECTED] wrote:
> CREATE TABLE chatmessages (id tinyint(6) DEFAULT '0' NOT NULL
> AUTO_INCREMENT, message text, username varchar(100), UNIQUE id (id);
> with php.
> But after some time i get the error:
> ERROR 1062: Duplicate entry '127' for key 1
>
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
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
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 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 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/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/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/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/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 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 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/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
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
#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
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
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,
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
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/
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
; , 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
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
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
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
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
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
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
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
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
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
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'],'';
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
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
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
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
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/
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
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
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
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
on 4/10/01 1:49 PM, Rob Griffiths at [EMAIL PROTECTED] wrote:
> **50** print "{$A["fname"]}" .
You need to separate out the array reference:
print "" . $A["fname"] . ""
That should do it.
Hope it helps,
Paul Burney
http://
ELECT substring_index(body, "." ,2) FROM news'
or
$result = mysql_query("SELECT substring_index(body, '.' ,2) FROM news"
Hope that helps,
Paul Burney
http://paulburney.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROT
p<->mysql tutorial is.
I like devshed.com tutorials. The format they use is very nice and easy to
follow.
Hope it helps,
Paul Burney
++
Paul Burney
Webmaster and Open Source Developer
Educational Technology Unit
Graduate School of Educa
assume that somewhere in the code
you have the connection made and the database selected.
Can you try this?
0) {
while ($myrow = mysql_fetch_array($result))
printf("%s\n", $myrow['headline']);
printf("%s\n", $myrow['body']
gt; Pls help me
Sorry, you should really subscribe to the PHP General list to post
non-php/database questions. You can do so here:
<http://php.net/support.php>
That page also has information about news groups and list archives.
Sincerely,
Paul Burney
<http://paulburney.com/>
--
PHP
net, zend.com, or
the general list archives for more info.
Hope that helps.
Sincerely,
Paul Burney
http://paulburney.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list a
ly set if PHP is sending the
authentication. If they don't work for you, you should be able to use the
environment variable $REMOTE_USER.
HTH,
Paul Burney
http://paulburney.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional co
d they run a while loop to drop the values into a select field, i.e.,
echo '' , $row['fieldname'] ,
'';
You may want to check out a small script I wrote:
<http://webdevel.burney.ws/code/id?14>
Hope that helps,
Paul Burney
++++++++
add a " selected" keyword to the appropriate option tag. Typically in PHP,
this is done with a series of if statements.
For example,
>One voyage only
Hope that helps,
Paul Burney
http://paulburney.com/
http://webdevel.burney.ws/
--
PHP Database Mailing List (http://www.php.net/)
u delete all rows from the table or something similar.
Hope that helps,
Paul
++++++
Paul Burney
Webmaster and Open Source Developer
Educational Technology Unit
Graduate School of Education and Information Studies
University of California, Los Angel
>
> [b]bold[/b]
> 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 S
is visible. IE is just trying to display what it can
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 Informat
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 MyS
Other than that, you could have the user do a limiting search on the DB for
the item first, and then make the drop box from that.
HTH,
Paul Burney
http://paulburney.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands,
nnerID=' . $banresult[bannerID];
mysql_db_query("phpads", $this_query);
If the bannerID field isn't numeric, you'll need to enclose it in quotes as
someone else mentioned.
HTH,
Paul Burney
http://paulburney.com/
http://webdevel.burney.ws/
--
PHP Database Mailing List
m_rows($result);
>
> Is this a new 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
+++++
do something with it. Call ifx_query or
something.*/
}
You could also just go through all the results in a similar fashion and set:
$orderdate = $row['orderdate'];
$ordertotal = $row['ordertotal'];
Hope that helps.
Sincerely,
Paul Burney
++
f checking for $submit, do something like:
... if (isset($submit_x)) { ...
Sincerely,
Paul Burney
++++++
Paul Burney
Webmaster && Open Source Developer
UCLA -> GSE&
t entails the necessary MySQL header files so that
PHP can compile 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
+++
ave a malformed table
while ($c % $n != 0) {
echo ' ';
$c++;
}
echo '';
// end table code (omitted)
?>
Hope that helps.
Sincerely,
Paul Burney
++
Paul Burney
Webmaste
r, and it won't add them anymore. Any 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 Burn
ig etc. respond to this.
Sincerely,
Paul Burney
+-+-----+
| Paul Burney | P: 310.825.8365 |
| Webmaster && Programmer | E: <[EMAIL PROTECTED]> |
| UCLA -
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
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
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
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
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
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
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 -&
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
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
($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
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
. $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
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
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
'" 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/>
+
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
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
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
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 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
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/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/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_
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
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
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
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
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
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/
"
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/>
-
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
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
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
#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
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
"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
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
1 - 100 of 123 matches
Mail list logo