rgaard" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Rick Taylor wrote:
I'm new to PHP and having issues. We have seperate servers for them. We
can use ODBC to test the connection and it works fine. However, when we
try to run the site we get a message of *** Error:
I'm new to PHP and having issues. We have seperate servers for them. We
can use ODBC to test the connection and it works fine. However, when we try
to run the site we get a message of *** Error: Unable to Connect to
Database. Please Try Again Later. ***
We are using a custom app that we are
"Brad Bonkoski" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Rosen wrote:
>> Hi,
>> I have a problem with PHP and Oracle SQL query.
>> I have 2 tables :
>>
>> Table Main:
>> ---
>> id number
>> text varchar2(100)
>>
>>
>> Table Recs
>> ---
>> id number
>> pos numb
Looking at that. You are combining html and php without distinguishing
between the two. I am assuming you are in "php mode" because html wouldn't
give you errors. try this:
echo "";
- Original Message -
From: "mayo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January
Hi all,
Does anyone have a class or function that can be used to search any
given string from a textfield ie:
$string = london rome paris...
Thanks in advance!
R
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Thanks...I used that idea and just did some replacing before and after the
parsing. The database is maintained by our clients and it would be too
confusing for them. Thanks
RIck
- Original Message -
From: "Ignatius Reilly" <[EMAIL PROTECTED]>
To: "Rick Dahl" &l
n how I can fix this?
Rick
What do I need and where can I get it?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
What is the best way to parse through a non-repeting XML output using php?
- Rick
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
dynamic. Any help is appreciated.
- Rick
I need to get the month in a number format; July =7. Right now it is returning the
string: July.
This is what I am doing.
$today = getdate();
$month = $today['month'];
$mday = $today['mday'];
$year = $today['year'];
What can I do to get the number instead of the word?
- Rick
How would I remove a # from a string?
I want #2 to be 2.
- Rick
le if there is some
once it is read in?
- Rick
I have a column (ID) that is currently not auto_incremental. I need to change it so
that it is auto_incremental. There are already records in this column. also, I need
to change the field type from int(4) to int(8).
Rick
I want to print out a timestamp of length 14. I want to have it formatted
like:
mm-dd-yy : hh-mm
I have looked but all I can find is how to format a date and I don't want
that. I want the time also.
Rick
"Don't burn the da
to all the people that tried to lend a hand.
For some reason the javascripts didn't work.
There wasn't a need to get as complicated as session variables.
I ultimately figured out a way to do it by just moving { } around.
Rick
The scripts I need to run before I redirect automatically send output to the browser.
I cannot alter these scripts. Is there a way around this?
Rick
I need to redirect to another page once some scripts that I can't alter run.
I have this function at the top of my page:
How do I call the function?
Rick
Having a member login is just checking the password against the database and
starting a session for that person, right?
Rick
_
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp
Why won't this work?
Edit Show List
Senthttp://twostep.antsmarching.org/bpedit.php3";>Back Receivedhttp://twostep.antsmarching.org/bpedit.php3";>Back Deletehttp://twostep.antsmarching.org/bpedit.php3";>Back \n";
echo "DateNameAddress
1Address 2City, State
ZipReceivedSentEdit";
while($
On Mon, 31 Mar 2003, Roger 'Rocky' Vetterberg wrote:
> [Snip]
>
>
> >>About the second suggestion, just pulling the data back out; I could
> >>do that, but the only thing that is unique in the string is the
> >>timestamp. Theoretically, on a busy site even that could be identical
> >>in two rows
Is the the type of thing I would need?
http://www.postcastserver.com/
I found where I am supposed to alter the PHP.ini file. What am I supposed
to type instead of 'localhost'
Rick
"Don't burn the day...away" ~ DJM
From: Jason Wong <[EMAIL PROTECTED]>
Reply-T
I think the fact that I don't have a mailserver would do it. Unless the PHP
home edition 2 bundle has a mailserver, I don't have one. Where can I get
one of those? Can I get it for free?
Rick
- Original Message -
From: "Jason Wong" <[EMAIL PROTECTED]>
To
I can't get it to work. I get the echo to show up but never receive a email.
if($blankpostage) {
$to = "Rick Dahl <[EMAIL PROTECTED]>";
$subject = "Online B+P Request";
$body = "Show ID = " . $id;
mail($to, $subject, $body);
echo &qu
$field)
{
print "$field";
}
print "";
}
print "";
Thanks
--rick
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
un the MySQL client and execute the status
command \s to find the proper location. Then edit your php.ini
file. Find the setting for mysql.default_socket and set it to the proper
location. You must restart Apache for php.ini changes to take effect.
Rick
--
PHP Database Mailing List (
mpany
1 46 Active Jones Inc.
2 54 InactiveBaker
Inc.
SELECT id, company.company_id, status, company
FROM projects
LEFT JOIN Companies USING( company_id )
ORDER BY company
enable access to MySQL, probably
by re-compiling PHP and Apache. The exact fix depends on operating system,
web server, and how PHP is compiled.
Rick
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ld be using Apache 1.3.
Rick
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
At 07:59 PM 12/16/02 -0800, Daevid Vincent wrote:
I need to use PHP to duplicate the schema of a database. This seems like
it should be a simple task -- taking a 'template' db and cloning it with
a new name.
The easiest way I know of is at the command line:
>mysqldump -p -u root name_of_exist
way, but nothing is returned.
i just copied & pasted the code from one section of the page to the next.
do i need to reset one of the vaiables?
mysql_data_seek()
http://www.php.net/manual/en/function.mysql-data-seek.php
Rick
--
PHP Database Mailing List (http://www.php.net/)
To unsub
= b.id
AND photog1 = c.id AND photog2 = d.id
AND what ever else you want in the where clause;
Rick
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
$VarName = 'School' . $Choice;
echo "";
}
For extra credit, figure out how you can create the $SchoolChoices array
from the output of the following query:
DESCRIBE TableName School;
(Yes you can send this to mysql_query, and get the possible values of the
enum.)
Rick
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
to GRANT access to various users as needed. That is
part of the mysql database
and the easiest way to merge them is by issuing the needed commands.
Rick
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
er the time required for the programmer to change all
the programs
that already have been coded.
Rick
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ember 16, 2002
> end_date: Sepetember 20, 2001
>
>Based on the above, I would like to echo out something like this:
>
> You will be in training September 16 - 20, 2002.
SELECT CONCAT( DATE_FORMAT(start_date, '%M %d' ), ' - ',
DA
w many addresses you
allow someone to enter. If you allow zero or one address per entry go ahead
and put it in one table. If you want to allow zero or more phone numbers that
would call for a separate table with the number and type of phone.
Rick
--
PHP Database Mailing List (http://www.php.ne
>>Hello
>>
>>I'm to have database, but server's administrator refuses to install MySQL
>>nor PHP MySQL support :( He told me he won't install it and I should use
>>textfiles if I want to have database.
Sounds like time too find another hosting pro
The problem is that he assigned a length to a TEXT field. You cannot do
that.
-Original Message-
From: George Pitcher [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 3:13 AM
To: [EMAIL PROTECTED]; Lisi
Subject: Re: [PHP-DB] Error creating new table
You can't have NOT NULL assig
fopen()
fwrite()
fclose()
-Original Message-
From: Raymond [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 12:05 PM
To: Frank Flynn; [EMAIL PROTECTED]
Subject: [PHP-DB] Re: Making a txt file from db data, is it possible?
Hi!
Ok, I think I maybe have to explain this a little bet
I had a typo:
$sql = "UPDATE $table_name SET file_name=\"$files\"";
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 12:29 PM
To: 'Jas'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Stuck on db entry from select box.
jas,
Ya didn't do what I told you to do. Now, do this:
";
$sql = "UPDATE $table_name SET file_name=\$files\"";
-Original Message-
From: Jas [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 12:01 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Stuck on db entry from select box...
O
Using VALUES() is faster
Nothing really wrong with SET clause, though
-Original Message-
From: Zach Curtis [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 10:34 AM
To: Rick Emery; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Insert, Arrays, & Null
Terrific! I tried an exa
ailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 9:29 AM
To: Rick Emery; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Insert, Arrays, & Null
The data being read dynamically into the array could contain values which
are NULL (the default) or numeric (if a numeric value exits). However, the
query i
When you say "...account for either a numeric or NULL value ...", do you
mean SELECT a value that could be NULL?
If so, the query is "SELECT * FROM mytable WHERE cusa IS NULL || cusa >= 0"
-Original Message-
From: Zach Curtis [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 9:11
$post = ereg_replace("(.*) ","\\1", $old_post);
If you want to search mysql for this that is something else
-Original Message-
From: Dave Carrera [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 10:29 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Please help count ?
Hi All
I
Jason,
If you don't have one, I would also recommend a good book that combines PHP
and MYSQL interaction. I would strongly suggest the one I cut my PHP teeth
on:
PHP Essentials by Julie Meloni
-Original Message-
From: Julie Meloni [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 20
change:
$Location_Info = mysql_fetch_row($result);
to:
$row = mysql_fetch_array($result);
$Location_Info = $row['fieldname'];
replace "fieldname" with the real name of your database field
-Original Message-
From: Jason Tobias [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 9:2
cron is an application/utility on ALL unix servers. It is used to execute
ANY unix command or script at specified dates, times, etc.
type the following to learn more:
man cron
man ctrontab
your cron job would execute the command to translate the dbase file to sql.
Then execute mysql to read in t
Josh,
Your question is too vague to answer.
Do you know mysql?
Do you know PHP or PERL?
If not, learn these, then ask.
If so, create code, then ask
-Original Message-
From: Evans, Josh [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 9:31 AM
To: [EMAIL PROTECTED]
Subject: [PHP-
]]
Sent: Thursday, April 04, 2002 8:41 AM
To: Rick Emery
Subject: RE: [PHP-DB] Database Sorting by date
The query fails when I try to look at a month it says "Query Failed"
>Ronald L. Allen (MCSE NT, MCP, CCNA)
SR. LAN/WAN Administrator
>SFOR - Hungary, Croatia
>[EMAIL
Can you use a cron (Unix) or at (Windows) job to dump the dbase data to a
comma-separated-value table? Then suck up the csv into the mysql databasde.
-Original Message-
From: Marij Bellen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 8:37 AM
To: '[EMAIL PROTECTED]'
Cc: '[EMA
Ron,
What problem are you having? I'm looking at your code, and it's so clean, I
could eat off of it.
My only suggestion would be that $month will NEVER == "NULL". If you are
testing for NULL, the test is:
if ($month == NULL )
Second, $month will be assigned a value, so it will never be NULL e
12:51 AM
To: Rick Emery
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Submitting Dynamic Form
Ah, I just knew there must be an easy way of doing it. Thanks Rick !
Is there a good reference on stuff like this with some examples ?
Am I pushing the friendship ? :-)
Rick Emery wrote
il 03, 2002 4:37 PM
To: Rick Emery
Subject: Re: help sorting by a column name
Oh thats teh statement that gets the number for this statement:
while ($info = mysql_fetch_row($max)) {
printf ("Hardware Reviews - %s Articles
Total", $info["0"]);
}
and prints the total number of a
you just cross-posted this to the mysql mailing list.
is this a mysql issue or PHP issue?
-Original Message-
From: Alex Behrens [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 4:33 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] sorting by colum name with nested loops
Hey Guys,
) construct to extract each key and value.
So then you just walk through the array and process each entry.
-Original Message-
From: Chris MacKenzie [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 8:47 AM
To: Rick Emery
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Submitting Dynamic
what happened when you extracted the form field names from the DB?
-Original Message-
From: Chris MacKenzie [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 3:13 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Submitting Dynamic Form
Hi All,
I'm pretty new to the whole php thing a
show your code
-Original Message-
From: Ron Allen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 5:43 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Problem with the beginning variable
I have a problem with the inital load of my page
When it loads it says that the variable is n
what command are you using?
When posting questions, give all details...wee can't read your mind
-Original Message-
From: Daniel Broome [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 01, 2002 9:33 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] autoincrement
I am trying to add auto increment
select PERIOD_DIFF(DATE_FORMAT("2002-04-01","%Y%m"),
DATE_FORMAT("2001-0801","%Y%m") ) as dd;
+--+
| dd |
+--+
|8 |
+--+
1 row in set (0.00 sec)
-Original Message-
From: John Hughes [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 2:28 AM
To: [EMAIL PROTECTED]
S
while( $row = mysql_fetch_array($result) )
{
}
-Original Message-
From: Natividad Castro [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 29, 2002 2:59 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] end of file
Hi to all,
how can I handle when the recordset reach the last record?
is it possib
SELECT * FROM mytable ORDER BY some_field DESC LIMIT 1;
-Original Message-
From: Ron [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 29, 2002 7:39 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Return the last record on database
My database has several records an ID is the primary key
I wan
Jason, this is intriguing.
Please show us a bit more code before the mysql_query() call.
-Original Message-
From: Jason [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 1:54 AM
To: Php-Db
Subject: [PHP-DB] MySQL/PHP Update
I'm trying to update my MySQL database, but it doesn't
did you start each include file with:
If not, PHP treats the code within as straight text
-Original Message-
From: Brad Melendy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 5:03 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] include() statement hell!
Ok, I've spent some time
show you code and db table struct
-Original Message-
From: Dave Carrera [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 2:38 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Very wierd problem ;-(
Hi All
I will try and explain as clearly as I can
I have a message board typ
You need to ensure that mysql.sock has the correct read-write-execute
permissions
Check the mail list archives; this question is asked and answered EVERY week
-Original Message-
From: Liam Gibbs [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 1:17 PM
To: [EMAIL PROTECTED]
Sub
I'm trying to decipher:
when I select the record to edit the drop-downlist has
the first option as the value instead of what the corresponding
StateID in
the column reads. How can I correct this? The form to insert and
edit have
the below code and correctly in
I suggest subscribing to the mysql mailing list and asking the question.
[EMAIL PROTECTED]
-Original Message-
From: Chris Payne [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 25, 2002 7:47 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] procedures?
Hi there,
Where can I find information in
]
Subject: Re: [PHP-DB] delete statement question
Rick, thanks for the idea but actually it wouldnt work :(
take a look:
mysql> delete answers
-> from exam e, questions q, answers a
-> where a.question_id=q.question_id and q.exam_id=e.exam_id;
ERROR 1064: You have an error in
First: what error are you getting?
Second, make your code more readable and easier to debug:
$query = "INSERT INTO usuario (USU_USUARIO, USU_CLAVE, USU_NOMBRE,
USU_EMPRESA, USU_DIRECCION, USU_TELEFONO, USU_CIUDAD, USU_DEPARTAMENTO,
USU_PAIS, USU_EMAIL, USU_REPCLAVE, USU_TIPCLIENTE)".
VALUES ('$C
this solution will not work for mysql databases, as mysql does not support
sub-selects
-Original Message-
From: Bill Morrow [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 25, 2002 2:02 PM
To: Andr?s Felipe Hern?ndez
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] delete statement question
O
if you are using mysql 4.x, you might try:
DELETE answers FROM exam e, questions q, answers a WHERE
a.question_id=q.question_id && q.exam_id=e.exam_id;
I've not tested this, though.
-Original Message-
From: Andrés Felipe Hernández [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 25, 2002
There's a bunch of ways to accomplish what you request. Therefore, I'll
offer what I would do. Other folks, more brilliant than, will provide
better ideas.
1. Do you have access to the mail server? For instance, I run qmail on my
SOHO system and, therefore, have full sys-admin rights. If yo
$query = "SELECT myvalue FROM mytable WHERE some_condition";
$result = mysql_query($query) or die("Error: ".mysql_error());
$srch = "";
while( list($myvalue) = mysql_fetch_array($result)
{
$srch .= "$myvalue, ";
}
$srch = substr($srch, 0, -2);
$query = "SELECT * FROM other_table WHERE this
tables already, users and
adressreg
???
/ljungan
"Rick Emery" <[EMAIL PROTECTED]> skrev i meddelandet
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> store and validate a username and password with each user's info
>
> -Original Message-
> From:
store and validate a username and password with each user's info
-Original Message-
From: Ljungan [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 22, 2002 11:07 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] "marking" DB entries...
Im making an adressbook using PHP and mySQL.
I want each use
First: cross-posting to multiple lists...not nice. Most PHP folks are on
both lists.
Second: your first sentence seems to indicate that unknowledgeable people
inhabit the PHP list, vice the PHP-DB list. H
Third: what error do you get when you get the parsing error?
-Original Messa
I mean:
mysql_insert_id()
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 2:28 PM
To: 'Morten Nielsen'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] LAST_INSERT_ID()
use mysql_last_id()
-Original Message-
From: Mort
use mysql_last_id()
-Original Message-
From: Morten Nielsen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 2:30 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] LAST_INSERT_ID()
Hi,
In the PHP manual under the function mysql_insert_id() function they have
the following line:
The
SELECT * FROM mytable WHERE record_name REGEXP "^[a-h]"
-Original Message-
From: Jordan Elver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 6:05 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Selecting Alphabetically
Hi,
Could anyone point me in the right direction with this one
Huh
-Original Message-
From: Ron [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 9:30 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: Relational database
But can you do that in PHP before you pull info from it
--
PHP Database Mailing List (http://www.php.net/)
To unsubs
What do you mean "last record in a table"? What are you REALLY trying to do
here? Do you want the last entry made according to a specific criteria?
-Original Message-
From: Ron [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 9:20 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re:
first, it helps if you show us your REAL code. The query statement you
showed below would obviously not work (it's missing the "mysql_query" part.
Second, when executing mysql_query() ALWAYS include the "or
die(mysql_error())" part to aid diagnostics.
Third, your query could not possibly work at
if( strcmp($date,"-00-00") )
{ do something}
-Original Message-
From: its me [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 14, 2002 12:16 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] date problem
i have an input field in a form that accept date called $date and in databse
i made it
SELECT DISTINCT city FROM addresses;
-Original Message-
From: Kevin Diffily [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 1:05 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] SQL Question
Hello,
I have a simple SQL Question. I would like to take the column city in
database add
MySQL does not currently support sub-selects.
The manual says:
DELETE [LOW_PRIORITY | QUICK] FROM table_name
[WHERE where_definition]
[ORDER BY ...]
[LIMIT rows]
Did you review the manual first?
-Original Message-
From: Riccardi Moreno [mailto:[EMAIL PROTECTED]]
Sent: Wednes
Vieliecht:
SELECT kat_id,immo_id FROM immo_kat WHERE immo_id=318 &&(kat_id = '1' OR
kat_id = '35' OR kat_id = '34') ORDER BY immo_id;
-Original Message-
From: Michael Plies [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 11, 2002 4:01 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] how can i jo
First: show us your exact query
Second: show us your exact error response
Third: show us your exact code and table structure
-Original Message-
From: Sander Peters [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 11, 2002 3:03 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] select rows from m
I tried the HAVING clause. it fails. This requires sub-selects or multiple
tables
-Original Message-
From: DL Neil [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 10:27 AM
To: Jonathan Underfoot; Rick Emery; [PHP-DB]
Subject: Re: [PHP-DB] SQL
Jonathan,
The original
First, what do you mean by "regs"?
If I understand your question, you want to know if mysql will re-use an old
auto_increment value that has been deleted. The answer is yes and no.
If you say: DELETE FROM mytable;
then the next insertion will cause the auto_increment value to begin at 1
If you
it works for me. What do your data and table structures look like?
-Original Message-
From: Fredrik Wahlberg [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 4:55 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql LIMIT and ORDER BY problem
I have a strange problem with LIMIT.
How could you possibly have such a condition exist? That is, what relation
do the counts have to the contents of the name field?
What ARE you trying to really accomplish?
-Original Message-
From: Jonathan Underfoot [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 2:57 PM
To:
Huh
$query = "CREATE TABLE mytable (".
"field1 int,".
"field2 varchar(50),".
"field3 decimal(6,2),".
"field4 int,".
"field5 int )";
mysql_query($query) or die("Error: ".mysql_error());
-Original Message-
From: CrossWalkCentral [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2
Mate,
what code/function are you using to convert the dates?
what do your data look like in the table (structure, examples)?
-Original Message-
From: George Pitcher [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 8:01 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Problem displa
ause you appear to have an extra " in fron of ORDER BY
-Original Message-
From: George Pitcher [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 18, 2002 9:53 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Problem connecting to db on Linux
Rick,
Sorry, here it is:
Warning: Supplied argum
ng else
which is obvious?
George
- Original Message -
From: "Rick Emery" <[EMAIL PROTECTED]>
To: "'George Pitcher'" <[EMAIL PROTECTED]>; "Rick Emery" <[EMAIL PROTECTED]>;
"Greg Donald" <[EMAIL PROTECTED]>; <[EMAIL
nt: Monday, February 18, 2002 8:48 AM
To: Rick Emery; Greg Donald; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Problem connecting to db on Linux
Rick,
I snipped the code from my windoze system. I did have to change the case of
the dbname to reflect the Linux version (all lc).
The error message I g
Have you spelled the name of the database correctly, including case
sensitivity?
What error message are you getting to indicate failure?
-Original Message-
From: George Pitcher [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 18, 2002 8:21 AM
To: Greg Donald; [EMAIL PROTECTED]
Subject:
Further, I recommend replacing your echos with the following:
echo "Type Of Car: "".
$myrow['car_type']."\n";
echo "Model Of Car: ".
$myrow['car_model']."\n";
echo "Year Of Car: ".
$myrow['car_year']."\n";
echo "Price Of Car: $".
$myrow['car_price'."\n";
echo "VIN Of Car: ".
$myrow['car_vin']
1 - 100 of 405 matches
Mail list logo