Tagged Questions

-5
votes
0answers
25 views

Where can I find expert help for a random internal server error for my php/mysql based sites? [on hold]

We keep having random 500 Internal Server Errors on several of our PHP based sites. I've spent hours trying to hunt down what's happening. Where can I find an php/mysql expert to help me resolve ...
0
votes
1answer
33 views

PHP mysql_fetch_array() not returning any results

I am trying to fetch records from mysql. Currently my query returns just one row. $queryBids = "select bid_amount,delivery_time,proposal,user_id from bids where project_id = ".$pid; $qbids = ...
0
votes
3answers
24 views

database insert does not work

hey i have a problem with inserting some data in my database: define('SECURE', true); include "storescripts/connect_to_mysql.php"; $txn_id = 123456789101234567; $payer_email = ...
0
votes
1answer
14 views

Best way to create and store a Dynamic widget

I'm creating a "hosted form" widget (PHP, jquery, MySql), the widget will be customize by the users dynamically, multiple HTML inputs, different font, sizes, colors, etc. I was thinking to store the ...
-9
votes
1answer
43 views

If in Array on PHP [on hold]

I have two result from MYSQL... $table = $db->getPrefix().'content'; $query = mysql_query("SELECT catid FROM $table WHERE id = $id"); $result = mysql_fetch_assoc($query); $catId = ...
-4
votes
0answers
20 views

Call a variable from vars.php into MySql. Echo on a php page from MySql

I have a MySQL database. In a table called "configuration" I want to save the following line: <?php include 'vars.php'; echo "$company";?> $company='Nokia, LLC'; is properly defined in ...
0
votes
1answer
67 views

Why does mysql discarding float values?

everything was working fine but what happened now i can't say. Actually mysql does not storing any floating values and all other values such as integer, varchar etc are accepting. i am posting a ...
0
votes
6answers
43 views

Take dashes out of MYSQL date

Here is my situation. I am sending records to database through php file. Then I have a date field being set with now(). It adds the date in this format: 2013-08-01 Then I am exporting the database to ...
0
votes
0answers
20 views

Show one table's row info in place of other using data from two tables

Ok lets say it looks like this in table users_chars i have pos_zone 255 in table two zone_id | name 255 | This_Area how would i go about comparing them and showing the name row instead of ...
0
votes
3answers
23 views

Joining two tables through a join in an already existing MYSQL Query

I have a structure something like this of my two tables: z_notes: | i_resident_id | resident_fname | resident_lname | i_communication_log | facility_id | dt_note_created | user_roles: | ...
0
votes
0answers
23 views

CodeIgniter multiple results from stored procedure

I have one stored procedure on MySQL, for example: CREATE PROCEDURE get_multiple_results() BEGIN SELECT 'A' AS A; SELECT 'B' AS B; SELECT 'C' AS C; END So, How I get the data using the query ...
-1
votes
1answer
25 views

INSERT Error - IF file EMPTY function not working

I have this code and for some reason I am getting this error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use ...
0
votes
1answer
7 views

Find “problematic” rows in a mysql table that will fail to export

I wanted to backup my database with PHP I tested the linked script but it was never ending, I tried to prepend the repair $table before the query but it didn't help So I figured out if I just skip ...
0
votes
2answers
40 views

to get random id using php and mysql

I have a 2 tables which contain id,subject,exam,qution,qution_id, in table 1 in table 2 id,question_id,answer,correct, here i have a problem to get a random questions from data base i am using ...
1
vote
5answers
27 views

How to prevent double records without checking every value if exists

I`m aware that if you would like to prevent double input data in you table you can check if the value exists by a simple query SELECT `id` FROM TABLE WHERE `title` == 'test' I'm also aware that PHP ...

1 2 3 4 5 … 4722
15 30 50 per page