8,966 Posted Topics

Member Avatar for ocbphoto

The problem exists because year is also a function. To make sure it uses your column name use backticks, so in the query it looks like this: `year`

Member Avatar for pritaeas
0
122
Member Avatar for umen
Member Avatar for pritaeas
0
55
Member Avatar for mr-cracker
Member Avatar for mangel.murti

Do you have a timestamp column ? Then sort descending and limit 10 on that column.

Member Avatar for dickersonka
0
106
Member Avatar for 3DProf4online
Member Avatar for Stefano Mtangoo
Member Avatar for Stefano Mtangoo
0
44
Member Avatar for mangel.murti

the one that is selected is in $_POST['cropcat']. You can use it to add the selected attribute of one of the options.

Member Avatar for pritaeas
0
113
Member Avatar for r_sathya

Do you want to paste text into a textarea, containing name, address, etc. and then parse that into an existing form ? This will only succeed if you know what to look for in the text, or know exactly at what position everything is placed. If that is fixed, then …

Member Avatar for pritaeas
0
100
Member Avatar for dellarby

I'd go for monitoring for new files. This can be done by creating an app that hooks into windows. This means you won't have to create a polling mechanism (either for files or for new database entries).

Member Avatar for pritaeas
0
115
Member Avatar for cali_dotcom
Member Avatar for pritaeas
0
149
Member Avatar for Studio

I normally put an include file (containing the connection info) into a separate directory, which is password protected, so from the outside it's not easy to access. Furthermore, only create localhost users on mysql. Your firewall should handle the rest.

Member Avatar for pritaeas
0
83
Member Avatar for brooksm
Member Avatar for steveissuperman

You could create a table that contains a users id and a headline's id. If the record is in there, he already voted. Both fields can function as a single unique primary key, so speed should not be an issue.

Member Avatar for pritaeas
0
120
Member Avatar for threebluIdboys

If you're just starting, and using a windows machine have a look at the XAMPP or WAMPSERVER packages. These will install the required tools for you.

Member Avatar for pritaeas
0
82
Member Avatar for babydolphin

Try: [code] echo $result_row["dates"]."</td>"; echo $result_row["news_desc"]."</td></tr>"; echo $result_row["news_details"]."</td></tr>"; [/code]

Member Avatar for babydolphin
0
81
Member Avatar for dreamer_0244

You could use one int ID field and a second type field, which would indicate the type of transaction.

Member Avatar for dreamer_0244
0
112
Member Avatar for FlashCreations
Member Avatar for FlashCreations
0
179
Member Avatar for 3DProf4online

What error ? Did you export data, or did you include the structure ? Be a bit more specific.

Member Avatar for brianlevine
0
108
Member Avatar for SeaZoneDev
Member Avatar for LizR
0
118
Member Avatar for joelogs

"using the password: no" means that you try to access mysql for user root, without a password. So you may have set a password, but it could be missing from the config file. [code] $cfg['Servers'][$i]['auth_type'] = 'config'; $cfg['Servers'][$i]['user'] = 'root'; // put here your password after setting one $cfg['Servers'][$i]['password'] = …

Member Avatar for joelogs
0
114
Member Avatar for therealme2006

Normally it would mean that the connection has not yet been established or an error in your query. Perhaps the exec() function is returning something different from what you are expecting ?

Member Avatar for pritaeas
0
77
Member Avatar for Venom Rush

[QUOTE=Venom Rush;709495]The value of Joe won't be overwritten with Suzy will it?[/QUOTE] Correct.

Member Avatar for Venom Rush
0
95
Member Avatar for tiger86
Member Avatar for Zolookas
Member Avatar for Morty222

I think you may need to use something like $_POST[$key]['fname'] or $value['fname'] The latter should be the right one, because it's the current array in the loop.

Member Avatar for pritaeas
0
79
Member Avatar for vanias
Member Avatar for nullified

any function that starts with mysql either needs to be replaced with the mysqli variant, or the mysqli method call.

Member Avatar for pritaeas
0
363
Member Avatar for espSquall

The string (Directory) in the record is causing your problem. You'll need to change it to e.g. string[30]. string may not appear in a typed file, since it's length is undetermined.

Member Avatar for espSquall
0
155
Member Avatar for deepak@

Are you perhaps waiting to receive a particular character or string ? So that it thinks it's done when the second packet comes in, but not with the first ?

Member Avatar for Denniz
0
106
Member Avatar for bubbelhund

WHERE '%$searchstring%' = ID is rather tricky. If a user enters ID = 1 then every ID with a 1 in it is returned. 1, 10, 11, and so on. If you remove the % signs, it will search for an exact match.

Member Avatar for bubbelhund
0
99
Member Avatar for hirts_gal

$source_file is just the name of the file. The file has not yet been moved to a permanent location using move_uploaded_file(). You'll have to do that first.

Member Avatar for hirts_gal
0
2K
Member Avatar for chennaiaras

If you've also installed mysql administrator (also from mysql ab) then you can use this gui tool to set all your options easily. Of course, you should be able to set this in the ini file.

Member Avatar for Shanti C
0
83
Member Avatar for babiker
Member Avatar for Doctor Inferno

This function is in the class. [code] /** * This function sets the directory where to upload the file * In case of Windows server use the form: c:\\temp\\ * In case of Unix server use the form: /tmp/ * * @param String Directory where to store the files */ …

Member Avatar for pritaeas
0
81
Member Avatar for vssp
Member Avatar for mwasif
0
107
Member Avatar for mattyb15

It would be something like this: [code] UPDATE person_table SET person_number = person_number + 1 WHERE person_name = 'this persons name' [/code]

Member Avatar for mattyb15
0
71
Member Avatar for vaishalinagare
Member Avatar for Aussi3ies

I personally like SMF very much. Has enough options to set rights on group level and has a clean interface.

Member Avatar for Shanti C
0
85
Member Avatar for odysseous

Download the trial of Navicat. If your tables have primary keys, you can compare or merge the two databases. [url]http://wiki.navicat.com/wiki/index.php/How_to_merge_two_tables_that_have_same_table_structure%3F[/url]

Member Avatar for dickersonka
0
209
Member Avatar for ryy705

According to the IMAP4rev1 RFC ([url]http://tools.ietf.org/html/rfc3501[/url] page 55) 1 is used for plain/text. 2 is used for application/octet-stream, so why this returns html, I don't know.

Member Avatar for pritaeas
0
372
Member Avatar for prashanth18
Member Avatar for whatanidea

Best would be not to store them at all, and let a third party payment processor do that job (e.g. Paypal, Servebase). The rules for privacy are getting tougher and tougher (PCI Compliance), so if you don't store this data, you'll save a lot of work.

Member Avatar for pritaeas
0
78
Member Avatar for anuj_sharma
Member Avatar for peter_budo
0
86
Member Avatar for elva.tanaem

Looks like 602SQL is based on ANSI SQL which doesn't support auto increment. Best to ask this at 602SQL support.

Member Avatar for pritaeas
0
53
Member Avatar for RobertCJohnson

wampserver has an active forum. i think you'd better try there. They most likely know best.

Member Avatar for pritaeas
0
66
Member Avatar for rickya100

Since the XML output for an RSS is fairly static, I use smarty to generate it, instead of an XML parser.

Member Avatar for rickya100
0
116
Member Avatar for ldigital

It's possible something is blocking. Did you try to use passive FTP ?

Member Avatar for pritaeas
0
29
Member Avatar for Thew
Member Avatar for pritaeas
0
22
Member Avatar for kevinritt
Member Avatar for sweet cLassy
0
74
Member Avatar for udaydesai

[url]http://nl3.php.net/manual/en/mysqli.query.php[/url] You're using the procedural style of mysqli, so the connection needs to be given as a parameter.

Member Avatar for udaydesai
0
343

The End.