Sorry if you are a newbie..
but if might help if you delete the records before you select them to display in
html
ie: put the delete query at the top of the page, just after this line:
require ("templates/db_connect.php");
adam
On Wednesday 03 July 2002 12:55, Russ wrote:
> Hi all:
>
> Our company uses for reasons of experience, an INT(10) field for storing
> dates in a MySQL DB. ((We just DO OK! ;-))
I'm curious to know if there are any other reasons why your company doesn't
store dates as dates. In absence of any oth
Hi all:
Our company uses for reasons of experience, an INT(10) field for storing
dates in a MySQL DB. ((We just DO OK! ;-))
However I it is because the date isn't stored as a DATE or DATETIME
(etc) that I can't do an accurate ORDER BY - as
MySQL doesn't recognise the field's content as a valid d
On Wednesday 03 July 2002 12:42, eat pasta type fasta wrote:
> I have a simple form which queries the database based on 2 pop-up menu
> choices and keywords entered by the user,
> it passes on the variables as follows:
>
> pop-up1=choice1, pop-up2=choice2, textfield=user specified data
>
> the que
I have a simple form which queries the database based on 2 pop-up menu
choices and keywords entered by the user,
it passes on the variables as follows:
pop-up1=choice1, pop-up2=choice2, textfield=user specified data
the query is as follows
$result = mysql_query("SELECT some_id, some_descriptio
On Wednesday 03 July 2002 04:36, Casey Allen Shobe wrote:
> On Thursday 27 June 2002 02:19 pm, Mattia wrote:
> > I would like to make multiple queries in a single mysql_query(...)
> > statement!! Like in the mysql client given with the distribution,
> > separated by a ; or a \g !!!
> > How can I??
Hi!
I have an oracle object type as follows,
create or replace type my_objtype as object (col1 number, col2 number)
/
create or replace type my_arrtype as table of my_objtype
/
I couldn't get this bound in php.
If I have an simple oracle object type (see the below one), I could bind it
and pa
I'm trying to write a PDF form that people can fill in. I want to then
take the data, store it in my database, and then recall the data, and
display a filled in form with that data. I see two options. The first is
to have acrobat post the entire PDF file and store the entire file. This
option seem
Hi there Everyone
I have a major problem. I have a new website for a client which works
great, but when the person selects their holiday it goes to my secure
SSL server. No problem, all pages and images are located on there so
its fully secure.
The thing is Im using Javascript validation a
I'm posting info into a SQL Server from a form, all has been working fine
inserting, updating and selecting information for months. I have recently
added a date field to the table with the type of datetime. It updates the
table in SQL Server fine, but it keeps pulling it back as this date [Feb 0
On Tuesday 02 July 2002 11:18 am, Casey Allen Shobe wrote:
> Oh, and what's the difference between [int field_number] and [int
> field_offset] (from odbc_field_name and sybase_fetch_field manual pages)?
> Are they the same, or is the offset one number less than the field number,
> or is it somethi
On Thursday 27 June 2002 02:19 pm, Mattia wrote:
> I would like to make multiple queries in a single mysql_query(...)
> statement!! Like in the mysql client given with the distribution, separated
> by a ; or a \g !!!
> How can I???
You should be able to use it exactly the same.
$foo = mysql_quer
Load the query into a variable, usually $query.
$query = "SELECT * FROM table; SELECT * FROM othertable;";
$result = mysql_query($query, $link_id)
or die("error msg");
>>> "Mattia" <[EMAIL PROTECTED]> 06/27/02 02:19PM >>>
I would like to make multiple queries in a single mysql_query(...)
sta
OK, loosely related to the database topic on this list.
I have a page that displays the contents of a contact list in an HTML table.
The contents are pulled from a MySQL db with a standard PHP query. Nothing
special happening there. In this table, I put Edit and Delete links to
maintain each line
I would like to make multiple queries in a single mysql_query(...)
statement!! Like in the mysql client given with the distribution, separated
by a ; or a \g !!!
How can I???
Mattia
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Well, here's what I got, since I put the data into the table directly it had no extra
slashes so it looked like this '\n' , but when retrieving it i ended up with '\\n'. I
would have expected stripSlashes to work but that turned them into 'n'. Here's what I
did as a workaround:
function strip
Try nl2br().
ie.
$var=nl2br($var);
This replaces \n with
"Ryan Jameson (USA)" <[EMAIL PROTECTED]> said:
> Hi guys, maybe I'm missing something silly but when I retrieve a string
from my SQL server with '\n' in it, they are displayed literally instead of
as line breaks. StripSlashes only
On Tuesday 02 July 2002 11:09 am, Casey Allen Shobe wrote:
> Following up. I found sybase_fetch_field, which fetches field information,
> including the column name, into an object.
>
> So now my question is, what is an object? And how would I go about getting
> the information I need out of it?
Following up. I found sybase_fetch_field, which fetches field information,
including the column name, into an object.
So now my question is, what is an object? And how would I go about getting
the information I need out of it?
Thanks.
On Tuesday 02 July 2002 11:03 am, Casey Allen Shobe wrot
Hi guys, maybe I'm missing something silly but when I retrieve a string from my SQL
server with '\n' in it, they are displayed literally instead of as line breaks.
StripSlashes only turns them into 'n'.
Any ideas?
<>< Ryan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, vis
On Tuesday 02 July 2002 10:32 am, Bogdan Stancescu wrote:
> odbc_num_fields() and odbc_field_name() in this case :-)
Thanks, that works!
Now, any advice for sybase? There's a sybase_num_fields function, but nothing
to get the columnname that I can see.
Thanks again in advance,
--
Casey Alle
It was fine this time! Your first message was addressed to
<<[EMAIL PROTECTED]>> instead of simply [EMAIL PROTECTED]
Well, make sure you don't use POST in the form and GET in the PHP - or
vice-versa. Also, try replacing your debug code in the PHP with
something like this:
--
echo ("Debug:\
Thanks for the tip. Unfortunately it didn't fix the issue. I am sorry about the way
the address message is displayed. There unfortunately isn't anything I can do about it.
Jeffrey Norsworthy MCP, CCNA
Network Administrator
Community Health Services
[EMAIL PROTECTED]
>>> Bogdan Stancescu <[EMAIL
odbc_num_fields() and odbc_field_name() in this case :-)
Bogdan
Casey Allen Shobe wrote:
>Whoops, should have been more clear.
>
>I'm looking for something to work with ODBC, and also Sybase. I'm already
>fetching the data fine, but can't figure out how to get the column headers.
>
>On Tuesda
Whoops, should have been more clear.
I'm looking for something to work with ODBC, and also Sybase. I'm already
fetching the data fine, but can't figure out how to get the column headers.
On Tuesday 02 July 2002 09:50 am, Casey Allen Shobe wrote:
> How can I get the column headers from a query?
For MySQL, see mysql_num_fields() and mysql_fetch_field() at
http://www.php.net
HTH
Bogdan
Casey Allen Shobe wrote:
>How can I get the column headers from a query?
>
>For example, on a 'select blah, blah2, blah3, something as blah4 from
>whereever', I would want the blah, blah2, blah3, blah4
Variable names are case-sensitive in PHP - try $HTTP_POST_VARS["first"]
- or, for new versions of PHP, $_POST["first"].
In another train of thoughts, please use the proper e-mail address - I'm
sure I'm not the only one using filters to automatically move mail to
folders and your although proba
Hello All,
I am new to PHP, and I am trying to design what I thought would be a fairly simple
form, that queries a MYSQL database for two fields, (first, and last name). It should
then return the entire results of the entry in the table. This part is actually 5
fields.
If I run the script
How can I get the column headers from a query?
For example, on a 'select blah, blah2, blah3, something as blah4 from
whereever', I would want the blah, blah2, blah3, blah4, preferably in an
array.
Thanks,
--
Casey Allen Shobe / Network Security Analyst & PHP Developer
SecureWorks, Inc. / 404
Without knowing what you really are trying to accomplish...
I've had very good results with the following bit of code:
//scan the directory and load its contents into an array
$handle=opendir($dir);
while (false !== ($file = readdir($handle)))
another way to do this is (quicker, using only one query):
$delete_IDs = implode(",",$name_array);
$sql = "DELETE FROM $mysql_table WHERE id IN ($delete_IDs)";
mysql_query($sql);
or you could delete the first line (implode) and take the square
brackets out of the name of the form field. this wi
Hi there,
I have a problem with content data. Currently I do store images inside a
data folder.
/data
This is causing a problem, because everytime I installan update of the
application on the server I have to move this folder around to the new
version of my application. I am worried that during
On Tue, 02 Jul 2002 12:57:56 +0200
Michael Bretterklieber <[EMAIL PROTECTED]> wrote:
> Hi,
>
> one point that you should keeped in mind is, if you have a cluster of
> webservers connecting to the same db-server, then you have to mount the
> filesystems, where you store the images on all webser
Hi,
one point that you should keeped in mind is, if you have a cluster of
webservers connecting to the same db-server, then you have to mount the
filesystems, where you store the images on all webservers.
On the other hand many db's like oracle have many restrictions with
lobs. In oracle you
On Tue, 2 Jul 2002 05:45:40 +0200
"Andy" <[EMAIL PROTECTED]> wrote:
> is the increase of the network traffic noticable? The query is pretty small
> just text. Do u really think this might increase the traffic?
Try to heavely charge a DB with images inside it.
Do the same without DB, that depends
use this on the first SELECT :
when u choose an option the page will be refreshed and the $choice will be
available thru HTTP_GET_VARS["choice"]
all u have to do is check if the var exists and execute the second MySql
SELECT acording to the $choice
-Mensagem original-
De: Peter
36 matches
Mail list logo
