Go Back   CodingForums.com > Search Forums
Reload this Page Search Results

Before you post, read our: Rules & Posting Guidelines

Page 1 of 9 1 23 Last »
Showing results 1 to 25 of 219
Search took 0.29 seconds. Search: Posts Made By: DataTalk
Forum: PHP 05-21-2011, 02:14 PM
Replies: 1
Views: 733
Posted By DataTalk
Copy rows from one table to another

Is there a better way to do this?

Copy all orders from orders_temp_table WHERE OrderNo = $orderno , to the orders production table

The goal here is to copy the orders serverside without...
Forum: PHP 04-29-2011, 01:11 AM
Replies: 2
Views: 259
Posted By DataTalk
Need help with with If Statement

This if statement works ok to list the selected products.
But if there are not products,, else does not return "No Products Available" .

What am i missing ??


// output all available...
Forum: PHP 02-23-2011, 10:38 PM
Replies: 1
Views: 299
Posted By DataTalk
Start with a simple query, and then keep adding...

Start with a simple query, and then keep adding your other stuff and you will figure this out a lot faster.

<?php
// make connection
$sql = ("SELECT * FROM `table`") or die ('Invalid...
Forum: PHP 02-23-2011, 10:18 PM
Replies: 5
Views: 400
Posted By DataTalk
you can use php if you convert excel data to...

you can use php if you convert excel data to comma, DIF, etc.

Then atomate you import from there - Of course, this depends on your server access. If you are on a local area network with file...
Forum: PHP 02-20-2011, 10:17 PM
Replies: 4
Views: 496
Posted By DataTalk
Thanks! The second example works fine for the...

Thanks! The second example works fine for the current date.

I want to convert $row[RecordDate] like in the first example; But it does not give the correct result.

$wdmy = date("W M d y",...
Forum: PHP 02-20-2011, 07:24 PM
Replies: 4
Views: 496
Posted By DataTalk
Date format

What is the proper method for this date conversion:
my sql field name [RecordDate] format is MM-DD-YY

I want to convert the RecordDate to $month $week $year.
In the code below the month is...
Forum: PHP 02-20-2011, 04:40 PM
Replies: 4
Views: 666
Posted By DataTalk
I'm not sure where you were going with that? ...

I'm not sure where you were going with that?

This seems to work for to spelling the record month from RecordDate (format is MM-DD-YY)


$date = $row[RecordDate];
$spellmonth =...
Forum: PHP 02-20-2011, 12:09 AM
Replies: 3
Views: 1,084
Posted By DataTalk
mysql_free_result($result) function is not...

mysql_free_result($result) function is not "required" for any query.

This function frees the result from memory.
Forum: PHP 02-19-2011, 11:53 PM
Replies: 4
Views: 666
Posted By DataTalk
Thanks, I tried the code like this: using...

Thanks, I tried the code like this: using uppercase letter 'M' which should return the name of month.

$month = date('m', strtotime($row['RecordDate']));

for some records its correct, but It...
Forum: PHP 02-19-2011, 11:10 PM
Replies: 4
Views: 666
Posted By DataTalk
name date

The field $row[RecordDate] format in my database is MM-DD-YY

How can I convert each row RecordDate to $day $month $year

I need to Reverse program the date function:
date('M') would return...
Forum: PHP 01-31-2011, 03:09 AM
Replies: 1
Views: 518
Posted By DataTalk
Is there a way to use %like with php

I know like can be used for filtering data in sql but what about in with php inside the while loop searching something like?

I could not find where like is a valid php search function, what...
Forum: PHP 01-29-2011, 04:52 PM
Replies: 0
Views: 611
Posted By DataTalk
Drop procedure and Create new procedure

I am using sqlA to drop and sqlB to create new.

How could this be combined into one query?


// Drop Procedure If Exists
$sqlA = (" DROP PROCEDURE IF EXISTS sp_jobs");
...
Forum: PHP 01-28-2011, 06:36 PM
Replies: 9
Views: 2,504
Posted By DataTalk
Try this <?php $sql = "SELECT * FROM...

Try this

<?php
$sql = "SELECT * FROM table" ;
$result = mysql_query($sql);
while($row = mysql_fetch_assoc($result)){
if($row[image] == null ) {
$image =...
Forum: PHP 01-27-2011, 02:54 PM
Replies: 48
Views: 6,113
Posted By DataTalk
This was quite an adventure! The add-edit-delete...

This was quite an adventure! The add-edit-delete functions are working.
Thanks!
Forum: PHP 01-27-2011, 02:16 PM
Replies: 48
Views: 6,113
Posted By DataTalk
yea, I see where it was changed. I just...

yea, I see where it was changed.

I just added the delete function and its not deleting the record.


if (isset($_POST['Delete'])) {
mysql_delete( $_POST['table_name'], $_POST, '`id` = '...
Forum: PHP 01-27-2011, 01:36 PM
Replies: 48
Views: 6,113
Posted By DataTalk
I will look at the differences in the file!

I will look at the differences in the file!
Forum: PHP 01-27-2011, 02:58 AM
Replies: 48
Views: 6,113
Posted By DataTalk
I have went throught it several times. There...

I have went throught it several times.
There is a wire crossed in the update function, I can't seem to find the bug in it, I will keep looking..

See my last post for the revised $_POST...
Forum: PHP 01-26-2011, 11:20 PM
Replies: 48
Views: 6,113
Posted By DataTalk
I revised input post: Works for insert but still...

I revised input post: Works for insert but still getting error on Edit


if (isset($_POST['table_name'])) { if (isset($_POST['insert_id'])) {
// Update Existing Record
mysql_update(...
Forum: PHP 01-26-2011, 08:01 PM
Replies: 48
Views: 6,113
Posted By DataTalk
Clicking Edit opens the correct record, but...

Clicking Edit opens the correct record, but creates a new record on save.

How do I correct this?
Forum: PHP 01-26-2011, 06:24 PM
Replies: 48
Views: 6,113
Posted By DataTalk
I'm kinda stuck here on Edit Records! I...

I'm kinda stuck here on Edit Records!

I changed the field values in the test_form.php from this :
value="<?php echo isset( $_POST['FirstName'] ) ? $_POST['FirstName'] : '' ?>"

to this: (GET...
Forum: PHP 01-26-2011, 04:45 PM
Replies: 48
Views: 6,113
Posted By DataTalk
Some of my databases have over 100K records, I...

Some of my databases have over 100K records, I use a limit option so this should be no prob! I will check it out, Thanks!.
Forum: PHP 01-26-2011, 03:43 PM
Replies: 48
Views: 6,113
Posted By DataTalk
Thats pretty slick, how does that affect...

Thats pretty slick, how does that affect performance in a large database?
Forum: PHP 01-25-2011, 10:49 PM
Replies: 48
Views: 6,113
Posted By DataTalk
when I change the header to: test_employees.php I...

when I change the header to: test_employees.php I get an error message.
Also saving blank records, no data.
Forum: PHP 01-25-2011, 08:10 PM
Replies: 48
Views: 6,113
Posted By DataTalk
No prob!... I will do it now. I am starting...

No prob!... I will do it now.

I am starting to understand the logic here.

Thanks for hanging in there!
Forum: PHP 01-25-2011, 06:17 PM
Replies: 48
Views: 6,113
Posted By DataTalk
for testing purposes I will use employees until...

for testing purposes I will use employees until everything works, then switch to post[table]

The form inserts a "BLANK" record in employees with Success!

The field names are spelled correctly...
Showing results 1 to 25 of 219
Page 1 of 9 1 23 Last »

 
Forum Jump

All times are GMT +1. The time now is 03:58 PM.