Have a look at how I would insert data in your case.
Howard
-Original Message-
From: sg [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 29 July 2001 8:57 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL newbie: inserting new entry to table?
Hi folks!
I'm new to PHP/mysql.
I created a db
Thank You Howard!
You sure are quick!
I found a way to make it work. I used to have both scripts (the one that
displays and the one that inserts new entries) on the same page...
Once I separated them I had a link on a third page. I first clicked on the
insert entry link then back to the display
go to http://www.php.net/eregi_replace
hth
Dave
-Original Message-
From: J- E- N [mailto:[EMAIL PROTECTED]]
Sent: 28 July 2001 15:41
To: [EMAIL PROTECTED]
Subject: [PHP-DB] replace string - case insensitive
hello
str_replace is case sensitive, what function should i use for
I am inserting binary image data into a mysql table (mediumblob).
Actually, what goes into the table is the /tmp... pathname.
This is the code I used to try to retrieve, but I get Resource ID#2
$get=mysql_query(SELECT bin_data FROM binary_data WHERE id=$id);
printimg src=$get;
=
Mark
Here's a VERY helpful link to help deal with a number of form situations.
http://www.linuxguruz.org/z.php?id=33
Little demo's of each too!
olinux
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
PHP
Thanks, David. That helped a little but now what I get is:
img src=/tmp/phpMVWr5Z in the output.
The tmp folder is up the directory tree outside of my www folder (on my
web host's 'puter)- I don't have direct access to it.
Heres the modified code:
$sql=mysql_query(SELECT bin_data FROM
I've figured out (with some help) how to query two tables at the same time.
In order to get a corresponding CompanyName with a specified ContactID I
created a SQL query that selects both tables ($table_name1,$table_name2) and
then selects contacts.CompanyID = '$CompanyID'. The result is a match
Hi all
During the process of importing a lot of Oracle data into MySQL, I have two
tables that are giving me a bit of a headache. One is a list of jobs and the
other is a list of employers. There's now a unique id for each table, and
the job table also has a column called id1, which *should*
No no no, what you want to do is echo $row[0], not img src=$row[0].
$row[0] is the actual jpeg data, and the browser will interpret it like that
since you put the header(Content-type: text/jpeg);
Try echoing $row[0] only and tell me how that goes.
-- David
-Original Message-
From: Mark
Hello,
I've got a pretty basic query which I am trying to run within a function.
The query looks like this:
SELECT
a.title,a.alt_title,a.articleID,a.articleSectionID,sect.URLname
FROM
$articlestable a, $categorytable sect
WHERE
a.articleSectionID = sect.articleSectionID
Maybe this helps:
$file = /tmp/pathtoimage/image.jg
$fp = fopen($file, filesize($file));
$image = fread($fp, filesize($file)); //not sure about fread function¿
print $image //or imagejpeg($image), I'm not sure..
Grtz,
Luc
[EMAIL PROTECTED]
- Original Message -
From: Mark Gordon
Od: "Sergey Larionov" [EMAIL PROTECTED]
Temat: [PHP-DB] InterBase
"Warning: InterBase: arithmetic exception, numeric overflow, or string
truncation Cannot transliterate character between character sets in
/home/larionov/public_html/base.php on line 6"
How I can turn off tranliteration?
Beyond that excellent answer, this is exactly the kind of situation where
transactions would be helpful (and in a lot of cases, mission critical).
So an expanded quasi-pseudocode rendition of olinux's answer could be:
$result_bt = mysql_query('[whatever it takes to begin a transaction]');
Halo,
How could I set up Informix driver in my Linux Server?
SF
At 13:26 27/7/2001 -0500, Muciño Zúñiga Marco Antonio wrote:
OK, I set my LIBS environment variable to my esql -libs result and the
confire shell is OK now, but now I get the next error when running the make
command:
#
14 matches
Mail list logo