Water_foul wrote:
i fixed those things and it didn't fix it :( :( :( :( :( :( :( :( :( is
there a icq chatroom for php?)
Shahmat Bin Dahlan [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Your SQL statement:
'SELECT Rune, username FROM RuneRunner
RuneRunner_1 WHERE
some tips when inserting data:
instead of inserting into the the table, do some debugging,echo the insert
string and check if:
1- all string fields are between single comma ('field_name').Numéric fields
do not need single comma;
2- all not null fields are present in the field list;
3-
hi guys,
i have created a 'history' table and would like to insert the 'bare' sql
query into that table just to check who did what on the database...
now, i have this :-
$CustUpdate = INSERT INTO record SET
recid = '',
customer_code = '$varCustomerCode',
id_reg =
On Wednesday 23 June 2004 17:14, Gawie Marais wrote:
i would like to add the whole query into a text field in the 'history'
table, but i get errors when i try to add it... can anyone help ?
this is the error :-
Invalid query: You have an error in your SQL syntax near '2004-06-23
11:09:57',
Thanks for the suggestions. I have
$TimeSheetID=$_POST['TimeSheetID'];
at the start of the script. However, what I neglected to mention is that TimeSheetID
is auto_increment, in first table, tblTimesheet.
I will try the other suggestions, and respond with my results.
Thanks,
Declan.
thanx guys.
Jason Wong [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Wednesday 23 June 2004 17:14, Gawie Marais wrote:
i would like to add the whole query into a text field in the 'history'
table, but i get errors when i try to add it... can anyone help ?
this is the
Solved... I needed to find a way to get the latest auto_increment value.
I did this using,
$new_id = mysql_insert_id();
Thanks,
Declan.
Thanks for the suggestions. I have
$TimeSheetID=$_POST['TimeSheetID'];
at the start of the script. However, what I neglected
Please post the table definition to the mailing list so we can help you
more quickly. Also, is there a table called RuneRunner_1 or are you
meaning to use RuneRunner_1 as an alias?
Odds are, your problem is not PHP related, it's an error in your SQL syntax.
Jon
water_foul wrote:
i fixed those
I'm using PHP with ADOdb ( and an MS Access 2000 db ) to write a simple
SQL statement but was running into some case sensitivity issues. Here's
my SQL currently:
SELECT autoQuesID,fldQuesTitle,fldBody
FROM tblFAQ_Question
WHERE fldBody LIKE '%$strSearchFor%';
All I'm trying to do is have the
Well, your query looked confusing to me, but break it up like this
First :
select
Then, name your coloumns, seperate with commas, or use wildcard for all
*
Define from what table you need to select
FROM database_table
Add some select statements with WHERE
WHERE
and the statements
Kim,
Won't redefining the variable destroy the MySQL Resource, resulting in a
resource invalid error, like he has?
$pic = mysql_query($sql,$connection); //Defines variable
$pic //Redefining variable, dumps old contents = //calling on an invalid MySQL Resource, because it doesn't exist
I have tried that and I don't get an error, but I don't get any records
returned either. And I have lowered the search string like you
mentioned. Here's what I tried ( Access syntax ):
SELECT autoQuesID,fldQuesTitle,fldBody
FROM tblFAQ_Question
WHERE LCase(fldBody) LIKE '%$strSearchFor%';
Hi there, I hoped someone might be able to tell me why this is not
working.
I have a form that updates the table 'media' with the 3 values below,
that and some other variables are the only data in the table. That works
nicely.
I then want to update one of the other columns ($E) based on the
$E= $C*$G;
Should be:
$E = $C * $G;
Never use quotation marks when doing math. Quotation marks are used
for strings. Hope that helps.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
14 matches
Mail list logo