Hello experts.
I'm learning a bit about JSON so I can use data for an autocomplete function. I was going to use the json-encode function to format the data in an array but my isp uses php v...
I have the following MySQL Class, which works very well to grab a single result or the total number of rows from a query. What it cannot do is loop through the results. What I would like to do...
I'm trying to implement a sql query that will retrieve 3 rows closest to the current date. Ideally I would also be pulling an entry with a date greater than or equal to today, however, this is...
Hi Experts!
I was hoping someone could help me with my problem.
I`ve been googling on this problem for a couple of hours now. And I`m getting tired.
Well.
I have on file .php file (opera...
I've searched EE and have found several helpful tips, but none seem to work for my problem.
I can upload files perfectly fine up to 2400 pixels wide by 2400 pixel height, then once I creep ...
If I wrap all my PHP queries in sprintf with mysql_real_escape_string, will it TOTALLY prevent SQL injection or are there other measures I need to take note of?
An example of the code I use...
i have the attached code on a joomla 1.0.15 page. when i run it, i get an empty result set, ie data is not inserted into my database. where could the problem be?
I am trying to have a while look to list all of the records matching the query, but I think I am missing the counter, but am not sure how to implement it. Would this be the reason only one TR...
Hi,
I would like to add text into mysql, but there is something fishy going on.
When i try to put this word into mysql: geÃÂïsoleerd
it changes into: geÃÂÃÂÃÂïsoleerd
...
My website is programmed in PHP/MySQL
Has Pulldown database driven menu
I would like to add treeview which is connected to the same menu table where I have saved all menus
and allows me to ...
Hello,
I'm trying to make a mysql query that will take $month and $year variables and select all record in a MySQL database whose 'date' field is "$year-$month-*"
How would I do this?
I have a MySQL Table with many fields that will not fit on my page when I display query results in a browser, I need to flip the table so that the Fields are displayed in the vertical axis ins...
I have a PHP front-end calling a SQL Server back-end. I have mostly embeded SQL in the front-end but a handful of stored procedure calls too. I tested my application on a Windows Server and ev...
Hi,
Using Dreamweaver Developer Toolbox, I added a Horizontal recordset to get two columns across for the city. Next to this is a number value of how many records are in the particular city.
...
Ok my meta refresh is mixxed in with my php files, only way i could get my page to refresh, i am very new to this. So here is all my code. How do i get this to stop, i would like to fill in th...
I have installed Apache 2.2, MySQL Community Server 5.0.67 and PHP 5.2.6 under Windows XP, all of which are running fine. I am running them all on an external drive (E) rather than on the C dr...
i have a php file that have some ckeckboxes in table, that are 'checked' or 'unchecked' by database value at the time of form load.
now i want 'check' or 'uncheck' the checkboxes and click a ...
I am using the following snip in code to insert a record from a standard PHP form. It works fine except when we use a & in the company name ex. ABC & Associates. When a & is used it cuts off...
I am trying to insert a date into a MySQL DB and cannot get the format correct
This is the code I am trying:
echo $_POST['TimeDate'] . " 1<br>";
Returns - 09-20-2008 1
$TimeDate = $_...
I would like to take a square image then with PHP crop the edges to make it a circle.
Is this possible? google hasnt helped me find a solution.
Hi,
I have this query:-
SELECT
`xcart_categories`.`category`
FROM
`xcart_products`
How can I adjust this to only show the first word, if at all!!!
MySQL version 5
PHP 5
If not is th...
Experts,
I have text box on a form that lists locations from a table.
I have over 250 listed with the PK of ID.
Currently, Currently, when a user filles out my form and needs to choose a ...
The below is my code.
What I need to do is loop though each value of the array, and run a test against that value of the array, for example if ($checked[0][0] == check) then do something......
Hi, I am trying to build a system to record all the tables and fields using in a MySQL database. Is there some kind of PHP function to verify if a table's field exists? Because I need to take ...
Hello -
I'm looking to turn my database table into an HTML table. Basically would like to retrieve everything from the DB table... then use a "for each" kind of deal to display it... with...
