Here's the mail I sent yesterday right after your question. I sent
it to the general PHP list (you posted it there). But obviously your
never read that list. Don't post any questions there then. There are
people putting time in answering your questions, so you have to make
sure they don't do this
replies below:
""M. Verheijen"" [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Dear reader,
A newbie mysql/php-question here! I've filled a mysql-database with about
1600 records. All these records contain items which
are on sale on a website. Every row contains
hi all
how does everyone feel about the get_browser function?? Is the general
impression it's overkill, and also flawed since it depends on the
browser.ini file being up to date, or it is widely used?
I'm about to need to use browser detection I'm wondering if a simple
i use get_env("HTTP_USER_AGENT") to log browser types and it works fine.
to be hones i didn't know about the get_browser function ...
user agent suplies loads of info though about browser, platform etc.
Steve Brett
Internal Development
EMIS Ltd.
"Privileged and /or Confidential information
I was thinking that MySQL doesn't support subselects ?!
Or is there a new MySQL-Version which does support them ?
Greetinx,
Mike
Michael Rudel
- Web-Development, Systemadministration -
___
Suchtreffer AG
Bleicherstrae 20
D-78467
What you are missing is the first row, not the last row.
To explain:
mysql_fetch_row() operates with an internal pointer which moves one step
down the result set with each call to the function. The first time it is
called, it returns the first row, and moves its pointer to the second row.
The
I thought that it was good db design to have no repeating data in your db but
to use a relationship instead?
Jord
On Tuesday 27 March 2001 14:42, you wrote:
Jord,
I don't see quite why you should want to use two tables, you can easily put
all the information in one table and have one
Why don't you just store the file names in a db?
iets much easyer
Hi,
I want to keep filenames of different kinds of media(real sudio, qt, mp3)
for
articles in a db table. Would it be best to store each kind of media in a
different table like one table for real audio, one for quicktime,
I am.
Jord
On Tuesday 27 March 2001 14:06, you wrote:
Why don't you just store the file names in a db?
iets much easyer
Hi,
I want to keep filenames of different kinds of media(real sudio, qt, mp3)
for
articles in a db table. Would it be best to store each kind of media in a
On Sat, Mar 24, 2001 at 08:55:13PM -, Grant wrote:
Is there any way of using a string in an SQL query instead of using the
table name. Something along the lines of
$result=mysql_query("SELECT * FROM $tablename",$db);
this doesnt work it come up with a parse error
Your problem is
Hi,
can anybody tell me for some cool MySQL database manager ?
Thanks,
Rosen Marinov
--
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 administrators, e-mail: [EMAIL PROTECTED]
www.mysqlfront.de
I have used it and found it to be great. However I am a beginner and if
there is a better product please let me know.
All the best
Lisa
-Original Message-
From: Rosen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 3:26 PM
To: [EMAIL PROTECTED]
Subject:
I think you should store all files in a table with an extra table with the
filetypes (like you suggest in the end of your mail)!! In my opinion this is
a well designed database modell, 'cause you have only one table (instead of
10 or twelve depending on the count of your datatypes), but you are
As title, I can't have some query like "insert into table (a, b, c)
where (?, ?, ?) and then fill the value in the loop.
This kind of statement often have better performance, why php don't
support this?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL
use isset($checkbox) where $checkbox is the name of the check box on the
page that processes the form.
Steve Brett
Internal Development
EMIS Ltd.
"Privileged and /or Confidential information may be contained in this
message. If you are not the original addressee indicated in this message (or
Does anyone know how to connect and display table rows from an ODBC source
MS Access MySQL databases?
--
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 administrators, e-mail:
Maybe you tell us, which system you are running, like linux, or windows. If
you use linux you should try to use unixODBC (Tutorial for uinxODBC and PHP:
www.unixODBC.org).. If you use windows, it should be done by uncommenting
the odbc-library in php.ini like:
extension=php_odbc.dll
Greetings,
The following code:
$result = mysql_query("SELECT * FROM motor_vehicle",$db);
$strSep = 'nbsp;|nbsp;';
while ($myrow = mysql_fetch_array($result))
{
echo $myrow['id'].$strSep;
}
Gives me the following error:
Warning: Undefined index: id in C:\PHP\Test_Scripts\testdb2.php on line 16
--
PHP
I have the insertRecord function which is supposed to be called only
when you hit submit. For some reason I'm blanking out on how to do
this. The function and function call ARE on the same page. I think I
just need some logic to indicate "stop" and "go".
Every form has a submit button right?
Columns used in the WHERE clause is the good identifier for which columns to
index. You don't want to index every column you select.
Typically adding indexes decreases insert performance. The more indexes the
slower inserts operate, because the indexes also must be updated.
Adding an index to
Click Here! "), so in that case I display the form. If it does not have
an
empty value, the user has clicked the submit button, so I can go ahead
processing the form data. Like this:
if ( empty($submit) )
{
### Display the form
}
else
{
### Do some checks to make the the data
Is it easier to update every web page you code with
get_env("HTTP_USER_AGENT") ; or easier to grab a new browser.ini file?
""Simon R Jones"" [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
hi all
how does everyone feel about the get_browser function?? Is the
Hi,
Is it possible to have multiple rows for one column of a MySQL databes? and if so how
would I insert another row into the column in question?
eg:
idNamePhone Number
1Kev 123123
2John 234234
345345
3 Paul
I like your simplicity and straightforwardness.
My code tends toward:
switch($submit) {
case: "Accept":
.. insert record
break;
case: "Delete":
.. delete record
break;
case "Cancel":
..
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] ("Anyangwe, Tanwani") wrote:
$result = mysql_query("SELECT * FROM motor_vehicle",$db);
$strSep = 'nbsp;|nbsp;';
while ($myrow = mysql_fetch_array($result))
{
echo $myrow['id'].$strSep;
}
Gives me the following error:
Warning: Undefined
what about kmysql and kmysqladmin ??
Greetinx,
Mike
-Original Message-
From: Rubanowicz, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 4:34 PM
To: 'Rosen'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] MySQL manager
www.mysqlfront.de
I have used it and found it to
I like your simplicity and straightforwardness.
Thanks. ;p
My code tends toward:
switch($submit) {
case: "Accept":
.. insert record
break;
case: "Delete":
.. delete record
break;
case "Cancel":
Hello,
I would like to know if it's possible to read a videoclip from Access97
with PHP?
I have inserted the clip as an OLE object but i don't know exactly how to
retrieve the format to visualize, i've also check the type of the column an
PHP says it's LONGBINARY.
Does anyone knows how to
Mauricio Junqueira wrote:
Hello, this is my first attempt to query and print a result coming from a
database, in this case interbase6.
I got the following error: InterBase: Dynamic SQL Error SQL error code =
-504 Cursor unknown in maingeral.htm on line 8
Here's the code:
?
If just comment the following lines, everything works Please help...
I'm getting nut !!
? include("php/header.php");
ibase_pconnect(BANCO,DBUSER,DBPASSWD)
or die ("script language='javaScript' alert('" . ibase_errmsg() .
"'); /script");
$stmt = "select count(*) from
I am setting up an episode guide for one of my favourite shows and with this
I need to include three screenshots:
episodeID_a.jpg
episodeID_b.jpg
episodeID_c.jpg
In some cases though the files will not exist and therefore I need too check
if they exist and if they don't then it will display a
Whats wrong with this code?
$img1 = "episodeID_a.jpg";
$img2 = "episodeID_b.jpg";
$img3 = "episodeID_c.jpg";
$img$x="blank.jpg";
That doesn't what you expect. I think the syntax is the same as Perl:
$var = "$img$x"; # $var hold the _name_ of the variable
How can I manage DATE fieldtype in PHP4 with Interbase?
The problem is that i manage DATEs in format DDMM (spain) but Interbase
manage it in MMDD format; so queries expected data in that format while
i need it in other format.
%
if(isset($action))
{
Why isn't this working?
?php
$img[] = "$episodeID_a.jpg";
$img[] = "$episodeID_b.jpg";
$img[] = "$episodeID_c.jpg";
for ($x=0; $xcount($img); $x++) {
if(!file_exists($img[$x])) {
print("td align=centerimg src=\"blank.gif\" width=160 height=120
border=\"1\"/td");
} else {
In article 99qq47$jvn$[EMAIL PROTECTED],
[EMAIL PROTECTED] (Martin Skjoldebrand) wrote:
How do I check for an empty string in PHP/MySQL.
http://www.php.net/empty/
http://www.php.net/is_null/
--
CC
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
Hello,
I'm new to PHP and mySQL. I'm trying to find more info on printf. Specifically
setting table properties, like height,width,background. Hoping someone can point me in
the right direction.
Thanks for the Help,
Mike
I don't know Postgresql, but all databases I've dealt with increments
auto-increment fields only on committing insert commands. I think you can
catch the last id number (MySQL do it) and show the number + 1 on the user
screen.
HTH
Jayme.
-Mensagem Original-
De: Julio Cuz, Jr. [EMAIL
how to export the text files to Msql database ?
My database now in Excel format.
what type of file should I saved
I will insert the file in MySQL
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Hello-
I'm running MySQL and php and when I run the query below I don't get any
return rows. As you can see I search for events that are happening between
a certain date. The "startDate" field is type DATE in MySQL and the date in
the database that should be returned in "2001-03-27" but I'm not
There is no date that was before Jan 4th and on or after March 1st
simultaneously--not even March 27th.
Today might be a special day to individuals for varying reasons (birthdays,
anniversaries, new jobs, promotions, whatever) but it's not THAT special
that it simultaneously exists in two
http://phpwizard.net/projects/phpMyAdmin/
Mit freundliche Gruessen / Regards
Juergen Immel
MultiServicesNetworks / Anwendungsentwicklung
|N |O |C |
--|--|--|--|-
| GROVE
Network Operation Center
http://www.grove.de
http://www.iag-net.de
Kooperationspartner des
I have a number of apartment features that are entered via checkboxes. In my revision
script, I am not sure of the best way to revise these.
With the system I am using now I set the field to "1" if the box is checked on the
initial form, otherwise, it becomes zero indicating, "NO" [ "1" is
Hello all.
Can someone tell me what I'm doing wrong here?
$sql = "SELECT * FROM user_prefs WHERE u_id='$UserID'";
$result = mysql_db_query($sql);
$color = mysql_fetch_array($result);
echo '
table bgcolor="'.$color[color_1].'" class="nav" .. ';
I can't get $color[color_1] to return a
43 matches
Mail list logo