Title: DB-stored images
Hi!
I have a db where we stores images in the database but I haven't figured out how I display
that image after I've selected it from the table.
I've tried with and but $data just return the Select-query:
Picture
Anyone have an idea what I can do?
Th
hi,
on Tuesday, November 26, 2002, 10:31:58 AM, you wrote:
OS> Hi!
OS> I have a db where we stores images in the database but I haven't figured out how I
display
OS> that image after I've selected it from the table.
OS> I've tried with and but $data just return the
Select-query:
OS>
OS>
O
Ohlson Stefan wrote:
Hi!
I have a db where we stores images in the database but I haven't figured out how I display
that image after I've selected it from the table.
I've tried with and but $data just return the Select-query:
Picture
I'm not familiar with fetching data from Oracle, but t
I'm trying to write a query to update the comission calculations on a
database
The sql looks something like
select
(round(pr_contents * 12)+ round(pr_buildings * 12)) *.33 as agent,
(round(pr_contents * 12) + round(pr_buildings * 12)) * .5 as manager,
from pipeline
if there a way of having a "
http://www.mysql.com/doc/en/Adding_users.html
Radovan Radic wrote:
Hi,
Since i dont know any mysql group, i will try here - it is anyway related to
php.
When i want to make php/mysql application i have mysql on the server and i
connect to it with mysql_pconnect("localhost","root","") and it work
Pete wrote:
I'm trying to write a query to update the comission calculations on a
database
The sql looks something like
select
(round(pr_contents * 12)+ round(pr_buildings * 12)) *.33 as agent,
(round(pr_contents * 12) + round(pr_buildings * 12)) * .5 as manager,
from pipeline
if there a way
don't think it won't work all in mysql... but what db are we talking about?
Well, have you tried it like that?
If that doesn't work you could try this:
select
@calc:=(round(pr_contents * 12)+ round(pr_buildings * 12)),
(@calc * .33) as agent,
(@calc * .5) as manager
from pipeline
Regards
Joakim
Ok, I've been racking my brain trying to figure this one out, so
I thought I'd post the question here and see who bytes. =)
I have a table:
id INTEGER, PRIMARY KEY
parentid INTEGER DEFAULT (0)
name VARCHAR(32) NOT NULL
Ok, and I am using this structure to make a kind of drill down
structure, so
The exec command, if passed a variable as a second argument, will output the
retun of the command to that array, one object per line.
In its default use, it will retun only the last line.
You may instead wnat to use the cURL functions within PHP to request pages
from a server. You may find more fu
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello Adam
On 26 November 2002 at 08:25:22 -0500 (which was 13:25 where I live) Adam
Voigt emanated these words of wisdom
< ... >
> Ok, and I am using this structure to make a kind of drill down
> structure, so the top level would be where parentid
You may want to check out using Nested Sets instead of a Parent-Child-ID
system. I think it's an easier system for representing hierarchies. Here is
a good article on the system:
http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci537290,00.html
Google for Nested Sets +sql or something and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello 1LT
On 26 November 2002 at 09:54:57 -0500 (which was 14:54 where I live) 1LT
John W. Holmes emanated these words of wisdom
> You may want to check out using Nested Sets instead of a Parent-Child-ID
> system.
This is OK for some simple trees, h
A coworker suggested I just write either the array or the actual menu
itself (in a .js file) at the time of category/subcategory creation and
just include it on the page with the menu, which I suppose is what I
must do since most other on-the-fly solutions seem fairly complicated
and can get expone
Hello.
I am using MySQL as a database for a departmental library. I have written
a quick search script, but keep getting "resource id #2" as a result to my
search. I have read the online documentation for the
mysql_fetch_array() function and must say, I don't see that I'm missing
anything. Howe
Add: print_r($row)
In your while loop, that will show you everything that is being returned
with both it's numeric and text based position.
On Tue, 2002-11-26 at 13:09, The Cossins Fam wrote:
> Hello.
>
> I am using MySQL as a database for a departmental library. I have written
> a quick search
Try this...
either...
while ($row = mysql_fetch_array($result)) {
$title = $row['Books.Title'];
$author = $row['Books.Author'];
...
print $title;
}
or...
while ($row = mysql_fetch_array($result)) {
print $row['Title'];
...
}
-Original Message--
On Wednesday 27 November 2002 02:09, The Cossins Fam wrote:
> Hello.
>
> I am using MySQL as a database for a departmental library. I have written
> a quick search script, but keep getting "resource id #2" as a result to my
> search. I have read the online documentation for the
> mysql_fetch_arra
I have two tables in my database with a department name.
One table (department), the name only appears once and it includes all
departments in the school. In the other table, (courses) department can
appear several times, but not all departments will be in the table.
I used the following code to t
Alex,
> I have two tables in my database with a department name.
> One table (department), the name only appears once and it includes all
> departments in the school. In the other table, (courses) department can
> appear several times, but not all departments will be in the table.
>
> I used the f
You really need to research join types for this. INNER JOIN, INNER LEFT,
OUTER RIGHT etc. There are a plethora of examples and options on the web.
Also, the DISTINCT keyword might help, as in "select DISTINCT department";
this would return only those departments in courses that have a
correspond
Hi list:
I've just moved over alot of new information into a mysql database and
am checking to see that members will
be able to log in under the new system.
I have a login page checking an htaccess file.
The problem is, the htaccess file is only letting some of the members
through, and denying
I have successfully installed PHP 4.2.3 on a Win NT 4 server, running IIS 4,
and can execute PHP functions now.
However, when I try to connect to an MS SQL 7 database on the same box, I
receive this error: "PHP Warning: Unable to load dynamic library
'./php3_mssql70.dll' - %1 is not a valid Win
> > You may want to check out using Nested Sets instead of a
Parent-Child-ID
> > system.
>
> This is OK for some simple trees, however it does have some
limitations.
>
> (1) Adding another tree / series of nodes into the middle if the set.
Not if you can define what the absolute max size of a no
Hi,
Although I have been working with PHP for a while, working with Databases is
something that I am only so so at. This code is supposed to grab the price from the
database given the auto_increment id is inside of $casing. I am trying to get the
$row[price] to echo so that Javascript rec
Well, is there an input field in your form whose name corresponds to . ?
It is more likely that if you have a dynamic form your fields will be called
by a ID identifier, like
price is 12 EUR
Where 12 is the price of grommet with ID 1012 in your DB
So perhaps your javascript generator echoes the w
On Wednesday 27 November 2002 15:24, Tyler Whitesides wrote:
> Hi,
>
> Although I have been working with PHP for a while, working with
> Databases is something that I am only so so at. This code is supposed to
> grab the price from the database given the auto_increment id is inside of
> $casin
26 matches
Mail list logo